I am unable to print a report from reporting services 2000 and then
from 2005. The rsclientprint file seems to not be compatible with
both. If I delete the file and allow it to reinstall, it will print
fine. But the other version will not.
Is there a rsclientprint.dll that will print both 2000 and 2005 reports
Thank you,
LonRS 2005 Coexisting with RS 2000
I have ran into trouble with printing reports from SQL RS 2005 and
2000. The RSClientPrint is a different version between 2005 and 2000.
The newer 2005 version may be compatible with the 2000, but the 2000
server is looking for its' rsclientprint.dll and throws an error when a
different version is found. I was hoping to maintain the old reports
and develop new reports in the new version. Any suggestion you have on
how to deal with this would be greatly appreciated.
Showing posts with label file. Show all posts
Showing posts with label file. Show all posts
Wednesday, March 28, 2012
Friday, March 23, 2012
RS2005: Excel huge file size
I have an issue with exporting RS2005 reports to Excel:
1) The exported fie size is disproportional to the rowset size - ~7000
records weigh 45 MB, whilst a CSV version of the same report weighs 7MB.
2) RS exports to Excel with a redundant blank A column on the left and 4
rows that hold the report caption. Is there anyway to configure RS not to
export with these rows and columns, so it'll start directly with my data?
We have SSRS Version 9.00.1399.00 with SQL Server 2000 - 8.00.818Offirh wrote:
> I have an issue with exporting RS2005 reports to Excel:
> 1) The exported fie size is disproportional to the rowset size - ~7000
> records weigh 45 MB, whilst a CSV version of the same report weighs 7MB.
> 2) RS exports to Excel with a redundant blank A column on the left and 4
> rows that hold the report caption. Is there anyway to configure RS not to
> export with these rows and columns, so it'll start directly with my data?
> We have SSRS Version 9.00.1399.00 with SQL Server 2000 - 8.00.818
The best way to minimize file size when exporting to excel is to remove
as much formatting from the report design as possible. Remove any
borders, colors, etc. Still, SSRS will apply some formatting to the
resulting export and make it very difficult to match the more efficient
CSV export, (which is your best workaround IMO).
Ghost columns can be very difficult to remove completely, however,
paying attention to the left and right boundaries of your controls in
relation to other controls on your report can help.
For example, if you have a textbox at the top of your report holding a
report title, and then a table beneath which contains detail records,
making sure that the left and right sides of the textbox control align
vertically with the table control, or column boundaries in the table
control will minimize the occurrence of Ghost columns in the excel
export.
Basically, SSRS seems to evaluate each control boundary, and will
define all columns necessary to bound each control's right and left
side, (often merging columns as well which makes things a real mess
when you try to sort data in the spreadsheet).
SoftArtisans has a nice product call OfficeWriter that helps eliminate
the problem altogether. OfficeWriter allows you to define DataSets in
SSRS, and then use Excel to define where you want the data from the
datasets to land. This bypasses SSRS doing the formatting of the Excel
spreadsheet, which results in several desirable outcomes:
1) The memory drawdown on your SSRS box is drastically reduced when
the report is being run. Excel exports take a lot of memory to
complete!
2) The resulting file size is reduced because none of the formatting
codes are generated by SSRS which balloon the excel file size.
3) You bypass all the other formatting problems with merged
columns/rows
4) You get to use all the native Excel functionality in the resulting
report, including custom macros, etc.
But, it's not free!
Philip|||One other design point. You should not use textboxes at all. If you have a
textbox at the top of your report and then a table the user will not be able
to sort the data because of merged columns issue in Excel. I add extra
header rows to my table and put the report title there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"PhilipL" <pal@.philiplee.com> wrote in message
news:1158092129.378116.36300@.b28g2000cwb.googlegroups.com...
> Offirh wrote:
>> I have an issue with exporting RS2005 reports to Excel:
>> 1) The exported fie size is disproportional to the rowset size - ~7000
>> records weigh 45 MB, whilst a CSV version of the same report weighs 7MB.
>> 2) RS exports to Excel with a redundant blank A column on the left and 4
>> rows that hold the report caption. Is there anyway to configure RS not to
>> export with these rows and columns, so it'll start directly with my data?
>> We have SSRS Version 9.00.1399.00 with SQL Server 2000 - 8.00.818
> The best way to minimize file size when exporting to excel is to remove
> as much formatting from the report design as possible. Remove any
> borders, colors, etc. Still, SSRS will apply some formatting to the
> resulting export and make it very difficult to match the more efficient
> CSV export, (which is your best workaround IMO).
> Ghost columns can be very difficult to remove completely, however,
> paying attention to the left and right boundaries of your controls in
> relation to other controls on your report can help.
> For example, if you have a textbox at the top of your report holding a
> report title, and then a table beneath which contains detail records,
> making sure that the left and right sides of the textbox control align
> vertically with the table control, or column boundaries in the table
> control will minimize the occurrence of Ghost columns in the excel
> export.
> Basically, SSRS seems to evaluate each control boundary, and will
> define all columns necessary to bound each control's right and left
> side, (often merging columns as well which makes things a real mess
> when you try to sort data in the spreadsheet).
> SoftArtisans has a nice product call OfficeWriter that helps eliminate
> the problem altogether. OfficeWriter allows you to define DataSets in
> SSRS, and then use Excel to define where you want the data from the
> datasets to land. This bypasses SSRS doing the formatting of the Excel
> spreadsheet, which results in several desirable outcomes:
> 1) The memory drawdown on your SSRS box is drastically reduced when
> the report is being run. Excel exports take a lot of memory to
> complete!
> 2) The resulting file size is reduced because none of the formatting
> codes are generated by SSRS which balloon the excel file size.
> 3) You bypass all the other formatting problems with merged
> columns/rows
> 4) You get to use all the native Excel functionality in the resulting
> report, including custom macros, etc.
> But, it's not free!
> Philip
>sql
1) The exported fie size is disproportional to the rowset size - ~7000
records weigh 45 MB, whilst a CSV version of the same report weighs 7MB.
2) RS exports to Excel with a redundant blank A column on the left and 4
rows that hold the report caption. Is there anyway to configure RS not to
export with these rows and columns, so it'll start directly with my data?
We have SSRS Version 9.00.1399.00 with SQL Server 2000 - 8.00.818Offirh wrote:
> I have an issue with exporting RS2005 reports to Excel:
> 1) The exported fie size is disproportional to the rowset size - ~7000
> records weigh 45 MB, whilst a CSV version of the same report weighs 7MB.
> 2) RS exports to Excel with a redundant blank A column on the left and 4
> rows that hold the report caption. Is there anyway to configure RS not to
> export with these rows and columns, so it'll start directly with my data?
> We have SSRS Version 9.00.1399.00 with SQL Server 2000 - 8.00.818
The best way to minimize file size when exporting to excel is to remove
as much formatting from the report design as possible. Remove any
borders, colors, etc. Still, SSRS will apply some formatting to the
resulting export and make it very difficult to match the more efficient
CSV export, (which is your best workaround IMO).
Ghost columns can be very difficult to remove completely, however,
paying attention to the left and right boundaries of your controls in
relation to other controls on your report can help.
For example, if you have a textbox at the top of your report holding a
report title, and then a table beneath which contains detail records,
making sure that the left and right sides of the textbox control align
vertically with the table control, or column boundaries in the table
control will minimize the occurrence of Ghost columns in the excel
export.
Basically, SSRS seems to evaluate each control boundary, and will
define all columns necessary to bound each control's right and left
side, (often merging columns as well which makes things a real mess
when you try to sort data in the spreadsheet).
SoftArtisans has a nice product call OfficeWriter that helps eliminate
the problem altogether. OfficeWriter allows you to define DataSets in
SSRS, and then use Excel to define where you want the data from the
datasets to land. This bypasses SSRS doing the formatting of the Excel
spreadsheet, which results in several desirable outcomes:
1) The memory drawdown on your SSRS box is drastically reduced when
the report is being run. Excel exports take a lot of memory to
complete!
2) The resulting file size is reduced because none of the formatting
codes are generated by SSRS which balloon the excel file size.
3) You bypass all the other formatting problems with merged
columns/rows
4) You get to use all the native Excel functionality in the resulting
report, including custom macros, etc.
But, it's not free!
Philip|||One other design point. You should not use textboxes at all. If you have a
textbox at the top of your report and then a table the user will not be able
to sort the data because of merged columns issue in Excel. I add extra
header rows to my table and put the report title there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"PhilipL" <pal@.philiplee.com> wrote in message
news:1158092129.378116.36300@.b28g2000cwb.googlegroups.com...
> Offirh wrote:
>> I have an issue with exporting RS2005 reports to Excel:
>> 1) The exported fie size is disproportional to the rowset size - ~7000
>> records weigh 45 MB, whilst a CSV version of the same report weighs 7MB.
>> 2) RS exports to Excel with a redundant blank A column on the left and 4
>> rows that hold the report caption. Is there anyway to configure RS not to
>> export with these rows and columns, so it'll start directly with my data?
>> We have SSRS Version 9.00.1399.00 with SQL Server 2000 - 8.00.818
> The best way to minimize file size when exporting to excel is to remove
> as much formatting from the report design as possible. Remove any
> borders, colors, etc. Still, SSRS will apply some formatting to the
> resulting export and make it very difficult to match the more efficient
> CSV export, (which is your best workaround IMO).
> Ghost columns can be very difficult to remove completely, however,
> paying attention to the left and right boundaries of your controls in
> relation to other controls on your report can help.
> For example, if you have a textbox at the top of your report holding a
> report title, and then a table beneath which contains detail records,
> making sure that the left and right sides of the textbox control align
> vertically with the table control, or column boundaries in the table
> control will minimize the occurrence of Ghost columns in the excel
> export.
> Basically, SSRS seems to evaluate each control boundary, and will
> define all columns necessary to bound each control's right and left
> side, (often merging columns as well which makes things a real mess
> when you try to sort data in the spreadsheet).
> SoftArtisans has a nice product call OfficeWriter that helps eliminate
> the problem altogether. OfficeWriter allows you to define DataSets in
> SSRS, and then use Excel to define where you want the data from the
> datasets to land. This bypasses SSRS doing the formatting of the Excel
> spreadsheet, which results in several desirable outcomes:
> 1) The memory drawdown on your SSRS box is drastically reduced when
> the report is being run. Excel exports take a lot of memory to
> complete!
> 2) The resulting file size is reduced because none of the formatting
> codes are generated by SSRS which balloon the excel file size.
> 3) You bypass all the other formatting problems with merged
> columns/rows
> 4) You get to use all the native Excel functionality in the resulting
> report, including custom macros, etc.
> But, it's not free!
> Philip
>sql
Wednesday, March 21, 2012
RS2000: Failure sending mail: Cannot access a closed file...
SQL Server 2000, RS2000...
I have 2 timed subscriptions to the same report. One of the
subscriptions delivers the report via Report Server Email, the other
via File share.
If I choose PDF orWeb Archive as the deliverable then then both
reports work. If I choose Excel, I get the following error message
posted on the Report Server next to Status when I look at both
subscriptions to the report.
Any idea what is happening?
Thanks,
KeithOn Feb 1, 5:29 pm, 1300...@.gmail.com wrote:
> SQL Server 2000, RS2000...
> I have 2 timed subscriptions to the same report. One of the
> subscriptions delivers the report via Report Server Email, the other
> via File share.
> If I choose PDF orWeb Archive as the deliverable then then both
> reports work. If I choose Excel, I get the following error message
> posted on the Report Server next to Status when I look at both
> subscriptions to the report.
Guess including the error might help!
Failure sending mail: Cannot access a closed file
> Any idea what is happening?
> Thanks,
> Keith
I have 2 timed subscriptions to the same report. One of the
subscriptions delivers the report via Report Server Email, the other
via File share.
If I choose PDF orWeb Archive as the deliverable then then both
reports work. If I choose Excel, I get the following error message
posted on the Report Server next to Status when I look at both
subscriptions to the report.
Any idea what is happening?
Thanks,
KeithOn Feb 1, 5:29 pm, 1300...@.gmail.com wrote:
> SQL Server 2000, RS2000...
> I have 2 timed subscriptions to the same report. One of the
> subscriptions delivers the report via Report Server Email, the other
> via File share.
> If I choose PDF orWeb Archive as the deliverable then then both
> reports work. If I choose Excel, I get the following error message
> posted on the Report Server next to Status when I look at both
> subscriptions to the report.
Guess including the error might help!
Failure sending mail: Cannot access a closed file
> Any idea what is happening?
> Thanks,
> Keith
Tuesday, March 20, 2012
RS_BooksOnline error 2711
I'm doing the command line install with
setup.exe /settings.
In my ini file, I have the following enry (watch for line
wrap):
ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
_BooksOnline_EN,RS_Samples,RS_AdventureWorks
The setup fails, and in the setup log file, I have this
error:
DEBUG: Error 2711: The specified Feature name
('RS_BooksOnline_EN') not found in Feature Table.
The installer has encountered an unexpected error
installing this package. This may indicate a problem with
this package. The error code is 2711. The arguments are:
RS_BooksOnline_EN, ,
MSI (s) (18:A0): Product: Microsoft SQL Server 2000
Reporting Services Developer Edition -- The installer has
encountered an unexpected error installing this package.
This may indicate a problem with this package. The error
code is 2711. The arguments are
: RS_BooksOnline_EN, ,
Question: if RS_BooksONline_EN is not the right entry,
what should be?
JoeTry RS_BooksOnline_1033. It looks like the sample template.ini is
incorrect.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
news:5d4101c474c2$1ccf94a0$a301280a@.phx.gbl...
> I'm doing the command line install with
> setup.exe /settings.
> In my ini file, I have the following enry (watch for line
> wrap):
> ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
> _BooksOnline_EN,RS_Samples,RS_AdventureWorks
> The setup fails, and in the setup log file, I have this
> error:
> DEBUG: Error 2711: The specified Feature name
> ('RS_BooksOnline_EN') not found in Feature Table.
> The installer has encountered an unexpected error
> installing this package. This may indicate a problem with
> this package. The error code is 2711. The arguments are:
> RS_BooksOnline_EN, ,
> MSI (s) (18:A0): Product: Microsoft SQL Server 2000
> Reporting Services Developer Edition -- The installer has
> encountered an unexpected error installing this package.
> This may indicate a problem with this package. The error
> code is 2711. The arguments are
> : RS_BooksOnline_EN, ,
> Question: if RS_BooksONline_EN is not the right entry,
> what should be?
> Joe
>|||Where is the mapping between these numbers and the language names
documented? I guess 1033 refers to English, right?
Linchi
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:e7yokNMdEHA.212@.TK2MSFTNGP12.phx.gbl...
> Try RS_BooksOnline_1033. It looks like the sample template.ini is
> incorrect.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> news:5d4101c474c2$1ccf94a0$a301280a@.phx.gbl...
> > I'm doing the command line install with
> > setup.exe /settings.
> > In my ini file, I have the following enry (watch for line
> > wrap):
> >
> > ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
> > _BooksOnline_EN,RS_Samples,RS_AdventureWorks
> >
> > The setup fails, and in the setup log file, I have this
> > error:
> >
> > DEBUG: Error 2711: The specified Feature name
> > ('RS_BooksOnline_EN') not found in Feature Table.
> > The installer has encountered an unexpected error
> > installing this package. This may indicate a problem with
> > this package. The error code is 2711. The arguments are:
> > RS_BooksOnline_EN, ,
> > MSI (s) (18:A0): Product: Microsoft SQL Server 2000
> > Reporting Services Developer Edition -- The installer has
> > encountered an unexpected error installing this package.
> > This may indicate a problem with this package. The error
> > code is 2711. The arguments are
> > : RS_BooksOnline_EN, ,
> >
> > Question: if RS_BooksONline_EN is not the right entry,
> > what should be?
> >
> > Joe
> >
>|||Here are the supported languages
Chinese Simplified = 2052
Chinese Traditional = 1028
English = 1033
French = 1036
German = 1031
Italian = 1040
Japanese = 1041
Korean = 1042
Spanish = 3082
Hope that helps.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:uf56xGOdEHA.1644@.tk2msftngp13.phx.gbl...
> Where is the mapping between these numbers and the language names
> documented? I guess 1033 refers to English, right?
> Linchi
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:e7yokNMdEHA.212@.TK2MSFTNGP12.phx.gbl...
> > Try RS_BooksOnline_1033. It looks like the sample template.ini is
> > incorrect.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> > news:5d4101c474c2$1ccf94a0$a301280a@.phx.gbl...
> > > I'm doing the command line install with
> > > setup.exe /settings.
> > > In my ini file, I have the following enry (watch for line
> > > wrap):
> > >
> > > ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
> > > _BooksOnline_EN,RS_Samples,RS_AdventureWorks
> > >
> > > The setup fails, and in the setup log file, I have this
> > > error:
> > >
> > > DEBUG: Error 2711: The specified Feature name
> > > ('RS_BooksOnline_EN') not found in Feature Table.
> > > The installer has encountered an unexpected error
> > > installing this package. This may indicate a problem with
> > > this package. The error code is 2711. The arguments are:
> > > RS_BooksOnline_EN, ,
> > > MSI (s) (18:A0): Product: Microsoft SQL Server 2000
> > > Reporting Services Developer Edition -- The installer has
> > > encountered an unexpected error installing this package.
> > > This may indicate a problem with this package. The error
> > > code is 2711. The arguments are
> > > : RS_BooksOnline_EN, ,
> > >
> > > Question: if RS_BooksONline_EN is not the right entry,
> > > what should be?
> > >
> > > Joe
> > >
> >
> >
>|||The mapping between culture identifiers and culture names is also documented
in MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemglobalizationcultureinfoclasstopic.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23GAOwwOdEHA.3016@.tk2msftngp13.phx.gbl...
> Here are the supported languages
> Chinese Simplified = 2052
> Chinese Traditional = 1028
> English = 1033
> French = 1036
> German = 1031
> Italian = 1040
> Japanese = 1041
> Korean = 1042
> Spanish = 3082
> Hope that helps.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
> news:uf56xGOdEHA.1644@.tk2msftngp13.phx.gbl...
> > Where is the mapping between these numbers and the language names
> > documented? I guess 1033 refers to English, right?
> >
> > Linchi
> >
> > "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> > news:e7yokNMdEHA.212@.TK2MSFTNGP12.phx.gbl...
> > > Try RS_BooksOnline_1033. It looks like the sample template.ini is
> > > incorrect.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> > > news:5d4101c474c2$1ccf94a0$a301280a@.phx.gbl...
> > > > I'm doing the command line install with
> > > > setup.exe /settings.
> > > > In my ini file, I have the following enry (watch for line
> > > > wrap):
> > > >
> > > > ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
> > > > _BooksOnline_EN,RS_Samples,RS_AdventureWorks
> > > >
> > > > The setup fails, and in the setup log file, I have this
> > > > error:
> > > >
> > > > DEBUG: Error 2711: The specified Feature name
> > > > ('RS_BooksOnline_EN') not found in Feature Table.
> > > > The installer has encountered an unexpected error
> > > > installing this package. This may indicate a problem with
> > > > this package. The error code is 2711. The arguments are:
> > > > RS_BooksOnline_EN, ,
> > > > MSI (s) (18:A0): Product: Microsoft SQL Server 2000
> > > > Reporting Services Developer Edition -- The installer has
> > > > encountered an unexpected error installing this package.
> > > > This may indicate a problem with this package. The error
> > > > code is 2711. The arguments are
> > > > : RS_BooksOnline_EN, ,
> > > >
> > > > Question: if RS_BooksONline_EN is not the right entry,
> > > > what should be?
> > > >
> > > > Joe
> > > >
> > >
> > >
> >
> >
>
setup.exe /settings.
In my ini file, I have the following enry (watch for line
wrap):
ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
_BooksOnline_EN,RS_Samples,RS_AdventureWorks
The setup fails, and in the setup log file, I have this
error:
DEBUG: Error 2711: The specified Feature name
('RS_BooksOnline_EN') not found in Feature Table.
The installer has encountered an unexpected error
installing this package. This may indicate a problem with
this package. The error code is 2711. The arguments are:
RS_BooksOnline_EN, ,
MSI (s) (18:A0): Product: Microsoft SQL Server 2000
Reporting Services Developer Edition -- The installer has
encountered an unexpected error installing this package.
This may indicate a problem with this package. The error
code is 2711. The arguments are
: RS_BooksOnline_EN, ,
Question: if RS_BooksONline_EN is not the right entry,
what should be?
JoeTry RS_BooksOnline_1033. It looks like the sample template.ini is
incorrect.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
news:5d4101c474c2$1ccf94a0$a301280a@.phx.gbl...
> I'm doing the command line install with
> setup.exe /settings.
> In my ini file, I have the following enry (watch for line
> wrap):
> ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
> _BooksOnline_EN,RS_Samples,RS_AdventureWorks
> The setup fails, and in the setup log file, I have this
> error:
> DEBUG: Error 2711: The specified Feature name
> ('RS_BooksOnline_EN') not found in Feature Table.
> The installer has encountered an unexpected error
> installing this package. This may indicate a problem with
> this package. The error code is 2711. The arguments are:
> RS_BooksOnline_EN, ,
> MSI (s) (18:A0): Product: Microsoft SQL Server 2000
> Reporting Services Developer Edition -- The installer has
> encountered an unexpected error installing this package.
> This may indicate a problem with this package. The error
> code is 2711. The arguments are
> : RS_BooksOnline_EN, ,
> Question: if RS_BooksONline_EN is not the right entry,
> what should be?
> Joe
>|||Where is the mapping between these numbers and the language names
documented? I guess 1033 refers to English, right?
Linchi
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:e7yokNMdEHA.212@.TK2MSFTNGP12.phx.gbl...
> Try RS_BooksOnline_1033. It looks like the sample template.ini is
> incorrect.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> news:5d4101c474c2$1ccf94a0$a301280a@.phx.gbl...
> > I'm doing the command line install with
> > setup.exe /settings.
> > In my ini file, I have the following enry (watch for line
> > wrap):
> >
> > ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
> > _BooksOnline_EN,RS_Samples,RS_AdventureWorks
> >
> > The setup fails, and in the setup log file, I have this
> > error:
> >
> > DEBUG: Error 2711: The specified Feature name
> > ('RS_BooksOnline_EN') not found in Feature Table.
> > The installer has encountered an unexpected error
> > installing this package. This may indicate a problem with
> > this package. The error code is 2711. The arguments are:
> > RS_BooksOnline_EN, ,
> > MSI (s) (18:A0): Product: Microsoft SQL Server 2000
> > Reporting Services Developer Edition -- The installer has
> > encountered an unexpected error installing this package.
> > This may indicate a problem with this package. The error
> > code is 2711. The arguments are
> > : RS_BooksOnline_EN, ,
> >
> > Question: if RS_BooksONline_EN is not the right entry,
> > what should be?
> >
> > Joe
> >
>|||Here are the supported languages
Chinese Simplified = 2052
Chinese Traditional = 1028
English = 1033
French = 1036
German = 1031
Italian = 1040
Japanese = 1041
Korean = 1042
Spanish = 3082
Hope that helps.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:uf56xGOdEHA.1644@.tk2msftngp13.phx.gbl...
> Where is the mapping between these numbers and the language names
> documented? I guess 1033 refers to English, right?
> Linchi
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:e7yokNMdEHA.212@.TK2MSFTNGP12.phx.gbl...
> > Try RS_BooksOnline_1033. It looks like the sample template.ini is
> > incorrect.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> > news:5d4101c474c2$1ccf94a0$a301280a@.phx.gbl...
> > > I'm doing the command line install with
> > > setup.exe /settings.
> > > In my ini file, I have the following enry (watch for line
> > > wrap):
> > >
> > > ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
> > > _BooksOnline_EN,RS_Samples,RS_AdventureWorks
> > >
> > > The setup fails, and in the setup log file, I have this
> > > error:
> > >
> > > DEBUG: Error 2711: The specified Feature name
> > > ('RS_BooksOnline_EN') not found in Feature Table.
> > > The installer has encountered an unexpected error
> > > installing this package. This may indicate a problem with
> > > this package. The error code is 2711. The arguments are:
> > > RS_BooksOnline_EN, ,
> > > MSI (s) (18:A0): Product: Microsoft SQL Server 2000
> > > Reporting Services Developer Edition -- The installer has
> > > encountered an unexpected error installing this package.
> > > This may indicate a problem with this package. The error
> > > code is 2711. The arguments are
> > > : RS_BooksOnline_EN, ,
> > >
> > > Question: if RS_BooksONline_EN is not the right entry,
> > > what should be?
> > >
> > > Joe
> > >
> >
> >
>|||The mapping between culture identifiers and culture names is also documented
in MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemglobalizationcultureinfoclasstopic.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23GAOwwOdEHA.3016@.tk2msftngp13.phx.gbl...
> Here are the supported languages
> Chinese Simplified = 2052
> Chinese Traditional = 1028
> English = 1033
> French = 1036
> German = 1031
> Italian = 1040
> Japanese = 1041
> Korean = 1042
> Spanish = 3082
> Hope that helps.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
> news:uf56xGOdEHA.1644@.tk2msftngp13.phx.gbl...
> > Where is the mapping between these numbers and the language names
> > documented? I guess 1033 refers to English, right?
> >
> > Linchi
> >
> > "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> > news:e7yokNMdEHA.212@.TK2MSFTNGP12.phx.gbl...
> > > Try RS_BooksOnline_1033. It looks like the sample template.ini is
> > > incorrect.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> > > news:5d4101c474c2$1ccf94a0$a301280a@.phx.gbl...
> > > > I'm doing the command line install with
> > > > setup.exe /settings.
> > > > In my ini file, I have the following enry (watch for line
> > > > wrap):
> > > >
> > > > ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
> > > > _BooksOnline_EN,RS_Samples,RS_AdventureWorks
> > > >
> > > > The setup fails, and in the setup log file, I have this
> > > > error:
> > > >
> > > > DEBUG: Error 2711: The specified Feature name
> > > > ('RS_BooksOnline_EN') not found in Feature Table.
> > > > The installer has encountered an unexpected error
> > > > installing this package. This may indicate a problem with
> > > > this package. The error code is 2711. The arguments are:
> > > > RS_BooksOnline_EN, ,
> > > > MSI (s) (18:A0): Product: Microsoft SQL Server 2000
> > > > Reporting Services Developer Edition -- The installer has
> > > > encountered an unexpected error installing this package.
> > > > This may indicate a problem with this package. The error
> > > > code is 2711. The arguments are
> > > > : RS_BooksOnline_EN, ,
> > > >
> > > > Question: if RS_BooksONline_EN is not the right entry,
> > > > what should be?
> > > >
> > > > Joe
> > > >
> > >
> > >
> >
> >
>
rs.exe Questions on using rss file
Multiple Questions on deploying a bulk insertion script file for inserting
reports into reporting services. The script provided by MSDN PublishReports
is really straight forward with some exceptions or at least for me.
How can I ensure that the Data connection that is added in the script gets
added to each report that gets published in the script?
I am recieving an error that states the data set 'Default' refers to a
shared data source 'Default', which is not published on the report server
when I run my script. However the dataconnection that I specified in the
script gets created by the script and works perfectly.
How can I specify a Published Name that is different than the Report.rdl
Name in the scrtipt at the time of insertion? Basically just as if you were
to do the publishing of a report one at a time through the manager and after
uploading the file you can change the name of the Report. How can I do that
in the script?
Thank you for the assitance!
Bradd
please email me @. the following address if you need further clarification to
help my stupid mind. bradd.schick@.fnf.com Thank youSorry the Data Connection taht I am creating in the script is not called
default it is named something different. Just incase anyone neede to know
that.
So Why am I getting an error on Default?
Thanks again
"Bradd Schick" wrote:
> Multiple Questions on deploying a bulk insertion script file for inserting
> reports into reporting services. The script provided by MSDN PublishReports
> is really straight forward with some exceptions or at least for me.
> How can I ensure that the Data connection that is added in the script gets
> added to each report that gets published in the script?
> I am recieving an error that states the data set 'Default' refers to a
> shared data source 'Default', which is not published on the report server
> when I run my script. However the dataconnection that I specified in the
> script gets created by the script and works perfectly.
> How can I specify a Published Name that is different than the Report.rdl
> Name in the scrtipt at the time of insertion? Basically just as if you were
> to do the publishing of a report one at a time through the manager and after
> uploading the file you can change the name of the Report. How can I do that
> in the script?
> Thank you for the assitance!
> Bradd
> please email me @. the following address if you need further clarification to
> help my stupid mind. bradd.schick@.fnf.com Thank you|||Alright I got my head out of you know where and I have solved the first
question of the data connection's. The person writing the report (rdl) file
screwed up. I still need help on the second question of the report name.
Thanks
"Bradd Schick" wrote:
> Multiple Questions on deploying a bulk insertion script file for inserting
> reports into reporting services. The script provided by MSDN PublishReports
> is really straight forward with some exceptions or at least for me.
> How can I ensure that the Data connection that is added in the script gets
> added to each report that gets published in the script?
> I am recieving an error that states the data set 'Default' refers to a
> shared data source 'Default', which is not published on the report server
> when I run my script. However the dataconnection that I specified in the
> script gets created by the script and works perfectly.
> How can I specify a Published Name that is different than the Report.rdl
> Name in the scrtipt at the time of insertion? Basically just as if you were
> to do the publishing of a report one at a time through the manager and after
> uploading the file you can change the name of the Report. How can I do that
> in the script?
> Thank you for the assitance!
> Bradd
> please email me @. the following address if you need further clarification to
> help my stupid mind. bradd.schick@.fnf.com Thank you|||Try this snippet in your script:
' Create an array representing the files in the specified directory.
Dim di As New DirectoryInfo(strPathName)
Dim fi As FileInfo() = di.GetFiles()
' Optional to echo to console
Console.WriteLine("The following files exist in the current
directory:")
' Iterate through the names of the files in the current directory.
Dim fiTemp As FileInfo
For Each fiTemp In fi
strReportName = Path.GetFileNameWithoutExtension(fiTemp.Name)
PublishReport(strReportName)
Next fiTemp
Just a bit of those new VB .NET methods.
--
Brian J. Matuschak
brian@.electronic-atlas.com
"Bradd Schick" wrote:
> Alright I got my head out of you know where and I have solved the first
> question of the data connection's. The person writing the report (rdl) file
> screwed up. I still need help on the second question of the report name.
> Thanks
> "Bradd Schick" wrote:
> > Multiple Questions on deploying a bulk insertion script file for inserting
> > reports into reporting services. The script provided by MSDN PublishReports
> > is really straight forward with some exceptions or at least for me.
> >
> > How can I ensure that the Data connection that is added in the script gets
> > added to each report that gets published in the script?
> > I am recieving an error that states the data set 'Default' refers to a
> > shared data source 'Default', which is not published on the report server
> > when I run my script. However the dataconnection that I specified in the
> > script gets created by the script and works perfectly.
> >
> > How can I specify a Published Name that is different than the Report.rdl
> > Name in the scrtipt at the time of insertion? Basically just as if you were
> > to do the publishing of a report one at a time through the manager and after
> > uploading the file you can change the name of the Report. How can I do that
> > in the script?
> >
> > Thank you for the assitance!
> >
> > Bradd
> > please email me @. the following address if you need further clarification to
> > help my stupid mind. bradd.schick@.fnf.com Thank you
reports into reporting services. The script provided by MSDN PublishReports
is really straight forward with some exceptions or at least for me.
How can I ensure that the Data connection that is added in the script gets
added to each report that gets published in the script?
I am recieving an error that states the data set 'Default' refers to a
shared data source 'Default', which is not published on the report server
when I run my script. However the dataconnection that I specified in the
script gets created by the script and works perfectly.
How can I specify a Published Name that is different than the Report.rdl
Name in the scrtipt at the time of insertion? Basically just as if you were
to do the publishing of a report one at a time through the manager and after
uploading the file you can change the name of the Report. How can I do that
in the script?
Thank you for the assitance!
Bradd
please email me @. the following address if you need further clarification to
help my stupid mind. bradd.schick@.fnf.com Thank youSorry the Data Connection taht I am creating in the script is not called
default it is named something different. Just incase anyone neede to know
that.
So Why am I getting an error on Default?
Thanks again
"Bradd Schick" wrote:
> Multiple Questions on deploying a bulk insertion script file for inserting
> reports into reporting services. The script provided by MSDN PublishReports
> is really straight forward with some exceptions or at least for me.
> How can I ensure that the Data connection that is added in the script gets
> added to each report that gets published in the script?
> I am recieving an error that states the data set 'Default' refers to a
> shared data source 'Default', which is not published on the report server
> when I run my script. However the dataconnection that I specified in the
> script gets created by the script and works perfectly.
> How can I specify a Published Name that is different than the Report.rdl
> Name in the scrtipt at the time of insertion? Basically just as if you were
> to do the publishing of a report one at a time through the manager and after
> uploading the file you can change the name of the Report. How can I do that
> in the script?
> Thank you for the assitance!
> Bradd
> please email me @. the following address if you need further clarification to
> help my stupid mind. bradd.schick@.fnf.com Thank you|||Alright I got my head out of you know where and I have solved the first
question of the data connection's. The person writing the report (rdl) file
screwed up. I still need help on the second question of the report name.
Thanks
"Bradd Schick" wrote:
> Multiple Questions on deploying a bulk insertion script file for inserting
> reports into reporting services. The script provided by MSDN PublishReports
> is really straight forward with some exceptions or at least for me.
> How can I ensure that the Data connection that is added in the script gets
> added to each report that gets published in the script?
> I am recieving an error that states the data set 'Default' refers to a
> shared data source 'Default', which is not published on the report server
> when I run my script. However the dataconnection that I specified in the
> script gets created by the script and works perfectly.
> How can I specify a Published Name that is different than the Report.rdl
> Name in the scrtipt at the time of insertion? Basically just as if you were
> to do the publishing of a report one at a time through the manager and after
> uploading the file you can change the name of the Report. How can I do that
> in the script?
> Thank you for the assitance!
> Bradd
> please email me @. the following address if you need further clarification to
> help my stupid mind. bradd.schick@.fnf.com Thank you|||Try this snippet in your script:
' Create an array representing the files in the specified directory.
Dim di As New DirectoryInfo(strPathName)
Dim fi As FileInfo() = di.GetFiles()
' Optional to echo to console
Console.WriteLine("The following files exist in the current
directory:")
' Iterate through the names of the files in the current directory.
Dim fiTemp As FileInfo
For Each fiTemp In fi
strReportName = Path.GetFileNameWithoutExtension(fiTemp.Name)
PublishReport(strReportName)
Next fiTemp
Just a bit of those new VB .NET methods.
--
Brian J. Matuschak
brian@.electronic-atlas.com
"Bradd Schick" wrote:
> Alright I got my head out of you know where and I have solved the first
> question of the data connection's. The person writing the report (rdl) file
> screwed up. I still need help on the second question of the report name.
> Thanks
> "Bradd Schick" wrote:
> > Multiple Questions on deploying a bulk insertion script file for inserting
> > reports into reporting services. The script provided by MSDN PublishReports
> > is really straight forward with some exceptions or at least for me.
> >
> > How can I ensure that the Data connection that is added in the script gets
> > added to each report that gets published in the script?
> > I am recieving an error that states the data set 'Default' refers to a
> > shared data source 'Default', which is not published on the report server
> > when I run my script. However the dataconnection that I specified in the
> > script gets created by the script and works perfectly.
> >
> > How can I specify a Published Name that is different than the Report.rdl
> > Name in the scrtipt at the time of insertion? Basically just as if you were
> > to do the publishing of a report one at a time through the manager and after
> > uploading the file you can change the name of the Report. How can I do that
> > in the script?
> >
> > Thank you for the assitance!
> >
> > Bradd
> > please email me @. the following address if you need further clarification to
> > help my stupid mind. bradd.schick@.fnf.com Thank you
rs.exe and Oracle
I am trying to create a .rss file that deploys my reports to the report
server. I have everything working except for the creation of the datasource.
The problem is that I am using an Oracle database and I cannot set the
correct setting in my code.
I can create a datasource; but I have to log into the report server and
change the "Connect Type" dropdown to "Oracle" to get the datasource to work.
The below bit of code works (notice I am setting the Extension to SQL)
...
Dim definition As New DataSourceDefinition()
definition.CredentialRetrieval = CredentialRetrievalEnum.Store
definition.ConnectString = connectionString
definition.Enabled = True
definition.Extension = "SQL"
definition.ImpersonateUser = False
definition.ImpersonateUserSpecified = True
definition.WindowsCredentials = False
...
The below code DOES NOT work (I am setting the Extension to Oracle)
...
Dim definition As New DataSourceDefinition()
definition.CredentialRetrieval = CredentialRetrievalEnum.Store
definition.ConnectString = connectionString
definition.Enabled = True
definition.Extension = "Oracle"
definition.ImpersonateUser = False
definition.ImpersonateUserSpecified = True
definition.WindowsCredentials = False
...
There has to be some easy change here to get this to work with an Oracle
database, I just cannot find out what the Oracle string is to set the
Extension.
Any ideas? Thanks for any help or suggestion.
RobRob,
Here is my rs code that worked for me, looks the same but maybe give it a
shot, the only thing i see if you have "Oracle" and i have "ORACLE", not sure
if that is it.:
Dim Definition As New DataSourceDefinition
Dim Properties(1) As [Property]
Dim Description As New [Property]
Dim Hidden As New [Property]
Description.Name = "Description"
Description.Value = "DataSourceDescription"
Hidden.Name = "Hidden"
Hidden.Value = "False"
Properties(0) = Description
Properties(1) = Hidden
Definition.CredentialRetrieval = CredentialRetrievalEnum.Store
Definition.UserName = "UserName"
Definition.ConnectString = "Data Source=DATABASE;Unicode=True"
Definition.Enabled = True
Definition.Extension = "ORACLE"
Definition.WindowsCredentials = False ' (Prompt and Store)
Definition.ImpersonateUser = False ' (Store)
Definition.EnabledSpecified = True
Definition.ImpersonateUserSpecified = True
Definition.OriginalConnectStringExpressionBased = False
Definition.UseOriginalConnectString = False
"Rob" wrote:
> I am trying to create a .rss file that deploys my reports to the report
> server. I have everything working except for the creation of the datasource.
> The problem is that I am using an Oracle database and I cannot set the
> correct setting in my code.
> I can create a datasource; but I have to log into the report server and
> change the "Connect Type" dropdown to "Oracle" to get the datasource to work.
> The below bit of code works (notice I am setting the Extension to SQL)
> ...
> Dim definition As New DataSourceDefinition()
> definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> definition.ConnectString = connectionString
> definition.Enabled = True
> definition.Extension = "SQL"
> definition.ImpersonateUser = False
> definition.ImpersonateUserSpecified = True
> definition.WindowsCredentials = False
> ...
> The below code DOES NOT work (I am setting the Extension to Oracle)
> ...
> Dim definition As New DataSourceDefinition()
> definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> definition.ConnectString = connectionString
> definition.Enabled = True
> definition.Extension = "Oracle"
> definition.ImpersonateUser = False
> definition.ImpersonateUserSpecified = True
> definition.WindowsCredentials = False
> ...
> There has to be some easy change here to get this to work with an Oracle
> database, I just cannot find out what the Oracle string is to set the
> Extension.
> Any ideas? Thanks for any help or suggestion.
> Rob
>|||One other thing, I posted this before, but here is how you can debug a RS.exe
script. Not sure if this is any help on this issue but can help down the road.
In Visual Studio
1. Create a new Visual Basic Console Application Project: name it RSDebug
2. In the Soultion Explorer window - right click on the RSDebug Project and
select the Add Web Reference option.
3. In the URL text box add:
http://servername/reportserver/reportservice2005.asmx
4. Click Go Command Button (This step takes a while)
5. In the Web Reference Name text box add SSRSWebService
6. Click Add Reference Command Button
7. In the Code Window above the Module Module1 add: Imports
RSDebug.SSRSWebService
Imports
System.Web.Services.Protocols
8. Below the Module Module1 add: Public rs As New ReportingService2005
9. Paste your script code in the Sub Main() procedure
10. Set your breakpoint and go.
Example: (In this example System.IO is needed due to the use of the
MemoryStream object)
Imports RSDebug.SSRSWebService
Imports System.Web.Services.Protocols
Imports System.IO ' This was added because MemoryStream was used
Module Module1
Public rs As New ReportingService2005
Sub Main()
Dim strObjectName As String = "Report Name"
Dim strObjectPath As String = "/Application"
Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
Dim strLocalFile As String = "Report Name.rdl"
Dim strLocalPath As String = "C:\"
Dim strLocalFullPath As String = strLocalPath & strLocalFile
Dim objReportDefinition As Byte()
Dim objMemoryStream As MemoryStream
Dim objDocument As New System.Xml.XmlDocument()
Try
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
objMemoryStream = New MemoryStream(objReportDefinition)
objDocument.Load(objMemoryStream)
objDocument.Save(strLocalFullPath)
Console.WriteLine("Standard: Report downloaded successfully.")
Catch e As SoapException
Console.WriteLine("Error: " +
e.Detail.Item("ErrorCode").InnerText + " (" +
e.Detail.Item("Message").InnerText + ")")
End Try
End Sub
End Module|||YES!!!
That was it. I used:
Definition.Extension = "ORACLE"
and the datasource was created successfully. Thank you so much for your
help. Sometimes the answer is right in front of your eyes yet one cannot see
it.
Once again, thanks.
Rob
"Reeves Smith" wrote:
> Rob,
> Here is my rs code that worked for me, looks the same but maybe give it a
> shot, the only thing i see if you have "Oracle" and i have "ORACLE", not sure
> if that is it.:
> Dim Definition As New DataSourceDefinition
> Dim Properties(1) As [Property]
> Dim Description As New [Property]
> Dim Hidden As New [Property]
> Description.Name = "Description"
> Description.Value = "DataSourceDescription"
> Hidden.Name = "Hidden"
> Hidden.Value = "False"
> Properties(0) = Description
> Properties(1) = Hidden
> Definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> Definition.UserName = "UserName"
> Definition.ConnectString = "Data Source=DATABASE;Unicode=True"
> Definition.Enabled = True
> Definition.Extension = "ORACLE"
> Definition.WindowsCredentials = False ' (Prompt and Store)
> Definition.ImpersonateUser = False ' (Store)
> Definition.EnabledSpecified = True
> Definition.ImpersonateUserSpecified = True
> Definition.OriginalConnectStringExpressionBased = False
> Definition.UseOriginalConnectString = False
>
> "Rob" wrote:
> > I am trying to create a .rss file that deploys my reports to the report
> > server. I have everything working except for the creation of the datasource.
> > The problem is that I am using an Oracle database and I cannot set the
> > correct setting in my code.
> >
> > I can create a datasource; but I have to log into the report server and
> > change the "Connect Type" dropdown to "Oracle" to get the datasource to work.
> >
> > The below bit of code works (notice I am setting the Extension to SQL)
> > ...
> > Dim definition As New DataSourceDefinition()
> > definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> > definition.ConnectString = connectionString
> > definition.Enabled = True
> > definition.Extension = "SQL"
> > definition.ImpersonateUser = False
> > definition.ImpersonateUserSpecified = True
> > definition.WindowsCredentials = False
> > ...
> >
> > The below code DOES NOT work (I am setting the Extension to Oracle)
> > ...
> > Dim definition As New DataSourceDefinition()
> > definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> > definition.ConnectString = connectionString
> > definition.Enabled = True
> > definition.Extension = "Oracle"
> > definition.ImpersonateUser = False
> > definition.ImpersonateUserSpecified = True
> > definition.WindowsCredentials = False
> > ...
> >
> > There has to be some easy change here to get this to work with an Oracle
> > database, I just cannot find out what the Oracle string is to set the
> > Extension.
> >
> > Any ideas? Thanks for any help or suggestion.
> >
> > Rob
> >
> >
server. I have everything working except for the creation of the datasource.
The problem is that I am using an Oracle database and I cannot set the
correct setting in my code.
I can create a datasource; but I have to log into the report server and
change the "Connect Type" dropdown to "Oracle" to get the datasource to work.
The below bit of code works (notice I am setting the Extension to SQL)
...
Dim definition As New DataSourceDefinition()
definition.CredentialRetrieval = CredentialRetrievalEnum.Store
definition.ConnectString = connectionString
definition.Enabled = True
definition.Extension = "SQL"
definition.ImpersonateUser = False
definition.ImpersonateUserSpecified = True
definition.WindowsCredentials = False
...
The below code DOES NOT work (I am setting the Extension to Oracle)
...
Dim definition As New DataSourceDefinition()
definition.CredentialRetrieval = CredentialRetrievalEnum.Store
definition.ConnectString = connectionString
definition.Enabled = True
definition.Extension = "Oracle"
definition.ImpersonateUser = False
definition.ImpersonateUserSpecified = True
definition.WindowsCredentials = False
...
There has to be some easy change here to get this to work with an Oracle
database, I just cannot find out what the Oracle string is to set the
Extension.
Any ideas? Thanks for any help or suggestion.
RobRob,
Here is my rs code that worked for me, looks the same but maybe give it a
shot, the only thing i see if you have "Oracle" and i have "ORACLE", not sure
if that is it.:
Dim Definition As New DataSourceDefinition
Dim Properties(1) As [Property]
Dim Description As New [Property]
Dim Hidden As New [Property]
Description.Name = "Description"
Description.Value = "DataSourceDescription"
Hidden.Name = "Hidden"
Hidden.Value = "False"
Properties(0) = Description
Properties(1) = Hidden
Definition.CredentialRetrieval = CredentialRetrievalEnum.Store
Definition.UserName = "UserName"
Definition.ConnectString = "Data Source=DATABASE;Unicode=True"
Definition.Enabled = True
Definition.Extension = "ORACLE"
Definition.WindowsCredentials = False ' (Prompt and Store)
Definition.ImpersonateUser = False ' (Store)
Definition.EnabledSpecified = True
Definition.ImpersonateUserSpecified = True
Definition.OriginalConnectStringExpressionBased = False
Definition.UseOriginalConnectString = False
"Rob" wrote:
> I am trying to create a .rss file that deploys my reports to the report
> server. I have everything working except for the creation of the datasource.
> The problem is that I am using an Oracle database and I cannot set the
> correct setting in my code.
> I can create a datasource; but I have to log into the report server and
> change the "Connect Type" dropdown to "Oracle" to get the datasource to work.
> The below bit of code works (notice I am setting the Extension to SQL)
> ...
> Dim definition As New DataSourceDefinition()
> definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> definition.ConnectString = connectionString
> definition.Enabled = True
> definition.Extension = "SQL"
> definition.ImpersonateUser = False
> definition.ImpersonateUserSpecified = True
> definition.WindowsCredentials = False
> ...
> The below code DOES NOT work (I am setting the Extension to Oracle)
> ...
> Dim definition As New DataSourceDefinition()
> definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> definition.ConnectString = connectionString
> definition.Enabled = True
> definition.Extension = "Oracle"
> definition.ImpersonateUser = False
> definition.ImpersonateUserSpecified = True
> definition.WindowsCredentials = False
> ...
> There has to be some easy change here to get this to work with an Oracle
> database, I just cannot find out what the Oracle string is to set the
> Extension.
> Any ideas? Thanks for any help or suggestion.
> Rob
>|||One other thing, I posted this before, but here is how you can debug a RS.exe
script. Not sure if this is any help on this issue but can help down the road.
In Visual Studio
1. Create a new Visual Basic Console Application Project: name it RSDebug
2. In the Soultion Explorer window - right click on the RSDebug Project and
select the Add Web Reference option.
3. In the URL text box add:
http://servername/reportserver/reportservice2005.asmx
4. Click Go Command Button (This step takes a while)
5. In the Web Reference Name text box add SSRSWebService
6. Click Add Reference Command Button
7. In the Code Window above the Module Module1 add: Imports
RSDebug.SSRSWebService
Imports
System.Web.Services.Protocols
8. Below the Module Module1 add: Public rs As New ReportingService2005
9. Paste your script code in the Sub Main() procedure
10. Set your breakpoint and go.
Example: (In this example System.IO is needed due to the use of the
MemoryStream object)
Imports RSDebug.SSRSWebService
Imports System.Web.Services.Protocols
Imports System.IO ' This was added because MemoryStream was used
Module Module1
Public rs As New ReportingService2005
Sub Main()
Dim strObjectName As String = "Report Name"
Dim strObjectPath As String = "/Application"
Dim strObjectFullPath As String = strObjectPath & "/" & strObjectName
Dim strLocalFile As String = "Report Name.rdl"
Dim strLocalPath As String = "C:\"
Dim strLocalFullPath As String = strLocalPath & strLocalFile
Dim objReportDefinition As Byte()
Dim objMemoryStream As MemoryStream
Dim objDocument As New System.Xml.XmlDocument()
Try
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
objReportDefinition = rs.GetReportDefinition(strObjectFullPath)
objMemoryStream = New MemoryStream(objReportDefinition)
objDocument.Load(objMemoryStream)
objDocument.Save(strLocalFullPath)
Console.WriteLine("Standard: Report downloaded successfully.")
Catch e As SoapException
Console.WriteLine("Error: " +
e.Detail.Item("ErrorCode").InnerText + " (" +
e.Detail.Item("Message").InnerText + ")")
End Try
End Sub
End Module|||YES!!!
That was it. I used:
Definition.Extension = "ORACLE"
and the datasource was created successfully. Thank you so much for your
help. Sometimes the answer is right in front of your eyes yet one cannot see
it.
Once again, thanks.
Rob
"Reeves Smith" wrote:
> Rob,
> Here is my rs code that worked for me, looks the same but maybe give it a
> shot, the only thing i see if you have "Oracle" and i have "ORACLE", not sure
> if that is it.:
> Dim Definition As New DataSourceDefinition
> Dim Properties(1) As [Property]
> Dim Description As New [Property]
> Dim Hidden As New [Property]
> Description.Name = "Description"
> Description.Value = "DataSourceDescription"
> Hidden.Name = "Hidden"
> Hidden.Value = "False"
> Properties(0) = Description
> Properties(1) = Hidden
> Definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> Definition.UserName = "UserName"
> Definition.ConnectString = "Data Source=DATABASE;Unicode=True"
> Definition.Enabled = True
> Definition.Extension = "ORACLE"
> Definition.WindowsCredentials = False ' (Prompt and Store)
> Definition.ImpersonateUser = False ' (Store)
> Definition.EnabledSpecified = True
> Definition.ImpersonateUserSpecified = True
> Definition.OriginalConnectStringExpressionBased = False
> Definition.UseOriginalConnectString = False
>
> "Rob" wrote:
> > I am trying to create a .rss file that deploys my reports to the report
> > server. I have everything working except for the creation of the datasource.
> > The problem is that I am using an Oracle database and I cannot set the
> > correct setting in my code.
> >
> > I can create a datasource; but I have to log into the report server and
> > change the "Connect Type" dropdown to "Oracle" to get the datasource to work.
> >
> > The below bit of code works (notice I am setting the Extension to SQL)
> > ...
> > Dim definition As New DataSourceDefinition()
> > definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> > definition.ConnectString = connectionString
> > definition.Enabled = True
> > definition.Extension = "SQL"
> > definition.ImpersonateUser = False
> > definition.ImpersonateUserSpecified = True
> > definition.WindowsCredentials = False
> > ...
> >
> > The below code DOES NOT work (I am setting the Extension to Oracle)
> > ...
> > Dim definition As New DataSourceDefinition()
> > definition.CredentialRetrieval = CredentialRetrievalEnum.Store
> > definition.ConnectString = connectionString
> > definition.Enabled = True
> > definition.Extension = "Oracle"
> > definition.ImpersonateUser = False
> > definition.ImpersonateUserSpecified = True
> > definition.WindowsCredentials = False
> > ...
> >
> > There has to be some easy change here to get this to work with an Oracle
> > database, I just cannot find out what the Oracle string is to set the
> > Extension.
> >
> > Any ideas? Thanks for any help or suggestion.
> >
> > Rob
> >
> >
Monday, March 12, 2012
RS Web Service Reference File
Where do I go to add a constractor of "this.Timeout=..." to a the Web Service
reference file?
Challenge: Long running reports are timing out
Thank you for your assistance.Find ReportingService() class in a reference file.
it looks like :
public class ReportingService :
System.Web.Services.Protocols.SoapHttpClientProtocol
{
.....
}
replace "public ReportingService() {...}" with
public ReportingService()
{
this.Timeout=1200000;
}
or you can even overload that constructor by adding the following
public ReportingService(string url)
{
this.Url = url;
this.Timeout=1200000;
}
do not regenerate it, otherwise you'll loose your changes.
another way is to extend ReportingService class.
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:76DCAFF8-F66B-4666-8C96-4A1817D13CD6@.microsoft.com...
> Where do I go to add a constractor of "this.Timeout=..." to a the Web
> Service
> reference file?
> Challenge: Long running reports are timing out
> Thank you for your assistance.
>
>|||Thank you very much!
"Oleg Yevteyev" wrote:
> Find ReportingService() class in a reference file.
> it looks like :
> public class ReportingService :
> System.Web.Services.Protocols.SoapHttpClientProtocol
> {
> ......
> }
> replace "public ReportingService() {...}" with
> public ReportingService()
> {
> this.Timeout=1200000;
> }
> or you can even overload that constructor by adding the following
> public ReportingService(string url)
> {
> this.Url = url;
> this.Timeout=1200000;
> }
> do not regenerate it, otherwise you'll loose your changes.
> another way is to extend ReportingService class.
>
> "Terry" <Terry@.discussions.microsoft.com> wrote in message
> news:76DCAFF8-F66B-4666-8C96-4A1817D13CD6@.microsoft.com...
> > Where do I go to add a constractor of "this.Timeout=..." to a the Web
> > Service
> > reference file?
> >
> > Challenge: Long running reports are timing out
> >
> > Thank you for your assistance.
> >
> >
> >
>
>
reference file?
Challenge: Long running reports are timing out
Thank you for your assistance.Find ReportingService() class in a reference file.
it looks like :
public class ReportingService :
System.Web.Services.Protocols.SoapHttpClientProtocol
{
.....
}
replace "public ReportingService() {...}" with
public ReportingService()
{
this.Timeout=1200000;
}
or you can even overload that constructor by adding the following
public ReportingService(string url)
{
this.Url = url;
this.Timeout=1200000;
}
do not regenerate it, otherwise you'll loose your changes.
another way is to extend ReportingService class.
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:76DCAFF8-F66B-4666-8C96-4A1817D13CD6@.microsoft.com...
> Where do I go to add a constractor of "this.Timeout=..." to a the Web
> Service
> reference file?
> Challenge: Long running reports are timing out
> Thank you for your assistance.
>
>|||Thank you very much!
"Oleg Yevteyev" wrote:
> Find ReportingService() class in a reference file.
> it looks like :
> public class ReportingService :
> System.Web.Services.Protocols.SoapHttpClientProtocol
> {
> ......
> }
> replace "public ReportingService() {...}" with
> public ReportingService()
> {
> this.Timeout=1200000;
> }
> or you can even overload that constructor by adding the following
> public ReportingService(string url)
> {
> this.Url = url;
> this.Timeout=1200000;
> }
> do not regenerate it, otherwise you'll loose your changes.
> another way is to extend ReportingService class.
>
> "Terry" <Terry@.discussions.microsoft.com> wrote in message
> news:76DCAFF8-F66B-4666-8C96-4A1817D13CD6@.microsoft.com...
> > Where do I go to add a constractor of "this.Timeout=..." to a the Web
> > Service
> > reference file?
> >
> > Challenge: Long running reports are timing out
> >
> > Thank you for your assistance.
> >
> >
> >
>
>
Friday, March 9, 2012
RS on the Internet
Im tring to gte my report server to work on the Internet.
It works fine locally but when I add the ReportServerExternalURL to the
config file as documented it fails saying ;
The configuration file contains an element that is not valid. The
ReportServerExternalURL element is not a configuration file element.
I am using Win2003 and RsSp1. Does anyone know what I am doing wrong?
NickIt must be something like
<Configuration>
<UI>
<ReportServerUrl>http://www.MyRSServer.com/ReportServer</ReportServerUrl>
</UI>
in RSWebApplication.config. I think ReportServerExternalURL is the wrong
property tag for this.
Hope this helps.
Regards
"Nick Jacobs" <news@.winman.co.uk> wrote in message
news:#A2Ff9tAFHA.1188@.tk2msftngp13.phx.gbl...
> Im tring to gte my report server to work on the Internet.
> It works fine locally but when I add the ReportServerExternalURL to the
> config file as documented it fails saying ;
> The configuration file contains an element that is not valid. The
> ReportServerExternalURL element is not a configuration file element.
> I am using Win2003 and RsSp1. Does anyone know what I am doing wrong?
> Nick
>
>|||You may be modifiying the wrong Config file. This change should be
made to the "RSWebApplication.config" file which is usually located at
the following path:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager
The new node will go within the UI element, alongside the
ReportServerUrl element. The value should be the fully-qualified
domain name for the external address.
<Configuration>
<UI>
<ReportServerUrl>http://localhost/ReportServer</ReportServerUrl>
<ReportServerExternalURL>reports.adventure-works.com</ReportServerExternalURL>
</UI>
...
NOTE: Be careful because, all elements are case-sensitive and this one
has "URL" capitalized instead of Pascal cased. Improper case can also
cause this to fail.
For more details, see MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp
I hope this helps,
Lance Hunt
http://weblogs.asp.net/lhunt/|||I have
<Configuration>
<UI>
<ReportServerUrl>http://COMSRV/ReportServer</ReportServerUrl>
<ReportServerExternalURL>http://remote.mydomain.co.uk/ReportServer</ReportServerExternalURL>
</UI>
In the RSWebApplication.config
Isn't this supposed to work?
Nick
"Lance" <lancehunt@.gmail.com> wrote in message
news:1106665173.525554.327200@.z14g2000cwz.googlegroups.com...
> You may be modifiying the wrong Config file. This change should be
> made to the "RSWebApplication.config" file which is usually located at
> the following path:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager
> The new node will go within the UI element, alongside the
> ReportServerUrl element. The value should be the fully-qualified
> domain name for the external address.
> <Configuration>
> <UI>
> <ReportServerUrl>http://localhost/ReportServer</ReportServerUrl>
> <ReportServerExternalURL>reports.adventure-works.com</ReportServerExternalURL>
> </UI>
> ...
>
> NOTE: Be careful because, all elements are case-sensitive and this one
> has "URL" capitalized instead of Pascal cased. Improper case can also
> cause this to fail.
> For more details, see MSDN:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp
> I hope this helps,
> Lance Hunt
> http://weblogs.asp.net/lhunt/
>|||You were half right Lance. It is the case of the element but it's the MSDN
documentation that is wrong.
The element should read ReportServerExternalUrl not ReportServerExternalURL.
Thanks for pointing me in the right direction.
Nick
"Lance" <lancehunt@.gmail.com> wrote in message
news:1106665173.525554.327200@.z14g2000cwz.googlegroups.com...
> You may be modifiying the wrong Config file. This change should be
> made to the "RSWebApplication.config" file which is usually located at
> the following path:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager
> The new node will go within the UI element, alongside the
> ReportServerUrl element. The value should be the fully-qualified
> domain name for the external address.
> <Configuration>
> <UI>
> <ReportServerUrl>http://localhost/ReportServer</ReportServerUrl>
> <ReportServerExternalURL>reports.adventure-works.com</ReportServerExternalURL>
> </UI>
> ...
>
> NOTE: Be careful because, all elements are case-sensitive and this one
> has "URL" capitalized instead of Pascal cased. Improper case can also
> cause this to fail.
> For more details, see MSDN:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp
> I hope this helps,
> Lance Hunt
> http://weblogs.asp.net/lhunt/
>|||Sorry about that. I usually test my suggestions locally before
posting, but I wasnt at my Dev PC when I posted that info. Now that
you mention it, I seem to recall this documentation mistake.
Regardless, I'm glad you worked it out.
Lance
http://weblogs.asp.net/lhunt/
It works fine locally but when I add the ReportServerExternalURL to the
config file as documented it fails saying ;
The configuration file contains an element that is not valid. The
ReportServerExternalURL element is not a configuration file element.
I am using Win2003 and RsSp1. Does anyone know what I am doing wrong?
NickIt must be something like
<Configuration>
<UI>
<ReportServerUrl>http://www.MyRSServer.com/ReportServer</ReportServerUrl>
</UI>
in RSWebApplication.config. I think ReportServerExternalURL is the wrong
property tag for this.
Hope this helps.
Regards
"Nick Jacobs" <news@.winman.co.uk> wrote in message
news:#A2Ff9tAFHA.1188@.tk2msftngp13.phx.gbl...
> Im tring to gte my report server to work on the Internet.
> It works fine locally but when I add the ReportServerExternalURL to the
> config file as documented it fails saying ;
> The configuration file contains an element that is not valid. The
> ReportServerExternalURL element is not a configuration file element.
> I am using Win2003 and RsSp1. Does anyone know what I am doing wrong?
> Nick
>
>|||You may be modifiying the wrong Config file. This change should be
made to the "RSWebApplication.config" file which is usually located at
the following path:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager
The new node will go within the UI element, alongside the
ReportServerUrl element. The value should be the fully-qualified
domain name for the external address.
<Configuration>
<UI>
<ReportServerUrl>http://localhost/ReportServer</ReportServerUrl>
<ReportServerExternalURL>reports.adventure-works.com</ReportServerExternalURL>
</UI>
...
NOTE: Be careful because, all elements are case-sensitive and this one
has "URL" capitalized instead of Pascal cased. Improper case can also
cause this to fail.
For more details, see MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp
I hope this helps,
Lance Hunt
http://weblogs.asp.net/lhunt/|||I have
<Configuration>
<UI>
<ReportServerUrl>http://COMSRV/ReportServer</ReportServerUrl>
<ReportServerExternalURL>http://remote.mydomain.co.uk/ReportServer</ReportServerExternalURL>
</UI>
In the RSWebApplication.config
Isn't this supposed to work?
Nick
"Lance" <lancehunt@.gmail.com> wrote in message
news:1106665173.525554.327200@.z14g2000cwz.googlegroups.com...
> You may be modifiying the wrong Config file. This change should be
> made to the "RSWebApplication.config" file which is usually located at
> the following path:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager
> The new node will go within the UI element, alongside the
> ReportServerUrl element. The value should be the fully-qualified
> domain name for the external address.
> <Configuration>
> <UI>
> <ReportServerUrl>http://localhost/ReportServer</ReportServerUrl>
> <ReportServerExternalURL>reports.adventure-works.com</ReportServerExternalURL>
> </UI>
> ...
>
> NOTE: Be careful because, all elements are case-sensitive and this one
> has "URL" capitalized instead of Pascal cased. Improper case can also
> cause this to fail.
> For more details, see MSDN:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp
> I hope this helps,
> Lance Hunt
> http://weblogs.asp.net/lhunt/
>|||You were half right Lance. It is the case of the element but it's the MSDN
documentation that is wrong.
The element should read ReportServerExternalUrl not ReportServerExternalURL.
Thanks for pointing me in the right direction.
Nick
"Lance" <lancehunt@.gmail.com> wrote in message
news:1106665173.525554.327200@.z14g2000cwz.googlegroups.com...
> You may be modifiying the wrong Config file. This change should be
> made to the "RSWebApplication.config" file which is usually located at
> the following path:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager
> The new node will go within the UI element, alongside the
> ReportServerUrl element. The value should be the fully-qualified
> domain name for the external address.
> <Configuration>
> <UI>
> <ReportServerUrl>http://localhost/ReportServer</ReportServerUrl>
> <ReportServerExternalURL>reports.adventure-works.com</ReportServerExternalURL>
> </UI>
> ...
>
> NOTE: Be careful because, all elements are case-sensitive and this one
> has "URL" capitalized instead of Pascal cased. Improper case can also
> cause this to fail.
> For more details, see MSDN:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp
> I hope this helps,
> Lance Hunt
> http://weblogs.asp.net/lhunt/
>|||Sorry about that. I usually test my suggestions locally before
posting, but I wasnt at my Dev PC when I posted that info. Now that
you mention it, I seem to recall this documentation mistake.
Regardless, I'm glad you worked it out.
Lance
http://weblogs.asp.net/lhunt/
Saturday, February 25, 2012
RS Bug? Multi-Page problem after many attempts...
Ok,
In using the rs.render function (soap) and sending a report to the printer
programatically as an emf file, for months, if the report goes beyond one
page in length, none of the controls (textboxes, images, data missing from
printed textboxes) I set as "repeat on every page" gets printed. First of
all, I've tried settings for the data areas that do get printed (details rows
and footer only) and that selection just doesn't work. I would be happy to
send or upload the report for examination (any help is much appreciated).
Does Microsoft have a fix for this, or is the workaround just not obvious?
Thanks,
Trint
--
Trinity Smith
c#/vb.Net Developer
EcoQuest, Intl.Trint,
We are experiencing the exact same problems. We've thought about rendering
as a Tiff, but image quality decreases. Have you received any feedback on
this issue from Microsoft?
Please pass on any info you have found as it would be greatly appreciated.
Thanks,
-Rick
"TrintCSD" wrote:
> Ok,
> In using the rs.render function (soap) and sending a report to the printer
> programatically as an emf file, for months, if the report goes beyond one
> page in length, none of the controls (textboxes, images, data missing from
> printed textboxes) I set as "repeat on every page" gets printed. First of
> all, I've tried settings for the data areas that do get printed (details rows
> and footer only) and that selection just doesn't work. I would be happy to
> send or upload the report for examination (any help is much appreciated).
> Does Microsoft have a fix for this, or is the workaround just not obvious?
> Thanks,
> Trint
> --
> Trinity Smith
> c#/vb.Net Developer
> EcoQuest, Intl.
In using the rs.render function (soap) and sending a report to the printer
programatically as an emf file, for months, if the report goes beyond one
page in length, none of the controls (textboxes, images, data missing from
printed textboxes) I set as "repeat on every page" gets printed. First of
all, I've tried settings for the data areas that do get printed (details rows
and footer only) and that selection just doesn't work. I would be happy to
send or upload the report for examination (any help is much appreciated).
Does Microsoft have a fix for this, or is the workaround just not obvious?
Thanks,
Trint
--
Trinity Smith
c#/vb.Net Developer
EcoQuest, Intl.Trint,
We are experiencing the exact same problems. We've thought about rendering
as a Tiff, but image quality decreases. Have you received any feedback on
this issue from Microsoft?
Please pass on any info you have found as it would be greatly appreciated.
Thanks,
-Rick
"TrintCSD" wrote:
> Ok,
> In using the rs.render function (soap) and sending a report to the printer
> programatically as an emf file, for months, if the report goes beyond one
> page in length, none of the controls (textboxes, images, data missing from
> printed textboxes) I set as "repeat on every page" gets printed. First of
> all, I've tried settings for the data areas that do get printed (details rows
> and footer only) and that selection just doesn't work. I would be happy to
> send or upload the report for examination (any help is much appreciated).
> Does Microsoft have a fix for this, or is the workaround just not obvious?
> Thanks,
> Trint
> --
> Trinity Smith
> c#/vb.Net Developer
> EcoQuest, Intl.
RS 2005: Subscription fails with Internal error
Hi all,
I have a (for me) strange problem with subscribing reports.
I've setup several reports that I want to create monthly and store to a file share.
In BIDS Preview and deployed to the report server everything works fine.
Each of my reports has an own schedule (they'll be created step by step), export format is Excel, as credentials I use a local user, all parameters are set porperly.
When the time to render the reports has gone, I just see the following behind each subscription:
Failure writing file LIS04 : An internal error occurred on the report
server. See the error log for more details.
The Log file contains the following: (I highlighted what I think to be the key error)
ReportingServicesService!library!4!12/19/2006-10:20:35:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!e!12/19/2006-10:20:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties.
ReportingServicesService!runningjobs!f!12/19/2006-10:21:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:21:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1a!12/19/2006-10:22:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:22:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1b!12/19/2006-10:23:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:23:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!3!12/19/2006-10:24:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!17!12/19/2006-10:24:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!17!12/19/2006-10:25:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!3!12/19/2006-10:25:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!16!12/19/2006-10:26:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:26:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!18!12/19/2006-10:27:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!13!12/19/2006-10:27:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!d!12/19/2006-10:28:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:28:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1c!12/19/2006-10:29:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:29:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!13!12/19/2006-10:30:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:30:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1c!12/19/2006-10:31:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!8!12/19/2006-10:31:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!c!12/19/2006-10:32:10:: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 executed at 12/19/2006 10:32:10 AM.
ReportingServicesService!schedule!f!12/19/2006-10:32:10:: Creating Time based subscription notification for subscription: 2ae5c0ed-9eea-4ca4-8e41-be5cde9f7908
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 execution completed at 12/19/2006 10:32:10 AM.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling finished processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!dbpolling!c!12/19/2006-10:32:20:: NotificationPolling processing 1 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!13!12/19/2006-10:32:20:: NotificationPolling processing item b216a965-eaa7-4003-b776-4663c19c8d54
ReportingServicesService!library!13!12/19/2006-10:32:21:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!13!12/19/2006-10:32:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.OverflowException: Arithmetic operation resulted in an overflow.
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
End of inner exception stack trace
ReportingServicesService!runningjobs!17!12/19/2006-10:32:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:32:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
Does anyone have an idea what goes wrong here?
Best regards
Florian
Are you running 64 bit RS? If yes, it looks like a known problem that will be fixed in SP2.
Tuesday, February 21, 2012
RS 2005, VS 2005 and specifying printer trays
I am trying to build a demo to prove the following can be done with SQL 2005 Reporting Services:
1. Export report as .pdf to file location. - Done
2. Use CSLA business objects with Reporting Services to reuse the object's ability to populate itself. - Done
3. Set certain reports to print from certain trays on a specific printer. More specifically, for a certain report, I need the first page to print from Tray 1 and all remaining pages to print from Tray 2.
This is the task I am having problems with. I am trying to just get the tray selection working now with just a windows app but even if I get that far, will I need to extend RS and write my own print routine? Also, if this report is served to the client via URL, will I be able to specify the printer and tray or will I need a print server to handle this?
Thanks.
I have had luck with using ABCPDF for PDF manipulation.http://www.websupergoo.com/
You could create two separate printers with different default trays and then print the first page to one printer, and the rest to another.
Bryan has a good article on printing from Reporting Services:
http://blogs.msdn.com/bryanke/articles/71491.aspx|||Unfortunately, this solution does not work for me. I am printing Optical Recognition Marks on the pages as they are printed so they need to come off the same printer so they are in the proper order to go into the feeder.
RS 2005, VS 2005 and specifying printer trays
I am trying to build a demo to prove the following can be done with SQL 2005 Reporting Services:
1. Export report as .pdf to file location. - Done
2. Use CSLA business objects with Reporting Services to reuse the object's ability to populate itself. - Done
3. Set certain reports to print from certain trays on a specific printer. More specifically, for a certain report, I need the first page to print from Tray 1 and all remaining pages to print from Tray 2.
This is the task I am having problems with. I am trying to just get the tray selection working now with just a windows app but even if I get that far, will I need to extend RS and write my own print routine? Also, if this report is served to the client via URL, will I be able to specify the printer and tray or will I need a print server to handle this?
Thanks.
I have had luck with using ABCPDF for PDF manipulation.http://www.websupergoo.com/
You could create two separate printers with different default trays and then print the first page to one printer, and the rest to another.
Bryan has a good article on printing from Reporting Services:
http://blogs.msdn.com/bryanke/articles/71491.aspx|||Unfortunately, this solution does not work for me. I am printing Optical Recognition Marks on the pages as they are printed so they need to come off the same printer so they are in the proper order to go into the feeder.
Subscribe to:
Posts (Atom)