Computer

For Online Computer Support, Ask a Computer Technician

Ask a Computer Expert,
Get an Answer ASAP!

Computer

I am trying to set up a Crystal report with multivalue parameters.

Customer Question
I do not want the...
I am trying to set up a Crystal report with multivalue parameters. I do not want the user to have to enter any values at all and to have the report interpret this as "ALL". I know how to evaluate the parameter to see if it is null, but I don't know how to build the selection formula so that if the parameter is null, then it selects all records (or doesn't evaluate that parameter at all). I cannot find info on this...
Submitted: 7 years ago.Category: Computer
Show More
Show Less
Ask Your Own Computer Question
Answered in 15 hours by:
5/5/2010
Tech Support Specialist: Richard, Computer Specialist replied 7 years ago
Richard
Richard, Computer Specialist
Category: Computer
Satisfied Customers: 39,354
Experience: Over 20 years of consulting to the IT industry
Verified

Hi there,

 

How about using an if statement in you selection formula for this?

 

 

Ask Your Own Computer Question
Customer reply replied 7 years ago

I have tried using an if statement. Perhaps I am using it incorrectly in the selection formula. Could you give me an example? Say that my selection criteria are

A = 1

and

B = 2

and

insert if statement here

 

How would this work so that I could check to see if my parameter input is null and if so, select all vendors, if not only select the one on the list?

Tech Support Specialist: Richard, Computer Specialist replied 7 years ago

Hi there,

 

I think its best you look at the following link which demonstrates an example of using an if statement in a selection formula

 

Click Me

 

It is also a very good location for additional references

Ask Your Own Computer Question
Customer reply replied 7 years ago
I thought you were supposed to give me an answer not tell me to find the answer myself. I don't use basic syntax in crystal. I also already know how to use if statements. What I tried to do is something like this but it doesn't work.

Selection formula:

A=1 and
B=1 and
If not isnull(?prompt) then C = (?prompt)

Can you give me an example crystal formula that will allow me to select all records if a parameter is passed a null? Do I have to write a stored procedure to handle this?
Tech Support Specialist: Richard, Computer Specialist replied 7 years ago

Hi there,

 

Ok, well what you need to do is conditionally make the select clause in the selection formula.

 

An example is

 

If a = null then

 

d.crystalreportviewer1.SelectionFormula = "{tblname.fieldname}"

 

else

 

d.crystalreportviewer1.SelectionFormula = "{tblname.fieldname}=VALUE"

 

end if

 

But if you do this repeatidly for a number of reports then it would be easier to use a stored procedure so that you can refer to that in all the reports and pass the nessesary value

 

 

 

 

Ask Your Own Computer Question
Customer reply replied 7 years ago
Relist: Answer quality.
Tech Support Specialist: Julio, Computer Software Engineer replied 7 years ago
Julio
Julio, Computer Software Engineer
Category: Computer
Satisfied Customers: 398
Experience: Computer Engineer/ Software Troubleshooting
Verified
Hi,

Thanks for visit Justanswer.com
My name is XXXXX XXXXX I will try to help you solve your problem

On Report - Records - Selection formula use this formula
A=1 and B=1 and iif(isnull(?prompt),true,C=(?prompt))

Thanks
Julio
Julio, Computer Software Engineer
Category: Computer
Satisfied Customers: 398
Experience: Computer Engineer/ Software Troubleshooting
Verified
Julio and 87 other Computer Specialists are ready to help you
Ask your own question now
Ask Julio Your Own Question
Julio
Julio
Julio, Computer Software Engineer
Category: Computer
Satisfied Customers: 398
398 Satisfied Customers
Experience: Computer Engineer/ Software Troubleshooting

Julio is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you!

RPAustin, TX

Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill

Bill M.Schenectady, New York

The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you!

FrankCanada

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

< Previous | Next >

Meet the Experts:

Andy

Andy

Computer Consultant

5,316 satisfied customers

11yr exp, Comp Engg, Internet expert, Web developer, SEO

Engineer John C.

Engineer John C.

Computer Science Engineer

3,227 satisfied customers

Computer Science Engineer with 10 years of experience in Computer Support, and Microsoft, A+ and Cisco certified

Ryan H.

Ryan H.

Computer Support Specialist

1,741 satisfied customers

A+ Certified Technician - 10 Years experience working with all types of computer systems.

Jane Lefler

Jane Lefler

Sr Prog Analyst / Technician

2 satisfied customers

Computer Programmer / Technician/ Consultant 16+ years

Frederick S.

Frederick S.

Computer Specialist

7,241 satisfied customers

Computer technician and founder of a home PC repair company.

lifesaver

lifesaver

Computer Software Engineer

4,288 satisfied customers

Engineering degree in Computer science,Microsoft Certified Professional.JA computer expert.

