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. Danielbryanuk

    How to Custom Aggregates for Group level of Crosstab

    I think you need to chang the aggregatge function on your calculation to 'calculated', and also for the roll up calculation. Then in the report add the subtotals and they should automatically calculate for each subtotal level. I've had a few issues in this area too, so I'd be grateful to know...
  2. Danielbryanuk

    Labelling nested crosstab rows

    Brilliant, thanks - I didn't realise you could nest them too! They also seem to resize with the rows. Thanks Ties!
  3. Danielbryanuk

    Labelling nested crosstab rows

    Hello again all! I am using cognos 8.4, and have a crosstab report with multiple nested rows, a couple of columns and one measure. I would like to have a header for the rows, much like is automatically generated with a list. I've tried the following to no avail: 1. Add cross tab space and...
  4. Danielbryanuk

    Conditional format - sorting

    Sorry for not being clear enough, it's pretty difficult to explain. Basically I would like to find a statement to use in a query to detect whether any of three optional prompts have been completed (that is, a string has been entered by the user), without requiring the user to enter a string for...
  5. Danielbryanuk

    Conditional format - sorting

    Ties, I was just wondering if you could help with the final step on this for me? here's the scenario... Again using 8.3 Report studio, I have a list report which is based on query 1. Query 1 is a join between Q2 and Q3, using outer joins on 5 data items, plus lots of additional calcuated data...
  6. Danielbryanuk

    Running reports with "no data" option in cognos connection

    Hi all I'm using report studio 8.3, and have in the past selected "no data" in the run options to run a report without data in order to view the output formatting. I have also in the past created jobs in cognos connection that run a list of reports (some with default values, others with...
  7. Danielbryanuk

    Totals in Crosstabs

    Still not heard anything or solved the problem - can anyone help?? Please???
  8. Danielbryanuk

    Referencing "no input" to prompt

    Just to clarify having read it again - I want the calculated data item to return the corresponding data item to any one of pCRM1,2 or 3. Only one of the pCRMs will be completed, therefore I need to change the "is null" operator to something that checks whether the prompt has been completed, in...
  9. Danielbryanuk

    Referencing "no input" to prompt

    Hi all Using report studio 8.3 I have a prompt page with many prompts, many of which are controlled using hmtl item. Simply put the html ensures one of 3 prompts must be completed before "finish". Thus after selecting an item in prompt 1, if the user selects an item from prompt 2, then...
  10. Danielbryanuk

    CASE WHEN in a detail filter

    Not my day today, I didn't read your post correctly - it seems to work, (in that I don't have an error message), but it is taking a lot longer to run the report now. I'll keep you posted if it works. Any ideas on improving the performance? Thanks very much Ties
  11. Danielbryanuk

    CASE WHEN in a detail filter

    Sorry Ties, should have been clearer, it was quite late when I posted!! The objective is to filter the year of my selected data items depending on the value of pID, thus when pID is between x and y then filter data for year = z I am therefore trying to use the THEN and ELSE clauses to return...
  12. Danielbryanuk

    CASE WHEN in a detail filter

    Hi all Using 8.3 Cognos report studio. I was someone could tell what is wrong with the follwing case statement, used in a detail filter in a report: "CASE WHEN ?pID? between 73 and 84 THEN ([GMT Product Overview by Asset Class].[Product Overview Facts by Asset Class].[Year] = 2006) WHEN...
  13. Danielbryanuk

    Search & Select Prompt - query operator

    Please ignore - stupid question!
  14. Danielbryanuk

    Search & Select Prompt - query operator

    Hi all Using Cognos 8.3 report studio. Sorry if this is an obvious one, but I've been racking my brains on it for a while. I have a search and select prompt which is used to select parameter value(s) to be referenced in a query filter. My filter expression is therefore: dataitem in...
  15. Danielbryanuk

    Cognos DLookup equivalent

    As you can probably already guess I don't know too much about these things...The temporary table (I call it a "table" but it is an sql query that produces another normal query) is created using the following sql: "select 'Unconstrained' as Text, 'A' as Category, 2.0 as part_1000, 1.3 as...
  16. Danielbryanuk

    Cognos DLookup equivalent

    Hi all I need an efficient method of obtaining the value of cross section of a table (manual and ad hoc table generated using sql query) in a query. I would like to avoid using "Case When" of "If" constucts as the table is very large. I have investigated using "tuple" but understand this is...
  17. Danielbryanuk

    Report errors with Excel/PDF output

    Ties, Could this also lead to having different results when running the same report on pdf and Excel? This is the situation i am in, where the excel report is correct but pdf incorrect, despite being the same report!! Very strange...
  18. Danielbryanuk

    Totals in Crosstabs

    Hello again all...another issue I know! I have a cross tab that contains 5 measures (all calculated), grouped by one member in the column and 4 members in the rows. For each row member there nested total line, which performs a sum of the crosstab fact cells. The trouble is that for one...
  19. Danielbryanuk

    Hidden reference??

    By way of an update, I guess in case anyone else has this problem, I solved the issue by creating a duplicate of the existing [Revenues YTD] data item in the offending query and replaced the measure on the report page. Bit of a fluke really, but bizarrely this only works when the old data item...
  20. Danielbryanuk

    Hidden reference??

    The base query runs fine, but the report query only runs when I delete the 4 total calc's I mentioned before, which also deletes the rows from the report: total(currentMeasure within detail [Team]) total(currentMeasure within detail [Submarket]) total(currentMeasure within detail [Sub-GMT])...

Part and Inventory Search

Back
Top