Skip to Content
Former Member
Jun 29, 2007 at 02:46 PM

fiscal year period variable when two queries combined in one template



i am combining two different queries in one web template. both of these queries are using fiscal year period variable. from the wad settings, i selected to show these two variables as one variable in the selection screen. however when i run the template, filter selection for fiscal year period shows odd values. for ex it shows 16 periods in a year although we are restricting to k4 fiscal year variant in both queries. also it shows only up to 2005, it doesn't show the periods in 2006 or 2007. however when i key in any values in 2006 0r 2007, the results are coming ok. when i run the queries individually i have no problem with this variable. they are both showing the correct values. so what is the problem when i combine them in one template? any help will be greatly appreciated. thanks.