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!

  • Congratulations Chris Miller 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: *

  1. gvg356

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

    set up as suggested above means creating the two groups too ..because I created only one group with the condition that you gave me above select day({alldatetimes.datetime}) case 1 to 16 : "Days 01-16" case 17 to 31 : "Days 17+" it's working but the problem is in getting the monthtotal column...
  2. gvg356

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

    I got the report as required based on your advice....I am unable to append the monthtotal column to the report in the second page which contains days 17 to end...Any help is appreciated.....Thanks
  3. gvg356

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

    I created formula and I inserted two groups as you said then I inserted crosstab also then I am getting 24 crosstabs. I am not sure if I am doing it correctly or no. I need only two pages in the first page days 1 to 16 and in the 2nd page 17 to 31 with their totals. Thanks
  4. 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...
  5. gvg356

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

    I tried this way but I am stuck at one poinr I created two sub reports in the main report and in each subreport I used cross tab to generate the totals in each page as of the row total as well as column total... The output is as follows 1st page timeperiod 1/1/2012.....1/16/2012 Total1 0...
  6. gvg356

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

    Thanks.. While I was about to create a group with the above formula it was throwing me an error.. Ther result of the selection formula must be a boolean
  7. gvg356

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

    My version is crystal reports 11 I am not sure how to write the formula for group#2 could you please write the formula in detail if possible and could you please elaborate on how to get month total also ... Thanks a lot .....
  8. gvg356

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

    As per the above post how to display 1/1/2012 to 1/16/2012 in one page and remaining in second page.. The issue that I am facing is I need to get rowtotal and columntotal for each page and monthtotal column in 2nd page is like sum(total1+total2) output should be like 1st page timeperiod...
  9. 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...
  10. gvg356

    How to insert cumulative total row in cross tab

    You solution worked...Thanks a lot
  11. gvg356

    How to insert cumulative total row in cross tab

    I tried it but I did in the wromg way I guess I am getting the sum(total) as single cell. I have a doubt "In design mode, resize the suppressed summary to minimize the height, by drawing the bottom border up" I am not supressing any summary field except the days column...Thank u very much
  12. gvg356

    How to insert cumulative total row in cross tab

    Thanks for your reply. I need both cumulative total and total as well..and cumulative total should be row underneath the total and it should have 12 columns similar to total row but the values should be like in Jan column the value is 8 Feb column it should be 8+10=18 Mar column 18+9(previous...
  13. gvg356

    How to insert cumulative total row in cross tab

    Thanks for your reply. I need both cumulative total and total as well..and cumulative total should be row underneath the total..Thanks
  14. gvg356

    How to insert cumulative total row in cross tab

    I am sorry....for rows I used database field command.days for columns it is command.monthname and the values are command.total so summary is sum(command.total).
  15. gvg356

    How to insert cumulative total row in cross tab

    Thanks for your reply. My version is crystal report 11 Day Jan Feb Mar Apr May...........Dec 1 2 3 3 3 3 2 3 4 3 2 2 3 2 2 2 3 4 . . . 31 1 1 1 1 1 Total 8 10 9...
  16. 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