Sunday, February 19, 2012

db login info problem

------------------------

in my report, i went to "Database Expert" --> "Project Data" --> "ADO.NET Dataset" and selected the one that is filled by this query:

SELECT CYMUSER.UNAME, TEST.TNAME, RESULT.STARTTIME, RESULT.ENDTIME, RESULT.TOTALMARKS, RESULT.GRADE
FROM CYMUSER INNER JOIN
TEST ON CYMUSER.UID = TEST.UID INNER JOIN
RESULT ON CYMUSER.UID = RESULT.UID AND TEST.TID = RESULT.TID
WHERE (RESULT.RID = @.RID)

at run time, when i execute the report, it keep asks for db login information, that is DB Name, Server Name, Pw, User Name. I use MS SQL, i didnt set up any password and user id at all. Why these non-existing info is asked, can anyone help me to get around it plz?btw, if i go "Database Expert" --> "OLE DB ADO" --> and select "MICROSOFT OLE DB Provider for SQL Server" --> and tick "integrated security" to get dataset from the dabaset directly instead of the way mentioned above, at runtime, the report works just fine, wont ask for any DB login info. However, if i did this way, i need help on how to get the above query work and how to get the parameter "@.RID" and pass it to the report fields. please help|||Thru Front End, pass parameter value as

CR.parameter(0)='someval'

No comments:

Post a Comment