June 7, 2010 at 5:00 pm
Hi,
I have a table with daily visits from sales persons.
In this table there are few attributes for example....salesperson, customer name, address, main contact and date of the visits like 05.22.2010 13:46:40.
I would like to make daily report which shoould be in real time with some command in order to get always current date.
It means that any manager or user in our company when press button for this report get always all visits per salesperson on current date.
Is it possible to make something like this?
How to make this report?
regards
Jagger
June 7, 2010 at 5:26 pm
I think you can create a Stored Procedure with Input Parameter @CurrentDate. You can filter records based on this parameter.
While calling this Procedure in SSRS report, you can pass Default value Now() for Parameter @CurrentDate. I hope this make sense..
June 8, 2010 at 1:03 am
You can also create a Data Driven Subscription for the same .
and pass a Visiting date as a parameter.
Give a Visiting date =getdate()
Thanks
Sonal Totla
June 11, 2010 at 8:18 am
It would probably easier just to use the sql command in the report, which would be something like
select * from mytable
where date_of_visit >=
--time element has been stripped out
CONVERT(SMALLDATETIME,CONVERT(VARCHAR(20),getdate(),101) )
The above script will return all data from the table only for the day that the report is run.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply