Recent content by nattyborneo

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...