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 derfloh 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: *

  • Users: scdmh
  • Order by date
  1. scdmh

    Stumped

    Thanks. This really helps. Dianne
  2. scdmh

    Stumped

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

    Stumped

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

    suppress white space in a cross-tab

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

    Need to find employees at certain age during a specific time period

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

    suppress white space in a cross-tab

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

    suppress white space in a cross-tab

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

    Total is for the wrong line on the report

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

    Crosstab too wide for one page

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

    Crosstab too wide for one page

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

    Total is for the wrong line on the report

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

Part and Inventory Search

Back
Top