INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

date parameter choice SQL/ Crystal Reports

date parameter choice SQL/ Crystal Reports

(OP)
I have two sets of date parameters in Crystal Reports each has a from and to. If they chose 1 date parameter they do not need to pick the other and vica versa.

process date from/process date to
Claim Live Service Date From/Claim Live Service Date to.

Can i do this in the command in my SQL statment?

RE: date parameter choice SQL/ Crystal Reports

Hi

I do not understand you issue here, do you mean that you want the date parameters to have default values?

Motlatjo

RE: date parameter choice SQL/ Crystal Reports

Have you considered posting on the crystal forum? This forum is for microsoft reporting services

http://www.tek-tips.com/threadminder.cfm?pid=149

----------------------------------------
www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

RE: date parameter choice SQL/ Crystal Reports

Relatively new to SSRS and am looking for some help in the correct formatting for using a parameter in an expression in the table of a report. I am building a report that lists payroll deductions for each employee that then has to compare the deductions between pay periods. When the report is run the user would put in the pay period numbers, 012013 and 022013 for example in two parameters, one for each pay period (pp1 & pp2). My dataset query brings in the correct records, an example being
Pp#     emp#  Ded Code  Amt
012013  118   1000      126.78
022013  118   1000      105.78

In the report what I am looking to do is:
Emp#  Ded Code  Amountpp1  Amountpp2
118    1000          126.78        105.78

My sticking point is getting the correct syntax in the expression in the report so that amountpp1 only lists deductions that are tied to the parameter pp1, i.e. in plain English – Amountpp1=(Fields!prpd_empe_amt.Value) where parameter=pp1.
Hopefully this makes sense to one of you gurus out there.
Thanks in advance for your help

Jim V

Jim

Elegant solutions are nice, but right now I'll settle for whatever works.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close