If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Summary Total Label

Started by Hatcher12, 10 May 2023 12:06:23 PM

Previous topic - Next topic

Hatcher12

Hello all,

  I am looking to change the label for some summary totals in my crosstab report. I am comfortable using param values in separate blocks at the top of my report so end users can see which parameters they selected after the report is ran. Right now, I just have a total line that sums across for each user and the label is 'total'. I am looking to have the label include the users name that is being summed on incase there is a lot of data down the page which will force users to scroll up. This sounds simple to do but I do not think I'm searching the right key words.

Thank you!

MFGF

Quote from: Hatcher12 on 10 May 2023 12:06:23 PM
Hello all,

  I am looking to change the label for some summary totals in my crosstab report. I am comfortable using param values in separate blocks at the top of my report so end users can see which parameters they selected after the report is ran. Right now, I just have a total line that sums across for each user and the label is 'total'. I am looking to have the label include the users name that is being summed on incase there is a lot of data down the page which will force users to scroll up. This sounds simple to do but I do not think I'm searching the right key words.

Thank you!

Hi,

When you mention "I just have a total line", is this a summary row in your crosstab, or is it outside the crosstab (eg as singletons)?

Assuming it is a summary row, you should be able to change the source type property of the row heading within the crosstab. I'm guessing at the moment it is "Data item label"? You could add a calculated item to your crosstab query that contains whatever text/data you need to be displayed, and then change the source type property of the crosstab row header to be "Data item value", and then pick the calculated item as the data item.

Cheers!

MF.
Meep!

Hatcher12

Quote from: MFGF on 10 May 2023 02:08:07 PM
Hi,

When you mention "I just have a total line", is this a summary row in your crosstab, or is it outside the crosstab (eg as singletons)?

Assuming it is a summary row, you should be able to change the source type property of the row heading within the crosstab. I'm guessing at the moment it is "Data item label"? You could add a calculated item to your crosstab query that contains whatever text/data you need to be displayed, and then change the source type property of the crosstab row header to be "Data item value", and then pick the calculated item as the data item.

Cheers!

MF.

I think I follow what you're saying. I created a query calculation with the data name of the total column (which I assume is a summary row in my cross tab, it's type is listed as 'Edge Summary' in my query) and the user's name. It's a query calculation expressed by [EMP_FULLNAME] + ' - '  + [Total(EMP_FULLNAME)]. I am receiving the error "XQE-PLN-0071 The query is not supported. The referenced detail 'EMP_FULLNAME' for the 'within detail' aggregate 'test total' can not be found on the same edge as a sibling of the given aggregate."

MFGF

Quote from: Hatcher12 on 10 May 2023 02:32:31 PM
I think I follow what you're saying. I created a query calculation with the data name of the total column (which I assume is a summary row in my cross tab, it's type is listed as 'Edge Summary' in my query) and the user's name. It's a query calculation expressed by [EMP_FULLNAME] + ' - '  + [Total(EMP_FULLNAME)]. I am receiving the error "XQE-PLN-0071 The query is not supported. The referenced detail 'EMP_FULLNAME' for the 'within detail' aggregate 'test total' can not be found on the same edge as a sibling of the given aggregate."

Hi,

You wouldn't normally include summaries in a row heading - these would be in the crosstab cells for the row? I assumed the row heading would be something like "Total for <employee name>"?

If so, the query calculation would be 'Total for ' + [EMP_FULLNAME]

Or am I misunderstanding? If so, can you go into more detail about what you are trying to achieve?

Cheers!

MF.
Meep!

cognostechie

Quote from: Hatcher12 on 10 May 2023 12:06:23 PM
Hello all,

  I am looking to change the label for some summary totals in my crosstab report. I am comfortable using param values in separate blocks at the top of my report so end users can see which parameters they selected after the report is ran. Right now, I just have a total line that sums across for each user and the label is 'total'. I am looking to have the label include the users name that is being summed on incase there is a lot of data down the page which will force users to scroll up. This sounds simple to do but I do not think I'm searching the right key words.

Thank you!

Normally, for changing the verbiage on the Summary line, I 'unlock' the list/crosstab and then add whatever I want. There is an icon on the top right which looks like a lock, click on that to unlock it and then you can drag any data item in the same column as the 'Total'.