I have two projects, one which has the report object in the designer and on the other I want to have the ability to display reports for custom time ranges.
Originally I tried to use the report viewer to display the filtered report but when I tried to access the report under the ‘reportPath’ property drop down it wasn’t available.
I then tried a different tact by getting the report as a PDF through scripting and then displaying it via the PDF viewer component. This approach allowed me to get access to the report as I could specify the project that the report exists in. So using this technique I could generate the reports no problem, but it seems to run into a problem when I select too long a time range. When this happens the report generates with no data. I know the data and query are solid as I can generate a report for the same time range using a report viewer object. I don’t get any errors so am at a loss to where I should start looking.
So two questions:
1 Can you access reports from other projects using the report viewer? As you can access it through scripting I don’t see why you shouldn’t be able to using the report viewer (although you would probably need a new property for which designer the object lives in).
2 Any ideas why I wouldn’t be able to pull a large time range using the scripting function?
Any ideas would be great