In the Report Studio i need to select start Year and end Year.
for this i used date promptand kept range property 'yes'
now if i want only year to be selected from the prompt wat to do.
You can also use a SQL statement in your query to break apart your date field and pull out the year, I'm not sure exactly how you have your dates formated, but "substring()" should work, with the correct converts if needed
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.