Search results for query: *

J, 1) Create a new report and select any column (Say ProductLine, ProductType) 2) Group on ProductLine. 3) Go to Query Explorer and Select Query 1. 4) Select the ProductType under Facts and change the Expression from the Properties to Count([Producttype]) and change the DataItem Name to...

Sasha, Check the CRN_ROOT environmental variable is pointing to FM directory. I am not sure whether this is causing the problem.Anyway please try and let me know if it works. Regards, Siva

If ReportNet then, create a filter "date_time_field<?p_dateTime?". This will filter data less than the selected in the prompt page. Hope this helps... Regards, Siva

Use this expression for calculation field. date('02/03/2002') - date('02/02/2002') Regards, Siva

Hello, In my database many connections are opened by application, and they are still remaining eventhough the application developers shutdown their machines. They are not properly closing their application before shutdown. So those connections remain in the database and sometimes it locks the...

Steve, i) How big are the rows Average size of the row is 600 Bytes ii) What kind of access patterns? Select Only iii) What kind of load and type of query (transactional or warehousing application)? Load will be more than average(Through screens) and our application is a transactional...

Hello, Please suggest a best way to access and preserve 180 million records in both database perspective and hardware perspective. Regards, Siva

Hello, Our Operating system is AIX (Production). rightnow the development is going on in Windows 2000 Server.We are using DB2 UDB v8.1 we have one web application and this application has one archiving process.When the user clicks start button in the page, the archiving process will start...

Hello, How can we kill a long running query in DB2? In the front end, we have one cancel button.When the user clicks cancel button, the query should stop processing. Regards, Siva

Hello, Our requirement is to access Cognos Reports from our applications through menus.Without entering into application, no one can access cognos reports.When the user clicks the menu, we just display the reports to the user.The corresponding link of that report, we will store it in the...

i) Have you tested your DataSourceName connection? ii) Are your other reports giving output in less time? Regards, Siva

i) Have you tested your DataSourceName connection? ii) Are your other reports are giving output in less time? Regards, Siva

Sudi, I haven't tried this yet.I will try and let you know.Which version of ReportNet do you have rightnow? Regards, Siva