Search results for query: *

HI Ibass, I got what you mean... sorry I am just stressfull, actually I also though the same think before but it is somehow mix with other stuff. Thanks for the help... rgds, Nat

Dear Bloomlight, the posible problem is date format is incorrect that cause formula is error. if it is long formula,you can add bracket (isnull ({patient discharge date}) and {patient insurace} = "Medicare") Or ({patient discharge date} >= 8/31/2011 and {patient insurace} = "Medicare")...

What I want is : I have several data CODE value AAB -1 ABC -5 AAB -1 ABC -5 ABC -5 ABC -5 ACC 0 ACC 0 I give formula if {value} = -1.00 then 1 else 0 if {value} = -5.00 then 1 else 0 then group the code and sum the formula flag. It will show CODE -1 -5...

Hi Bloomlight, you can use : isnull ({patient discharge date}) or {patient discharge date} >= 8/31/2011 rgds, Nat

Hi Ibass, the problem is : coulumn b and coulumn c are group value (summary). I think we can't put maximum in summary. or??? rgds, Nat

Dear fisheromacse , coulumn a coulumn b coulumn c AAX 100 0 ABX 0 100 I want to fail the report with divide it by 0 if report only contains value in coulumn c or 0 in both coulumn I need to run the report...

hi all, please help.. I have report coulumn a contain grouping code coulumn b contain summary of a value coulumn c contain summary of b value I suppress the row if both coulumns (b and c) have 0 as value. The report can have several model output like, for ex : coulumn a contain AAX coulumn b...

Dear all, I have one report and result could be changing, like : 1. only one result where sum row a coulumn a = 0.00 sum row a coulumn b = 0.00 2. only one result where sum row a coulumn a > 0.00 sum row a coulumn b = 0.00 3. there are several results where sum row a coulumn a...

hallo, does anyone know how to fail sending report if report is suppresed because contain no data? thanks

Hi Kelvin, may you share the code? how to make it fails? rgds, Nat

Dear Ibass, I just figure it out by using SHARED STRINGVAR but the problem now is.. my result in main report jump to second row. It means 1st row doesn't give any value and it makes all result jump to one row..any idea why it's happen? thanks rgds, LN

Dear all, Unfortunately, I always have problem with share variable. can somebody really help me to understand it. I have a report with sub report. I am trying to not use shared variable in my formula. so...the idea is if I have same value from main report link to sub report, I put flag as YES...

thanks Ibas...

Dear all, in publication, there is function for delivery rule. Deliver individual document when condition is met then I choose deliver only when report contains data I already put formula in the report, to supress report if no value. So it means if there is no value, report will be empty. but...

Dear all, in publication, there is function for delivery rule. Deliver individual document when condition is met then I choose deliver only when report contains data I already put formula in the report, to supress report if no value. So it means if there is no value, report will be empty. but...

Dear Aelsn, could it be possible if you are using section expert and put formula in supress (no drill down) isnull(GH2)

Dear all guru, I want to schedule my report using publication. Is anyone know how to set rule for delivery? for ex : I have 10 reports and I want to send them once. it could be that 2 of those reports contain no value from database, but contain same value generate automatically, like date...

Dear all guru, I hope, it's correct if I am asking BO scheduling here. I have a report (Crystal Report) : A condition Computer OK Printer OK Monitor NO each time in condition column, 'NO' appear, the report should be scheduled. If not, no...

Dear Hilfy, thanks for the help. If I get the result is = 0, I want to supress the zero number. how to do this? tahnks again. rgds, LN

Dear all guru, need urgent your advice... I have table : branch code branch key JPKL 12 USBR 10 USBA -8 JAKL -2 BILO -8 KLMN -2 BILO -8 JAKL -2 JAKL -2 I want to have the result of counting (for -8 and -2)...