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
Sorry, Attachment is here !
Regards,
Mohsin
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
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
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
can you just write: Select * from Employees
Ensure the correct DATA SOURCE is selected.
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
you can write the same query select * from EMPLOYEES in COGNOS, and try if it is OK?
In properties select Data Source: Office_DB
i have done exactly the same thing even that it is giving that error ???
:'(
Hurrrrrah ......... .. it has succeeded :D
Regards,
Mohsin
Great, what was the problem?
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
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.
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