Exec a stored procedure over a view in CR10

[abarroso]

Hello
I'm using CE 10 and SQL2000 I have a view and a stored procedure that performs some calculations over this view.

The thing is that on the view I have "evaluations" made over a period of time recorded in a date field and each "evaluation" has near 40 rows with diferent items/points.
The SP then calculate the nr of "evaluations" and the average points of each item.

My trouble begins when I must set a parameter where CR/CE must ask the report a period of time.

Any ideas of how can this be done? I've set parameters within the SP but I'm not able to execute them in runtime after the report is finished and deployed in CE.
I'm a begginer in CR/CE and I have medium SQL knowledge.
Thanks
AB

 

[pelajhia]

You might want to restate this; it does not seem very clear what the problem is. Some sample data would help.

 

[abarroso]

Thanks for the reply, anyway, my questions is as simple as this: I have a SP with two parameters (Begin DATE and End DATE) this works until the creation of the report. When I try to use the parameters, automaticaly created in CE Business Element, I can't make it run at the time when the report is published (eportfolio) and executed (it shows the parameters input at the time of the creation).
The DATE value does not reside in the SP but on the view where it gets the calculations.
Any clue ?
Thanks

 

[fredp1]

With V8.5, I have added the SP in a Subreport and have passed a Crystal parameter to the sp parameter via the link to the subreport. (I may have added the parameter to a variable and passed it that way)
The Sub was just added to the report header/footer so it just ran once which gave good performance.

I can't help with V10, but if you get stuck with the above approach I can dig up the details.

Cheers
Fred