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

Posted by Lakn2 under ASP.NET on 6/20/2011 | Points: 10 | Views : 2709 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

Latest Posts