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.
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...
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})
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}
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.