Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MonteBob

    Combining Data From Multiple Datasets In Single Table?

    Thanks Jymm. I should be able to work with that.
  2. MonteBob

    Combining Data From Multiple Datasets In Single Table?

    Jymm/Rose, Thanks for the suggestions. I have used cross-server joins before where both datasources are SQL-Server based, but in this case one of the data sources is an Excel spreadsheet. If it is possible to join to an Excel sheet from a SQL query, can you please advise me on the syntax? I...
  3. MonteBob

    Combining Data From Multiple Datasets In Single Table?

    Hello, I am trying to do something I thought would be quite simple. I am using RS 2005. I have 2 datasets in a report, 1 is a SQL Server query and the other is a spreadsheet. Both datasets contain the same 3 fields with the same data types. Now, where I am struggling is trying to create a...
  4. MonteBob

    Report preview only shows 1 detail line

    Help! I have a report which is only showing 1 line in the detail, regardless of how many are selected by the underlying query. However, all of the totals are adding together the correct information. When I export the report as *.rtf, all of the detail appears and the totals make sense again. I...

Part and Inventory Search

Back
Top