Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: If formula true place check marks on a list Post Reply Post New Topic
Author Message
alzniagara
Newbie
Newbie
Avatar

Joined: 30 Jan 2014
Location: Canada
Online Status: Offline
Posts: 9
Quote alzniagara Replybullet Topic: If formula true place check marks on a list
    Posted: 19 Mar 2014 at 7:32am
Hi - I have 2 tables in my report CLIENT and ATTRIBUTES. They are joined with a left outer join (each client has multiple attributes). I have used the select criteria to choose a single attribute category, and grouped by this category.



I have created a formula for each attribute code in that category that reads like:

if {ATTRIBUTES.CODE} = '11'
then "ü"
else ""

which will print a check mark if true. My trouble is that I need all of my formulas/check marks to appear in a single section of the report. Right now the report prints a new detail section for each "true" formula:



Is there any way I can get the checkmarks to appear on the same list? (btw, my "list" is an embedded word object) I tried a subreport but had the same problems. I feel like this should be such a simple thing to figure out, but I'm totally drawing a blank!

IP IP Logged
otto
Groupie
Groupie


Joined: 17 Mar 2014
Online Status: Offline
Posts: 53
Quote otto Replybullet Posted: 19 Mar 2014 at 8:01am
could you please post a print screen of how the report is printing right now? I mean a print screen where I can see more data, for instance the first page of the report.

Edited by otto - 19 Mar 2014 at 8:22am
IP IP Logged
alzniagara
Newbie
Newbie
Avatar

Joined: 30 Jan 2014
Location: Canada
Online Status: Offline
Posts: 9
Quote alzniagara Replybullet Posted: 19 Mar 2014 at 8:42am
no problem....here is the first page of the report.



the second page just repeats that table with the check mark it different places (like the bottom image in my first post)
IP IP Logged
otto
Groupie
Groupie


Joined: 17 Mar 2014
Online Status: Offline
Posts: 53
Quote otto Replybullet Posted: 19 Mar 2014 at 8:58am
let me see if i understand your report. do you have there that table repeated by each details(ATTRIBUTES)?
IP IP Logged
otto
Groupie
Groupie


Joined: 17 Mar 2014
Online Status: Offline
Posts: 53
Quote otto Replybullet Posted: 19 Mar 2014 at 9:06am
instead of draw the whole table in the details put it on the header or footer and create a sub-report for each check mark
IP IP Logged
alzniagara
Newbie
Newbie
Avatar

Joined: 30 Jan 2014
Location: Canada
Online Status: Offline
Posts: 9
Quote alzniagara Replybullet Posted: 19 Mar 2014 at 9:52am
Ahhh.....thank you! I think that will work. I tried a single subreport, but I do believe a separate subreport for each code might do the trick!
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.018 seconds.