i m using a sub-report where i need the parent data to be displayed then one field of the parent data i need to send it to a stored procedure for some processing the return a table for the child data
i m using sql datasource to provide the data to the report - i faced a lot of problems to send parameter from parent to child datasources
i found the solution but i dont know if it is correct or no - so i attached a simillar one like what i need depending on northwind database (sql 2000) so that any one can try to downlload and help me plz
i am using CrystalReportSource
then i add CrystalReportSource1 to the page and go to properties of CrystalReportSource1
and then Report
and then add the datasources for the main report and the sub
and then add the parameters
all these properties in the CrystalReportSource1 properties
ALL is going ok but
AFTER prompting for logon
THEN i write the password
THEN the report display data in the right way
SO what am i wrong with this
can anyone take a look on my crystal reports
http://www.4shared.com/file/YMPWN_7V/WebSite1.html[
^]
and could u plz help me investigate this strange problem
taking into consideration
that when i try to run a report with no
sub report and no sub data
it goes right
without any prompt
thank u in advance