Sudipto

Sudipto

Hardware Engineer

4,115 satisfied customers

Certificate Course In Computer Maintenance

< Previous | Next >

Related Computer Questions
I replaced all of the ink cartridges. However, the black ink
I replaced all of the ink cartridges. However, the black ink cartridge does not print. I tried two new black cartridges and have the same problem. What should I do? … read more
Kris R
Kris R
IT Manager
Computing
2,241 satisfied customers
I have an Epson scanner and when I scan musical excerpts
Hello, I have an Epson scanner and when I scan musical excerpts with a white background, the scanned image ends up with a pale yellow background. I am using Professional mode but I don't know what set… read more
Kris R
Kris R
IT Manager
Computing
2,241 satisfied customers
My CS3 will open, but not launch docs. I've been talking to
I've been talking to Apple for an hour; no resolution; they say it's the product. By the way, just upgraded Mac OS to 10.13.1. Compatible with CS3? … read more
Ricky Kresslein
Ricky Kresslein
Bachelor\u0027s Degree
447 satisfied customers
I can't get google hangout to work. Some can "invite" me and
I can't get google hangout to work. Some can "invite" me and it works, but when I try to invite them, it doesn't. … read more
Kris R
Kris R
IT Manager
Computing
2,241 satisfied customers
Why am I not able to fax from my printer. Hp 3830. Too many
Too many years ago, however I always was able to fax ubtil I started using Magic Jack. … read more
Kris R
Kris R
IT Manager
Computing
2,241 satisfied customers
While editing, the timeline cursor stopped working ( not
While editing, the timeline cursor stopped working ( not responding) , it changed to green. The system is locked up ....but I did manage to output the file to another drive. The program timeline is fr… read more
Damian Costa
Damian Costa
Owner
Computer Network System Engineer
36 satisfied customers
I can't log into my google mail. It does not recognize me.
I can't log into my google mail. It does not recognize me. Am getting very frustrated. Only one place can I get in. That is on the M apt on my cell phone. Need to get in on my regular google cell apt … read more
IT Miro
IT Miro
Studying for Masters Degree in IT
Bachelor\u0027s Degree
196 satisfied customers
I need to recover my user name and pass word for my yahoo
I need to recover my user name and pass word for my yahoo hosted web site … read more
Kris R
Kris R
IT Manager
Computing
2,241 satisfied customers
Computer states i have no space but i have over a tb of
computer states i have no space but i have over a tb of space left … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
952 satisfied customers
Is there a way in which I can move my Outlook 2007 porgram,
Is there a way in which I can move my Outlook 2007 porgram, including all (All Mail, Task, Business Manager Contacts, and Notes) from one computer to another? Both computers are running Windows XP Pro… read more
lifesaver
lifesaver
Computer Software Engineer
Bachelor's Degree
4,288 satisfied customers
I need to know the Gmail and the password that was used to
i need to know the Gmail and the password ***** was used to sign in in my google gmile on nov10 itcame from my motorola 3 G Phone … read more
Karthik
Karthik
Senior Engineer
Bachelor of Engineering
25 satisfied customers
Nothing on my computer....trying to locate some who uses
nothing on my computer....trying to locate some who uses Skype in Ukraine....how do I do that? … read more
Chris L.
Chris L.
IT/Web Manager
Vocational, Technical or Trade Scho
29 satisfied customers
The Google search feature for the Ohio Agricultural
The Google search feature for the Ohio Agricultural Department ends up with my phone number. The Ag Dept is in Columbus; I'm in Bowling Green. I'm really tired of getting phone calls for the Ag. Dept.… read more
PC_Wizzard
PC_Wizzard
IT Technician
32 satisfied customers
My computer has a black screen with the following error
My computer has a black screen with the following error message. Windows could not start because the following file is missing or corrupt: \system32\hal.dll. Please re-install a copy of the above file… read more
Matt
Matt
2nd Line IT Support / Administrator
Bachelor's Degree
289 satisfied customers
I called for tech support last month and got 2 guys IN INDIA
I called for tech support last month and got 2 guys IN INDIA who worked on … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
952 satisfied customers
For some reason we cannot get connection with Skype. We have
For some reason we cannot get connection with Skype. We have an automatic payment at the moment about $43 paid just recently. All we can get is a drop down window requesting our Skype information. We … read more
Kris R
Kris R
IT Manager
Computing
2,241 satisfied customers
Why I am not to connect to my email account? I have been
none really just trying to regain my connection to my account … read more
Richard
Richard
Computer Specialist
39,354 satisfied customers
I have a problem. My trouble is #11-114048200, and the
I have a problem. My trouble is #11-114048200, and the Orignal Number -880161696. … read more
Russell H.
Russell H.
computer technology consultant
Vocational, Technical or Trade Scho
775 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x