2 Replies Latest reply on Dec 2, 2008 3:16 PM by Jennifer Bahnsen

Report generator help

Jennifer Bahnsen Dec 2, 2008 2:31 PM

OK, so I'm just learning sql and I would like to be able to create my own reports. I've looked over the sample reports and the "How to create your own PDMWorks Enterprise reports" document. Where I'm a little confused is how do I know what the tables names and field names are?

Does anyone know if there is anything documented anywhere?

Thanks

Report generator help

Joy Garon Dec 2, 2008 2:41 PM (in response to Jennifer Bahnsen)

Hi Jennifer -

That is where the SQL Server Management Studio is handy. You can browse the tables and relationships between the tables. It takes a while to familiarize yourself with the structure and where information is stored. (A bit like reverse engineering).

You can create an ER (entitiy relationship diagram) by using Visio 2003 (SP3) that is essentially a table map.

Joy
Like Show 0 Likes(0)

Actions
- Report generator help
  
  Jennifer Bahnsen Dec 2, 2008 3:16 PM (in response to Joy Garon)
  
  Thanks Joy,
  I didn't even think about the entity relationship diagrams. That should do it.
  
  Jennifer
  
  Like Show 0 Likes(0)
  
  Actions

Go to original post