- Right-click the category axis and click Axis Properties. The Axis Properties dialog box opens.
- In Axis Options, set Interval to 1. Every category group label is displayed. If you want to show every other category group label on the x-axis, type 2.
- Click OK.
Tuesday, December 3, 2013
How to show all category labels on the Column Chart SSRS 2012
How to show all category labels on the Column Chart X-Axis SSRS 2012:
Monday, December 2, 2013
How to have a parameter value automatically selected when another parameter value Selected in MS SSRS.
Step 1: Create cascade parameter in SSRS.
Step 2: One Parameter value is depend on another parameter value.
Step 3: The Depending parameter data set always return One Value.
Step 4:In Parameter Select-->Default Value Tab-->Get value from a Query-->Select Dependent data set--Select Value.
Example:
Dataset1:
Dataset2:
Dataset2 is depend on Dataset1.Both data set are using for Parameter in Report.
Result:When we select Snapshot_Wk in one parameter,other two parameter automatically filled with corresponding Wk_Start data and Wk_End Date.
Step 2: One Parameter value is depend on another parameter value.
Step 3: The Depending parameter data set always return One Value.
Step 4:In Parameter Select-->Default Value Tab-->Get value from a Query-->Select Dependent data set--Select Value.
Example:
Dataset1:
select distinct
snapshot_WK
,cast(snapshot_Wkstart as date) as Snapshot_WKstart
,cast(snapshot_Wkend as date) as Snapshot_WKend
from sandbox..[Rawdata_Master](nolock)
order by snapshot_Wk
select top 1
cast(snapshot_Wkstart as date) as Snapshot_WKstart
,cast(snapshot_Wkend as date) as Snapshot_WKend
from sandbox..[Rawdata_Master](nolock)
where snapshot_WK = @Reporting_Wk
Subscribe to:
Posts (Atom)