Can we pass parameter values from Crystal Report prompt?

building reports crystal reports
1

Hi,

Can we pass parameter values from Crystal Report prompt to stored procedure?

I have something like user enters date1 and date2.These dates have to be passed to the stored procedure.

And based on that the stored proc returns data which is to be displayed in the report.

Thanks,

senapatid (BOB member since 2009-04-01)

2

You need to put the parameters in the Stored Procedure, then when the report is connected to the SP it will prompt you to enter the params.

NOTE - Parameter options on the SP are much-more limited than the Parameter options in Crystal.

MJRBIM :canada: (BOB member since 2007-03-23)

3

Yes. you can pass parameters. But make sure you have right data type in both places. e.x: look at the date type in report and declare same thing in the StoreProcedure like
Create or Replace Procedure Procedurename (PStartDate IN DATE type, PEndDate IN DATE type…)

in WHERE clause, ORDER_DATE between PStartDate and PEndDate…

Hope this helps…

remata :us: (BOB member since 2006-04-19)