Hi
When I connect to a database through an ODC file, it lists all the tables in the database. In the properties of the connection file, I can specify whether the connection file is referring to a table, Stored Procedure or a Command Text. Now If I have an Excel Workbook with sheets containing data got by different SQL queries, Can I accomplish this with a single Office Data Connection file Or do i need to specify different .odc files for different queries
Thanks
Guruprasad Karnik
Multiple Queries in a single Office Data Connection File
Hot Topic
- Creating Visio Diagrams in an ASP.Net Web Form Programmatically (C#)
- Reusable framwork library
- BDC and Table maintenance (editing data)
- Is CSF Mature? Does it support other industries?
- AppConfig
- Passing Business Objects through tiers?
- failover to backup web service
- The participant 'HelloWorldParticipant' does not support action
- Workflow Designer Not outputting Correct Link
- looking to improve efficency or finding a different control
SharePoint Products
- Recurring Appointment Database Storage
- Thin client vs smart client
- Task notification emails have US date format in them?
- Changing from a 2 server to 3 server architecture....
- Sample required For Simple Scenario ?
- Search Results RSS feed incorrect URLs
- Windows service not running from installer
- Information on Datamigration/Data Conversion
- How does datasheet control work?
- Business Data Catalog / View Applications/ Applications / Change Setting is not present
Multiple Queries in a single Office Data Connection File
Cest la vie
I found the answer. The ODC file represents a view or a table and hence for each of the report snapshots, one has to use different ODC files. The one shortcoming in the above case is that you cannot pass parameters into the query written in the ODC file properties since views by nature do not support parameters. If you need to provide a report in Excel with filtering option, then you need to go for Pivot Tables whose data source is the back-end database.