on 03-06-2015 8:54 PM
Hi,
I have a report that groups as such:
Salesperson Name
Customer Number
Order Number
Line Number
Line Item Number
I currently do a lot of collapsing and bucketing, but I don't see where that would affect my new need.
I want to be able to enter a Product number and if that Product doesn't that product isn't on either the Line or the Line Item, then I want to suppress that Order, and all of its detail.
I believe I've worked through something similar by setting a variable associated with the record as it's being selected, but I don't recall how I filtered after that, and associated it with an Order Number.
Hi,
Thank you Dell.
At this point, I don't think a subreport is going to add anything for me. I can't reject a record until I'm satisfied that there are no other records for that same order that meet the criteria.
If a subreport can't return a derived value, then it looks like the slicing needs to be done with the SQL.
Before I go nutty with the SQL (not an expert), will Crystal support temporary tables created within a Command?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can anyone tell me if this possibly needs to be reconstructed with a subreport?
If i break out:
Order Number
Line Number
Line Item Number
into a subreport, then use logic that sets a value in the Order Number Footer, can that value be passed back to the main report to determine if the subreport prints for that Order?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Unfortunately, you can't use a value from a subreport to determine whether that subreport will be suppressed in the main report. The suppression for a section is evaluated prior to the contents of the section.
I might base the subreport on a Command that will filter out any records that don't meet the criteria you want to use for suppression - that way you only get records in the subreport if you have data that you want to show. From there, suppress all of the sections in the subreport if some key field is null. Then turn on "Suppress blank section" for the section in the main report that contains the subreport.
-Dell
Hi Matt,
Do you have an example dataset please?
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.