Click here to Skip to main content
15,889,216 members
Articles / SSRS
Alternative
Tip/Trick

SSRS - Error: Subreport could not be shown

Rate me:
Please Sign up or sign in to vote.
0.00/5 (No votes)
10 Nov 2011CPOL 11.1K   2   3
I tried this for the second subreport, Table2, but no subreport for Table2 was displayed:METHOD SubReportEventHandler(sender AS OBJECT, e AS SubreportProcessingEventArgs) AS VOID LOCAL oDS AS ReportDataSource LOCAL table AS datatable // fill table here with the...

I tried this for the second subreport, Table2, but no subreport for Table2 was displayed:


SQL
METHOD SubReportEventHandler(sender AS OBJECT, 
       e AS SubreportProcessingEventArgs) AS VOID
    LOCAL oDS   AS ReportDataSource
    LOCAL table AS datatable
    // fill table here with the appropriate data
    oDS                 := ReportDataSource{"SFMSales",Table}
    e:DataSources:Add(oDS)
oDS                 := ReportDataSource{"SFMSales",Table}
   e:DataSources:Add(oDS)
oDS := ReportDataSource{"SFMSales",Table2}

   e:DataSources:Add(oDS)

Both subreports are in the same directory. How shall I code for the second subreport inside the SubReportEventHandler?

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Unknown
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

 
QuestionProblem with SSRS Authentica​tion - don't want to use Custom Authentica​tion - Please guide Pin
Member 1069685125-Mar-14 4:27
Member 1069685125-Mar-14 4:27 
​Good Morning Sir,

Please guide me.
I am working with SSRS 2008 and I am having problem with Report server Authentication.
I am getting prompted to pass credentials to execute the report.

I am using SSRS report server to display the report information with passing below URL to
iframe control.
"http://<<servername>>/reportserver....."

With the help of Custom Authentication type I am able to generate reports but its not valid authentication.

Please Please guide me.

Thanking you Sir.

Asif .S

hiasifsyed@gmail.com
GeneralThank you so much for the guidance. I am now able to solve m... Pin
ben ong9-Nov-11 23:02
ben ong9-Nov-11 23:02 
GeneralThe SubReportEventHandler is called for each subreport. Here... Pin
Willie Moore9-Nov-11 5:00
Willie Moore9-Nov-11 5:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.