Crystal Reports Subreport problem

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Subreport problem

Author	Message
maryammarz Newbie Joined: 17 Jan 2009 Location: Iran Online Status: Offline Posts: 18	Topic: Subreport problem Posted: 26 Jan 2009 at 10:58pm
	I have a subreport and I want to show all Messages at the end of each group. here is my subreport: Group header Detail1 Detal2 Detail3 .... Group footer Message1 + Message2 + Message3 + .... any help would be appriciated. Edited by maryammarz - 26 Jan 2009 at 11:52pm
	IP Logged


catch_meow Newbie Joined: 26 Jan 2009 Location: Philippines Online Status: Offline Posts: 4	Posted: 27 Jan 2009 at 3:45am
	Hi, this might help u... try to put a shared variable in Subreport and Main report. You can then display the message in the main report and just concatenate the messages in one formula box. In subreport formula: whileprintingrecords; Shared Stringvar x:= ToText(message1) In main report formula: whileprintingrecords; Shared Stringvar x; have 3 shared variable x,y,z then use concatenate formula to get them all together.. Have a good day! -cat
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 27 Jan 2009 at 6:46am
	you would probably want the in subreport formulat to be: Whileprintingrecords; shared stringvar x := x + totext(message1) don't forget to have a formula in main report that resets the message for the next group. something like: whileprintingrecords; shared stringvar x := ""; hope this helps.
	IP Logged

maryammarz Newbie Joined: 17 Jan 2009 Location: Iran Online Status: Offline Posts: 18	Posted: 27 Jan 2009 at 9:31pm
	Hi, thanx for ur reply I do the same thing that u said. but this time I got the last record of each group concatenated . any idea? thanks in advance. maryam Edited by maryammarz - 27 Jan 2009 at 9:35pm
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 28 Jan 2009 at 6:37am
	sounds like the formula is being applied in the group footer. The formula should be applied in (probably) the detail section. If you don't want to see the string getting longer and longer, add a line after that just has "" on it. The formula returns the last line to be visible. Hope this helps
	IP Logged

maryammarz Newbie Joined: 17 Jan 2009 Location: Iran Online Status: Offline Posts: 18	Posted: 30 Jan 2009 at 11:01pm
	Thank u lockwelle, It works! just one thing. the last record repeats. how can I fix that?
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 02 Feb 2009 at 6:04am
	did you by chance leave the formula in the group footer? that would cause it to duplicate.
	IP Logged

maryammarz Newbie Joined: 17 Jan 2009 Location: Iran Online Status: Offline Posts: 18	Posted: 03 Feb 2009 at 10:03pm
	mmm... actualy yes. because I want to show this at Group footer. I got it. I create another formula and put it in group footer with this code: Whileprintingrecords; shared stringvar x := x It solve my problem. Edited by maryammarz - 03 Feb 2009 at 10:13pm
	IP Logged

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