Query embedded XML Dataset with parameters for Reporting Services

desiboy69

New Member
I am using an embedded xml dataset for my demo report.\[code\]<Query><ElementPath>Root /S {@FirstConnected (Date), @NumberOfDevices (Decimal)} </ElementPath><XmlData><Root><S FirstConnected="2011-01-01T00:00:00" NumberOfDevices="0"></S><S FirstConnected="2011-02-01T00:00:00" NumberOfDevices="1234"></S><S FirstConnected="2011-03-01T00:00:00" NumberOfDevices="3590"></S><S FirstConnected="2011-04-01T00:00:00" NumberOfDevices="7290"></S><S FirstConnected="2011-05-01T00:00:00" NumberOfDevices="15351"></S></Root></XmlData></Query>\[/code\]How can I pass parameters @StartDate and @EndDate to this query, to retrieve only some of the xml nodes like where FirstConnected >= @StartDate AND FirstConnected <= @EndDate ?
 
Back
Top