Hey guys, I know this is a very old thread, but I am not able to download the attachment. Is there a trick for that.

Thank you @Cognostechie for the reply. Sorry for the confusion. I just updated the question as "percentage".
  I meant to display static percentage value on the chart for the corresponding dimension values.

But how can the chart show a character value?

Even if  we create a calculated column, how the chart can display the same?

Thanks,

If this is an Aging chart then you should have different bars for different buckets. Ex: one bar for 1-30, another bar for 31-60 and so on so the last bar would accumulate data for anything that is > 90.

When you say display character values on the chart, do you mean the tooltip when you hover over the bar? Then you have to create calculated columns using a Case statement.

Hi,
  I have a bar chart and would like to display * when the measure value is <10 percentage and "GT 90" when value is >90 percentage. How can I display character values on the chart?

Thanks,

This is Impromptu forum. Impromptu is a very old and discontinued product. Are you sure you want to use this product for modelling? If you already have this and need help then I can help but there are no free training materials other than what IBM has https://www.ibm.com/support/pages/cognos-impromptu-74-product-documentation

Haha, thanks. Funnily enough I said the same thing to them.

I think I tracked the issue to the JSQLConnect driver which is bundled with Cognos, which doesn't support '22. I'm going to see if I can upgrade this driver directly but not holding my breath as I'm guessing it's a separate licensed product just for Cognos.

All their SQL envs are moving to '22 so an earlier version is not on the table. Looks like they'll have to throw it on Oracle/DB2!

Thanks.

Ummm... good luck?

The Cognos Business Intelligence 10.2.1 Supported Software Environments system has mostly broken links.  I'm thinking that Azure SQL 2022 may not be in the compatibility list for a system for which support ended about seven years ago.  Maybe suggest running SQL Server 2012 on Windows Server 2012R2 on an Azure VM.

Quote from: vj040 on 12 Jul 2025 07:31:32 AMHi,

I'm using Cognos report studio 11x and want to print hyperlink at the last page inside the page footer.
The expression "IF ( PageCount () = PageNumber () ) THEN  ( 'Last') ELSE ( '' )" inside text source for hyperlink gives correct result but hyperlink is printing on all pages except last page as hidden link. I've used conditional formatting, conditional rendering, conditional block, style variables but nothing seems to be working.

How can I print this hyperlink only at the last page?

Appreciate any help or suggestions.

Regards

How are you testing this? If you are running interactively as HTML, Cognos will not know how what the final pagecount will be, as each page gets rendered on-demand. What do you see if you render as PDF (for example), or if you run the report in the background?

Cheers!

MF.

Hey all -

I'm maintaining a 10.2 installation (AIX not Windows) for a client that's decomming in another year but they want to move the existing SQL server instance that currently hosts the CS to Azure SQL Server 2022. Only the CS and audit DBs will be hosted there, not reporting data sources.

When the CS connection is created in Cogconfig, it successfully connects the first time but then times out thereafter. We think it could be either TLS related, driver, or perhaps SSL cert issue since we have to use SSL option set to true to connect.

Has anyone either successfully connected to Azure or SQL Server 2022? I know it uses JDBC to connect in CogConfig, and we've tried a few solutions from some old KB articles (such as setting overrideDefaultTLS=true -- although this isn't obvious where to set it in Linux) to no avail.

Cheers.

Hi,

I'm using Cognos report studio 11x and want to print hyperlink at the last page inside the page footer.
The expression "IF ( PageCount () = PageNumber () ) THEN  ( 'Last') ELSE ( '' )" inside text source for hyperlink gives correct result but hyperlink is printing on all pages except last page as hidden link. I've used conditional formatting, conditional rendering, conditional block, style variables but nothing seems to be working.

How can I print this hyperlink only at the last page?

Appreciate any help or suggestions.

Regards