| Author |
Message |
_Wired_
Newbie
Joined: 15 May 2009
Online Status: Offline
Posts: 30
|
   Posted: 02 Jun 2009 at 10:04pm |
|
thanks for the reply... there's no SUM on the summary.. only maximum, minimum, count, distinct count, mode, Nth largest, Nth smallest, and Nth most frequent... sorry.. im new in CR.. :)
|
 IP Logged |
|
_Wired_
Newbie
Joined: 15 May 2009
Online Status: Offline
Posts: 30
|
Posted: 02 Jun 2009 at 11:06pm |
|
sorry sorry... my bad.. i declare the "countofworkers" as text... hehehehe.. thanks for your help.... god bless
|
|
IP Logged |
|
_Wired_
Newbie
Joined: 15 May 2009
Online Status: Offline
Posts: 30
|
Posted: 16 Jun 2009 at 7:39pm |
i have another problem... ORIGINAL CROSSTAB direct link of the pic >> http://i39.tinypic.com/xqknir.jpg I put two textobject and 3 lines:
direct link of the pic >> http://i41.tinypic.com/r8tf95.jpg
Here's the problem.. in the first page.. i can see the textobject and lines that I inserted.. but in the second page, it's gone.. what seems to be the problem on it? I put the crosstab in the report footer section.
direct link of the pic >> http://i40.tinypic.com/2n1991j.jpg
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 17 Jun 2009 at 4:03pm |
Hey Wired,
I am not sure how you will be able to do this. The crosstab can be set to repeat the headers on each page but your text objects and lines are not technically part of the headers. They will not repeat unless they are part of the header.
|
|
IP Logged |
|
_Wired_
Newbie
Joined: 15 May 2009
Online Status: Offline
Posts: 30
|
Posted: 17 Jun 2009 at 6:10pm |
|
thanks for the reply...
i already figure it out.. just make another report footer section.. and put the objects that u want to show in the second page... just align it...
i don't know what will happen if there will be a third page... hehehehe
maybe make another report footer again.. hehehehe..
i hope this will help to those who has the same problem.. god bless..
|
|
IP Logged |
|
_Wired_
Newbie
Joined: 15 May 2009
Online Status: Offline
Posts: 30
|
Posted: 23 Jun 2009 at 8:23pm |
|
i have problem again.... im trying to put another crosstab.. but the number of employees messed up... it doesn't show the original count of the employee... im trying to sum up the grand totals of the two crosstab... BTW i inserted another database fields for the data of my second crosstab..
Edited by _Wired_ - 23 Jun 2009 at 10:35pm
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 24 Jun 2009 at 6:59am |
Sorry, having trouble understanding exactly how you need this presented.
I saw your other post and would agree with lockwelle's response on that. The grnad totals in the crosstab can be garnered via another solution and those two solutions can be added via a formula. For example:
formula1 as SUM(table1.field1)
formula2 as COUNT(table2. fieldA)
formula 3 as formula1 + formula2
|
|
IP Logged |
|
_Wired_
Newbie
Joined: 15 May 2009
Online Status: Offline
Posts: 30
|
Posted: 24 Jun 2009 at 6:25pm |
THANKS FOR THE REPLY.. THIS IS MY DATAFIELD
MY REPORT WITH 1 CROSSTAB
THEN I INSERT ANOTHER CROSSTAB... LOOK AT THE DATA'S ON MY FIRST CROSSTAB... IT CHANGED.. EVEN THE 2ND CROSSTAB IT DOESN'T GIVE ME THE EXACT DATA
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 24 Jun 2009 at 7:08pm |
By adding in the second table you increased your data lines (looks like by 4). Since your crosstab sums the data rows your numbers will increase.
YOu can delete crosstab2 and your numbers will still be too large in crosstab1. It was adding the table to the report that did it not adding the crosstab.
You may have to do this as a subreport. You can used shared variables to get a sum from table2 and move it to the main report and add it to a sum from table 1 in there.
|
|
IP Logged |
|
_Wired_
Newbie
Joined: 15 May 2009
Online Status: Offline
Posts: 30
|
Posted: 24 Jun 2009 at 7:32pm |
|
thanks.. how do i add the grand total of crosstab 1 and grandtotal of the subreport?
|
|
IP Logged |
|
|
|
