| Author |
Message |
Carlos
Newbie
Joined: 12 May 2011
Online Status: Offline
Posts: 17
|
  
Topic: Subreport
Posted: 27 Sep 2011 at 2:18am |
Dear all,
I'm using in a Sub report the following formula:
{inv_hdr.inv-num} = Previous ({inv_hdr.inv-num})
However this formula is working only for the first records (rows) where double records are retrieved.
Does any one know how come the formula is not working for the complete report and only for some records?
Thank you for any advice,
|
|
Kind Regards,
Carlos
|
 IP Logged |
|
|
|
Robotacha
Groupie
Joined: 11 Nov 2009
Location: United Kingdom
Online Status: Offline
Posts: 97
|
Posted: 27 Sep 2011 at 5:21am |
im not sure, as you are very vague with your details.
but first glance, It appears your formula is saying:
invoice number matches previous invoice number.
so, surely it would only return matching invoice numbers?
ALSO, im a newbie, so dont assume my comments have any value to them.
just tryign to be helpful. may be better if you explain your situtation more and what you are trying to achieve. Edited by Robotacha - 27 Sep 2011 at 5:22am
|
|
Regards,
Michael Jones
|
| IP Logged |
|
Carlos
Newbie
Joined: 12 May 2011
Online Status: Offline
Posts: 17
|
Posted: 27 Sep 2011 at 7:15am |
Robotacha, indeed I should be clearer on this,
Will try to explain; I want to delete from the sub rpt the double records.
I had tried several things like 'suppress if duplicated', Group by {inv_hdr.inv-num} then suppress with formula previous, suppress on different levels and change the linkage on to the main rpt.
Searching on the web i found out that the formula previous should help on this and it does but not for the complete rpt only for the first records.
So, the main question should be who to delete the double records from this sub-report and or if the formula is OK why is this not deleting the double records from the complete rpt?
Thank you again for the advice, Edited by Carlos - 27 Sep 2011 at 7:17am
|
|
Kind Regards,
Carlos
|
| IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 27 Sep 2011 at 8:20am |
|
if this is just a matter of displaying (in the subreport) then group on the {inv_hdr.inv-num} and suppress all the details and the group footer
Edited by DBlank - 27 Sep 2011 at 8:20am
|
| IP Logged |
|
Carlos
Newbie
Joined: 12 May 2011
Online Status: Offline
Posts: 17
|
Posted: 27 Sep 2011 at 8:44am |
DBlank,
Indeed it is a matter of displaying. I did the steps you mention already but didn't work, however I did it again (you never know!) but the same, still I can see two identical inv-numbers :-) pffff seams to be the end of the tunnel
Thank you,
|
|
Kind Regards,
Carlos
|
| IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 27 Sep 2011 at 8:47am |
for clarity, are you getting duplicates inside one subreport that is then displayed in the main report, or are your duplciated in the main report that are running duplicate sub reports?
|
| IP Logged |
|
Carlos
Newbie
Joined: 12 May 2011
Online Status: Offline
Posts: 17
|
Posted: 27 Sep 2011 at 9:00am |
I hope to have understood your questions:
I have only one sub report and this displayed duplicate data in the main rpt.
|
|
Kind Regards,
Carlos
|
| IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 27 Sep 2011 at 9:11am |
so your sub report is set up as this:
GH (inv-num)
detail - suppressed
GF suppressed
And youa re getting duplicates?
This does not seem feasible... Edited by DBlank - 27 Sep 2011 at 9:12am
|
| IP Logged |
|
Carlos
Newbie
Joined: 12 May 2011
Online Status: Offline
Posts: 17
|
Posted: 27 Sep 2011 at 9:28am |
yes that is what I did, and that is what I don't understand what i'm doing wrong.
now you more or less confirm me that it should work and it doesn't. i'm lost one this.
Thank you any way,
|
|
Kind Regards,
Carlos
|
| IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 27 Sep 2011 at 9:33am |
again for clarity sake
in the sub report
in the section expert
1. in the GH you have set both "Hide(drill down OK)" and "Supress (no Drill down)" to FALSE (unchecked) with no formulas entered ( the x-2 box is blue).
2. the detail is set to "Supress (no Drill Down)" as TRUE with no formulas entered ( the x-2 box is blue)
3. The GF is set to "Supress (no Drill Down)" as TRUE with no formulas entered ( the x-2 box is blue)
|
| IP Logged |
|
|
|
