i even tried to hardcode this part

Code:
Logon(rptsummary, con.Server, con.Database, con.Username, "sa")
and change it to

Code:
Logon(rptsummary, "myServer", "testdatabase", "admin", "sa")
but to no avail, nothing happened, it still asked for the database login everytime i generate the report.