my sub-report usually prompt for database password

See more:

C#2.0

C#

ASP.NET

CrystalReports

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