Search results for query: *

Rewob65 In regards to your query about shades of grey for a mono printer, I find the RGB color function very useful. Also FWIW, my personal preference is to use the Mod function instead of Remainder. if GroupNumber mod 2 = 0 then color(R,G,B) else crNoColor // where R,G & B are decimal...

CR8.5/Oracle I have a formula field in a report that holds dates of which some equate to a null value via date(0,0,0). The report details are grouped and I want to determine the minimum date per group for this formulated date field - ignoring the null dates. As it stands, if I do a Minimum...

Thanks LB I'll adopt this approach - have only got 3-4 subreports to worry about. Have minimal experience with the use of subreports so might have some parameter & display issues associated with these sub reports. I'll see how I go!. Thanks again Teddles

Thanks Brian & LB for your advice. I have in fact got my report structured as you suggest, however it doesn't meet my needs. I'm afraid I'm guilty of oversimplifying the problem and haven't clearly put my case. By way of further explanation, I want to be able to provide summary info on other...

Help wanted please. I need to group on a database field that has multiple instances of the same value, with the group being based on the total count of each distinct value. For example: Field Values -pear -orange -pear -plum -plum -apple -orange -pear For the above data set there are: 3x pear...

Thanks LB. The solutions can be so simple when you know how!!. As you can tell by my posts, I haven't quite reached Guru status with CR yet :) Teddles

Thanks for the solution guys - much appreciated. There is one complication however. The last page of my report is the report footer formatted with 'New Page Before'. It contains a summary X-tab table. How can I suppress either the formula providing the alphabetic range or the page footer...

I have a report that groups on a string field. How can I display the alphabetic range of the Grp Header values that list on each page?. e.g. First Grp header on page = CDE Last Grp header on page = FGH Value to display (in page footer) = "C-F". Thanks