Hi,
I have a subreport requires input parameters (FromDate and ToDate)to run the underlying SQL server stored procedure. The main report has nothing to do with the subreport except they share the same input parameters (same date range).
The subreport's query runs fine by itself and it is catching the null value and return a string properly when there is no data. However, when I ran the main report with the subreport, after puting in the desired date range, the main report printed out fine but I got an error message from the subreport query saying "Invalid length parameter passed to the substring function". My guess is that the substring function was using a field that contains null value, but when I checked the data, it was not the case. I'd appreciate if anyone can help.
I have a subreport requires input parameters (FromDate and ToDate)to run the underlying SQL server stored procedure. The main report has nothing to do with the subreport except they share the same input parameters (same date range).
The subreport's query runs fine by itself and it is catching the null value and return a string properly when there is no data. However, when I ran the main report with the subreport, after puting in the desired date range, the main report printed out fine but I got an error message from the subreport query saying "Invalid length parameter passed to the substring function". My guess is that the substring function was using a field that contains null value, but when I checked the data, it was not the case. I'd appreciate if anyone can help.