March 3, 2015 at 8:55 am
have a very simple query to extract data see below with one dataset what I want to do is get YTD and week ending data all from the same dataset. For example I want to get YTD Invoice_date from 20150101 to 20150228 (January 1, 2015 – February 28, 2015), but within my report I want to show for invoice_date from 20150222 - 20150228 (Feburary 22, 215 - February 28 , 2015) in a separate table I want to have two separate tables one for Week ending and YTD. Currently I have two parameters (paraFrom_Date and paraEnd_date). For one of the tables I can query for YTD 20150101 to 20150228, but I don’t know how to ask for 20150222 – 20150228 in the week ending table. Has anybody done this similar to what I want to do? How do I add another parameter for the Week ending table? Please be specific. Thank you in advance.
Select Customer, Sales, Invoice_Date
From CustomerDetail
Where Invoice_Date between 20150101 and 20150228
March 4, 2015 at 7:55 am
alex_martinez (3/3/2015)
have a very simple query to extract data see below with one dataset what I want to do is get YTD and week ending data all from the same dataset. For example I want to get YTD Invoice_date from 20150101 to 20150228 (January 1, 2015 – February 28, 2015), but within my report I want to show for invoice_date from 20150222 - 20150228 (Feburary 22, 215 - February 28 , 2015) in a separate table I want to have two separate tables one for Week ending and YTD. Currently I have two parameters (paraFrom_Date and paraEnd_date). For one of the tables I can query for YTD 20150101 to 20150228, but I don’t know how to ask for 20150222 – 20150228 in the week ending table. Has anybody done this similar to what I want to do? How do I add another parameter for the Week ending table? Please be specific. Thank you in advance.Select Customer, Sales, Invoice_Date
From CustomerDetail
Where Invoice_Date between 20150101 and 20150228
First add a parameter - Report data pane, right click on Parameters, add parameter. Name it something like Weekly YTD Begin Date.
Then add a table to the output, right click in left corner, Tablix Properties. General section, choose the dataset. Filters section, click Add button. In Expression, choose Invoice Date field, Operate >=, and Value field, click fx button on right, in bottom right Category, click on Parameters. In Value pane on bottom right, double click on WeeklyYTD parameter.
This will filter the table using the weekly YTD parameter.
March 4, 2015 at 9:04 am
Thank you SQL Sarah I appreciate your tip. I will give it a try. Thanks again.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply