Crystal Link to Sub-reports
Posted on 2013-11-14
Can i use "LIKE" or "STARSWITH" in a Sub-report link?
Does a sub-report read the first record and then process data, and then the second record or does it have to read every record for each link in the sub report?
Created a report that show sales for specific items for specified customers during a date range. I trimmed the item Name to 5 letters in a formula field.
(the item we are comparing against are samples, all samples begin with "SS". Trimed the Item code so that is represents the non-sample item code.)
I create and run a separate report using Parameter fields entering in the Customer number and the Special Item codes and I get data returned. I did this to test linking up the sub-report.
But when I add the sub report to the original report it hangs,(of course I updated the links to the sub report and verified that the Report Selection Formulas are correct.
when I run the report I get some data but when I go to page 2 it seems to hang.
I get the first customer data back, this customer sub-report is blank because it did not meet the criteria for the sub report.
In the main report I have a detail section with the customer number, item number, invoice date, invoice number. quantity sold, and custom filed that I trimed using the MID function well call it SPECIAL ITEM CODE.
This main report is grouped using the Customer number and the detail records are sorted by Date.
I insert the new sub-report into the Group footer for the customer number group.
Because the main report has Customers detail records that do not meet the sub-report links it will return a blank sub-reports (I like to have these records be removed?)
It also seems to stop running, because whenever I go to view the next page of data it locks up and start to recalculate the report?
So....If I can, How do I link the sub-report correctly so that it runs only returns customer sales data that is matched?
Also does it make a big difference which section I insert the sub-report?
I am so close to making this work, I think!