| Author |
Message |
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
   Posted: 11 Aug 2010 at 10:59am |
kind of depends on how the data neesd to be displayed but basically...
group on location as group 1 and change your running totals to reset on group 1 and place them in group footer 1 (new location group footer) to show amounts per location
Edited by DBlank - 11 Aug 2010 at 11:02am
|
 IP Logged |
|
a4chan
Newbie
Joined: 07 Aug 2010
Location: United States
Online Status: Offline
Posts: 21
|
Posted: 11 Aug 2010 at 11:18am |
Well its not working in that way.I need a count which should not effect the original formula i,e laptop or desktop but notboth & laptop and desktop.I can only able to get the count of all in the report footer but not in the group footer for location,date.It is giving arbitrary values.
|
|
a4chan
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 11 Aug 2010 at 11:23am |
|
what are all of the design specs?
|
|
IP Logged |
|
a4chan
Newbie
Joined: 07 Aug 2010
Location: United States
Online Status: Offline
Posts: 21
|
Posted: 11 Aug 2010 at 11:59am |
1
Edited by a4chan - 12 Aug 2010 at 6:20am
|
|
a4chan
|
|
IP Logged |
|
a4chan
Newbie
Joined: 07 Aug 2010
Location: United States
Online Status: Offline
Posts: 21
|
Posted: 11 Aug 2010 at 12:24pm |
SUM ({ @DTflag},{table.date},"daily")>0
and
SUM ({ @LTflag},{table.date},"daily")>0
The formula which you posted earlier is somehow not working for one case and it works perfectly for all others.The case is :
| TID |
Date |
Item |
| 101 |
2/2/2010 |
Laptop |
| 101 |
2/2/2010 |
Desktop |
| 102 |
2/2/2010 |
Laptop |
| 103 |
2/2/2010 |
Desktop |
Distinctcount of laptop and desktop should be 1 but its returning 3 as sum ({ @DTflag}) is 2 and sum({ @LTflag}) is 2 and it is doing a distinct count for all TID's .
The other case is :
| TID |
Date |
Item |
| 101 |
3/1/2010 |
Desktop |
| 102 |
3/1/2010 |
Laptop |
That logic is returning count as 2 for this example infact it should return 0.Can you please help me to resolve this issue ?
Edited by a4chan - 11 Aug 2010 at 4:14pm
|
|
a4chan
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 12 Aug 2010 at 3:55am |
The distinctcounts in the group headers will not work because these are running totals (RTs).
RTs must reside on the rows they are counting to see them incriimenatally change or below the last row to be counted to show the sum (like whileprintingrecords). Move those to the group footers.
Edited by DBlank - 12 Aug 2010 at 3:55am
|
|
IP Logged |
|
a4chan
Newbie
Joined: 07 Aug 2010
Location: United States
Online Status: Offline
Posts: 21
|
Posted: 12 Aug 2010 at 3:58am |
okay.what about this formula :
SUM ({ @DTflag},{table.date},"daily")>0
and
SUM ({ @LTflag},{table.date},"daily")>0
its not working for few cases which I discussed in detail in my earlier post.
|
|
a4chan
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 12 Aug 2010 at 4:04am |
It is because you are missing the group of the customer.
try and insert another groupon customer iD
at group level 2
g1=location
g2=customerid
g3=date (by day)
|
|
IP Logged |
|
a4chan
Newbie
Joined: 07 Aug 2010
Location: United States
Online Status: Offline
Posts: 21
|
Posted: 12 Aug 2010 at 5:01am |
Thanks a bunch !!!! Its working fine :)
|
|
a4chan
|
|
IP Logged |
|
|
|
