I have this report which is taking about 15-24 seconds to show in my custom preview form, the preview form will show up blank with the "No Report" label (see image RSS slow loading), then the report will be shown normally.

I know that the data is coming out in less than a second, and the preview form is shown without the report, I have not found a way to display a message to the user letting him/her know that the report is being process.  The code to generate the report is splitted in two classes:

• ServiceCallRouteDataSource.vb will take care of getting the data and pass it to the report with the following code:

'-- Assign the populated datasource from the Dialog Browser to the Report Manager Object.
ReportManagerObject.DataSources.Item(reportDataSourceName) = Me.DataSource
ReportManagerObject.DataSources.Item(reportApplianceDataSourceName) = Me.DataSource.SourceBO.SC_Appliances
'-- Prepare Report to run
ReportManagerObject.Reports(Me.PerpetuumSoftReportName).Prepare()

• ReportEngine.vb will actually run the report in the custom preview form like this:

Public Shared Function RunReport(ByVal ReportName As FixTrackReports, _
ByVal ReportManagerObject As PerpetuumSoft.Reporting.Components.ReportManager, _
Optional ByVal tBDStringValue As String = "", _
Optional ByVal tEmployeePK As Int64 = 0) As Boolean
     Dim reportDataSourceObject As IReportDataSource
     '-- Get the data source for the report
     reportDataSourceObject = GetReportDataSource(ReportName)
     '-- Populate the data source
     If reportDataSourceObject.PopulateDataSource(ReportManagerObject, tBDStringValue, tEmployeePK) Then
          Dim f As New ReportViewerDialog()
          '-- Set the Report Viewer source with the Report to be used.
          f.rptViewer.Source = ReportManagerObject.Reports(reportDataSourceObject.PerpetuumSoftReportName)
          f.Title = MicroFour.StrataFrame.Tools.Common.GetEnumDisplayValue(ReportName)
          f.TitleDetailText = ""
          f.ShowDialog()
          Return True
     Else
          MicroFour.StrataFrame.Messaging.MessageForm.ShowMessageByKey("NoDataForReport")
          Return False
     End If
End Function

I have other simple reports which generates faster, so I must be missing something in my whole process.  I will appreciate if somebody can see what am I missing here?

Thanks.

Once the RSS engine is handed the data set, it will genereate the report pretty fast.  The slow part always comes when gathering data.  We gather all data prior to caling the report itself.  We have a unique stored procedure for each report that we create that gathers all of the result sets and is optimized to make sure that the loading of the data is fast.  So you need to figure out where your slowness is.

How long is it taking to gather the result sets alone?  This is generally the slow spot.  Are you creating sprocs (genreally a good idea to improve performance)?  Also, are you show a "generating report dialog" while RSS is generating the report?  They have one by default that you can show, but we created our own and you can replace theirs.  They have an implementation called IRenderSite that you can use to create a render status.  When you call the ReportSLot.Prepare method, you can supply class that implements IRenderSite that will show dialog that you create (if that is what you want to do).  This way you can at least see that the rendering is taking place.

Well I have a Custom Field Property "CustomerBuildingAddress" used like this:

GetData("ServiceCallProfileDS.CustomerBuildingAddress")+ " Apt " + GetData("ServiceCallProfileDS.Apt_No")

I did a simple test and use the Building Adress FK an ran the report and it took 11 Secs instead of 37 Secs.  Here is the code for the Custom Field Property which I created in the main bo, not the report bo.

Public ReadOnly Property [CustomerBuildingAddress]() As System.String
     Get
          Dim loBusinessObject As New bizBuildings
          loBusinessObject.FillByPrimaryKey(Me.FK_Buildings)
          If loBusinessObject.Count = 1 Then
               Return String.Format("{0}, {1} {2}", loBusinessObject.Street, loBusinessObject.City, loBusinessObject.State)
          Else
               Return String.Empty
          End If
          loBusinessObject.Dispose()
     End Get
End Property

Yes, I am using a SP (thanks to Dustin for the clarification in another thread).  The gathering of the data takes milliseconds, so it is pretty quick, I think my problem is with the Custom Field Properties, which are really nice, but guess I will need to use another solution to show those lookup fields descriptions.

I was not aware of such dialog, but yes I need to implement it, without it the user gets the impression that no report is being generated or that the system is freeze.  I am using my own ReportViewerDialog and classes logic used in the StrataFlix, it took me some time to digest, but after that and with yours and Ivan help I was able to get it running with RSS, one thing that I also noticed is that after a report has been rendered and the preview form is closed, when a new report is generated, the image of the previous one will be shown until the new process completes the rendering, is there a way to overcome this?

Trent, I have been looking in RSS help file and could not find any reference to this dialog or how to make my report use the default one.  RSS site seems to be down, if possible could you tell me how to make use of the default dialog?

One more question if you don't mind I have some Custom Field Properties (CFP) in the main BO, which when using the BBS builder, will create a report bo inheriting the main bo and then will have those CFP, is there any way to remove those CFP from the report BO?

Overridable would work in my case, since I will refactor those Custom Properties but since they are used in some forms I don't want to redo the whole thing, I want to refactor them for the report only, to see if I can gain some speed in the process.