generate reports using more than one stored procedure in asp.net

Posted by Lakn2 under ASP.NET on 6/20/2011 | Points: 10 | Views : 1926 | Status : [Member] | Replies : 2
i had two sotred procedures

sp1-- i am getting data from two tables

sp2-- i want to calculate sum of total in first table according to some condition

when i get two stored procedures to crystal report it doesn't show any data

Thanks&Regards
LakshmiNarayana Nalluri.



Responses

Posted by: Rajesh_a_kumar on: 7/7/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

Any reporting tool can receive data in single record set (can contain the result of multiple tables or SP). So, either re-design your stored procedure or write one new procedure that gives the result of first 2 stored procedures.

Regards,
Rajesh

Lakn2, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Lakn2 on: 7/7/2011 [Member] Starter | Points: 25

Up
0
Down
i got answer anyway thank you for your reply

Thanks&Regards
LakshmiNarayana Nalluri.

Lakn2, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response