How to pass stored Procedure Parameters to the report?
Answers were Sorted based on User's Feedback
Answer / elaiyaraja nallathambi
Need to Pass it as an Array so that it allows us to Support
multiple Values and From the Report Side we need to write a
formula to Convert the Array into the Comma Seperated Value.
|Is This Answer Correct ?||1 Yes||0 No|
Answer / hema
Choose File -> Options menu. In the Options dialog box
Click the Database tab and ensure that Stored Procedures is
selected. Selecting "Stored Procedures" automatically
displays any available stored procedures when you log on to
an SQL database.
Click OK to exit the Options dialog box.
On the Start Page, click Blank Report.
Locate and select the SQL Server data source that contains
the stored procedure you want to use.
Click Next to go to the Connection Information dialog box.
Enter the required information to log in.
Highlight an SQL stored procedure in the Stored Procedures
folder, and click the > arrow to add it to the Selected
The Enter Parameter Values dialog box appears.
Highlight a parameter in the Parameter Fields list.
Assign a value by typing into the Discrete Value box and
then click OK.
You are returned to the Database Expert.
Click OK and create your report using the fields in the
|Is This Answer Correct ?||11 Yes||14 No|
hi.. i've created a crystal report and one crystal report viewer in windows form. i've two form form1 and form2 in form2 i've kept one button called print. when i press this button it should print the document into .pdf format. without using the crystal report viewers print button.
Can we add any database field once we have chosen ?Close? button?
How do you format your crystal reports so that on exporting to word doc or pdf it will not lose the orginal format
How to open subreport in new ie window using hyperlink button. I used target=new; in the formula field. But it overrides the main window and show the report?
Can we export data of reports into other format like in world doc etc?
hi.. i've one crystal report. i want the report header as "employee database". i dont want to right click->insert and goto text object and insert. i've one aspx page and aspx.cs page also. now i want the "employee database" header to be printed from .cs file. i dont want to pass by parameter also.. i.e is there any option in .cs file something like ReportDocument myreport = new ReportDocument(); myreport.Load(MapPath("~/" + "emp.rpt")); myReport.Reportheader="Employee database"; i hope u have understood this. only thing is from .cs file i want to print the header as employee database. i dont want by passing parameter also... please help....
How to Filter the Crystal reports?
How can i normalize a Crystal Report..??
How to conditionally suppress a field based on whether a page number is odd or even?
how should i highlight a particular column in a report in actuate e designer report? It should be done dynamically while creating report Thanks in advance!!!!!!!!!!
What are field expressions and what are the diff types? (I looked this up in the internet and never found anything with regards to types of field expressions)?
How do we connect to the database?