Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Display data after parameters. Post Reply Post New Topic
Page  of 3 Next >>
Author Message
soulsniper
Newbie
Newbie


Joined: 24 May 2011
Online Status: Offline
Posts: 19
Quote soulsniper Replybullet Topic: Display data after parameters.
    Posted: 19 Jul 2011 at 4:28am
Theres a field that requires data. I've made a report such that whatever you type into this field it will generate the report accordingly. Now, I want to be able to show all data if nothing(null) is put but I realize that if try
 
a={test1} and a={test2} and a= {test3} it won't show as 'a' cannot be all three tables at once. How do I make it so that when a "" aka null is put, that all data is shown(exactly how it is when you just display all data....but doing parameters seems to mess it up)
 
Thank you.


Edited by soulsniper - 19 Jul 2011 at 4:30am
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 19 Jul 2011 at 4:46am
so you arent using parameters? 
do you have something in the record selection?
sharona
IP IP Logged
soulsniper
Newbie
Newbie


Joined: 24 May 2011
Online Status: Offline
Posts: 19
Quote soulsniper Replybullet Posted: 19 Jul 2011 at 4:51am

I do have parameters. I just need to make it so when its null all values in the field show instead of one; as I said before it is exactly how it is when you display all the data without tampering with parameters and getting specific.

 
I'm not sure if there is a feature in CR that allows this or I have to program this myself.


Edited by soulsniper - 19 Jul 2011 at 4:52am
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 19 Jul 2011 at 5:05am
okay, just trying to get a clearer picture on what you need to accomplish
you have parameters that are in the record selection - PLEASE PASTE THAT BELOW.
parameters filter data, dependent on where they are used.
 
how many parameters do you have 3?
sharona
IP IP Logged
soulsniper
Newbie
Newbie


Joined: 24 May 2011
Online Status: Offline
Posts: 19
Quote soulsniper Replybullet Posted: 19 Jul 2011 at 5:15am
Okay, there is a table of values. I made a report to filter out anything that is not the parameter. By default if you make a report the select expert puts it to "any value", but since I've made parameters it uses "formula:". I have two parameters(each with more than one value). 
 
I just want it so when nothing is put it shows all values. The issue is prolly this:
 
if parameter1= "" then
a= ""
 
yet i want 'a' to not be ""(null) i want 'a' to be ALL.
 
let me know if this is clear enough.


Edited by soulsniper - 19 Jul 2011 at 5:15am
IP IP Logged
soulsniper
Newbie
Newbie


Joined: 24 May 2011
Online Status: Offline
Posts: 19
Quote soulsniper Replybullet Posted: 19 Jul 2011 at 5:20am

It evident that "" isn't a value thats why nothingis shown. Is there like a command that will display all the table values? or since i made parameters i have to program further to implement this?
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 19 Jul 2011 at 5:21am
please paste your record selection below.
i would like to see the parameters and the how the report is using them.
sharona
IP IP Logged
soulsniper
Newbie
Newbie


Joined: 24 May 2011
Online Status: Offline
Posts: 19
Quote soulsniper Replybullet Posted: 19 Jul 2011 at 5:29am
if {pam1}= "ADSL" then
{test}= "1"
else if {pam1}= "F10" then
{test}= "32"
else if {pam1}= "F10+" then
{test}= "33"
else if {pam1}= "F100" then
{test}= "34"
else if {pam1}= "F100+" then
{test}= "35"
else if {pam1}= "F1g" then
{test}= "36"
else if {pam1}= "F1g+" then
{test}= "37"
else if {pam1}= "HDSL" then
{test}= "4"
else if {pam1}= "BIHS" then
{test}= "BIHS" and
{test2} = {pam2} and
if {test2}= "" then
{test2}= "I" AND {test}= "R" AND{test2}= "S"                    \\NOTE: this line is what i want so that it is able to show all but doesn't work cause test2 cant be all 3..//
 
 
is that what you awnted?


Edited by soulsniper - 19 Jul 2011 at 5:32am
IP IP Logged
soulsniper
Newbie
Newbie


Joined: 24 May 2011
Online Status: Offline
Posts: 19
Quote soulsniper Replybullet Posted: 19 Jul 2011 at 5:41am

Instead of showing a specific paramter i want it to show all values when it is null("")
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 19 Jul 2011 at 6:04am

try this

go to file
report options
check NULL VALUE BOXES
 
then Add ALL to your parameter setup
take the following and place in a formula
 

if {pam1}= "ADSL" then {test}= "1"
else

if {pam1}= "F10" then {test}= "32"
else

 if {pam1}= "F10+" then {test}= "33"
else

if {pam1}= "F100" then {test}= "34"
else

if {pam1}= "F100+" then {test}= "35"
else

if {pam1}= "F1g" then {test}= "36"
else

if {pam1}= "F1g+" then {test}= "37"
else

if {pam1}= "HDSL" then {test}= "4"
else

if {pam1}= "BIHS" then {test}= "BIHS"  

 
in the record selection paste the following
 

if{pam1}= "ALL" then TRUE else {pam1}= {formula}
 
sharona
IP IP Logged
Page  of 3 Next >>
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.016 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.