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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MonteBob

  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...
See more

Part and Inventory Search

Back
Top