Search results for query: *

Hi I have a situation in which the report output is showing 35K rows of data which is incorrect. However when i execute the cognos sql (generated from the report studio report) against the db I'm getiing around 3 million rows, which is in tune with the expected result. Can anyone please let...

Hi, You could use the same logic used with normal reports. If the user selects month - Jan -07 and no. of months 13 then You can set a filter like - between (?monthprompt?) and _add_months(?monthprompt?, -(?no.ofmonthsprompt?)) I hope this works and I understood you question correctly. R

Did you give solve order for the last column as say 2? I had the same problem and my datasource was DMR. In the query explorer I changed the solve order of the column to a higher number and got the correct result. Do let me know the result.. R

You could try giving a higher solve order to that column sum.

Hi, I have a nested crosstab with years as columns. I have tree prompt on the report page for year. My data source is a cube. My requirement is that when i select a particular level in the prompt, the report columns should directly show data at that level. For eg, if i select month in the...

Thanks for the respnse.. Since mine is a nested crosstab, after the cells hide the rows and columns get shifted and the crosstab looks zigzag. I want some kind of filter condition which would be applied to the entire crosstab and not affect the % calculation. Thinking wht would that be.. Do let...

Thanks for the reply. I did that but it ws of no use.. Could you think of any other way?? R

Hi I have a crosstab column in my report that calculates the % of the two nested columns in the crosstab at the end under totals column. It works fine. But I have a requirement wherein I have to supress rows with zeros. When I give a filter saying [measure]>0, it works but my percentage column...