I'm working on my first SSRS report project and I'm a bit confused. I've design my own custom report that looks exactly like my invoice template in Excel. My goal is to have this invoice/report in a schedule to send out to customers on a monthly basis.
However, my problem is getting the data into the fields of my report. I've been using tables to insert data but it is not working out so well. I created a data set with the following query:
SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY]
The value expression for the field:SELECT CONVERT(VARCHAR(10),
GETDATE(), 103) AS [DD/MM/YYYY] contains an error. Expression Expected
Please go through the link to understand how to create datasets and populate date on to your reports
The steps to create a dataset which retrieves current date is
1.Create a new dataset .Go to the data tab of your report and click on the drop down menu and select < new Dataset >
3.When u click ok ,you will see the newly created dataset in the dataset windows
4.You can execute the sql query just to verify whether you are getting the current date or not .
5.Then in the Layout panel drag a Textbox in the header and then drag the column from the newly created dataset into it or you can write an expression
There is another way of getting the current date and time from SSRS itself instead of creating a dataset .You can use the inbuilt date and time functions in the SSRS .