crystal report problem

Posted by Lakn2 under Regular Expressions on 6/24/2011 | Points: 10 | Views : 1328 | Status : [Member] | Replies : 3
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.



Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response