Page 1 of 1

Conditional field suppression?

Posted: Thu Oct 25, 2007 7:48 pm
by Martha
I need to create a report which shows data for each day of the current month. The day # (1 through current day of month) will be column headers, with 3 buckets of data for each day. I^d like to be able to run this on any day of the month. So, for example, on the 3rd, it would show data for days 1, 2 and 3. On the 31st, it would show data for days 1 through 31. I need to be able to run this automatically. If I export to a worksheet, it can not contain columns for a day # greater than the current day, not even empty ones. Can this be done?____I find export to a pivot table to be unacceptable, based on limited formatting options.____I^m using version 8.1.____Thank you.

=> RE: Conditional field suppression?

Posted: Thu Oct 25, 2007 8:29 pm
by Martha
Okay, I found that if printing (and hopefully exporting to RTF), I could use 31 different header lines, and 31 different detail lines, one of each for each combination of days, using line suppression to print only the header and detail line I wish. Not pretty, but it works.____However, when I use rswrun.exe and have it export to a spreadsheet, it only prints the column headers and no detail.