Friday, March 23, 2012
exe to export reports to pdf
We have a need to create something like a win app that would be scheduled to
run on the web/reporting server, query the db, pass some parameters to
reports and auto-generate them in pdf format (to be stored in db or on the
same box) to make them available for the website visitors.
Have anybody done something like this before or seen an example of? We tried
to do something similar when reporting services when it just came out but
were unable to implement. Would really appreciate any advice on how to
tackle this!Thanks! Are you using data-driven subscription feature for this? Is it only
available with Enterprise SQL edition?
"Wickherm" <Wickherm@.discussions.microsoft.com> wrote in message
news:3CF580B4-0CD1-4C37-8099-2B65FBF846B2@.microsoft.com...
> We use the subscriptons in RS to schedule reports to save to a file share.
> The parameters in the reports call outside dll's to get the values.
> "ilona" wrote:
>> Hi,
>> We have a need to create something like a win app that would be scheduled
>> to
>> run on the web/reporting server, query the db, pass some parameters to
>> reports and auto-generate them in pdf format (to be stored in db or on
>> the
>> same box) to make them available for the website visitors.
>> Have anybody done something like this before or seen an example of? We
>> tried
>> to do something similar when reporting services when it just came out but
>> were unable to implement. Would really appreciate any advice on how to
>> tackle this!
>>
Wednesday, March 21, 2012
Excluding Export Options on Report
In the rsreportserver.config there is a <ExcludedRenderFormats> element, which allows you to list the rendering formats that are excluded from the export option for all reports.
Is this the only way you can change this? i.e. can you change this through Management Studio or Report Manager, and also can you exclude the export options for a single report rather than having to do it for all reports?
Thank you
Hi,no this is a serverwide property which can only be administered through the "XML-Interface" <:-)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||To confirm the "XML-Interface" being the rsReportServer.config file|||Yes.sql
Sunday, February 26, 2012
Exception Error while exporting to Excel
I have a report that runs ok at the report manager. However, when I try to
export it to excel
I receive the following error message. Any ideas?
Thank you.
CD
Reporting Services Error
----
--
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
a.. Item has already been added. Key in dictionary: "20" Key being
added: "20"
----
--
Microsoft Reporting ServicesDo you have a matrix in your report? Does the matrix has subtotals?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"DC" <DC@.yahoo.com> wrote in message
news:eWjCLQAnEHA.2680@.TK2MSFTNGP15.phx.gbl...
>
> Hello,
> I have a report that runs ok at the report manager. However, when I try to
> export it to excel
> I receive the following error message. Any ideas?
> Thank you.
> CD
> Reporting Services Error
> ----
--
> --
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> a.. Item has already been added. Key in dictionary: "20" Key being
> added: "20"
> ----
--
> --
> Microsoft Reporting Services
>|||Yes, I do have a matrix report which has subtotals.
CD
"Nico Cristache [MSFT]" <nipirvan@.microsoft.com> wrote in message
news:uBPuy1AnEHA.3292@.TK2MSFTNGP15.phx.gbl...
> Do you have a matrix in your report? Does the matrix has subtotals?
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "DC" <DC@.yahoo.com> wrote in message
> news:eWjCLQAnEHA.2680@.TK2MSFTNGP15.phx.gbl...
> >
> >
> > Hello,
> > I have a report that runs ok at the report manager. However, when I try
to
> > export it to excel
> > I receive the following error message. Any ideas?
> >
> > Thank you.
> > CD
> >
> > Reporting Services Error
> ----
> --
> > --
> >
> > a.. Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. (rrRenderingError) Get Online Help
> > a.. Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > a.. Item has already been added. Key in dictionary: "20" Key being
> > added: "20"
> >
> ----
> --
> > --
> > Microsoft Reporting Services
> >
> >
>|||Here comes another bug. If you have a matrix with subtotals, you might
experience some difficulty while exporting reports to excel.
Here is the procedure I followed:
-Get rid of the total column.
-Deploy the report, check if export works.
-Put it back in.
-Deploy the report, check if export works.
When I apply column color changes it failed, and gave me the error message.
Even without color I am happy.
Regards,
Cem
"DC" <DC@.yahoo.com> wrote in message
news:eki3H7AnEHA.3628@.TK2MSFTNGP09.phx.gbl...
> Yes, I do have a matrix report which has subtotals.
> CD
>
> "Nico Cristache [MSFT]" <nipirvan@.microsoft.com> wrote in message
> news:uBPuy1AnEHA.3292@.TK2MSFTNGP15.phx.gbl...
> > Do you have a matrix in your report? Does the matrix has subtotals?
> >
> > --
> > Nico Cristache [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "DC" <DC@.yahoo.com> wrote in message
> > news:eWjCLQAnEHA.2680@.TK2MSFTNGP15.phx.gbl...
> > >
> > >
> > > Hello,
> > > I have a report that runs ok at the report manager. However, when I
try
> to
> > > export it to excel
> > > I receive the following error message. Any ideas?
> > >
> > > Thank you.
> > > CD
> > >
> > > Reporting Services Error
> >
> ----
> > --
> > > --
> > >
> > > a.. Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was
> > > thrown. (rrRenderingError) Get Online Help
> > > a.. Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was
> > > thrown.
> > > a.. Item has already been added. Key in dictionary: "20" Key
being
> > > added: "20"
> > >
> >
> ----
> > --
> > > --
> > > Microsoft Reporting Services
> > >
> > >
> >
> >
>
Friday, February 24, 2012
Excell row 33 problem
When I export to Excel, if my report has 33 rows, last row doesn't show.
If it has more rows or less it displays okUse a empty text box at the bottom of your report and try.
Probably its where the page break happens.
SRM
"Joško Šugar" wrote:
> I don't know if any of you have encountered this problem...
> When I export to Excel, if my report has 33 rows, last row doesn't show.
> If it has more rows or less it displays ok
>
excell export doesn't work
excell
it reporting services returns an error message:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Index was out of range. Must be non-negative and less than the size of the
collection. Parameter name: index
can anybody help me solve this?"Dirkjan van Groeningen" <DirkjanvanGroeningen@.discussions.microsoft.com>
wrote in message news:F60A2429-8A44-4DE7-B162-D29FB36091E2@.microsoft.com...
>I have a report with multiple tables, when I trie to export this report to
> excell
> it reporting services returns an error message:
>
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Index was out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index
> can anybody help me solve this?
Hi, I have the same problem. I have post this issue here 3 times with no
meaningful help.
Please post back if you find a solution.
Good luck,
Bryan
EXCEL XP - Need xls not MHTNL
report in quotes in the filename box (i.e.; "My Report.xls"), however, it is
default saving as an MHTML document.
Is there any way to force an .xls extension?
--
aleJust install Reporting Services SP1 and it will generate BIFF instead of
MHTML.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"ale" <ale@.discussions.microsoft.com> wrote in message
news:445A9480-F90D-44A4-96A7-18B173380F67@.microsoft.com...
> I am running EXCEL 2002 SP#. When I export to Excel it shows the name of
the
> report in quotes in the filename box (i.e.; "My Report.xls"), however, it
is
> default saving as an MHTML document.
> Is there any way to force an .xls extension?
> --
> ale
Sunday, February 19, 2012
Excel to MS SQL
I want to export the data from Excel sheet to SQL database. In the Excel sheet one column contains the date value and non date like 0 and blank. I want to transfer this to my table by changing the format to dd/mm/yyyy.
If I open and format the column to date, and if I export then in the table i am getting different formats ( based on the client machines Date format , The column in the table is Varchar becaust the Excel sheet column will contain date and other non date like 0 , blank etc )
Now how can I export the Excel column that contains date , 0 and blanks to the table in the database with date format dd/mm/yyyy and null for non date values?
Thanks
NarayanaswamyYou should import your data as VARCHAR in a temporary table, and transform it in a second step.|||Hai ,
I tried that also, but the problem is
If In the excel sheet first field is a text or 0 then All thetext values are transfered to the Table but the date fields are transfered as NULL.
If the first row in the excel is Date then All the date are transferred properly and the text and 0 are transfered as NULL.
But the date transfed is of various type ( as per the client machine Date format how can i convert it to same format?)
Can you help me in solving this problem?
Thanks
Narayanaswamy|||Yeah, Excel is great, but not for storing data.
I would take another approach, and would include some VBA code into your workbooks to transform your sheets first into the proper format before exporting them. Your could also consider to export them by VBA.|||Originally posted by Narayanaswamy
Hai ,
I tried that also, but the problem is
If In the excel sheet first field is a text or 0 then All thetext values are transfered to the Table but the date fields are transfered as NULL.
If the first row in the excel is Date then All the date are transferred properly and the text and 0 are transfered as NULL.
But the date transfed is of various type ( as per the client machine Date format how can i convert it to same format?)
Can you help me in solving this problem?
Thanks
Narayanaswamy
I did have the same problem with importing excel data to MSSQL.
After some fighting I just imported data to Access and then to MSSQL.
It was needed to do not often. :)
Excel Sheet name and Sorting Problem...
Is it possible to give another name that "Sheet1" when I export my
report to Excel ?
Also
When i make report header it is not allowing me to sort?
Any solutions/Samples ?
Thanks in advance
Aravind.SNot sure about the Sheet1 name, but when you create a report header, make
sure that the end of the header text box lines up with the end of a text box
in your detail.
Hope that helps!
"aravindsabapathy@.gmail.com" wrote:
> Hai,
> Is it possible to give another name that "Sheet1" when I export my
> report to Excel ?
> Also
> When i make report header it is not allowing me to sort?
> Any solutions/Samples ?
> Thanks in advance
> Aravind.S
>
Excel report
knows about this, your answer is much appreciated.
I export a report with links into Excel. When I open the Excel report and
put my mouse over the link, the URL is displayed. This is unacceptable
because the URL contains hidden data that we pass between reports.
Can this be prevented?
Thank you,
MelissaHi Melissa,
Thanks for your post.
From your descriptions, I understood that the you do not want the links to
be shown when Reports had been exported to Excel formats. Have I understood
you? Correct me if I was wrong. However, I am not sure whether you still
want this URL to be valid? (For example, it dispalyed as "Hello" and it's
internal URL was http://www.mydomain.com/hiddendata, do you still want
http://www.mydomain.com/hiddendata stored somewhere in Excel or it could be
delete, you just want it be displayed as "Hello"?)
Based on my scope, unfortuantely, this behavior is by design in Excel. As
we all known, when you type an entry in your worksheet that begins with any
of the following prefixes (http://, www., ftp://, mailto:, file://, news:,
\\), Microsoft Excel automatically creates a hyperlink. Also, I am afraid
there is no options in Reporting Services could be used to realize such
functionality.
However, I think the following KB might be help in Excel side, but you will
have to do it manually
XL2002: How to Prevent the Automatic Creation of Hyperlinks
http://support.microsoft.com/kb/291209/EN-US/
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Thanks for the answer Michael.
I am just looking to display the text in Excel without the link.
I checked the link that you mentioned, and it's a good solution, but I have
no idea how to accomplish this upon exporting the report to Excel.
Melissa
""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:T8P1r3luEHA.3388@.cpmsftngxa10.phx.gbl...
> Hi Melissa,
> Thanks for your post.
> From your descriptions, I understood that the you do not want the links to
> be shown when Reports had been exported to Excel formats. Have I
understood
> you? Correct me if I was wrong. However, I am not sure whether you still
> want this URL to be valid? (For example, it dispalyed as "Hello" and it's
> internal URL was http://www.mydomain.com/hiddendata, do you still want
> http://www.mydomain.com/hiddendata stored somewhere in Excel or it could
be
> delete, you just want it be displayed as "Hello"?)
> Based on my scope, unfortuantely, this behavior is by design in Excel. As
> we all known, when you type an entry in your worksheet that begins with
any
> of the following prefixes (http://, www., ftp://, mailto:, file://, news:,
> \\), Microsoft Excel automatically creates a hyperlink. Also, I am afraid
> there is no options in Reporting Services could be used to realize such
> functionality.
> However, I think the following KB might be help in Excel side, but you
will
> have to do it manually
> XL2002: How to Prevent the Automatic Creation of Hyperlinks
> http://support.microsoft.com/kb/291209/EN-US/
>
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Melissa,
As I have said that it was by design in Reporting Services to export to
Excel and there is no options available doing so, I am afraid there is not
a better way doing this except two workaround below, which seems rather
Ugly :(
First of all, you will have to change your raw data from http://www... to
'http://www...
Secondly, write the marco codes as KB:Q291209 described and save the file
in C:\Program Files\Microsoft Office\OFFICE11\XLSTART (in case you are
using Office 2003, if not, you will find the correct path to put the file
to be loaded when Excel started in KB:Q291209). Even if you have put this
marco to be loaded automatically, the excel file will still be open as all
hyperlinks available, the links will be invalid as expected only when it
get the focus and then lose the focus.
AGAIN, I understood that neither of the workaround seems done a good job,
however, regarding this by design issue, I really appreciated your
understanding that we do not have such funcationality directly and
beautifully.
If you have any questions or concerns, don't hesitate to let me know. We
are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Melissa,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Friday, February 17, 2012
Excel Rendering - Urgent
I have a fairly simple report (with a lot of columns) that I'm trying to
export to Excel. Everytime I do this, I get the following error:
"Excel Rendering Extension: Width of excel cell in the excel sheet exceeded
the maximum limit of 1726.5 Points."
I know that 1726.5 equates to 255 characters in a column, but when I export
to CSV and check the lengths of every value, none of them reach 255.
Is there a workaround to this bug?
Any guidance on this matter would be much apprecited.
Best Regards,
Benjamin Pierce
Open Text CorporationThe experience I have is when the report is empty and you want to render it
to Excel, RS will combine all the columns into one single cell in Excel. One
way to solve this is to shrink the width of all the columns so that the total
length is less than 255 characters.
"Benjamin Pierce" wrote:
> Well, after much trial and error I found the problem.
> I had two tables. A summary table then a "data dump" below that. On the
> first table, I had the "PageBreakAtEnd" property set to true. When I
> changed it to False, the error went away.
> As a workaround, I attempted to set the "PageBreakAtStart" property of the
> second table to true, but this re-introduced the error.
> @. Microsoft: Is this a known bug? I'm attaching my RDL for further
> analysis. It seems like a fairly serious flaw in the Excel Renderer.
> Please let me know if you need more info.
>
> Regards,
> Benjamin Pierce
> Open Text Corporation
>
>
> "Benjamin Pierce" <bpierce@.opentext.com> wrote in message
> news:eRd9aCymEHA.3868@.TK2MSFTNGP11.phx.gbl...
> > Hello,
> >
> > I have a fairly simple report (with a lot of columns) that I'm trying to
> > export to Excel. Everytime I do this, I get the following error:
> >
> > "Excel Rendering Extension: Width of excel cell in the excel sheet
> exceeded
> > the maximum limit of 1726.5 Points."
> >
> > I know that 1726.5 equates to 255 characters in a column, but when I
> export
> > to CSV and check the lengths of every value, none of them reach 255.
> >
> > Is there a workaround to this bug?
> >
> > Any guidance on this matter would be much apprecited.
> >
> >
> >
> > Best Regards,
> >
> > Benjamin Pierce
> > Open Text Corporation
> >
> >
> >
>
>
>|||The fix will be available in the next service pack (SP2).
You may also contact Microsoft Product Support Services. See
http://support.microsoft.com/default.aspx?pr=cntactms&style=home. A hotfix
for the issue is available. The KB article (883501) should be available
soon.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Benjamin Pierce" <bpierce@.opentext.com> wrote in message
news:eRd9aCymEHA.3868@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I have a fairly simple report (with a lot of columns) that I'm trying to
> export to Excel. Everytime I do this, I get the following error:
> "Excel Rendering Extension: Width of excel cell in the excel sheet
exceeded
> the maximum limit of 1726.5 Points."
> I know that 1726.5 equates to 255 characters in a column, but when I
export
> to CSV and check the lengths of every value, none of them reach 255.
> Is there a workaround to this bug?
> Any guidance on this matter would be much apprecited.
>
> Best Regards,
> Benjamin Pierce
> Open Text Corporation
>
>|||This patch appears to fix the stated problem, but creates another.
This is not a catastrophe; I will structure the report differently to work
around the problem, but I thought RS Engineering might want to hear about it.
The report contains a table followed by a textbox. One of the cells in the
table contains a formula like this:
=ReportItems!TextBoxInThisTable.Value *
ReportItems!TextBoxOnTheSecondPage.Value
This is rendered properly within the report designer and to excel. In
excel, the table data and the standalone textbox are rendered correctly and
the cell containing the formula is calculated correctly. The excel version
retains the formula which something like: _123 * _456.
So far so good.
The problem arises when I define a PageBreakAfter attribute on the table.
Before applying the hotfix, when I attempted to save as excel, report
designer generated the error as described in kb883501: "Excel Rendering
Extension : Width of excel cell in the excel sheet exceeded the maximum limit
of 1726.5 Points."
After the hotfix, the report designer saves the file, but the resulting file
contains a fatal flaw:
The cell containing the formula simply displays the value contained in
ReportItems!TextBoxInThisTable. When I click on the offending cell to view
the formula, Excel crashes with this signature:
AppName: excel.exe AppVer: 11.0.6355.0 AppStamp:40aa979f
ModName: excel.exe ModVer: 11.0.6355.0 ModStamp:40aa979f
fDebug: 0 Offset: 0010be7e
My guess is that this is related to the fact that Excel has always disliked
formulae that refer to cells in other sheets, though there are ways of
"tricking it" into working.
Cheers,
Jeff Gilbert|||I've created a simple rdl which reproduces the problem. It can be found
attached to SRX050121600563, or just let me know and I can provide it.
-Jeff|||Does this SP need to be applied to the Report Server as well or simply on
workstations developing?
"Robert Bruckner [MSFT]" wrote:
> The fix will be available in the next service pack (SP2).
> You may also contact Microsoft Product Support Services. See
> http://support.microsoft.com/default.aspx?pr=cntactms&style=home. A hotfix
> for the issue is available. The KB article (883501) should be available
> soon.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Benjamin Pierce" <bpierce@.opentext.com> wrote in message
> news:eRd9aCymEHA.3868@.TK2MSFTNGP11.phx.gbl...
> > Hello,
> >
> > I have a fairly simple report (with a lot of columns) that I'm trying to
> > export to Excel. Everytime I do this, I get the following error:
> >
> > "Excel Rendering Extension: Width of excel cell in the excel sheet
> exceeded
> > the maximum limit of 1726.5 Points."
> >
> > I know that 1726.5 equates to 255 characters in a column, but when I
> export
> > to CSV and check the lengths of every value, none of them reach 255.
> >
> > Is there a workaround to this bug?
> >
> > Any guidance on this matter would be much apprecited.
> >
> >
> >
> > Best Regards,
> >
> > Benjamin Pierce
> > Open Text Corporation
> >
> >
> >
>
>|||It needs to be applied on the report server also.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:1B570DFA-5592-4557-914A-740474FBBFDF@.microsoft.com...
> Does this SP need to be applied to the Report Server as well or simply on
> workstations developing?
> "Robert Bruckner [MSFT]" wrote:
>> The fix will be available in the next service pack (SP2).
>> You may also contact Microsoft Product Support Services. See
>> http://support.microsoft.com/default.aspx?pr=cntactms&style=home. A
>> hotfix
>> for the issue is available. The KB article (883501) should be available
>> soon.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Benjamin Pierce" <bpierce@.opentext.com> wrote in message
>> news:eRd9aCymEHA.3868@.TK2MSFTNGP11.phx.gbl...
>> > Hello,
>> >
>> > I have a fairly simple report (with a lot of columns) that I'm trying
>> > to
>> > export to Excel. Everytime I do this, I get the following error:
>> >
>> > "Excel Rendering Extension: Width of excel cell in the excel sheet
>> exceeded
>> > the maximum limit of 1726.5 Points."
>> >
>> > I know that 1726.5 equates to 255 characters in a column, but when I
>> export
>> > to CSV and check the lengths of every value, none of them reach 255.
>> >
>> > Is there a workaround to this bug?
>> >
>> > Any guidance on this matter would be much apprecited.
>> >
>> >
>> >
>> > Best Regards,
>> >
>> > Benjamin Pierce
>> > Open Text Corporation
>> >
>> >
>> >
>>
Excel Pop-up
Hi,
In a particular report, i've got the following pop-up when opening the excel export:
http://img515.imageshack.us/img515/9868/xlerror5ye.jpg
(translation from french: "Name already used - Name can't be identical to a predefined name").
It seems that there is a problem with names generated automatically for cells references.
When I suppress report's header, the pop-up doesn't appear.
Any explanation for this behaviour ?
Thanks in advance.
Grgory.
I have the same problem !!