Skip to Content
0
Former Member
Dec 03, 2009 at 07:32 PM

Issues once subreport is added to main report.

36 Views

Another question from a new Crystal Reports Developer. I have been battling this one for multiple days. I have built two seperate reports through Crystal Reports that pull their data through an ODBC connection from Remedy ITSM. One report is pulling data through the table AST_AssetPeople. It is pulling the following fields: Asset_ID and Full_Name. The other report is pulling data from the AST_ComputerSystem table showing the following: Name, Category, Type, Item, Model_Number, Serial_Number. I am using the AssetPeople report as the main and the ComputerSystem report as the subreport. When I pull the ComputerSystems report into the AssetPeople report as a subreport, my CR lags very badly. I let CR attempt to pull the data for about 2 hours before I left work the other day and ended up having to leave it overnight. When I came back to work the following day it had finally completed and I was able to view all pages of data. This is with the subreport being added to the details section of my main report. I had sent it to someone else at work that has Crystal Reports on their PC and they were able to run it just fine and it only took a few minutes to get all pages of the data back and viewable. That lead me to think that it was my PC, but when I went over to the other persons PC and logged in with my profile, I had the same problem that I had on my PC. This leads me to believe that it is an issue with the settings. The other person is out for the next week so I cannot verify that my settings match his, so I was wondering if anyone on here might have an idea what may be causing the issues that I am having. Both reports run just fine on their own, as do all my other reports that are simple reports from one table. It is just when I try to pull in a subreport that I have this issue. Any help would be greatly appreciated.