Search results for query: *

I need to conditionally suppress rows in my Crystal 8.5 report. Psuedo If parameter = 'Yes' AND column B = '123' then suppress row. Example ======= col_a, col_b, col_c AAA BBB CCC KKK 123 CCC -- Suppress this row NMB N78 KLK Parameter = 'Yes' Desired Outcome...

Thanks Reboo and Everyone else. Tatips

Thanks for reply reboo but I dont think its quite there. i may be wrong though. My dates are 04-JUN-2004 and 01-JUL-2004: This makes it 26 days in total the formula returns 4 Weeks and 3 days. I make it 26/7 = 3 Weeks and 5 Days. Not sure here. Thanks. ta.

Hi: can anyone suggest how to calculate the difference between two dates in Weeks and Days please ? Eg. 3 Weeks 2 Days Thanks. Ta.

To clarify: IF {tab_a.field1} = 'A' THEN crbold NOTE: I cant seem to get "crbold" to work. Is "crbold" valid. it seems to compile but text stays the same. Thanks for the suggestion by the way. Ta.

HI: How can I set a text object to BOLD programmatically. Thanks. Ta.

Hi: In my report I have a formula that returns ‘Number of people’ +' '+ ToText(count_ppl). Count_ppl is a variable and calculated. The problem is that I am selecting this in the Select Expert in that I am looking for records “Is equal to” , ‘Number of people’ but of course this formula is...

Hi: When I check the "Repeat Group Header on Each Page" box in the "Change Group Options" dialog box, How can I append "Continued...." for all headers repeated ? Thanks. Ta.

What "Rep trigger" are u calling it from ?

Thank You Hammerman.

NOTE: The columnm is CUSTOMER_AGE. eg.30 No DOB arithmetic is required just how to group according to a number column. Ta.

hi: I need to create groups in my report based on Age.. For example.. 30 - 50 and 60 - 70 The column is a number column. Any examples of how to create these groups please ? Thanks. Tatips.

Cheers guys the d/load worked okay

Thanks Guys. Is the Do/load process easy and will it screw up my fresh 2 day old pc with xp ? Tatips

hI: I have I/Explorer 6 and I want to Enable Java on it. The way to do this is via Tools, Internet Options, Advanced and then scroll down to Microsoft VM option and enable a few swithces in list. But there is NO "Microsoft VM" node in my list so I cannot Enable Java. Can anyone...

Hi: My forms6i(c/s) has an attached library. The problem is that when I call a FUNCTION in the library I get a ORA-06508 "Could not find program....". When I drag the FUNCTION from the library down to the PROGRAM UNIT node (so that it is explicitly defind at prog unit level)it works...

Hi: Is it possible to schedule a job on the DB to run a Report 6i object every month, for example. We are using 6i (c/s) on an 8i(8.1.7). So the benefits to be gained from the reports server functionality is sadly out of our reach. Thanks, Pradeep

Thanks Nagornyi, Sounds Nice. N

I can help you with 1. The link is always there. Its created much in the same way as a sequence is. So the link will only expire when the link is dropped. Happy new year. N

Hi: Reports 6i (c/s) Sometimes I need to count "distinct" values in a report in a summary column, which I believe is not possible, so it is neccessary to code a 'SELECT' statement to get a distinct count of a column. This can have impact on performance especially at GROUP level...