date parameter choice SQL/ Crystal Reports

[sandeep2013]

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?

 

[Motlatjo]

Hi

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

Motlatjo

 

[SQLScholar]

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

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

----------------------------------------

http://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
----------------------------------------

 

[ncvandy]

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.