Can we join stored procedure and command in crystal report ?

[nkshah]

Hi friends,

i have one already developed reports.

now based on some requirments changes, i need to add YTD sales in reports.

i have already built Command for this reports.
Command also used one of tables which contain each month sales data.

Now, i need to add YTD calculation in reports.

so how can i handle this YTD in existing Command or do i need to develoed anohter stored procedure ?

Thanks.

 

[lbass]

It sounds like you are working with a command, not a stored procedure. It is better to use one command as your datasource, instead of linking multiple commands together, since the linking occurs locally and can slow your report. So instead, you should add a subquery for the YTD sales as another "field" in your select statement.

-LB