Search results for query: *

Thanks. This really helps. Dianne

I'm not sure. Let's say I have a record where the admission date = 12/1/1995 and the discharge date = 2/15/1996 (this is a long-term hospital). My crosstab dates are, for each month, 7/1/1995 through 6/30/1996. The crosstab would indicate "1" for Dec, Jan, and Feb. The other months would be "0".

This has been driving me crazy for a long time now andit keeps cropping up. I need to find out how many patients were in the hospital between two dates. I need to set up a crosstab report based on months: Jan Feb Mar Apr Hospital A Hospital B I have an admission date and a...

The solution was to shrink the headers to the smallest. I went into the Customize Type tab and changed the Orders.Order Date line white (it was red). Then I went to Format Grid Lines and deselected the top horizontal and vertical lines. Once I OK'd out of there I clicked on the actual...

I would use three formulas: Formula 1 - (Date(2009,07,01) - {table.dob})/365.25 Formula 2 - (Date(2011,06,30) - {table.dob})/365.25 Formula 3 - {@Formula 2} - ((Date(2011,6,30) - Date(2009,7,1))/365.25) (I'm sure there are other ways to write this but the first one will determine the...

Can you recreate the problem using the Xtreme database and post a URL to the file?

I have struggled with this same problem. What you need to do is go to the Customize Style tab then click on the "Format Grid Lines" button. From there you can click on the top/header lines then deselect then to be drawn. Dianne

It may be the long way around but I (almost) always set up three variables: xxx-01-init This is where I initialize my variable. xxx-02-eval This is where I evaluate (aggregate, etc). xxx-03-display This is where my final result displays. --------------- zzz This is the field that...

I was the same way. :~/ Luckily I saved it to my desktop. Dianne

There is a sample report at http://diamond.businessobjects.com/node/2899. Click on CM04_Wrapping Crosstab.rpt to download the sample Dianne

Your subreport needs to be in an area above the area where you have the variable field. In this case it would be the group header. You cannot suppress the group header or the subreort won't run. However you can make the font of the fields within the subreport white and well as the subreport...