Search results for query: *

So my question is, is there a way to have a global parameter or value for cognos to pass from one page to another page in the same report (where neither page is the prompt page) Here is my problem: I want to clean my report up and make both my report and drill-through report as one report...

you should be able to use the agg function in the toolbar just as you do in a list, you may have to play around with it a little bit to select the right column/row you are wishing to see the total on, but if you can give me a better break down of your crosstab I can probably give you a more...

You can also use a SQL statement in your query to break apart your date field and pull out the year, I'm not sure exactly how you have your dates formated, but "substring()" should work, with the correct converts if needed

Depending on how you made your joins/queries, you should be able to write a "case" SQL statement that puts in any value you choose when it returns nothing. Or you could make something as simple as another column that will always return a value for ordering or sorting purposes that will be filled...

I am using Cognos 8.3, I found a solution for my problem but it only works with Reportnet (of course). And the Crosstab looks more like this, on the left there is only a single row, "Department", above there is 3 column headings, there is a high level column heading "Month" (which is made long...

So I have found some help searching the cognos support through IBM, but it isn't right for my situation. I am trying to make a crosstab where each row alternates colors (color doesn't matter, just need it for visibility purposes). The reason why my situation is a little different is because...

What do you mean by align the reportquery? I have made sure to refresh and re-enter the usevalue and make sure it is pulling from the right place, what else is required to align the report query once I change the usevalue in the date query were I pull the months from?

Okay, so I cannot seem to figure out what my "error" is in my report. I am trying to set my prompt up so that it sorts my date (months only) in order of their value (Jan = 01, Feb = 02 etc) instead of in the standard alphabetical order (April, August, etc etc). Now when I set up my prompt...