thanks LB. using your logic i tried 'if totalpagecount > 1 then pagenumber = totalpagecount' in the supress x-2 and that worked too
thanks again
carl
Using Crystal v10
lbass, once again you've helped me out as you have many times over the years. however i was wondering if you could explain what its doing and why this works and my suppress formula doesnt. the reason being is that in 10 years writing crystal reports i've always worked stand alone so when i've...
Hi, i've designed a report showing some basic data with a cross tab at the bottom. some staff will simply print the last page to use, others will export the data to use in other reports/spreadsheets etc.
the issue i have is that if i suppress the page header on my last page where the cross tab...
for anyone who's interested i solved my own problem :)
where {@address},= addr1 & ", " & addr2 & ", " & addr2 & ", "& addr4 & ", " & addr5
i used:
Local stringvar array x := split({@address},',');local stringvar y;local numbervar i;for i := 1 to ubound(x)Do( if x[i] <> '' then y...
hi all, i have written a letter using crystal bringing a number of fields through. at the top are the 5 address fields. however my data isnt 100% complete. some might have nothing in addr 2 but something in 3 so there's a gap in the address which looks bad.
i know the answer is using an array...
as soon as i put that i knew text box was the answer. so i created 13 of them, all under the dates with a red * and formula like:
supress if week 1 < target
supress if week 1 < target or target > week 2
etc and it works :)
thanks again
Using Crystal v10
LB i've thought of a differnt way. by solving problem one, i.e. running totals across the top of the graph i can then say if sumweek1<target then supress line 1 (repeat 13 times)
however i cant put a line infront of a graph it always puts it behind!!!
any thoughts?
Using Crystal v10
Hi LB, the problem is that it would be very rare that the target amount is = the running total amount. our targets are very obscure figures (as its whats owed to lenders at the time). so my formula is simply if a payment puts it over the target then that paydate so i get a rowset like
pay amt...
with regards to the second bit i've created a running total of cash rec'd and a formula that says
if RT0>target then paymentdate
that returns nulls until it hits target then payment dates every time after but i cant summarise that formula to say minimum(X) becasue if i could i could create 13...
Hi all, i have a list of cash payments which i've grouped in 12 weeks plus one at the end for >12 weeks to show a timeline of cash recieved from start of a job.
i've produced a line graph easy enough but they want two things on there i cant do.
firstly they want a running total across the...
no problem thanks for trying for me. arrays are something ive never been able to work. think i might be in need of a refresher course.
Using Crystal v10
i know i should know this but i cant think of it. i need each group summary table to be on its own page but obv selecing new page after the group footer in the section expert produces a blank last page and i cant remember how to get rid of it
thanks
lbass just to let you know i've discovered another table that gave these staff specific roles in the case so i was able to use that to do a cross tab report on there.
thanks for your help though
carl
sorry i misunderstood. its a rolling figure, so a staff member who leaves today will eventually drop off as they're only looking at cases going back a certain time. however once its stamped onto a case then no it wont change they've handled that case so they're involved till its closed.
however...
there can only every be five staff on one case but there can be as little as one. but its added to the same field so it can either just say
SQW or
SQW/CXB or
SQW/CXB/BR
so i've split them into 5 sep fields but i need to count the status of cases each persons on.
lbass im hoping you can help with this one. for each case we have upto 5 ppl involved (which i've split into 5 usernames) as above and for each line there is a status (1-3) so for eg i have
case status person1 person2 person3 person4 person5
A 2 SQW CXB...
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.