Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. wolverinec7

    Exporting issue

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

    Exporting issue

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

    Exporting issue

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

    address field issue

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

    address field issue

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

    graphs

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

    graphs

    just realised you cant supress a line based on a formula! Using Crystal v10
  8. wolverinec7

    graphs

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

    graphs

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

    graphs

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

    graphs

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

    graphs

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

    graphs

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

    split string problem

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

    suppressing blank page after 'new page after' option

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

    suppressing blank page after 'new page after' option

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

    split string problem

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

    split string problem

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

    split string problem

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

    split string problem

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

Part and Inventory Search

Back
Top