Filters issue

[chinnucognos]

Hi All,

I have strcuk in one of the report having 11 (eleven) optional filters.
If i run the report without selecting any value(among eleven optional filetrs) output is throwing,
but if i select any of the optional filter value, output is not throwing.
Note: the same report which is in .net , throwing output.

What will be the issue...Please help


Thanks in Advance

[MFGF]

Hi All,

I have strcuk in one of the report having 11 (eleven) optional filters.
If i run the report without selecting any value(among eleven optional filetrs) output is throwing,
but if i select any of the optional filter value, output is not throwing.
Note: the same report which is in .net , throwing output.

What will be the issue...Please help


Thanks in Advance

Hi,

Sorry - you are not making your issue clear at all. What does "output is throwing" mean? Even if we knew this, you haven't given us any details about the report so we probably couldn't suggest what the issue might be. You haven't told us how your filters are defined or what your report should be doing. Can you give us more information?

MF.

[chinnucognos]

Actually report has 11 value prompts(optional) and one date prompt.
If i select date range without selecting any value in  value prompts, reports showing output data
If i select date range along with some values in value prompts, report showing "no data content page".
For each value prompt, i have taken "use value" and "dsiplay value", for eg: use value=location_key(identifier)  and display value= location_eng_desc(attribute)...
I have changed in properties "aggregate function=automatic" for all identifiers , eg: location_key.

Please let me know any further info needed...

[MFGF]

Thanks. If you look at one of the underlying filters using the parameter from one of your optional value prompts, does the item you are filtering on match the Use Value selected in your prompt?

MF.

[chinnucognos]

yes ...it matches exactly

[MFGF]

Ok. Have you verified that there really are rows in your data with both the date you selected and the ID you selected? Are you sure that your prompt parameter is only used in one filter - could it also be in another that is coded incorrectly? I ask this because (on so many occasions) I have deleted a prompt and recreated it, but when I deleted the original prompt I forgot to delete the corresponding filter, and I then ended up with two filters based on the same parameter...

MF.

[chinnucognos]

yeah..this may be the issue..let me check and i wil revert back to u

[chinnucognos]

thanks...it worked...

cheers :)