Search results for query: *

Okay, a little more tricky but still the same principal: You can apply that same suppression to all of the fields in that band. That way it will still take up the space, but will not print for the ones you don't want.

Why are you using subreports? I've done a similar report to print a sheet of labels for s single patient. I just created what one label would look like, then copied and pasted it several times.

Just do it by row. You can have parameters for ?StartRow and ?StopRow then just put a suppression formula in each Detail band.

replace 0.00 with 2

You can create a formula like {table.accountname} & {table.accountnumber} and group on the formula.

You probably want to filter on the dates and the times separately. Let's say you selected Day Shift for March 1 thru March 4 Your records would include all day for March 2 and 3, not just Day shift. to display your formulas you just need to make your variables shared, and create additional...

Your problem is the AND stringvar Starttime := ""; stringvar Endtime := ""; if {?Days/Nights} = "Day shift" then (starttime := "06:00:00" ; endtime := "17:59:59" ) else (starttime := "18:00:00" ; endtime := "05:59:59" )

What determines the size of your group footer? Is it a string field with "can grow" checked?

You don't need to use cascading for that. (isnull({?NamePrompt}) or {table.name} = {?NamePrompt}) you could also use ({?NamePrompt = "ALL" OR {table.name} = {?NamePrompt})

Having done similar projects, I suggest you also scan for "alternate" spellings of "Weapon

The CRRed would be applied based on the results on the formula that LInda provided.

I would create s delimited string, something like 23/14/17/32 Pass that to the subreport, then use SPLIT to treat it as an array.

This may not be elegant but it works. Replace the first line with local stringvar RAW := {table.yourfield} It will not handle double close brackets well. local stringvar RAW := "ABC[DEF]GHI[HIDE ME]JKL"; local numbervar I :=1; LOCAL NUMBERVAR GOSTOP := 0 ; local stringvar cooked := ""; while...

You may need to change the order of your ifs. Right now if the type is Stock or In Kind, then you would get that sentence, even if the person is a Member.

One way to do this is with Shared variables. First Group on your Member, then split the group footer in two. Suppress the group header, detail, and the second group footer. Create a formula like this: //init shared stringvar memb1 := ' '; shared stringvar memb2 := ' '; shared stringvar memb2...

You can use either NEXT or PREVIOUS depending on which line you need the result on. NEXT({table.admission_date}) - {table.dismissal_date} or {table.admission_date}) - PREVIOUS({table.dismissal_date}) with either one be sure you're testing to see that you're still on the same patient.

Another approach is to apply names to the fields in the SQLL Command, so that would look something like: SELECT table1.keyfield ,table1.address as home_address ,table2.address as work_address from table1 join table2 on table1.keyfield = table2.keyfield

Not exactly clear on what you're trying to get to. Do you want totals by month including each of the last three months, or do you want the last three months rolled up while you do totals for other months individually? If you want to do something like this: Customer ! month 1 10 month 2 15...

You can have a formula that contains the value, then just use that formula in the eval: //@subresult shared numbervar totval Then in your evaluate formula you can use {@subresult}

Are you trying to do something like this: IF {table_date.balance_accrual} > 0 then "Accrual Loans" else "Other