Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RyanDonohue

    Report server not responding when moving filter to tuple. Please help.

    I have a list report that needs to use different members of my ledger (Budget and Actual), date (current month, prior month, prior year), and measures (current month vs YTD). I can successfully create the report using tuples for ledger and measure when the date is applied as a filter. In order...
  2. RyanDonohue

    Filter is dropped in the middle of a crosstab

    I have had my entire team look at the following issue and none of us can figure it out. I certainly hope you can. I have a report with 4 crosstabs; each one gives a little more detail than the level before it. They all refer to the same query 1) Aggregate(Division) (1 Column) 2) Division (As...
  3. RyanDonohue

    One List affects the results of a second list - WHY?

    I have a list in my report that uses a custom grouping based on the name of the object. For example, Case when [Name] in ('Cat','Dog') then ('Mammal') When [Name] in ('Lizard') then ('Reptile') ...etc... End In some circumstances, the grouped items will repeat themselves based on level below...
  4. RyanDonohue

    Token prompt removes another parameter from parameter list

    This is a very peculiar situation and I am looking for some assistance to make sense of it all. I have a report with a parameter for Brand (without a value prompt as this is a pass through value). This displays on the parameter list for the pass through. I am adding a token prompt called...
  5. RyanDonohue

    Dynamic Measure in a tuple issue

    I have a report with a series of crosstabs and graphs that works fine with a static measure of Current Amount or YTD Amount. I created a prompt in the report so the user can switch between the 2 measures. I created a calculated measure using case when else. I added this calculated measure to my...
  6. RyanDonohue

    Scroll down to previous position after drilldown

    The issue that I have encountered is more of just a nuissance and would like to fix it if possible. In my report, I have several Crosstabs. Each crosstab has drilldown enabled and works fine. What I am experiencing, is when I scroll down to the bottom crosstab and drill into, the webpage...
  7. RyanDonohue

    Loss of drill up/down behavior for custom sets (using unions)

    Hello All, I am pretty new to Cognos, but have been having fun creating reports with custom sets using unions for items in the same hierarchy level until I realized this causes the issue of losing the ability to drill up or down. Is there anyway to enable drilling up/down for these sets? I...

Part and Inventory Search

Back
Top