CR10 Report with Subrep asks to login in twice to SQL server

[DougP]

I have a report that I copied from another one
I also saved the subreport from it and then imported it in my new report.
all reports ask to login to SQL server when started.
The original report just asks one
my new report asks two times (the login box pops up I key in password and then it pops up again)
I know the password is correct cause I paste it in.

all reports use the same stored procedures to run
The main report uses a different stored procedure than the subreport.

Can someone help me with this
Also when the report is run from VB6, it prompts only once and the subreport it then blank


DougP, MCP, A+

 

[bubu2006]

ARE U USING PARAMETER IN YOUR REPORT?

 

[DougP]

yes there are 3 in the main report and 4 in the esubreport
the the first 3 are the same in both reports
Facid
Quarter
Year
Etiology is the additional 4th one on the sub report

DougP, MCP, A+

 

[DougP]

Ok I figured it out
the main report was looking at OLE DB (ADO) connection to SQL server
the subreport was looking at a ODBC (RDO) connection
so that's why it was prompting twice once for each.
now that both sub and main are looking at the same source it only prompts once.



DougP, MCP, A+