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
Great Article. As I read the blog I felt a tug on the heartstrings. it exhibits how much effort has been put into this.
ReplyDeleteIEEE Projects for CSE in Big Data
Spring Framework Corporate TRaining
Final Year Project Centers in Chennai
JavaScript Training in Chennai