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!

Recent content by highsmith

  1. highsmith

    Selection

    Are you using the database expert to get your data or did you write a command statement? What database are you using? With such a detailed selection formula I'm guessing you're using the database expert. I would normally accomplish this through my command statement by writing a where...
  2. highsmith

    Selection

    begins with a 9 or just has a 9 in the code? if you want any other one that begins with a 9 use the following: [code] ...and ( {TPB900_CHG_CODE_MST.chg_cod_ext_id} in [ "91000", "91001", "91002", "91003", "91004", "91005", "91006","00002","90435" ,"90285", "00119", "00309", "00325", "00614"...
  3. highsmith

    Report to compare current year with last year based off parameters

    Yeah, you could do it with a subreport, but I generally use subreports for different data sets. What is your selection formula? You can probably do it all there with the addition of 1 parameter to specify the number of years worth of data to pull. cheers -- See and search my pics at...
  4. highsmith

    Report to compare current year with last year based off parameters

    What is your data source and how are you getting at it? With a command statement? I always write SQL commands to a SQL server DB and I would just pull all the data from both years with 1 query. For SQL server guys, this site has a wonderful function for doing date math...
  5. highsmith

    group number skipping suppressed groups

    With a little tweaking I got it working! thanks LB I should have known this, I just wanted to avoid referencing the suppress formula if possible because it's more complicated than I have explained here. I was hoping there was some magic trick I didn't know about to the effect of 'if printed...
  6. highsmith

    group number skipping suppressed groups

    Ok you are thinking along the same lines I did originally. But my suppression formula is specific to group 2. No groups from group 1 are suppressed so it's not going to work. My suppression formula = {@sup_cust}. The suppress properties of GH2 is set to: {@test suppress cust}=true {@sup_cust}...
  7. highsmith

    group number skipping suppressed groups

    Hi Gents, what's the easiest way to run a count of groups printed? I need the following numbering scheme to make my alternating colors work properly. GH1 1 GH2 - (suppressed) GH2 2 GH1 3 GH2 4 GH1 5 GH2 6 GH1 7 using groupnumber, my results would be GH1 1 GH2 2...
  8. highsmith

    Variable number of lines.

    all i can think of is maybe add a subreport that has 1 detail record with a line drawn on it. i'm sure could pass a variable to it to say how many times it should repeat. cheers -- See and search my pics at willhighsmith.com
  9. highsmith

    underlay following selections seems to cover lines

    yeah it's nice. i put a lot more time into the design of my reports than what i've seen from most people. i like the nice slick shiny web 3.0 looks and CR doesn't give you a lot of tools to help. useablilty is important. data is not information and information is not knowledge... yadda...
  10. highsmith

    underlay following selections seems to cover lines

    layering is difficult in CR sometimes. it sure isn't Photoshop! i usually play with the Move Forward and To Front commands on each item until I get it right, but you don't always have the option and when you have images cascading from one section to another it's even more difficult. good...
  11. highsmith

    Variable number of lines.

    what happens if you just draw a line on each A, B & C section of the details? do they repeat on their own or is there always 3 details total per page? are you grouping the data? something with a page break before or afterwards, perhaps? do you want the A,B&C sections to ALWAYS repeat the...
  12. highsmith

    underlay following selections seems to cover lines

    After you get the text box in place on the line, click the lock format and lock size/position buttons so you don't accidentally more it around when you're working with the other fields on the line. then right click on the data fields you say are being hidden and then select Move, then 'to...
  13. highsmith

    subreport grouping error

    i'm pretty certain it's not an issue with the SQL, but just in case... here is the select for my Subreport, all subreports use the same command: select * from ##dailysalesrpt union select * from ##dailyinvoicerpt union select * from ##dailycreditrpt and here is the select in the master...
  14. highsmith

    underlay following selections seems to cover lines

    Sometimes I make a borderless colored box on the line instead of changing the background color of the line. You can set your color control formula on the box just as you can in the section expert. Sometimes when layering images and colors this gives more flexibility in deciding what is 'on...
  15. highsmith

    Need to suppress last inner group footer

    Since I'm asking questions today I'll try to help with a few too! Can you answer these two questions and maybe I can help... Group 1 hdr Group 2 hdr Group 2 ftr Group 2 hdr Group 2 ftr <--you want to suppress just this one? always? Group 1 ftr
See more

Part and Inventory Search

Back
Top