SSRS : How to Show Past 5 weeks data on weekly Basis

I just want to show you how to  design your Report if the Requirement is to show last 5 weeks data from the day the user selected  Date ( default is current day ).

Step 1 : Create Parameter  SelectDate  with Data Type  Date/Time  and Its Default value
=today()

Step 2 : Create Paratemeter StartDate with DataType  Date/Time and Make it Hidden and Its Default value is 
DateAdd
("d",-35,Fields!BirthDate.Value)
 
Step 3 :  Create  Dataset  with Fallowing Query i am just taking sample columns

select convert(varchar(10),DATEADD(DAY, 1-DATEPART(WEEKDAY, DateColumn), DateColumn),103) as [week], Measure from TableName where DateColumn Between @startDate and @SelectDate
 
Step 4 : In the graph select  Week In Category Groups   and Measure column in Measure values section and  Make Sure In Series Properties The Value Filed should have SUM aggreative function on Measure column . 

Comments

Post a Comment

Popular posts from this blog

SQL Server MDS : How to Know Actual MDS Table name for Model Entity and Column name for the Attribute

How to Know Actual MDS Table name for Model Entity and Column name for the Attribute . here is the Script  USE MDS ------------------------------------------------------------ -- TODO: Define Model name, Entity name, and Attribute Name        DECLARE @Model NVARCHAR ( 50 )        = '<<GiveModelName>>' ;        DECLARE @Entity_Name NVARCHAR ( 50 ) = '<<GiveEntityName>>' ;        DECLARE @Attribute_Name NVARCHAR ( 50 )= '<<GiveAttributeName>>' ; ------------------------------------------------------------ -- Set @Table name        DECLARE @Table NVARCHAR ( 128 );              SELECT @Table = EntityTable FROM mdm . viw_SYSTEM_SCHEMA_ENTITY WHERE Model_Name = @Model AND name = @Entity_Name ; --...
Read more

SSRS : [Teradata Database] 3939 There is a mismatch between the number of parameters specified and the number of parameters required.

Error : [Teradata Database] 3939   There is a mismatch between the number of parameters specified and the number of parameters required. When we get this Error : when we are creating SSRS reports on Teradata database and in which when we are using parameters in the dataset in wrong style\format. Just for Info :  to connect Terdata we need to have  .Net Data provider for Terdata  when we installed this on our machine  Then we are able to see Teradata data source type in SSRS. How to Solve this issue :  This error will come if we are not using correct syntax to create parameterized data set .  The correct way is we need to ?  for parameter The report parameters can be named or unnamed. Teradata only supports unnamed parameters. An unnamed parameter is denoted by a ‘?’, and is merely a placeholder for data that is going to be entered at report processing time. For example, the following is a dataset with a single-value ...
Read more

SSAS Error : XML parsing failed at line 1, column 0: A document must contain exactly one root element

when i am planning to redeploy the Cube . I took the latest cube from Production and want to deploy in Dev server . i am getting the fallowing error . Error 33 XML parsing failed at line 1, column 0: A document must contain exactly one root element. .  0 0 Error 34 Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, '\\?\E:\MSSQL\Data\DbR4.194.db\MSC ID.112677.dim.xml'.  0 0 Solution : Go the path specified the in the Error on the deploying server not on you local server . and there you will find that file with 0 KB  . Delete that file and redeploy the project .
Read more