Developing Unified report features in Project Web Access

[scott.brimin]

Hi folks,

I'm an uncertified untrained but surprisingly fair developer tasked
with the job of extending the functionality of Project Web Access 2003.

The main problem with Project Web Access (PWA) is that you can't view
reports on multiple projects. I have been solving this by writing
additional pages that make use of existing Web Access code.

So far, my success has been generating custom (very) large reports in
the form of Excel XML spreadsheets. But now I must use replicate the
way Grid view that PWA works.

I know that it uses a PjGrid and makes use of RDS with SQL Stored
Procedures and I have almost got it all figured out.
I need to know one more thing and that is what I need help with.

Not all the SQL Stored Procedures (SPs) can be used with RDS, possibly
a security concern. I need to know what or where I need to go to allow
the SQL SPs to be used in RDS. I suspect that there is a file of SP
unique IDs or possibly a database entry that'll give it access.

Please help, I am but a developer in need of some friendly assistance
and/or advice.

I thank you muchly in advance.

 

[scott.brimin]

And as is sometimes the case.

I have solved by own problems. If anyone else has similar problems,
give me an emu and I'll try to help you out.

Laters.