Recent Posts

Pages: [1] 2 3 ... 10
Reporting / Re: Create Summary List
« Last post by fofofo2554 on Today at 07:17:11 am »

When the Error list has no record, the count suppose to return ‘0’.
However I faced some issue which I will explain with below scenarios.

1: Error list has 0 record
2: Success list has 3 records

I have a Summary list with 3 columns:
1: Total Count
2: Error Count
3: Success Count
1: Total Count is the aggregate for Error Count and Success Count
2: Error Count is the counting of record from the Error list
3: Success Count is the counting of record from the Success list

Everything is fine if there’re records in the Error list or Success list. If the Error list record is 0, the Summary list does not show 0 at the Error Count column, it is blank at the Error Count column.  The Success Count column will still show ‘3’, but the Total Count Column does not show the total which should be 3, it is blank.

I was wondering if the count for Error list is 0, it should return 0. Or it return null? For this I have tried to add IF THEN ELSE to check on the null in the Expression Definition, if null return 0 else return the actual count. However this doesn’t seem to work.

Any clues what are happening? Thanks.

Reporting / weekly seggregated date rolled up on sunday's
« Last post by PrawinM on 23 Mar 2018 08:14:45 pm »
Hi ,

in my weekly date column my data is rolled up on monday's if users selected date range from monday to sunday we are getting data if we selecting Tuesday to Sunday we are not getting data ,

they are expecting if they selected tuesday to saturday to it has to show mondays data

Please help me.

Thanks in advance.

Yes, thanks so much for your time. Great help!  :) :)
I think we will talk to our DBAs to get the fiscal year going as well,
Reporting / Re: Date filter for Oracle database
« Last post by cognos4321 on 23 Mar 2018 04:25:39 pm »
Just wanted to mention [Begin Date] is not just a single date field, it's the Column name.

Thanks in advance.
Reporting / Re: AS/400 + Cognos
« Last post by adam_mc on 23 Mar 2018 04:14:06 pm »
Not sure if this will work, but try adding a scheduled trigger to the report/job. - Assuming you have the ability to schedule "By Trigger".
Then, try a RUNRMTCMD statement in a CL program to execute a .bat file that has the appropriate syntax to activate that trigger.

Not sure what permissions you will need setup on the .bat file, but I assume AS400 user will need sufficient authority to execute the .bat file.

Let me know what you find out.
Reporting / Date filter for Oracle database
« Last post by cognos4321 on 23 Mar 2018 03:13:32 pm »
I need to create a report from a relational database(oracle)

There is a begin date column in the table, name: [Begin Date]
The business needs a Calendar prompt which would let them select any date , parameter name: 'pSelectedDate'
They want the cognos report to filter data on the condition :
[Begin Date] <='pSelectedDate'

When I put this expression in the detail filter area : [Begin Date] <=?pSelectedDate?
It doesn't give me any error but shows incorrect data.

Please help.
Thanks in advance.
Here is what I'm trying to do but getting error: when type of Bill is paper, get the max between the dates for Paper and Electronics.

when [Type Of Bill] in ('Paper') and [Settled Date] >= '2015-04-17' then
maximum ([Settled Date] for [Type Of Bill]  in ('Paper','Electronics')
[Settled Date]

Thanks a lot@ :) :)

Yeah, I think that's what the system seems to be expecting to happen anyway.

What "should" be happening is that our system (which has an embedded interface to Cognos's scheduling interface that's been running for a few years now) creates a report view (behind the scenes) in that user's "my folders" folder, that it then creates a schedule for.  [this seems to be working correctly]  Those schedules "should" run the report view, and e-mail the results as an attachment, not a URL.  [This is the part that's appears to have stopped working correctly for some reason]

So far, I've confirmed that:
  • Both the report views and schedules created are owned by the users that set them up.
  • Both the report views and schedules appear to be using the default setting of "View the most recent report"
  • The users' credentials within the schedule look OK too.

Report Studio / Password/Encrypt Excel Files
« Last post by dud987 on 23 Mar 2018 12:54:31 pm »
Hi All,

I have to burst an Excel file and it should be password Protected.
I tried the following Option with PDF and it worked but don't know how to implement in Excel
Steps followed for implementing in PDF
1. Open the Report Properties page in the Connection Page, Click on the report tab and then Override Default Options
2. Then under PDF options, Click set and click on Requires a password to open the report.

Then you enter the password and schedule it and when opening the pdf it asks for a password and not with Excel?
Don't know how to do it in Excel.

Appreciate your response.


I have to get the maximum date between two different data elements so I can use the data item in a list. May be using a Case Statement of if and else.


Unique ID        Condition 1                 Date 1                Date 2             Date 3 (Data item)

111                 ABC                           01/01/2017        09/01/2017      09/01/2017
112                HGH                           02/02/2018        03/03/2017       03/03/2017

If Date 2 is bigger than date 1, take date 2 values. If Date 1 is bigger than Date 2, take Date 1

So the Date 3 as the Data Item will include the latest date for ABC and HIGH conditions.
Pages: [1] 2 3 ... 10