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 |
|
manared
Starting Member
10 Posts |
 Posted - 2009-06-22 : 08:09:59
|
| I have 3 tables that I need to pull information from for the report I'll be making (using Telerik Reporting). tblCWMods (fields ProjectID, Phase, JobName, Dealer, etc.), tblCWModItems (fields ProjectID, Phase, LetterID, Modification), and tblCWModFiles (fields ProjectID, Phase, LetterID, downloadName, description). In my report I need the info from tblCWMods as the main part or grouping. For each report there will only be one main group. Within that, I may have several entries from tblCWModItems (related by ProjectID & Phase to tblCWMods) each having a unique LetterID. Within those groups there may be several entries from tblCWModFiles (related by LetterID to tblCWModItems). So my groups should be like this in the report:ProjectID & Phase & JobName, etc (tblCWMods) LetterID & Modification (tblCWModItems) downloadName & description (tblCWModFiles) LetterID & Modification (tblCWModItems) downloadName & description (tblCWModFiles)I'm just wondering how I would go about grabbing all this information from my sql database and then apply it to a new report. I think I'm talking myself in circles on this one and have confused myself!! :) I'm using vb.net 2008 and I'm a beginner using Telerik Reporting. So any information would definitely be appreciated!! Please let me know if any other information is needed. Thanks in advance. |
|
|
|
|
|
|
|
grabbing correct info from SQL database