crystal report problem

Posted by Lakn2 under Regular Expressions on 6/24/2011 | Points: 10 | Views : 2155 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hi i have two stored procedures
sp1 is getting data from two tables using join query
sp2 is getting data only from table2

table1
--------
regdno    name  doa dod  advance tpa cardno

table2
-------
col1    col2   col3   col4    regdno head

now my problem is when i take sp1 to crystal report it is working fine but when i take sp2 it won't display any data i had searched many sites i did n't get my solution

if any needful info please provide me

Thanks&Regards
LakshmiNarayana Nalluri.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bugwee on: 6/24/2011 [Member] Starter | Points: 25

0	hi Lakn2, What do you mean? u need to put the 2 stored procedures in your crystal report? or you only put stored procedure 1 at a time? Regards, Bugwee Lakn2, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	ya i want two storedprocedures in one cr. Thanks&Regards LakshmiNarayana Nalluri. Lakn2, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bugwee on: 6/24/2011 [Member] Starter | Points: 25

0	Hi, if you are using parameters for you stored procedures then the problem there it might be the parameter you are passing. if not using parameters then try to use 1 Stored Procedure at a time to check if what SP doesn't able to display data. If both SP able to displays data then you may now add the 2 SP into the single CR. Regards, Bugwee Lakn2, if this helps please login to Mark As Answer. \| Alert Moderator

Hi,

if you are using parameters for you stored procedures then the problem there it might be the parameter you are passing.
if not using parameters then try to use 1 Stored Procedure at a time to check if what SP doesn't able to display data.
If both SP able to displays data then you may now add the 2 SP into the single CR.

Regards,
Bugwee

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

Latest Posts