Recent content by wolverinec7

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

just realised you cant supress a line based on a formula! 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

LB in all the years you've been replying to my posts i think thats a first, its normally my logic thats wrong :) thanks carl 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...

and i have solved the first one so just need help with this minimum date problem Using Crystal v10

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

onlastrecord <> true worked a treat thanks have updated my signature to include my crystal version too rgs carl Using Crystal v10