I have a report that's main purpose is to show events with a spend >$200k OR attendance over 60 ppl. The attendance portion is no problem, but the spend is stored in a different table in multiple rows per event so I need to sum it first. I've tried a simple summary field, displaying in the event ID header, which returns the correct value, but isn't available to me in the record selector. I also tried a shared currencyvar in a subreport and passed it to the main report displaying in the details section. It displays correctly but is also unavailable in the record selector. Can anyone help with info on what to try next or what to mod on the other options I've tried? Thanks. I'm in crystal v10.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Summary field or shared variable summary in record selection
- Thread starter huddy33
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question