Database integer reprts as a number

[TMcClellan38]

Good evening,
I am trying to pull the Project ID out of the Project Server database. When
I pull the number into a report it comes out as a number without .00
following it. When I try to take that same field and insert it into a
hyperlink ( I have a graphic that I want to hyperlink to a project file in
PWA and it is based on the project ID) the number comes out as x.00. I have
tried to change the variable to an integer and trim the string to no avail.
Is there any way to get rid of the .00 coming out of the database.

Thanks

 

[Aaron Tamblyn]

Hi,

I haven't had the problem that you describe but have done a fair bit of
custom reporting against the Project Server db. I would suggest that you use
the schema definitions linked to below. I suspect that the problem is in
data type of variable/s you are storing the project ID in.

Project Server database schem
http://www.microsoft.com/downloads/...75-1367-4b66-870d-f280c054efe2&DisplayLang=en

Project schem
http://www.microsoft.com/downloads/...c2-3ac1-4fc8-8e67-d908cdb9faf2&DisplayLang=en