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

Recent Posts

Pages: [1] 2 3 ... 10
1
Reporting / Re: Countdown Timer
« Last post by dougp on Today at 03:38:55 pm »
Quote
<html item>
You're trying to use Cognos 10 technology in Cognos 11.  It may work if you use the compatible viewer, but that's a step backward.

You'll probably want to develop a custom control.
https://public.dhe.ibm.com/software/data/sw-library/cognos/mobile/scriptable_reports/index.html
2
Reporting / Re: Countdown Timer
« Last post by bus_pass_man on Today at 12:18:32 pm »
You know the roll out time.  There's a function called current_time.  Subtract it from the rollout time and you have your countdown timer.

Put that calculation into a table widget.

Set the refresh rate for the widget (the fastest refresh rate is 5 seconds). 

The twist for you is that there's two roll out times.

You could deal with that by comparing the current time to the two roll out times and which ever one is the lesser use that.  You can do that with a case or a if else in the expression. 

Something along these lines:

If ( (Rollout_time_1 - current_time) =< x)  {where x is some value which would allow you to  know that rollout time 1 is next one up.}

then (Rollout_time_1 - current_time)
else
(Rollout_time_2 - current_time)


Set the colour with the conditional formatting properties.

You will need to have the query item as a measure and set the aggregate to none.
3
Reporting / Re: Countdown Timer
« Last post by lrjurgen on Today at 11:54:23 am »
I thought so to at first but I don't seem to be able to get it to work in a report.
I am pretty green with Cognos so forgive me, I don't know where exactly to do this.
I assumed an <html item> but I get an error there.

HTML report output is not well formed. If your report uses "HTML Item" elements ensure that they result in well-formed HTML.
Reason:internal error: detected an error in element content

URL:null
Line:267
Character:1
Source:
This page contains the following errors:error on line 267 at column 1: internal error: detected an error in element content

Below is a rendering of the page up to the first error.
4
Reporting / Re: Countdown Timer
« Last post by dougp on Today at 11:25:26 am »
It seems this should be a fairly trivial JavaScript problem.  What part is causing you trouble?
5
Reporting / Countdown Timer
« Last post by lrjurgen on Today at 10:28:05 am »
This is probably a strange request/question, but has anyone built a report that displays a countdown timer to show on a visual board with multiple reports?

We have a large display board that will have 2 or 3 cognos reports running and updating every x minutes/seconds etc.
And we have 2 times throughout the day that our trucks leave our distribution center. I've been asked to add a timer that counts down (and changes color at certain check points) and then once it reaches the first time, restart and count down to the 2nd one.

For example:
9am target (each day)
2pm target (each day)
Count down from the current time / current day until 2 hours prior to the target and update color to yellow, at 1 hour prior update color to red

6
Reporting / Re: Showing data from SQL with variable content
« Last post by MFGF on Today at 07:07:39 am »
Hi all,
We would like to create a Cognos report based on content from different tables where the table name is prompted. The content in the tables is variable.

The report should function as drillthrough detail report in a dashboard where the table to get details from is variable.

Without being said that direct SQL should be used, in simple SQL it could look something like this:

Select *
from ?put table name here?

Any ideas anyone?

Hi,

I can't ever see this approach working. When you author a report and save it, you are defining an XML specification of how to generate the query, which specific items to retrieve, how to arrange those items and how to render them. If the table and the items will be variable, you can never create a report spec to accommodate this - it's not the way a Cognos report works.

Sorry if that's not what you were hoping to hear, but hopefully it means you can look for other solutions without wasting much time on this one.

Cheers!

MF.
7
Reporting / Showing data from SQL with variable content
« Last post by wdv72 on Today at 03:45:01 am »
Hi all,
We would like to create a Cognos report based on content from different tables where the table name is prompted. The content in the tables is variable.

The report should function as drillthrough detail report in a dashboard where the table to get details from is variable.

Without being said that direct SQL should be used, in simple SQL it could look something like this:

Select *
from ?put table name here?

Any ideas anyone?

8
Reporting / How to show the additional role in the cognos report builder
« Last post by et21 on 24 May 2022 10:08:09 pm »
Hi all I need help with the Cognos report, Im currently build a report with the user name and their role in each projects, some user might have multiple roles in one project but whenever i run the report its only show ONE roles and not showing the additional role for that user.
9
Dashboards / Re: Unable to retrieve data from data set...
« Last post by Magdalina08 on 24 May 2022 01:42:32 pm »
Is there a solution for this when you don't use Microsoft IIS? We are on a Linux server and I am having the same issue.
10
Report Studio / Re: Filter based on prompt values
« Last post by sanchoniathon on 20 May 2022 10:39:28 am »
Thanks once again.

Are we gerting rid of 1 of 2 prompts i'm currently using in this logic ?

Regards !
Pages: [1] 2 3 ... 10