Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Hiding and showing a box on basis of field value Post Reply Post New Topic
Author Message
qasimali84
Newbie
Newbie
Avatar

Joined: 14 Oct 2008
Location: Pakistan
Online Status: Offline
Posts: 27
Quote qasimali84 Replybullet Topic: Hiding and showing a box on basis of field value
     Posted: 14 Oct 2008 at 7:03am
I am new to Crystal reports
 
I have following task to do.
 
I am developing crystal report for Clinical Lab test using VS 2005. My report has four fields.
 
1. Test Id     2. Test Name      3. Test Result      4. Normal Values
 
When there is TestId=18 or 19 It has to show table of normal values at Page footer of that page only. I am using store procedures.
How I will complete this task?
 
Please help me
 
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 14 Oct 2008 at 9:57am
I would create a subreport that shows the table of normal values and put that in the page footer. Second, I would set the suppress property to use a formula like this: 
{table.TestId}<>18 AND {table.TestId}<>19;
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
qasimali84
Newbie
Newbie
Avatar

Joined: 14 Oct 2008
Location: Pakistan
Online Status: Offline
Posts: 27
Quote qasimali84 Replybullet Posted: 15 Oct 2008 at 12:56am

Thanks. It is working.

But now problem is that Page footer is occupying space in other pages, where Testcode <>18 or 19.

Thanks
 
IP IP Logged
qasimali84
Newbie
Newbie
Avatar

Joined: 14 Oct 2008
Location: Pakistan
Online Status: Offline
Posts: 27
Quote qasimali84 Replybullet Posted: 15 Oct 2008 at 1:20am

Thanks

Problem has been solved
IP IP Logged
qasimali84
Newbie
Newbie
Avatar

Joined: 14 Oct 2008
Location: Pakistan
Online Status: Offline
Posts: 27
Quote qasimali84 Replybullet Posted: 15 Oct 2008 at 3:21am
Thanks for help.
it is working only when Test Id=18 or 19  is the last record of that page. If this record is not the last record then Page footer does not display.

Please help
IP IP Logged
Savan
Senior Member
Senior Member
Avatar

Joined: 14 Dec 2007
Location: India
Online Status: Offline
Posts: 162
Quote Savan Replybullet Posted: 15 Oct 2008 at 4:16am

create a runing total forumla "showrec". in the evaluate part select  "use a formula" option. there u can put this condition  table.TestId}<>18 AND {table.TestId}<>19

u can use "showrec" to suppress the page footer. i.e is if showrec <=  0 then supress
Thanks
Savan
IP IP Logged
qasimali84
Newbie
Newbie
Avatar

Joined: 14 Oct 2008
Location: Pakistan
Online Status: Offline
Posts: 27
Quote qasimali84 Replybullet Posted: 15 Oct 2008 at 6:49am
Thanks Savan
Problem has solved.
 
 
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.