31 Answered Questions for the topic reporting services

Reporting Services Microsoft Excel Excel Ssrs

05/13/19

Excel as a data source in SSRS Query a Specific Column of a Sheet?
I want to query the data from an excel file utilizing ODBC System DSN for Excel 12.0. What will be the right syntax to query specific columns from a worksheet and not the whole worksheet like... more
Follows • 1
Expert Answers •1
Reporting Services Microsoft Excel Excel Ssrs

05/12/19

Connection String for ODBC on report server?
I want to create a datasource on report server from an excel. I put my excel to report server. Than i wrote a connection string, but it did not work. What is wrong? "Data... more
Follows • 1
Expert Answers •1
Reporting Services Microsoft Excel Excel Visual Studio

05/11/19

ssrs exporting to excel as csv?
I am calling SSRS reports from an in house piece of software. All the reports made before me render as xlsx or xls and mine continuously are rendering as csv files which is messing up my... more
Follows • 1
Expert Answers •1
Reporting Services Microsoft Excel Excel Export

05/11/19

Save Excel File with a Timestamp when Exporting a Report in SSRS 2016?
I've been fiddling around with SSRS 2016 and tried, without any success, to add a timestamp to the saved excel file when exporting a report. Is there a way, preferably one that isn't much of a... more
Follows • 1
Expert Answers •1
Reporting Services Microsoft Excel Excel Report

05/11/19

SSRS: creating a report optimized for exporting to Excel?
I have a client that needs a particular report that he can export to excel. I haven’t started to build the report, but I’m thinking the best way to do this is to keep the report as simple as... more
Follows • 1
Expert Answers •1
Reporting Services Microsoft Excel Excel Ssrs

05/11/19

SSRS footer text color not changing?
We are applying a stylesheet to SSRS report footer. Footer Font color is set dynamically based on the configuration in the database. When report is exported into Excel, footer color is always... more
Follows • 1
Expert Answers •1

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.