Recent content by highsmith

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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