Recent content by devcog

Hi, Since, Oracle has a limitation on the number of values it can have in the IN clause, you'll have to make use of the LIKE operator to achieve the results. So, replace Select & Search prompt with a TextBox prompt. And train the user to type in the first few characters of the filter value...

Hi Flex, I have made the required changes in Cognos Configuration to have Active Directory as the authentication source for ReportNet. But, when I open Cognos Connection: a) I am prompted to enter the password b) It fails to authenticate. I have set the host and port properties and also set the...

Hi, one of the iqd reads 0 records. Can you pls confirm if this is the iqd used to generate the cube? I mean if the remaining data sources are used to generate just the categories then this might be one of the problem. Regards,

Hi aaronpan, 1) Take a backup of the following folders: C:\Program Files\Cognos\crn\configuration\csk C:\Program Files\Cognos\crn\configuration\encryptkeypair C:\Program Files\Cognos\crn\configuration\signkeypair 2) Delete the above folders 3) Ensure that the reportnet service is...

Hello All, Has anybody setup the sample audit reports in CRN? The sample model (audit.cpf) provided contains reference to 2 XML-type data sources: url_xml and url_class. Can you please let me know how to set up these data sources? Thanks,

Hi shwetabh, You can schedule a report to generate the output in Excel but I don't think so that you can generated an Excel output which will prompt users to provide filter values. Regards,

Hi All, Does anybody have an idea about the maximum number of rows which can be displayed successfully in a ReportNet report in PDF format? We have a report which fetches records in multiples of 100 thousand from a driving table having 117 million rows. Thanks,

Hi All, I am unable to prepare a bookmark for a cube as I get the following error:"This bookmark is larger than 2 kilobytes in size and may not be read properly by your Web browser." I tried to recreate the bookmark after updating the 'MaxBookmarkUrlSize' in PPSRoot.cfx but in vain. When I...

Hi All, We have a distributed ReportNet setup in our production environment with the gateway installed on one machine and the ReportNet server on another machine. When we direct the output of a report to the printer from Cognos Connection, the request is processed without any errors but the...

Hi All, The report header in drill-through target report displays the date prompt values in YYYY-MM-DDTHH:MM:SS.MMM format inspite of setting the data format to Date (DD/MM/YYYY). The date prompt values are passed as drill-through filters to the target report. When the target drill-through...

Hi, I have an MS Access datasource. When I try to create a cascading prompt, I get the following run-time error message: "CCLAssertError:0:Fatal: CCL_ASSERT(!parentUseColumnExpr.empty());" Has anybody faced a similar situation or know the reason for the error? I would be grateful if you could...

Hi, Can anyone please let me know how to use an excel file as datasource for ReportNet report...? I have created a system DSN pointing to the excel file on the ReportNet server. But, I am not able to see it in Cognos Connection while creating the datasource. Please let me know if have missed...

Hi, Has anyone tried to compute median value in ReportNet report? There is a 'median' function provided under OLAP section in the help, but it is not visible within Report Studio. I would be grateful if you could help me to achieve this calculation. Thanks,

Hi All, Does Cognos Series 7 has a feature to generate a formatted report for the audit log file generated by PPES (ppes_audit.log)...? Thanks,

Hi, Has anybody used OLAP functions provided by ReportNet...? Regards,