Designing a report in SQL from an Excel worksheet
I am trying to design a report from an Excel worksheet, and Iām not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to import this specific information?
View Answer
| Sep 22 2008 3:20 PM GMT
| asked by
SQL Server Ask the Experts
SQL, Microsoft Excel, SQL Server reporting
sql reports
Sql Server Reporting service.1.first queryI have given a task of generating reports using sql server reporting service.I need to generate a summary view as below,Fig:1 Jan-08 Feb-08 Mar-08Bug...
Answer Question
| Aug 18 2008 12:49 AM GMT
| asked by
3301
SQL Server Reporting Services, SQL Server reporting
SSRS Excel export
HelloI have a slight problem when end users are trying to export reports into Excel. When they export the report, one or two columns in the report appear to merge together once exported into Excel, thereby making it difficult for my end users to perform spreadsheet data manipulations.
View Answer
| Jul 25 2008 8:33 AM GMT
| asked by
BBoy
SSRS, Microsoft Excel, SQL Server Reporting Services
Excluding Data Usin NOT IN
I'm trying to export data from a sql table into sql reporter. The information I'm trying to retrieve is information regarding permissions (this is audit stuff). The problem is, there are spaces (and always a different amount of spaces) between the user and the permissions; for example:Type ...
View Answer
| Jul 7 2008 1:10 PM GMT
| asked by
Jerzdevs
SQL Server permissions, SQL Server reporting, SQL statements
SQL Reporting Service 2005 Report Stayle/Layout
How to make the Reports layout change automatically? That it looks just like the clients webpage? Even when they change their colors, borders etc.
View Answer
| Jun 24 2008 11:57 AM GMT
| asked by
Hedi
SQL Server Reporting Services, SQL Server 2005, SSRS 2005
Hosting SSRS on Windows XP - user limitation.
While I host SSRS on a Win XP Prof machine is there a limitation on the number of users who can access this site at once.
View Answer
| Mar 17 2008 6:00 AM GMT
| asked by
Yup
SQL Server reporting, SSRS, SQL Server Reporting Services
