Information générale
Forum:
Microsoft SQL Server
Catégorie:
Services de reporting
Ok this is to both of you.
This is what I understand:
- I have to set up a dataset with my tables to design the report.
- The dataset wizard does not let me do a select statement so I can't do the join when I'm designing the report.
- The report table requires a link to a dataset which can only be a specific database table otherwise an error occurs if another column from a different database table is added.
- The report table cannot have a blank dataset or the encapsulating dataset that contains all database tables as this throws an error.
- The datasets can have queries attached to them but the report structure must stay the same so therefore joins can't be done at run time.
- Multiple datasets can be added to the report and various fields from different database tables can be displayed in the likes of textboxes.
From the above I just can't see how my required report table from below can be displayed.
Transaction
transID, custRef,
TransactionDetail
detailID, transID_FK, stockID_FK, qty, amount
Stock
stockID, stockRef, stockDesc
The table will display:
transID, stockID, stockDesc, qty, amount
All examples I've come across just have the one database table in the report table and then have textboxes from other datasets to make the statement. I really appreciate you guys helping me out but if this can't be done I need to move on and look at something else.
Oh and do you honestly believe an Irish person would share alcohol? ;) lol
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement