Report Generated By Sql giving Error (RQP-DEF-0177) HELP PLS....

[mohsin2010]

HI,

i m creating simple report having just list i drag Query object and then Sql object next to it .. .double click the Sql object and write query and getting  error as shown in the attachment ... . i have set my source for the query and using Oracle as back end ... .  :(

Best Regards,

Mohsin

[mohsin2010]

Sorry, Attachment is here !

Regards,

Mohsin

[mohsin2010]

i am just trying to get the FIRST _NAME from the DB ,i have attached file also to see my package and DB.. .

Regards,

Mohsin

[PRIT AMRIT]

What i am seeing from the attached error screenshot is, the table/view doesn't exist.

Hope you have already noticed this and double checked in your DB that the table/view 'Employees' does exist?

Have you tried to import and run the same to ensure if it is OK?

Thanks
P

[mohsin2010]

PRIT,

    data exist in the table employee because if i generate report with out creating my own query .. .and simply drag and drop first name and last name from the table employee it shows output  :(
      i have attached two file you see whether the format of the query is correct ur not it dosen't mean that i cant write query just to con-fum that the query that i m writing in Report studio is in correct format ur not ?

Thanks,

Mohsin

[PRIT AMRIT]

can you just write: Select * from Employees

Ensure the correct DATA SOURCE is selected.

[mohsin2010]

PRIT,

Employee is the table where firstname , lastname.... exist but there is also [Office_DB] which is datasource so how should i write query in report studio  ???
     select * from EMPLOYEES this query is perfect in Microsoft SQL but in Cognos is it write ?? or we have to add some aliases with it ??

Regards,

Mohsin

[PRIT AMRIT]

you can write the same query select * from EMPLOYEES in COGNOS, and try if it is OK?

In properties select Data Source: Office_DB

[mohsin2010]

i have done exactly the same thing even that it is giving that error  ???
:'(

[mohsin2010]

Hurrrrrah ......... .. it has succeeded  :D

Regards,

Mohsin

[PRIT AMRIT]

Great, what was the problem?

[mohsin2010]

PRIT,

Actually i publish one DB with two different name now both have the same DB so i tried to change the DB Source to the other i Published not i resolved my problem but the question is that why that one is not connecting when both have the same DB i m Diagnosing it ... .
    Perhaps i did some mistake while publishing the first one because at that time i was not familiar to the environment of FM

Regards

Mohsin

[MFGF]

Glad you were successful, but one question occurs: why would you ever need to code a SQL query like this in your report? It seems like a very odd and potentially unsupportable technique to use.

Just curious,

MF.

[mohsin2010]

MFGF,

      Hi, how are you sir .. . i have used this query to check whether i m getting data from query to generate report Ur not i was just checking and u can say that it was Test report.

Best Regards,

Mohsin