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 Shaun E 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: gvg356
  • Content: Threads
  • Order by date
  1. gvg356

    printing null values instead of zeroes

    I have a report output like days Jan Feb Mar..... 1 3 2 2 2 3 .... 31 0 If there is no value in database it should print null but the issue is for the month of feb we don't have 31 but in my report it is printing 0 instead of null values similarly for april also it is...
  2. gvg356

    How to get labels for rows and columns in crosstab by default

    I have a report which needs to look like this timeperiod 1/1/2012 1/2/2012 1/3/2012 1/4/2012 ...1/31/2012 0 1 2 ... 23 but in the database I am missing some, like I have only 0,3,5,6,8,9 but by default I need to get all 24 values(0-23) and even there are some missing dates...
  3. gvg356

    How to insert cumulative total row in cross tab

    I have cross tab table in the following format row1 3 4 5 row2 2 3 4 total 5 7 9 cumulative 5 12 21 total cumulative total is 5, (5+7),(5+7+9) Can anyone help me in generating the cumulative total and how can I insert into...

Part and Inventory Search

Back
Top