Broken Report, Push Model

Ok, so I messed up a report I'm working on big time, I'm using, and have a dataset as where I'm pulling my data from.  I fill this dataset from code, send it to the report at runtime and it USED to work great!...until...

I added a new field to my dataset, and tried to get crystal report to update it, so I could use the new field from within the report.  I started doing things I probably shouldn't have done, like "Log Off/On Server" and "Add/Remove Database"  Well I messed it up somehow, and now when I try to run the report, which ran great and I haven't made changes to the code, I get the dreaded "logon failed" error.  This confuses me, because the report shouldn't be "logging" onto anything.  The report itself seems like it should work, my original database table is there, and when I view how this is connected it us using the classfile of the DataSet.   Let me describe what is happening...

'ds is my dataset, already filled

Dim oRpt As ReportDocument = New ReportDocument
oRpt.Load("E:\myReport.rpt", OpenReportMethod.OpenReportByDefault)
oRpt.SetDataSource(ds) 'When I step through the code, when I execute this line, I get about a 30 second delay, churns my processor really good, but the error doesn't happen at this point

Dim oStream As MemoryStream = CType(oRpt.ExportToStream(ExportFormatType.PortableDocFormat), MemoryStream) <-- error occurs immediately when I hit this line

The ugly error:
[LogOnException: Logon failed.]
   .F(String       , EngineExceptionErrorID 
) +506
   .A(Int16 , Int32 )
   .@(Int16 )
   CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
   CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType)
   Intranet.ScheduleInvestments.Page_Load(Object sender, EventArgs e) in E:\www\Intranet\financial_reporting\ScheduleInvestments.aspx.vb:77
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +750
LVL 33
Who is Participating?
moduloConnect With a Mentor Commented:
PAQ-ing the question and refunding 500  points

Thanks mlmcc !


Community Support Moderator
Experts Exchange
To get the reort to see "new" fields you need to Verify the Database.

Open the report

raterusAuthor Commented:
Oh, I tried that originally, don't remember it working.  This isn't my problem now though.  Any ideas on my current problem?
raterusAuthor Commented:
Push Model + Extraordinary Large DataSet = Logon failed errors

I had a simple error in my sql statement getting the data, it resulted in a mass amount of data being sent to my crystal report, which broke everything.  As soon as I fixed that the report started working again.
No problem.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.