Make report and joining between tables

[pat...@q-c.nu]

Hi

Im new to this software and i wonder if it possible to make some report from a MS SQL databse with more than one table?

I try to explain.

I have a databse: DB01

In this database i have 4 tables: Article, Order, Property, Measure

In the Article table i have this Row: Articleid, Articleno, Articlepartname

In the Order table i have fkArticleid, Orderid, Orderno, Description, Customer

In the Property table i have fkOrderid, Propertyid, Name, Nom, utl, ltl

In the Measure i have fkPropertyid, measureid, measurevalue, timestamp

Now i want to connect this tables to get out some information.

I want connect this tables together like connect the order table to the article table (Otder.fkArticleid=Article.Articleid)

And then connect Property table (Property.fkOrderid=Order.Orderid) ......

Is it possible to make this type of report in SOFA?

Best regards

Patric

[Grant Paton-Simpson]

Hi Patric,

You will need to join the data in SQL e.g. in a view or derived table and get SOFA to link to that. SQL does the joining bit it is very, very good at and SOFA does the stats, reporting bit.

All the best,
Grant

--

---
You received this message because you are subscribed to the Google Groups "sofastatistics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sofastatistic...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.