Cognos Transformer datasources can be found in cs7g.ini located in <install location>\CS7Gateways\bin folder.
There will be entries under [Databases]. The name will be the same as the one defined in Datasources window.
Cognos Transformer datasources can be found in cs7g.ini located in <install location>\CS7Gateways\bin folder.
There will be entries under [Databases]. The name will be the same as the one defined in Datasources window.
I encountered another export to excel issue where the 3rd column stretched too long because a text somewhere in the headers is too long and the solution in my previous post did not work.
After a bit of reading and testing I found another solution... add multiple columns to the table where the text is located, then merge the columns.
How many columns you need to merge depend on several factors including how long the text is, the other text headers/labels in other part of the report, etc. You just have to experiment to get the best excel output you can get.
I encountered this issue of unsightly long header columns when exporting to excel.
A bit of a side effect is that the HTML output looks like this. Not that bad though.
I recently encountered this error in one of the crosstabs of a report I am editing:
This happens when I run or preview the report. Tabular view of the query is ok and returns data.
The root query, let us call it YTD, has SQL as its source. The crosstab's query source, is using YTD as its source:
I check everything in the query and crosstab, including the data items for sorting, etc and everything seems to be ok. .Took me several hours to figure out what is wrong.
Turns out, I edited the SQL and somehow did not validate it. Validating the SQL made the error go away.