sub report logon error

ADAC Programming · October 4th, 2005, 02:36 PM

VisitorTotals and VisitorsUnique are subreports that are added to the head of the report WIBStats. I am then outputting them to PDF. Each of these reports work fine if I do them singely, However if I either of the two subreports into the WIBStats report I get a
"CrystalDecisions.CrystalReports.Engine.LogOnExcept ion: Logon failed." error at where the oStream gets set.

I'd appreciate any ideas on how to fix this.
Thanks Dwayne

Code:

FilldsKioskActivitiesHistory1();
FilldsKioskVisitorTotals1();
FilldsKioskVisitorsUnique1();

VisitorTotals1 = new VisitorTotals();        
VisitorTotals1.SetDataSource(this.dsKioskVisitorTotals1); 

VisitorsUnique1 = new VisitorsUnique();        
VisitorsUnique1.SetDataSource(this.dsKioskVisitorsUnique1); 

WIBStats1 = new WIBStats();        
WIBStats1.SetDataSource(this.dsKioskActivitiesHistory1); 

MemoryStream oStream;            
Response.Clear();
Response.Buffer = true;            

oStream = (MemoryStream)WIBStats1.ExportToStream
    (CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);

Response.ContentType = "application/pdf";                

Response.BinaryWrite(oStream.ToArray());
Response.End();

Dwayne http://www.adacprogramming.com
http://www.topwebsitetips.com

ADAC Programming · October 5th, 2005, 05:53 PM

Found my own answer. I've been to a ton of sites where a similar question was posted so I thought I'd Post the answer for the next guy.

Scrap the new instance of VisitorsUnique.rpt. Once you have added the subreport to the main report the instance is already created. Set the DataSource through the main report. Use what ever name the wizard created for the subreport. You add the subreport to the main by right clicking the section you want the subreport in, >>insert, >>subreport.

WIBStats1 = new WIBStats();
WIBStats1.SetDataSource(this.dsKioskActivitiesHist ory1);

WIBStats1.OpenSubreport("VisitorsUnique.rpt").SetD ataSource(this.dsKioskVisitorsUnique1);

MemoryStream oStream;

Dwayne http://www.adacprogramming.com
http://www.topwebsitetips.com