Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Passing data from Subreport to Main report Post Reply Post New Topic
Author Message
BSquare
Newbie
Newbie
Avatar

Joined: 05 Jul 2012
Location: United States
Online Status: Offline
Posts: 5
Quote BSquare Replybullet Topic: Passing data from Subreport to Main report
    Posted: 03 May 2013 at 11:12am
I am still fairly new to subreports so thanks for bearing with me.
I am creating a list of patients that were seen by our mental health clinic but they don't want to see any patients who have ever had any visits to our medical clinic. Due to the range of parameters that was requested on my main report, I thought that a sub report would be the best way to get a list of all of the patients who have been seen by the medical clinic and then eliminate those patients from the main report.
 
Basically, how do I get my list of patients from my subreport to not show up in my main report?
 
Any advice would be greatly appreciated!
 
Thanks!
Kristin
Kristin
EHR Application Specialist
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 06 May 2013 at 4:47am
the only thought that comes to mind is put them in an array in the subreport, and then using shared variables, 'pass' the array to the main report. The main report, I think, could use an IN or you could loop through the array...either way, it should work.

arrays are not the most friendly / useful in CR, they are just 1-D, and I don't use them much, so I don't know the syntax off the top of my head, but you can look at CR Help. You would probably want to dimension the array to relatively large value or use REDIM PRESERVE to allow it to grow.

Hope this leads to a solution.
IP IP Logged
BSquare
Newbie
Newbie
Avatar

Joined: 05 Jul 2012
Location: United States
Online Status: Offline
Posts: 5
Quote BSquare Replybullet Posted: 06 May 2013 at 12:29pm
That's what I was afraid I might have to do after a weekend of thought. Arg. Thank you for your response, I really appreciate it! :)
Kristin
EHR Application Specialist
IP IP Logged
guptaa
Newbie
Newbie


Joined: 21 Feb 2013
Location: United States
Online Status: Offline
Posts: 14
Quote guptaa Replybullet Posted: 23 May 2013 at 3:48pm
still looking for help...?
Please provide the sample data set.

You could write suppress condition while records print...if data allows.
Aradhana
IP IP Logged
Post Reply Post New Topic
Printable version 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



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.