Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ref_biru
Starting Member
1 Post |
 Posted - 2010-02-23 : 23:24:08
|
| Hi Expert, I want to make a report like below PRODUCT : A--------------------COMPONENT A1 --> VALUE = X COMPONENT A2 --> VALUE = YCOMPONENT A3 --> VALUE = ZX,Y,Z are textbox and value depent on PRODUCT,COMPONENT a1 etc, value and it's comes from multiple tableSome one have sample of expresion (to put in text box expresion) if the query of value comes from combination many table ?Appreciate for the help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-24 : 10:18:29
|
| you need to do join between tables and bring result together in a query and use it as source for report. then in report apply hierarchy on fields PRODUCT,COMPONENT etc as per your requirement------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Query for value from multiple table expresion