Hello.
I'm trying to create a report that depends on what a user enters, a different SELECT statement is to run. For example, if a user enters a calendar year value, then a SELECT statement for the calendar year runs. If a user enters a fiscal year value, then a SELECT statement for the fiscal year runs. I didn't even know that I could do this from the Command windows to begin with. My code looks like:
IF ( ({?BeginCY}) = ' ' ) BEGIN select fiscal_year,station_response_area_category, count(*) as Incident_count from dw_prod.dbo.vw_unit_response where fiscal_year between {?BeginFY} and {?EndFY} group by fiscal_year,station_response_area_category END ELSE BEGIN select year,station_response_area_category, count(*) as Incident_count from dw_prod.dbo.vw_unit_response where year between {?BeginCY} and {?EndCY} group by year, fiscal_year,station_response_area_category END
Of course the code isn't working right now. I'm trying to figure out how to do the IF section... Please help.