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...
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
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
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...
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...
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
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 .....
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...
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...
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
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...
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).
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.