Hi All,
I'm having a problem with a report and can't figure out why?
I will try to describe as much as I can...
I have a report that contains 5 parameters... The Parameters are:
@StaffID BIGINT,
@StartDate DATETIME,
@pBranch VARCHAR(10),
@Group VARCHAR(35),
@StaffFilterID INT,
@Blank BIT
Which are the parameters of the Stored Procedure that is called by the Report.
This report contains a sub report that uses the same Stored Procedure and the Sub Report Links have been set to match the parameters.
When I run the Report in the Crystal Report Viewer or the Crystal Report Web Viewer everything works fine. Where things start going bezerk is when the @Blank bit is set to true. In that case, the Crystal report viewer shows everything fine but the Crystal Report Web Viewer doesn't show any data in the Report and no data in the Sub Report too.
When I remove the Sub Report from the Report, the data is returned in bith Crystal Report Viewer and Web Viewer with the @Blank bit set to true
As soon as I add the subreport to the report and edit the links it behave irradically again... It must be something I'm doing?
I've been busting my head trying to figure it out and searching on the web
Any help is greatly appreciated.
Thank you
JG