Search results for query: *

I had a feeling there was no way to do what I wanted. I would have liked to set defaults for the range as described, but still allow the user to change these range defaults. A discrete value would thus not suffice in all cases. By the way, today is 09/03/02. Hope your computer clock is not...

Using CR 8.5: I have created a Date Range Parameter. I want to have two different dates be the default for the Start and End of Range, but I don't know how to do this in the Set Default Values screen. It seems I can only have one date be both the default Start and the default End of Date...

Using CR 8.5. I want to set a Date Range Parameter to have, effectively, "No Lower Bound" in the "Set Defaults" window so the user doesn't have to check the "No Lower Bound" check box when running the report. However, the "Set Default Values" screen for...

The Report sections are: RH - always prints PH - doesn't print for page 1 Da - fields/supp. if blank Db - prints formula/supp. if blank RFa- prints formula/supp. if blank...

if not(If {field_name} In [3,5,8,13] Then '') then "" is almost right, Rosemary. I found that: if not ({field_name} IN [3,5,8,13]) Then 'blank' else {field_name] works. Thanks. bjplayer

Thanks for that suggestion. The formula I presented was part of a much longer formula, so the exact thing you suggested would not work, but it did make me think about rearranging the formula. When I did that, I did not even have to use "In." bjplayer

This formula compiles OK: If {field_name} In [3,5,8,13] Then ' ' The following forumula gets a "The Keyword THEN is missing" error: If {field_name} Not In [3,5,8,13] Then ' ' The only change was to negate the condition. I know I have used this without problems in versions prior to...

Boo. And Boo Hoo. bjplayer

I used Set Location to change a table name used in a report. This worked correctly. The old table name was mapped to the new table name, but the old table name still appears a lot of places in the report, including field names. I tried to use Set Alias to replace the old table names in the...

That works! Thanks.

I have a report with 3 groups - group C is the innermost, group B is in the middle and group A is outermost. I would like a page break to occur whenever group A changes, OR whenever group B changes, for example: Pg 1 - Grp A1 Grp B1 Pg 2 - Grp A1 Grp B2 Pg 3 - Grp A2 Grp B2 Pg 4 - Grp A2 Grp...