Hello Everyone :),
I have a reported that can be prompted using day date name--say from Jan 1 to Jan 16, 2008. The columns, sales, plan for the period, last year's sale for the period are properly filtered by the date prompt parameter.
Users need to look at the full month's plan . For example , for january 2008, they want to see the plan for the period AND the Plan for the whole month.
THe date parameter filters all columns--including the Plan for the Month.
If you prompt it less than a full month, plan for the month also shows just the inclusive days of the prompt.
What is the best way to add the full month plan--without being affected by the prompt filter?
Thanks!
Create a separate query that doesn't have the prompt filter.
Then have a list or crosstab from this query that is unaffected by the prompt selection.
To expand on Suraj's suggestion: in the separate Plan query, add a filter which uses the month portion of your prompt dates. You didn't mention whether the report can be run for a range which spans multiple months, but if so you'll need to consider that in creating the filter expression for the new query.
Presumably you want the full-month plan data reported along with the rest, so you may want to union the new query with the existing one to include both sets of data in your existing list or crosstab rather than adding another.
Another possible approach would be to read the entire month from the database and conditionally calculate the non-Plan measures based on the prompt date range. The viability of this approach depends on the structure of your source(s), and there may be performance implications since you're reading more data.