Creating report with passed parameter

[ulag]

I have data from stored procedure with passed parameters.

I need to create report like using CR8.5

Section1
state Amount
----- -------
CA $30
TX $25
....

Section2
state Value
----- -------
CA 130
TX 225

I have data by statewise for amount and value
state,amount, value
... ... ...

Can any one help?
I have problems in passed parameter or in grouping by state

Thanks
ulag

 

[mbolek]

From the report designer select your db connection
Then select the stored procedure that you want to use. Crystal will automatically recognize the parameters. Grouping problem create a new group by state and it should do the trick for you

 

[ulag]

Now it prints one page report per state. I want all state together

 

[sommererdbeere]

did you check the "break by page"? selection when you rt. click on the section which you put your stated?

 

[lbass]

If you want to show all the states with amounts, followed by all the states with values, then try using the state and amount field in a main report, and then insert an unlinked subreport into the report footer that uses the state and value fields.

-LB