Hello
I have a report that effectively needs three datasources, the second two that need to show in datatables, to be set via the calling webpage.
After some failed attempts, I decided to change them to sub reports but the lack of documentation on what exactly needs to be done from start to finish didn't help.
So I've gone back to the data tables as I had and thought I'd use the needdatasource for each of them and grab the data from a method that way rather than from the calling webpage.
Now in debug mode, this does appear to work - it does go into the needdatasource for each and it does show the data on the report correctly.
However, as soon as I publish, the two tables show without any data, just the layouts as if there isn't any data being found.
Here is my needdatasource for one of the tables:
Private Sub QuoteLines_NeedDataSource(sender As Object, e As EventArgs) Handles QuoteLines.NeedDataSource
Dim oQA As New Reports
Dim dsQuoteLines As DataSet = oQA.Report_GetQuoteLines(Me.ReportParameters("QUID").Value)
QuoteLines.DataSource = dsQuoteLines
End Sub
Any ideas??
thanks
I have a report that effectively needs three datasources, the second two that need to show in datatables, to be set via the calling webpage.
After some failed attempts, I decided to change them to sub reports but the lack of documentation on what exactly needs to be done from start to finish didn't help.
So I've gone back to the data tables as I had and thought I'd use the needdatasource for each of them and grab the data from a method that way rather than from the calling webpage.
Now in debug mode, this does appear to work - it does go into the needdatasource for each and it does show the data on the report correctly.
However, as soon as I publish, the two tables show without any data, just the layouts as if there isn't any data being found.
Here is my needdatasource for one of the tables:
Private Sub QuoteLines_NeedDataSource(sender As Object, e As EventArgs) Handles QuoteLines.NeedDataSource
Dim oQA As New Reports
Dim dsQuoteLines As DataSet = oQA.Report_GetQuoteLines(Me.ReportParameters("QUID").Value)
QuoteLines.DataSource = dsQuoteLines
End Sub
Any ideas??
thanks