Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reportnet error: Unable to find item in the query "Query1"

Status
Not open for further replies.
Apr 4, 2005
13
US
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" tab to Dimensions and Facts.

When I go to page explorer and drag these query items on report page and if I validate the report. I get following error for every field I try to drag from query item:
RSV-RND-0053 Unable to find the item " Number_of_members" in the query "Query1"
RSV-RND-0053 Unable to find the item " Number_of_visits" in the query "Query1"
RSV-RND-0053 Unable to find the item "Group_Name" in the query "Query1".

I will really appreciate help regarding this error.I have attached a new tabular sql I added.

The tabular sql I added is as follows.

Select COUNT("S1"."Member_Number_ID")"Number_of_Members",

char("S1"."c2") "Number_of_Visits", "S1"."Specific_Service_Date","S1"."Group_Name","S1"."Coverage_Group_ID","S1"."Primary_Level_Care","S1"."Secondary_Level_Care","S1"."Tertiary_Level_Care"

FROM

(select "T1"."MBRNO" "Member_Number_ID" ,sum("T1"."PCDQT") "c2", "T1"."SPECSVCDT" "Specific_Service_Date",

"T1"."GRNAME" "Group_Name" ,"T1"."GRPID" "Coverage_Group_ID", "T2"."PRMLVLCRCD" "Primary_Level_Care" , "T2"."SCDLVLCRCD" "Secondary_Level_Care" , "T2"."TERLVLCRDS" "Tertiary_Level_Care"

from "DWCLAIMS"."CLMCURWK" "T1" LEFT OUTER JOIN "DWMHN"."CLMLVLCARE" "T2" on "T1"."BECAT" = "T2"."BENCATCD"

where "T1"."GRNAME" in (#prompt('GRNAME')#) and "T1"."SPECSVCDT" between char(#prompt('SPECSVCDT1')#) and char(#prompt('SPECSVCDT2')#) and "T1"."GRPID" in ((#prompt('GRPID')#) ) and "T1"."BECAT" = "T2"."BENCATCD" and "T2"."PRMLVLCRCD" in (#prompt('PRMLVLCRCD')#) and "T2"."SCDLVLCRCD" in (#prompt('SCDLVLCRCD')#) and "T2"."TERLVLCRDS" in (#prompt('TERLVLCRDS')#)

group by "T1"."MBRNO", "T1"."GRNAME", "T1"."GRPID", "T1"."SPECSVCDT", "T2"."PRMLVLCRCD", "T2"."SCDLVLCRCD", "T2"."TERLVLCRDS" )"S1"

group by "c2","Coverage_Group_ID" ,"Group_Name"

,"Specific_Service_Date","Primary_Level_Care","Secondary_Level_Care","Tertiary_Level_Care"

Thanks

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top