date parameter choice SQL/ Crystal Reports date parameter choice SQL/ Crystal Reports sandeep2013 (IS/IT--Management) (OP) 26 Jun 13 13:00 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 Motlatjo (Programmer) 18 Jul 13 03:52 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 SQLScholar (Programmer) 30 Jul 13 10:02 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 ncvandy (MIS) 31 Jul 13 15:56 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.