How JustAnswer Works:

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

Ask Julio Your Own Question

Julio
Julio, Computer Software Engineer
Category: Computer
Satisfied Customers: 398
Experience:  Computer Engineer/ Software Troubleshooting
28896607
Type Your Computer Question Here...
Julio is online now
A new question is answered every 9 seconds

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

Resolved Question:

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: 4 years ago.
Category: Computer
Expert:  Richard replied 4 years ago.

Hi there,

 

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

 

 

Customer: replied 4 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?

Expert:  Richard replied 4 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

Customer: replied 4 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?
Expert:  Richard replied 4 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

 

 

 

 

Customer: replied 4 years ago.
Relist: Answer quality.
Expert:  Julio replied 4 years ago.
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, Computer Software Engineer
Category: Computer
Satisfied Customers: 398
Experience: Computer Engineer/ Software Troubleshooting
Julio and 8 other Computer Specialists are ready to help you

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 Customer New York
< Last | Next >
  • 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 Customer New York
  • I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you! RP Austin, 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! Frank Canada
  • 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!!!! Alex Los 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. GP Hesperia, CA
 
 
 

Meet The Experts:

 
 
 
  • Andy

    Computer Consultant

    Satisfied Customers:

    5311
    11yr exp, Comp Engg, Internet expert, Web developer, SEO
< Last | Next >
  • http://ww2.justanswer.com/uploads/EN/Engineer1010/2012-6-9_132423_jaj12a.64x64.jpg Andy's Avatar

    Andy

    Computer Consultant

    Satisfied Customers:

    5311
    11yr exp, Comp Engg, Internet expert, Web developer, SEO
  • http://ww2.justanswer.com/uploads/BA/barrenrock/2011-10-19_215925_JamesJAFinal.64x64.jpg James's Avatar

    James

    Sr. Computer Support Expert

    Satisfied Customers:

    8376
    20 years of experience building, fixing and servicing PCs and operating systems.
  • http://ww2.justanswer.com/uploads/zeyank/2009-09-26_154244_P8110079.png Ryan H.'s Avatar

    Ryan H.

    Computer Support Specialist

    Satisfied Customers:

    1741
    A+ Certified Technician - 10 Years experience working with all types of computer systems.
  • http://ww2.justanswer.com/uploads/JA/jadedangel57/2011-11-8_193134_janenewsm.64x64.jpg Jane Lefler's Avatar

    Jane Lefler

    Sr Prog Analyst / Technician

    Satisfied Customers:

    0
    Computer Programmer / Technician/ Consultant 16+ years
  • http://ww2.justanswer.com/uploads/RO/robmpreston/2013-9-23_233814_mijiFZm.64x64.jpg RPI Solutions's Avatar

    RPI Solutions

    Support Specialist

    Satisfied Customers:

    3476
    5+ Years in IT, BS in Computer Science
  • http://ww2.justanswer.com/uploads/BA/barunrath/2012-7-5_201954_Profilepic2.64x64.jpg B. Rath's Avatar

    B. Rath

    Computer Support Specialist

    Satisfied Customers:

    8671
    Certified Computer/Networking Support Specialist.
  • http://ww2.justanswer.com/uploads/FS/fszcze/2012-6-18_181848_500test.64x64.jpg Frederick S.'s Avatar

    Frederick S.

    Computer Specialist

    Satisfied Customers:

    7240
    Computer technician and founder of a home PC repair company.