sql - get data into report ssrs -

i'm working on first ssrs report project , i'm bit confused. i've design own custom report looks invoice template in excel. goal have invoice/report in schedule send out customers on monthly basis.

however, problem getting data fields of report. i've been using tables insert data not working out well. created data set following query:

select convert(varchar(10), getdate(), 103) [dd/mm/yyyy] 

the column: dd/mm/yyyy not exist in database, current date. receiving error saying:

the value expression field:select convert(varchar(10), getdate(), 103) [dd/mm/yyyy] contains error. expression expected

there other calculation other parts of report. question is, data want put tables have column in database? or can create them using ssrs? thanks

please go through link understand how create datasets , populate date on reports

working datasets

the steps create dataset retrieves current date

1.create new dataset .go data tab of report , click on drop down menu , select < new dataset >

2. a dialog box appear u need enter sql query

3.when u click ok ,you see newly created dataset in dataset windows

4.you can execute sql query verify whether getting current date or not .

5.then in layout panel drag textbox in header , drag column newly created dataset or can write expression

  =first(fields!dd_mm_yyyy.value, "gettingdate") 

there way of getting current date , time ssrs instead of creating dataset .you can use inbuilt date , time functions in ssrs .