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

You can use macros.   The attached picture shows you where.

I don't exactly know what you mean by Data Source connection property. Are you referring to the connection of the Data Source in Cognos admin page or Data Source properties in FM? Both are different things. The Data Source object in FM is a local Data Source embedded inside the xml file which connects to the actual Data Source using the properties defined.

It is working now. The problem was the model was brand new so it was using DQM mode. It doesn't work in DQM models. When I made a CQM model, it worked. To double check it, I also converted the new DQM model to CQM and it worked! Seems like they disabled it for DQM models.

Gunny,

We had the same issue occur with us and found this to be related to a Web application firewall rule (external to cognos itself) that was preventing http delete actions from reaching cognos when the corporate CDN was used, vs logging into cognos directly (via port 9300) which allowed for "My Content" owned-object deletion by users.

 

I'm assuming that you consciously made the decision to not put the macro into the data source connection property and, instead, pursue this approach. Could you explain why that method was not suitable please. 

Any free training material to use with VAI S2K?