Crystal Reports Subreport

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Subreport

<< Prev Page of 2

Author

Message

Carlos
Newbie
Newbie

Joined: 12 May 2011
Online Status: Offline
Posts: 17

Posted: 27 Sep 2011 at 9:49am

Yes that is what i did,

(I couldn't copy paste any screen shot so that you could see by your self)

:-/

Kind Regards,
Carlos

IP Logged

DBlank
Moderator

Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053

Posted: 27 Sep 2011 at 9:53am

what does the output look like then?

IP Logged

Carlos
Newbie
Newbie

Joined: 12 May 2011
Online Status: Offline
Posts: 17

Posted: 27 Sep 2011 at 10:26am

it looks like this
the bold is the outpur from the Sub report and the lines not bold are the main rpt. may I have to say; on the main rpt you will see more invoices link to the same customer and co-num due to the case that the order is invoice again after credited.

Inv-num/seq Cust-num/seq inv-date co-order

757585 0 FR00672 5 10-5-2011 CFR0136

757.611

756996 0 FR05452 1 17-3-2011 CFR0140

757.177

757.631

757632 0 FR05452 1 13-5-2011 CFR0140

757.177

757.631

757633 0 FR05452 1 13-5-2011 CFR0140

757.177

Edited by Carlos - 27 Sep 2011 at 11:06am

Kind Regards,
Carlos

IP Logged

DBlank
Moderator

Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053

Posted: 27 Sep 2011 at 10:59am

in your sample can you indicate what is the problem or duplicated value that should not be showing up per your design requirement.

IP Logged

Carlos
Newbie
Newbie

Joined: 12 May 2011
Online Status: Offline
Posts: 17

Posted: 27 Sep 2011 at 11:19am

example of inv-num 757585 cred-num 757611 is ok, as soon there are more invoices for the same order the creditnote(s) done on the first Invoice are dublicated.

Inv-num/seq Cust-num/seq inv-date co-order

757585	0 OK	FR00672	5	10-5-2011	CFR0136
757.611 Credit num OK
756996	0 OK	FR05452	1	17-3-2011	CFR0140
757.177 Credit num OK
757.631 Credit num OK
757632	0 OK	FR05452	1	13-5-2011	CFR0140
757.177 Cr. num to be deleted
757.631 Cr. num to be deleted
757633	0 OK	FR05452	1	13-5-2011	CFR0140
757.177 Cr. num to be deleted

Kind Regards,
Carlos

IP Logged

DBlank
Moderator

Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053

Posted: 27 Sep 2011 at 11:33am

at first glance this is going to be brutal.

you are running the subreport in group level in the main report.

Each time it runs (once per instance of a group) it is an independent report and the previosu runs have no connection to it. That is why your grouping is 'not working'.

you would have to pass variable from the sub report to the main report back into the sub report and supress on that. You would also have to make it an array that keep sadding values to itself and then using a like or instring to compare the next subreport to it.

very unpleasant process.

Do you really have to use a sub report here?

IP Logged

Carlos
Newbie
Newbie

Joined: 12 May 2011
Online Status: Offline
Posts: 17

Posted: 27 Sep 2011 at 12:06pm

Hi Dblank,

I had try to make a main rpt only but I didn’t succeed to combine the invoices with the Manual Credit notes in one, I will try again on making one main report, as the solution you give me is out of my CR knowledge right now or it will take me some time to figure out how to setup this.

Thank you very much for your advice,

Kind Regards,
Carlos

IP Logged

<< Prev Page of 2

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum