How to pass stored Procedure Parameters to the report?

Answers were Sorted based on User's Feedback

How to pass stored Procedure Parameters to the report?..

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

How to pass stored Procedure Parameters to the report?..

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.
Click Finish.
Highlight an SQL stored procedure in the Stored Procedures
folder, and click the > arrow to add it to the Selected
Tables list.
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
stored procedure.

Is This Answer Correct ?    11 Yes 14 No

Post New Answer

More Crystal Reports Interview Questions

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.

0 Answers  

Can we add any database field once we have chosen ?Close? button?

2 Answers  

How do you format your crystal reports so that on exporting to word doc or pdf it will not lose the orginal format

3 Answers   Target,

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?

0 Answers  

Can we export data of reports into other format like in world doc etc?

5 Answers  

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....

0 Answers  

How to Filter the Crystal reports?

12 Answers   CCIL, Mammut Building Systems,

How can i normalize a Crystal Report..??

0 Answers   HCL,

How to conditionally suppress a field based on whether a page number is odd or even?

3 Answers  

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!!!!!!!!!!

0 Answers  

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)?

0 Answers  

How do we connect to the database?

6 Answers