Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Professional
| Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 29th, 2006, 05:09 AM
Authorized User
 
Join Date: Feb 2006
Location: , , India.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Passing Parameter in Crystal report 10


In the given code iam trying to pass 1 parameter ..its working fine ... how can i pass more than 1 parameter ???

CrystalDecisions.Shared.TableLogOnInfo objConInfo;
ReportDocument objRDoc;
--------------------------
--------------------------
objRDoc.SetParameterValue("USERID", 1);
--------------------------
--------------------------
objobjExpOptspts.ExportDestinationType=exportDesti nationType.DiskFile;
objobjExpOptspts.ExportFormatType = ExportFormatType.PortableDocFormat;
objobjExpOptspts.DestinationOptions = objDiskFileOpts;
objRDoc.SetDatabaseLogon("userid", "password");
objRDoc.Export();

thanks
Arunlal
 
Old April 25th, 2007, 03:01 AM
Registered User
 
Join Date: Apr 2007
Location: , , Malaysia.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to mamaharis
Default

can i know..
objRDoc.SetParameterValue("USERID",1);
1 is for what??? can you explain?
thanks

 
Old April 25th, 2007, 05:57 AM
Friend of Wrox
 
Join Date: Aug 2006
Location: Amman, , Jordan.
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Default

well..
I use the following function for setting the parameters and I adjust it on need
so see if it helps you

    private void insertParam()
    {
        try
        {
            string strData = Session["param"].ToString(); ;

            string[] aryData = strData.Split(';');

            ParameterFields paramFields = CrystalReportViewer1.ParameterFieldInfo;

            for (int i = 0; i < aryData.Length; i++)
            {
            ParameterValues param = new ParameterValues();
            ParameterDiscreteValue paramValue = new ParameterDiscreteValue();

            paramValue.Value = aryData[i];

            param.Add(paramValue);

            ParameterField paramField = paramFields[i];
            paramField.CurrentValues = param;
            }
        }
        catch (Exception ex)
        {
            lblError.Text = ex.Message;
        }
    }

Note the following: I sent the parameters seperated by ";" and the parameters types/order should be as it in the report.

Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"




Similar Threads
Thread Thread Starter Forum Replies Last Post
crystal report passing multiple parameter noppanit C# 0 March 20th, 2007 12:32 PM
passing parameter values to the crystal report connect2sandep Crystal Reports 0 December 20th, 2005 06:27 AM
Passing a parameter from VB6 to Crystal Report pavel Pro VB Databases 2 February 2nd, 2005 11:28 PM
Crystal report, passing parameter suni_kutty Crystal Reports 2 October 7th, 2004 03:13 AM
passing parameter to crystal report.net shamala Crystal Reports 2 August 19th, 2004 02:04 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.