Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Report boxes Post Reply Post New Topic
Author Message
avila139
Newbie
Newbie


Joined: 19 Jan 2009
Online Status: Offline
Posts: 4
Quote avila139 Replybullet Topic: Report boxes
    Posted: 19 Jan 2009 at 8:22am
I'm new in using crystal and I'd like to know if this is possible to do. I want the report to be able to determine how many rows to create based on a variable in my db. I don't want to have to create 8 rows when some records will only have 5 values and i don't want blamk rows. Not sure if that makes sense...please help.
IP IP Logged
AntDC
Groupie
Groupie
Avatar

Joined: 23 Dec 2008
Online Status: Offline
Posts: 76
Quote AntDC Replybullet Posted: 19 Jan 2009 at 8:27am
Let the SQL in a Command do that for you.

DC
IP IP Logged
avila139
Newbie
Newbie


Joined: 19 Jan 2009
Online Status: Offline
Posts: 4
Quote avila139 Replybullet Posted: 19 Jan 2009 at 8:37am
Thanks, i've been using access and I couldn't get it work so i'll give this a try.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Jan 2009 at 9:25am
Hi avila139,
What kind of variable are you referring to?
When you are grouping data, your detail rows will only display the number of rows that it finds and not disply blank rows (unless you are inserting extra details sections  manually like detail-a, detail-b, details-c, etc.).
For example, your table has a Store Name field and Store Locations field with as many rows as there are locations. Store A has 3 rows in the table and Store B has 7 rows in the table.
If you group on Store Name and put the Store locations on the details it will repeat the details only 3 time for Store A and 7 times for Store B (it will not display blank rows).
If all of your data is on one row and you are creating extra detail rows to handle this you can always conditionally suppress those sections where isnull({field})=true or {field}='' so you don't show blank rows in your report.
IP IP Logged
avila139
Newbie
Newbie


Joined: 19 Jan 2009
Online Status: Offline
Posts: 4
Quote avila139 Replybullet Posted: 19 Jan 2009 at 9:54am

all of my data is on one row in the table.. which is a representation of how many internet/cable/phone plans a person is offered based on their location. i have the report divided into three sections with tables already created in each. the problem is that even when the extra fields are removed the data below doesn't move up on the report. not sure if i made my problem clear in the first post.

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Jan 2009 at 10:03am

You mean you have inserted extra detail sections to handle each possible "internet/cable/phone plans a person is offered based on their location" that is stored in different fields in the same row for that location?

Conditionaly suppress each detail section where that field is NULL or = " " (depending on how your data is stored in the database). Each detail section will have to check against the exact field that is supposed to be displayed in it:
detail-a displays Location1 field so conditionally suppress it with:
isnull({table.location1field})=true or {table.location1field})=''
detail-b displays Location2 field so conditionally suppress it with:
isnull({table.location2field})=true or {table.location2field})=''
Is this accurate as to your set up and will it work for what you are trying to do?
IP IP Logged
avila139
Newbie
Newbie


Joined: 19 Jan 2009
Online Status: Offline
Posts: 4
Quote avila139 Replybullet Posted: 19 Jan 2009 at 11:11am

yes that works, thank you very much!

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.