Recent Posts

Pages: [1] 2 3 ... 10
1
Reporting / Re: Redirect on report load
« Last post by Reinhard on Today at 05:29:26 am »
In C11 you go into the properties of the report in the Cognos navigation (Team content...). There under tab report you open advanced and see interactivity which you uncheck.

An example for Javascript in an HTML item would be
<script LANGUAGE=”JavaScript”>
alert("kill all humans");
</script>

However, I was not able to test this atm:-(

Regards
2
Reporting / Report in CSV takes too long to generate
« Last post by rteruyas on Today at 05:28:04 am »
Good day guys

When my report runs in CSV format, it takes about 10 minutes to complete and retrieve 260k rows. File size is about 100MBs and it's simply a data dump from 1 table.
What confuses me is why it takes so long to complete. It's a data dump from 1 table without transformation. Is this something to expect to happen?

cognos version: 11.0.9
datasource: framework manager package

Anything I could check to improve the execution time?
Thanks in advance. Have a good day

Regards
3
Report Studio / Re: Cross tab boarder formatting
« Last post by ashley on Today at 04:29:35 am »
What version of Cognos are you running? Are you getting an error?
4
Report Studio / Re: Cross tab boarder formatting
« Last post by RGascoigne on Today at 04:19:41 am »
Hi Ash,

I don't seem to be able to run the query.  How do I apply boarder to the last row of a grouping?

Thanks,

Rob
5
Report Studio / Re: Cross tab boarder formatting
« Last post by ashley on Today at 03:47:56 am »
Hi Rob,

Find attached a report xml using the GO sales (query) package. You can just copy this and then open report from clipboard under the report properties setting.



Take note of the data items called Running-count and Count distinct as these are what calculate the last row in each grouping. I've then added a conditional style which applies a border to the bottom of the last row.

If you don't have the samples packages set up then let me know and I can explain in more detail.

Thanks,

Ash
6
Reporting / Re: Redirect on report load
« Last post by bergsorensen on Today at 03:45:10 am »
Hello @Reinhard.

Im not sure where in cognos this options should be set?

Did you just embed the JavaScript in a html element?

(an example would be much appriciated)

Thank you!!
Kasper
7
Reporting / Re: Redirect on report load
« Last post by Reinhard on Today at 03:40:39 am »
Hi,

in C10 I regularly used JavaScript with success but in C11 you need to set the execution mode in the properties of the report first.

Regards
8
Reporting / Redirect on report load
« Last post by bergsorensen on Today at 02:58:27 am »
First question on this forum :)

I am trying to have a report auto redirect to another URL (report) on load / when report is run.

I have tried to add a HTML string with meta and/or JavaScript without luck.

Is there a way to accomplish this?

THANK YOU!
Kasper
EG.dk
9
Report Studio / Cross tab boarder formatting
« Last post by RGascoigne on Today at 02:19:22 am »
Hia,


I'm trying to format a productivity report.  See attached.  Top is current format, bottom is what I want to achieve.  This keeps the data relating to the individual easier to review across the table.

Any ideas?

Thanks,
Rob
10
I believe I solved a very similar thing here: http://www.cognoise.com/index.php/topic,34811.0.html

Whether the optional prompt is on a prompt page or on the report page does not really matter, that solution should be applicable to both scenarios.
Pages: [1] 2 3 ... 10

       
Twittear