Report Table Numbers Are Text In Excel
Apr 22, 2008Hi
I have a report, a matrix as always, were the numbers are text when I save the report to Excel. What did I do wrong or what properties do I have to change?
Kind regards
ADVERTISEMENT
Dataflow To Excel - Convert Numbers Stored As Text To Numbers Excel Cell Error
Mar 27, 2007I'm trying to write data to excel from an ssis component to a excel destination.
Even thought I'm writing numerics, every cell gets this error with a green tag:
Convert numbers stored as text to numbers
Excel Cells were all pre-formated to accounting 2 decimal, and if i manually type the exact data Im sending it formats just fine.
I'm hearing this a common problem -
On another project I was able to find a workaround for the web based version of excel, by writing this to the top of the file:
<style>.text { mso-number-format:@; } </style>
is there anything I can pre-set in excel (cells are already formated) or write to my file so that numerics are seen as numerics and not text.
Maybe some setting in my write drivers - using sql servers excel destination.
So close.. Thanks for any help or information.
Numbers Converted To Text When Exporting To Excel
Dec 11, 2007Hi all,
I'm having an issue with data from an OLE DB source being converted from numeric [DT_R8] to text when I export it to Excel. I had the column in the spreadsheet formatted as Numeric, but when I set it up as the data destination, it is showing in SSIS as [DT_WSTR].
The SSIS job runs OK, it just converts my numeric data to text in the spreadsheet. I'm surprised that the job actually runs, since I have to do explicit data conversions for my OLE DB string data in order to convert it to unicode. From what I have read elsewhere, the decision was made in SSIS not to use implicit data conversion, but to require explicit conversion. Yet this export is converting my numeric data to text.
I would appreciate any information on how to set up the Excel Destination to properly handle numeric information.
When Exporting To Excel - The Numbers Show Up As Text
Apr 4, 2007Hi,
is there a way to force the numers to show in excel as numbers, not as text?
Thanks,
Igor
Problems Importing Data From Excel (numbers Stored As Text Error)
May 21, 2008i have an excel sheet
in it there is a column that holds values of item numbers
some of these values are preceeded with zeros E.G "00123" (with out the ")
when i view the data in excel i get this little green corner whice states (when pressed) that these values are numbers stoerd as text.
no inside the excel sheet i have no problem with that
but when i try to import the excel sheet into ssis using an excel source task
all these values are imported as nulls!!!
i am lost
i tried converting the format of these cells to numbers but then i loose the leading zeros
what i done temporarly to solve this problem is to accept excel's suggestion and turn these values into numbers
i then import them and convert them to strings in ssis and then ad dthe zeros.
now althouge this works, this isnt realy a solution.
i canot manualy correct each excel file each time i get a new copy
and in the future i will not have the luxuery of having fixed lenght values (so i wont be able to know how many zeroe i"d need to add)
there must be a better way
please help
thanks in advance
Daniel
Formatting Numbers In A Mixed Column (numbers In Some Cells Strings In Other Cells) In Excel As Numbers
Feb 1, 2007I have a report with a column which contains either a string such as "N/A" or a number such as 12. A user exports the report to Excel. In Excel the numbers are formatted as text.
I already tried to set the value as CDbl which returns error for the cells containing a string.
The requirement is to export the column to Excel with the numbers formatted as numbers and the strings such as "N/A' in the same column as string.
Any suggestions?
How To Insert Numbers From A Text Box To A Sql Database Table Column’s Type Numeric?
Nov 3, 2004Hi,
I am getting an error when I try to insert a number typed in a text box control into a Sql database table column’s type numeric(6,2). For example: If I type 35,22 into the text box, or 35, and then I submit the form to insert the data into database, I get the follow error:
System.FormatException: Input string was not in a correct format.
Line 428: CmdInsert.Parameters.Add(New SqlParameter("@Measure", SqlDbType.decimal, "Measure"))
A piece of the SP inside Sql server:
USE market26
GO
ALTER PROC new_offer
@Offer_id bigint, @Measure numeric(6,2) = null, …
What is wrong? Why it doesn’ t accept the number typed in my text box?
Thank you,
Cesar
I Need To Update A Table With Random Numbers Or Sequential Numbers
Mar 11, 2008
I have a table with a column ID of ContentID. The ID in that column is all NULLs. I need a way to change those nulls to a number. It does not matter what type of number it is as long as they are different. Can someone point me somewhere with a piece of T-SQL that I could use to do that. There are over 24000 rows so cursor change will not be very efficient.
Thanks for any help
Reporting Services :: Report Exported To Excel - In Print Preview Footer Text Box Data Truncated
May 6, 2015I am exporting SSRS report to Excel I am aware that excel doesn't show footer , It shows in print preview but my footer has text box which have text disclaimer more than 255 characters, the data getting truncated.
View 3 Replies View RelatedImport Long Text From Excel Into Table
Dec 3, 2007
Hi everyone,
I've got an excel file that I want to import into a database table.
The longest text in a cell is 385 characters.
I've made the fields in the table nvarchar(1024).
I created a data flow task for the import.
When I run this task, I get the following error:
[Excel Source [1]] Error: There was an error with output column "Line Text" (52) on output "Excel Source Output" (9). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".
[Excel Source [1]] Error: The "output column "Line Text" (52)" failed because truncation occurred, and the truncation row disposition on "output column "Line Text" (52)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
is it possible that there is a restriction on the length of the text ?
regards,
Filip
SSIS Excel Into Table Or Text File (dont Ask)
Jan 30, 2008I have an excel file source, that has a column that is a date column, although the group puts in more that just a date sometimes: example (11/1/2007) or (Sold), the problem is I cant get SSIS to ever see anything but the date, for the cells that have Sold shows me null, or blank when doing a view. Any thoughts??? I am starting to hate excel more and more.
View 4 Replies View RelatedReport Export To Excel - Report Header Is Not Appearing In Each Page Of Excel.
Feb 28, 2007I've built a fairly straight forward report in RS that looks normal in preview mode and in PDF format with out any issues.But when I export it to Excel report header is not appearing in each page.Any ideas as to why this is occurring?thanks in advance,Ramesh KS
View 1 Replies View RelatedExcel Not Recognizing Numbers
Oct 31, 2013I've got a SQL query returning data into MS Excel.
One of the columns returns numbers that I then have a SUMIF formula totalling.
However, when the numbers get to Excel, they are not recognised as numbers so my SUM doesn't work. Even if I format the cells as number, general or currency, the sum doesn't work.
Excel knows that there is something in the cell but doesn't treat it as a number in any way.
Can I include something in the SQL statement so that it forces the results to be a number?
Excel Numbers Format
Feb 22, 2007Hi all i'm having an issues when i trying to do a report:
i make a report and there is a field which contains data that can be numeric and numeric with letter: "77756" or "345WS" when i export my report to excel i and i open it i get like a make in the upper left coner of the cells that have only numbers asking me to convert this to numeric format, but this think is that i need this values to be string so i can apply filtering. is there a way that i can format my cell to string so the excel take it like that and allowme to do the autoifilter.
I would really appriciate your Help
Thanks
Displaying Data In The Table Of Report On Text Box
May 23, 2008Hi,
In my report, I have a table that displays all the data from query. I need to take the value of the 3rd row,2nd column of the table and display in a text box.
I tried to do like:
=ReportItems("TextBox2").Value., where TextBox2 is the 3rd row,2nd column of the table.
This returns just the first row value of the seleted data. But, I need the 3rd row value.
Please let me know how can I acheive this.
Programatically Query Database And Save Report In An Excel Table
May 2, 2007Hello All,
I am working on constructing a software layer around some features of the RDL language that would allow me to programatically generate reports.
I am reading the RDL specification language, and I do not understand three things:
1) How the DataSet element is populated by the query or more precisely how do the <Field> elements capture all the rows inside the table that is being queries?
To my understanding I wilkl have to define several fields that correspond to all columns of interest in the query.
But that is only for one row (?!) How do the rest of the rows get populated? Does the server recursively create new rows based on my definitions until it matches row for row all the data in the table?
2) Once the elements are inside a DataSet how do make use of that data to render it in a table.
I understand how the DataSource, DataSet, and Table work individually, yet I do not understand how to establish a flow of data between DataSet and Table.
3) Do I even need to use a <Table> as an RDL element in order to organize the data in an excel table?
I would appreciate any help. Thank you!
Problems Importing Negative Numbers From Excel
Aug 14, 2007Hi there,
I am trying to import about 3300 lines of data from excel. Some of the columns in excel have negative, positive and even 0 as numbers.
I have matched those columns in the DB and have tried all the different data types that i thought should work, but on import, all negative and 0 numbers get dropped.
I have played with the excel formatting as well, but nothing seems to work.
Anyone encounter this before?
Thanks,
How To Add Comma To Alphanumeric Numbers In Text
Jul 18, 2013I have a text where it is mix up of all alphanumeric values... For example like this
ACETAMINOPHEN 250 MG ASPIRIN65 MG CAFFEINE
ACER NEGUNDO POLLEN0.0021 G/ML ACER RUBRUM POLLEN0.0021 G/ML ACER SACCHARINUM POLLEN0.0021 G/ML ACER SACCHARUM POLLEN
So my requirement is i need to add comma (,) before every number value in this text.The text is different from each other.But main one what ever the number is there need to add comma before that one (decimal,numeric etc)
ACETAMINOPHEN,250 MG ASPIRIN,65 MG CAFFEINE
ACER NEGUNDO POLLEN,0.0021 G/ML ACER RUBRUM POLLEN,0.0021 G/ML ACER SACCHARINUM POLLEN,0.0021 G/ML ACER SACCHARUM POLLEN
Dealing With Numbers In Text Field
Mar 29, 2015I have run into a problem when searching for a Movie title that is a number (like the movie name 21)
This is an access database and the Movie_Name is a text field
The SQL I am using is
Select * from Movie_Data where Movie_Title = ‘” & Movie_Name & “’”
This works perfectly for everything except when the Movie_Name = a number
Is there a way to make this search work with both characters and numbers?
Full Text Search And Numbers
May 16, 2007Does Full text search have problems with numbers?
I have a text field in a table that has been full text indexed. Some of the data in some of the fields start with numbers.
For Example
"123p45 the bla bla bla"
When I run a standard SELECT statement on LIKE '%p4%' it returns the above record.
If I run a full text query using CONTAINS(fieldname,'"*p4*"') it returns nothing.
After much head banging I was able to get the CONTAINS to work when I used *123p4*
I figured since there are alpha characters after the p4 the second * works however since there are no preceeding alpha characters before the p4 it fails.
I would like to be able to do a "full text" search for the "p4" and get the record above.
Any feedback would be appreciated..
Unable To Format Excel Destination Column For Numbers
Oct 31, 2006Hi,
I have an excel export with numeric values. When the SSIS package writes into the excel it treats all data types as strings and attaches an apostrophe in the beginning. I tried formatting the excel sheet with the number data type and saving it . It doesnt work.
Other strange thing is that when I go into the advanced editor for the excel destination and look into the properties of the external columns all of them have the data type as Unicode String[DT_WSTR] irrespective of what the data type is from the input.The UI allows me to change it to numeric for numeric columns without any error but the value is not saved at all which is very frustrating. I also tried changing it in the xml file of the package, it some how seems to overwrite it after validation. It would be really nice if it threw an error saying that it cannot be changed.
Anyways there seems to be no way of changing the destination data type if it s an existing file and if I create a new excel sheet there is no way of formatting data. Is there any way out?
Thanks
Setting A ID Field That Holds Numbers And Text
Mar 3, 2007I am totally confused, i have set my data type in the ID field for my database as VarChar (SQL Server Database)
I am confused a have it declared in ASP.NET 2 as a string but it doesnt recognise it when i try and insert the data into a database, what am I doing wrong?
Thanks
1 <%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Untitled Page" %>
2
3 <script runat="server">
4
5 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
6
7 End Sub
8
9 </script>
10
11 <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
12 <span style="font-size: 11pt" id="SPAN1">
13 To initiate a new project, Enter details and
14 select <strong>Insert</strong>.
15 <br />
16 <br />
17 <asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False" DataSourceID="SqlDataSource1" Height="50px" Width="324px" DefaultMode="Insert">
18 <Fields>
19 <asp:BoundField DataField="ProjectID" HeaderText="ProjectID" SortExpression="ProjectID" />
20 <asp:BoundField DataField="ProjectName" HeaderText="Project Name" SortExpression="ProjectName" />
21 <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
22 <asp:TemplateField HeaderText="Project Manager" SortExpression="ProjectManagersID">
23 <EditItemTemplate>
24 <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("ProjectManagersID") %>'></asp:TextBox>
25 </EditItemTemplate>
26 <InsertItemTemplate>
27 <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="ProjMan" DataTextField="PMName"
28 DataValueField="ProjectManagersID" SelectedValue='<%# Bind("ProjectManagersID") %>'>
29 </asp:DropDownList><asp:SqlDataSource ID="ProjMan" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
30 DeleteCommand="DELETE FROM [ProjectManagers] WHERE [ProjectManagersID] = @ProjectManagersID"
31 InsertCommand="INSERT INTO [ProjectManagers] ([PMName]) VALUES (@PMName)" SelectCommand="SELECT [ProjectManagersID], [PMName] FROM [ProjectManagers]"
32 UpdateCommand="UPDATE [ProjectManagers] SET [PMName] = @PMName WHERE [ProjectManagersID] = @ProjectManagersID">
33 <DeleteParameters>
34 <asp:Parameter Name="ProjectManagersID" Type="Int32" />
35 </DeleteParameters>
36 <UpdateParameters>
37 <asp:Parameter Name="PMName" Type="String" />
38 <asp:Parameter Name="ProjectManagersID" Type="Int32" />
39 </UpdateParameters>
40 <InsertParameters>
41 <asp:Parameter Name="PMName" Type="String" />
42 </InsertParameters>
43 </asp:SqlDataSource>
44 </InsertItemTemplate>
45 <ItemTemplate>
46 <asp:Label ID="Label1" runat="server" Text='<%# Bind("ProjectManagersID") %>'></asp:Label>
47 </ItemTemplate>
48 </asp:TemplateField>
49 <asp:TemplateField HeaderText="Project Type" SortExpression="ProjectTypeID">
50 <EditItemTemplate>
51 <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("ProjectTypeID") %>'></asp:TextBox>
52 </EditItemTemplate>
53 <InsertItemTemplate>
54 <asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="ProjType" DataTextField="ProjectType"
55 DataValueField="ProjectTypeID" SelectedValue='<%# Bind("ProjectTypeID") %>'>
56 </asp:DropDownList><asp:SqlDataSource ID="ProjType" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
57 DeleteCommand="DELETE FROM [ProjectType] WHERE [ProjectTypeID] = @ProjectTypeID"
58 InsertCommand="INSERT INTO [ProjectType] ([ProjectTypeID], [ProjectType]) VALUES (@ProjectTypeID, @ProjectType)"
59 SelectCommand="SELECT * FROM [ProjectType]" UpdateCommand="UPDATE [ProjectType] SET [ProjectType] = @ProjectType WHERE [ProjectTypeID] = @ProjectTypeID">
60 <DeleteParameters>
61 <asp:Parameter Name="ProjectTypeID" Type="Int32" />
62 </DeleteParameters>
63 <UpdateParameters>
64 <asp:Parameter Name="ProjectType" Type="String" />
65 <asp:Parameter Name="ProjectTypeID" Type="Int32" />
66 </UpdateParameters>
67 <InsertParameters>
68 <asp:Parameter Name="ProjectTypeID" Type="Int32" />
69 <asp:Parameter Name="ProjectType" Type="String" />
70 </InsertParameters>
71 </asp:SqlDataSource>
72 </InsertItemTemplate>
73 <ItemTemplate>
74 <asp:Label ID="Label2" runat="server" Text='<%# Bind("ProjectTypeID") %>'></asp:Label>
75 </ItemTemplate>
76 </asp:TemplateField>
77 <asp:BoundField DataField="StatusID" HeaderText="Status" insertvisible=False readonly=True SortExpression="StatusID" />
78 <asp:CommandField ShowInsertButton="True" ButtonType=Button />
79 </Fields>
80 </asp:DetailsView>
81 <br />
82 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
83 DeleteCommand="DELETE FROM [Project] WHERE [ProjectID] = @ProjectID" InsertCommand="INSERT INTO [Project] ([ProjectName], [Description], [ProjectManagersID], [ProjectTypeID], [StatusID]) VALUES (@ProjectName, @Description, @ProjectManagersID, @ProjectTypeID, @StatusID)"
84 SelectCommand="SELECT [ProjectID], [ProjectName], [Description], [ProjectManagersID], [ProjectTypeID], [StatusID] FROM [Project]"
85 UpdateCommand="UPDATE [Project] SET [ProjectName] = @ProjectName, [Description] = @Description, [ProjectManagersID] = @ProjectManagersID, [ProjectTypeID] = @ProjectTypeID, [StatusID] = @StatusID WHERE [ProjectID] = @ProjectID">
86 <DeleteParameters>
87 <asp:Parameter Name="ProjectID" Type="Int32" />
88 </DeleteParameters>
89 <UpdateParameters>
90 <asp:Parameter Name="ProjectName" Type="String" />
91 <asp:Parameter Name="Description" Type="String" />
92 <asp:Parameter Name="ProjectManagersID" Type="Int32" />
93 <asp:Parameter Name="ProjectTypeID" Type="Int32" />
94 <asp:Parameter Name="StatusID" Type="Int32" />
95 <asp:Parameter Name="ProjectID" Type="Int32" />
96 </UpdateParameters>
97 <InsertParameters>
98 <asp:Parameter Name="ProjectID" Type="String" />
99 <asp:Parameter Name="ProjectName" Type="String" />
100 <asp:Parameter Name="Description" Type="String" />
101 <asp:Parameter Name="ProjectManagersID" Type="Int32" />
102 <asp:Parameter Name="ProjectTypeID" Type="Int32" />
103 <asp:Parameter Name="StatusID" Type="Int32" DefaultValue=1 />
104 </InsertParameters>
105 </asp:SqlDataSource>
106 </span>
107 </asp:Content>
108
109
Creating A Auto Increment Which Contains Numbers && Text
May 25, 2005Hi,Please can you let me know the best solution for creating a primary key which automatically increments by 1 each time a record is added. My current Primary key is of type "Int" which increments by 1 each time, but I would like my primary key to contain "ABC" before the 1. So each time a record is added I would like to see:-ABC000001 ABC000002ABC000003Etc, EtcI am using SQL Server 2000 and creating an ASP.Net application, will I need to write code in a Stored Procedure to do this?Regards,Brett
View 4 Replies View RelatedSQL Server 2012 :: Extract Text From Numbers
Oct 20, 2014I have a field which contains something like prj(5616) .
I have been assigned to display the actual name and not the text with the number.
Example: if prj(8616) is called Soccer , then I want display Soccer instead of prj(8616).
Numbers(format=N2) Showing As Strings In Matrix-&&>excel Export
Jun 7, 2007Anyone know why my xls does not have number formats when exporting from a report with a matrix?
I keep having to do 'paste special multiply by 1' on the whole thing.
Ridiculous!
Deleting Leading 0's In Numbers Stored In A Text Field.
Jul 25, 2006I am trying to use several tables that have one 10-character text field in
common. Most of the records have a numeric expression, but some tables have leading
0's, and some don't.
I can't cast the field to numbers because there are some records that have
letters also.
What function can I use to get rid of all the 0s at the left of each record?
(Sort of a LTRIM function that gets rid of 0s instead of spaces).
Thanks!
Reporting Services :: Interactive Sort On A Text Field Having Decimal Numbers
Jun 19, 2015I have the following text field in SSRS report:
Version
2.2.32.7
1.0.0.0
2.0.0.0
1.2.0.0
2.1.8.8
1.4.11.0
I want to sort this field interactively.I have already sorted other fields, but as this field is text but has decimal data, its not sorting properly. How do I do this correctly? Once sorted ascending, report should show
Version
1.0.0.0
1.2.0.0
1.4.11.0
2.0.0.0
2.1.8.8
2.2.32.7
Line Numbers In Report Builder
Nov 10, 2005I have a report in which the user community would like line numbers associated with each row. Has anyone done this or have any ideas how to accomplish this?
View 8 Replies View RelatedExcel Report Export Causes Excel 2000 To Crash On Print
Dec 5, 2007When I open the spreadsheet in Excel 2000, it works fine. When I try to print, it crashes Excel. In testing, I narrowed it down to the Header/Footer, because it also crashes when I go to Page Setup and click on the header/footer tab.
However, I can print the same spreasheet from Excel 2007.
Am I just dealing with a "you need to upgrade all your clients" situation, or is there a known issue with certian formatting that is passed out with reports that is not supported by older versions of Excel?
I am using Reporting Services 2005 SP2 to serve up the report that is exported to Excel.
Any assistance is appreciated.
Issue With SSRS Report Exporting To Excel With The Matrix Control Inside The Table Control
Jan 27, 2008Hi All,
I am placing a Matrix inside the table control for grouping requirements,but when we export the report to the Excel, the contents inside the table cell are ignored. Is there any way to get the full report exported, as per the Requirement.Please help me with this issue.
With Thanks
M.Mahendra
Displaying Html Formatted Text In Text Object In Visual Studio 2005 Crystal Report
Apr 29, 2008Hello,
I know this question has been asked here before, but it was ridiculously answered : http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=98764&SiteID=1
I have a text object on my crystal report, to which I programmatically want to assign text in CS. It all works fine, except that if I have html tags in there, the text doesn't get formatted, it just displays the html tags as text as well.
Now in thread linked above, the answer was: right click the text object, and format the text object, hit paragraph text and select text interpretation to HTML. The only problem is, that for a text object, it doesn't have the text interpretation option. It's only an option for a formula field. It says so in the tech support link posted inside the post itself!!!
So if you have any idea how I can do this, please someone help me out. I am new to crystal, and there's not much helpful info on it online. I've searched for this for hours, and no solution.
Thanks
Deploying A Report Model Gives Client Found Response Content Type Of 'text/html; Charset=utf-8', But Expected 'text/xml'
Jan 22, 2008Hi,I have setup a report model and am ready to deploy it for the first time. I have had no issues deploying my report definitions so presumably this should be alright.However, trying to deploy it gives this error:
TITLE: Microsoft Semantic Model Designer
------------------------------
A connection could not be made to the report server http://localhost/ReportServer.
------------------------------
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300; TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerRSReportServer.config' is denied.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.SemanticQueryDesign)
I'd greatly appreciate any insight you could give me into fixing this problem.ThanksJohn
Report Builder Using Report Model Based On Linked Server (Excel) - Primary Key?
Sep 6, 2007I've created a linked server with a pretty basic Excel spreadsheet, and used this command to create a linked server to it:
sp_addlinkedserver ''XL_SPS_1', 'Excel', 'Microsoft.Jet.OLEDB.4.0', 'c:MyExcel.xls', null, 'Excel 8.0'
I want to use this as the data from which to build a report model. As linked servers don't show up in the Data Source View wizard, I created a view in SQL Server:
create view MyExcel
as
select * from XL_SPS_1...Sheet1$
Okay, great, now the view shows up in the DSV wizard and I can create the data source view. However, when I create a new report model based on this data source view, the Report Model Wizard tells me at "Create entities for all tables" that I've got an error when it processes dbo_MyExcel that "Table does not have a primary key."
I assume this is where the identifying attributes for the entities in the report model are taken from, so I really can't go further. Does anyone have an idea as to how to add a primary key to a linked server (Excel) in SQL 2005? Can this be done? Other than importing spreadsheet data to a SQL table, how can I get around this?
Thanks,
--Stan