Search results for query: *

I created a tabular sql query in Query1 of reportnet report. I get projected data items as Number_of_ members, Number_of_visits, Specific_Service_Date, Group_Name, Coverage_Group_id, Primary_level_care, Secondary_level_Care, Tertiary_level_care. I dragged those in Query 1 from "Query Items"...

Hi! Can anyone please let me know what version of XML parser and build of win2000 is needed for cognos reportnet? Thanks

I have one report in reportnet which uses following tabular SQL. Select COUNT("S1"."Member_Number_ID")"Number_of_Members", char("S1"."c2") "Number_of_Visits" FROM (select "T1"."MBRNO" "Member_Number_ID" , sum("T1"."PCDQT") "c2" from "DWCLAIMS"."CLMCURWK" "T1" LEFT OUTER JOIN...

Hi! I have many columns "0 to 7 Days", "0 to 14 day" "0 to 30 days" etc ( as shown in the following query) like this in my report. I tried to use calculation with search case statement. It does not work. It gives me lot of errors. The client database is DB2. Can anyone suggest any other way to...

For the report I created as per requirement I need to select multiple clients( GRNAME) from value prompt. I have ["T1"."GRNAME" in (#prompt('GRNAME')#) ] in the tabular sql. Also for the value prompt property I added multiselect as "Yes". Still when I run the report , I can not select multiple...

I have a question. Rightnow my client has lot of reports and they write the queries in showcase tools and run the report. Few of their reports are using batch files. eg. if there are 3 queries for 1 report. After running 1st and 2nd query, we don't get any output and there is output for 3rd...

Hi! I created a report showing columns Member Number ID( Social Security Number) and Number of Visits for that member. Actual requirement is the report should give how many people visited how many times. (i.e. 20 people visited 5 times. 67 peopele visited 30 times. So columns required in the...

Hi! I am new to reportnet. Can someone guide me about adding date range prompt in reportnet. Without adding any date prompts, If I write a expression in main query " Specific Date Of Service >= (2/3/2004) and Specific Date Of Service <= ( 7/2/2004)." It works and I get the report output. I...

Can we use reportnet SDK to create DB2 signon?

Can one use a database table in DB2 to store user names, passwords and user classes or do he has to use an LDAP?

In framework manager there is a calculation in the DB2 section called "Date". Supposedly this field will change a numeric date "01012005" to an actual date "01/01/2005". But, we tried it and it does not work. Can you see if you can find anything that will allow us to create a calculated field...

In the current project, cognos reportnet is in Java container. ( Reportnet uses java portal) when one logins to the project website, a java window comes up. I have two questions. 1) How can reportnet get username and password from Java? 2) How can you pass same username and password down to...

In framework manager there is a calculation in the DB2 section called "Date". Supposedly this field will change a numeric date "01012005" to an actual date "01/01/2005". But, we tried it and it does not work. Can you see if you can find anything that will allow us to create a calculated field...