HI

I am trying to setup a date paramater in my report. I would like a user to be able to select a from and to date.
I have a main dataset and then another one for the date selection however when I enter a from and to date noe results are displayed.

Below iare my two data sets

Main dataset

SELECT
CASE WHEN clientcode = 'Finance' THEN 'Corporate Services'
WHEN clientcode = 'Information Management Services ' THEN 'Corporate Services'
WHEN clientcode = 'Customer Services' THEN 'Corporate Services'
WHEN clientcode = 'Committee Support Group' THEN 'Corporate Services'
WHEN clientcode = 'network Infrastructure' THEN 'Operations and services'
WHEN clientcode = 'Community Facilities' THEN 'Operationd and Services'
WHEN clientcode = 'Policy' THEN 'Strategic Planning and Policy'
WHEN clientcode = 'Legal' THEN 'Strategic Planning and Policy'
WHEN clientcode = 'Regulatory' THEN 'Regulatory'
WHEN clientcode = 'Building' THEN 'Regulatory'
WHEN clientcode = 'Communications' THEN 'Chief Executive'
WHEN clientcode = 'Human Resources'THEN 'Chief Executive'
WHEN clientcode = 'Executives' THEN 'Chief Executive' END AS Directorate,
ClientCode,
SUBSTRING(Username, 10, 12) AS Username,
SUM(CASE WHEN papersize = 'A0' THEN pages END) AS A0_total,
SUM(CASE WHEN papersize = 'A1' THEN pages END) AS A1_total,
SUM(CASE WHEN papersize = 'A2' THEN pages END) AS A2_total,
SUM(CASE WHEN papersize = 'A3' THEN pages END) AS A3_total,
SUM(CASE WHEN papersize = 'A4' THEN pages END) AS A4_total,
SUM(CASE WHEN papersize = 'A5' THEN pages END) AS A5_total,
SUM(CASE WHEN papersize = 'Legal' THEN pages END) AS Legal_total,
SUM(CASE WHEN papersize = 'DEFAULT' THEN pages END) AS Default_total,
SUM(CASE WHEN papersize = 'Letter' THEN pages END) AS Letter_total
FROM tbl_pcounterlog
WHERE (ClientCode IS NOT NULL) AND (Printer NOT LIKE '\\FDCPKUTILITY\PPUK06') AND (Printer NOT LIKE '\\FDCPKUTILITY\PPUK33 COLOUR') AND
(DatePrinted = @DateFrom) AND (DatePrinted = @DateTo)
GROUP BY ClientCode, Username

Date Dataset

SELECT DISTINCT DatePrinted AS Date
FROM tbl_pcounterlog
WHERE (NOT (ClientCode IS NULL))
ORDER BY DatePrinted

Can anyone tel me where I am going wrong?

Thanks

Greg

Firstly, the way you are handling your dates is probably too restrictive:
Usually, you want a range of data between these two dates:
Secondly, confirm the format of your date when it is passed from the report to the stored procedure. I think the report passes the date as a string (can't be certain though), so you may need to format the date value that is passed in.

E.g.