Report parameter - date format

I have developed few reports using reporting services (service pack 2), but
still facing some problem in the date parameter and would look for help /
share here. Thanks advance!
1) How RS treat the date format?
YYYY-MM-DD (the data is correct when i use this format)
DD/MM/YYYY
MM/DD/YYYY
What is the purpose to define the date parameter as "MM/DD/YYYY" from the
"Expression" windows?
Any way to limit the input date format or any method to convert the format
to YYYY-MM-DD if user really input the format as DD/MM/YYYY or MM/DD/YYYY?
2) Anyone know how to use date time picker in RS, or possible to use it? I
believe if RS could use the date time picker, I don't need to worry the
parameter formatHi,
have a look at this article:
http://www.databasejournal.com/features/mssql/article.php/2197931
You'll find the way to solve your problem (I had the same problem and by
converting the date with the CONVERT function in my SQL query I managed to
solve it).
If you have some time could you take a look at my post (just after yours),
maybe you have the solution.
Thanks,
--
JB
"Franklin" wrote:
> I have developed few reports using reporting services (service pack 2), but
> still facing some problem in the date parameter and would look for help /
> share here. Thanks advance!
> 1) How RS treat the date format?
> YYYY-MM-DD (the data is correct when i use this format)
> DD/MM/YYYY
> MM/DD/YYYY
> What is the purpose to define the date parameter as "MM/DD/YYYY" from the
> "Expression" windows?
> Any way to limit the input date format or any method to convert the format
> to YYYY-MM-DD if user really input the format as DD/MM/YYYY or MM/DD/YYYY?
> 2) Anyone know how to use date time picker in RS, or possible to use it? I
> believe if RS could use the date time picker, I don't need to worry the
> parameter format
>sql

Report pagination for charts

Hi,

We have developed few reports displaying data using chart layout. In the Data tab, we have specified MDX query that will return top 10 records.

But now, instead of restricting to just top 10 records, we would like to display all records and go in for pagination.

Is there some setting in the chart properties, where in I can display the first n records in first page, and the next n records( if available) in the next page and so on?

Can I specify the value of n somewhere in the propeties?

I read through many posts regarding pagination but those couldn't help me much.

Please help me in solving this problem.

Any help would be appreciated.

Thanks in advance!

No response yet!:(|||

One approach is the following:

Step 1: Add a table to the report
Step 2: Group by a number of rows
Right-click on the table and select Properties. Add a table group (with a group header, but no group footer)
Enter this for the group expression: =Ceiling(RowNumber(Nothing)/10)
This will cause the table to group on every ten rows. So you'll get a separate table group for every ten rows.
Step 3: Add a chart in the table group header
Design your chart.

Note: this approach is similar to the table inline charts approach discussed in the following whitepaper: http://msdn2.microsoft.com/en-us/library/aa964128.aspx

-- Robert

|||

Thanks a lot Robert!

I got the idea from the solution provided by you and did the following:

Step 1: Add a list to the report

Step 2: Added group expression for the list to group the data

Grouping =Ceiling(RowNumber(Nothing)/10)

Set the following properties for list:

KeepTogether: False

PageBreakAtEnd: True

Step 3: Added chart to the list

Set the property, PageBreakAtEnd: True for the chart.

The above steps solved my problem of report pagination for charts.

Thanks once again!

sql

Report pagination for charts

Hi,

We have developed few reports displaying data using chart layout. In the Data tab, we have specified MDX query that will return top 10 records.

But now, instead of restricting to just top 10 records, we would like to display all records and go in for pagination.

Is there some setting in the chart properties, where in I can display the first n records in first page, and the next n records( if available) in the next page and so on?

Can I specify the value of n somewhere in the propeties?

I read through many posts regarding pagination but those couldn't help me much.

Please help me in solving this problem.

Any help would be appreciated.

Thanks in advance!

No response yet!:(|||

One approach is the following:

Step 1: Add a table to the report
Step 2: Group by a number of rows
Right-click on the table and select Properties. Add a table group (with a group header, but no group footer)
Enter this for the group expression: =Ceiling(RowNumber(Nothing)/10)
This will cause the table to group on every ten rows. So you'll get a separate table group for every ten rows.
Step 3: Add a chart in the table group header
Design your chart.

Note: this approach is similar to the table inline charts approach discussed in the following whitepaper: http://msdn2.microsoft.com/en-us/library/aa964128.aspx

-- Robert

|||

Thanks a lot Robert!

I got the idea from the solution provided by you and did the following:

Step 1: Add a list to the report

Step 2: Added group expression for the list to group the data

Grouping =Ceiling(RowNumber(Nothing)/10)

Set the following properties for list:

KeepTogether: False

PageBreakAtEnd: True

Step 3: Added chart to the list

Set the property, PageBreakAtEnd: True for the chart.

The above steps solved my problem of report pagination for charts.

Thanks once again!

Report Page Issue?

I have a report that I developed. When I click the preview tab and see the
report it show's 1 page which is correct. When I click the "Print Preview"
button it shows the 1st page and 3 blank pages after? It also prints this
way.
Why is it doing this?
DavidMake sure that your report satisfies the condition specified below
(Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=Body.Width
Ponnurangam
"Yoshi" <yoshi@.home.com> wrote in message
news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
> I have a report that I developed. When I click the preview tab and see the
> report it show's 1 page which is correct. When I click the "Print Preview"
> button it shows the 1st page and 3 blank pages after? It also prints this
> way.
> Why is it doing this?
> David
>|||Ponnurangam,
I thought that was going to solve my problem but it didn't. Thanks for good
info. Do you have any other suggestions?
Thanks,
Davod
"Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
> Make sure that your report satisfies the condition specified below
> (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=> Body.Width
> Ponnurangam
> "Yoshi" <yoshi@.home.com> wrote in message
> news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
>> I have a report that I developed. When I click the preview tab and see
>> the
>> report it show's 1 page which is correct. When I click the "Print
>> Preview"
>> button it shows the 1st page and 3 blank pages after? It also prints
>> this
>> way.
>> Why is it doing this?
>> David
>>
>|||Hi
I have also had the same problem today and have worked out that the white
background with the dots is like the canvas, is the body width and must be
smaller than Report.PageWidth - Report.LeftMargin - Report.Right Margin.
Hope you get my meaning.
Fiona
"Yoshi" wrote:
> Ponnurangam,
> I thought that was going to solve my problem but it didn't. Thanks for good
> info. Do you have any other suggestions?
> Thanks,
> Davod
> "Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
> news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
> > Make sure that your report satisfies the condition specified below
> >
> > (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=> > Body.Width
> >
> > Ponnurangam
> >
> > "Yoshi" <yoshi@.home.com> wrote in message
> > news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
> >> I have a report that I developed. When I click the preview tab and see
> >> the
> >> report it show's 1 page which is correct. When I click the "Print
> >> Preview"
> >> button it shows the 1st page and 3 blank pages after? It also prints
> >> this
> >> way.
> >>
> >> Why is it doing this?
> >>
> >> David
> >>
> >>
> >
> >
>
>|||I finally understand what everyone is saying. Thank you so much!
David P.
"Fiona Harrison" <FionaHarrison@.discussions.microsoft.com> wrote in message
news:40621EF4-C726-4859-935F-53C239980B96@.microsoft.com...
> Hi
> I have also had the same problem today and have worked out that the white
> background with the dots is like the canvas, is the body width and must be
> smaller than Report.PageWidth - Report.LeftMargin - Report.Right Margin.
> Hope you get my meaning.
> Fiona
> "Yoshi" wrote:
>> Ponnurangam,
>> I thought that was going to solve my problem but it didn't. Thanks for
>> good
>> info. Do you have any other suggestions?
>> Thanks,
>> Davod
>> "Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
>> news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
>> > Make sure that your report satisfies the condition specified below
>> >
>> > (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=>> > Body.Width
>> >
>> > Ponnurangam
>> >
>> > "Yoshi" <yoshi@.home.com> wrote in message
>> > news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
>> >> I have a report that I developed. When I click the preview tab and see
>> >> the
>> >> report it show's 1 page which is correct. When I click the "Print
>> >> Preview"
>> >> button it shows the 1st page and 3 blank pages after? It also prints
>> >> this
>> >> way.
>> >>
>> >> Why is it doing this?
>> >>
>> >> David
>> >>
>> >>
>> >
>> >
>>

Report OK in local development, won't run on server

I am attempting to migrate a report I developed locally in my development
environment to the Reporting Services server in preparation for deployment.
The report gets its data from a stored procedure that requires no
parameters; it simply runs and returns data.
I am able to upload the RDL file to the server without incident and the
report is shown properly in the report listing on the reporting server web
page.
However when I try to render the report on the reporting server I receive
the following errors:
An error has occurred during report processing. (rsProcessingAborted)
Cannot set the command type for data set 'DataSet1'.
(rsErrorSettingCommandType)
Stored Procedure command type is not supported.
The report itself is very simple, only one matrix control exists on the page.
I did not install the server environment myself however I have been able to
determine that Reporting Services SP2 has been installed - as it has been in
my development environment.
Any help you could give would be appreciated, thanks.
-ChuckAlthough I haven't see this exact error I have seen an issue with the stored
procedure security rights not allowing the credentials your report is
running under to execute it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ExNooYorka" <ExNooYorka@.discussions.microsoft.com> wrote in message
news:3447A77A-5DB5-4D1B-A067-3E576605F484@.microsoft.com...
>I am attempting to migrate a report I developed locally in my development
> environment to the Reporting Services server in preparation for
> deployment.
> The report gets its data from a stored procedure that requires no
> parameters; it simply runs and returns data.
> I am able to upload the RDL file to the server without incident and the
> report is shown properly in the report listing on the reporting server web
> page.
> However when I try to render the report on the reporting server I receive
> the following errors:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot set the command type for data set 'DataSet1'.
> (rsErrorSettingCommandType)
> Stored Procedure command type is not supported.
> The report itself is very simple, only one matrix control exists on the
> page.
> I did not install the server environment myself however I have been able
> to
> determine that Reporting Services SP2 has been installed - as it has been
> in
> my development environment.
> Any help you could give would be appreciated, thanks.
> -Chuck|||Bruce:
Thanks for the reply.
When I read your reply I thought you hit the nail right on the head
because on the remote SQL Server I had indeed not granted credentials
to anyone - only admins could run my stored procedure.
However even granting rights to the PUBLIC group did not resolve the
problem described below.
I have, however, resolved it.
The data source present on the reporting server was pointed to a custom
data provider that did not support the Stored Procedure command type.
I believe it was the custom data provider (or the layer that interacts
with the custom data provider) that was throwing the error described
below.
I created a new data source on the report server that points to the
native SQL Server data provider and that resolved the issue.
Thanks again for your help - a fresh pair of eyes is always most
helpful.
-Chuck
Bruce L-C [MVP] wrote:
> Although I haven't see this exact error I have seen an issue with the stored
> procedure security rights not allowing the credentials your report is
> running under to execute it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ExNooYorka" <ExNooYorka@.discussions.microsoft.com> wrote in message
> news:3447A77A-5DB5-4D1B-A067-3E576605F484@.microsoft.com...
> >I am attempting to migrate a report I developed locally in my development
> > environment to the Reporting Services server in preparation for
> > deployment.
> >
> > The report gets its data from a stored procedure that requires no
> > parameters; it simply runs and returns data.
> >
> > I am able to upload the RDL file to the server without incident and the
> > report is shown properly in the report listing on the reporting server web
> > page.
> >
> > However when I try to render the report on the reporting server I receive
> > the following errors:
> >
> > An error has occurred during report processing. (rsProcessingAborted)
> > Cannot set the command type for data set 'DataSet1'.
> > (rsErrorSettingCommandType)
> > Stored Procedure command type is not supported.
> >
> > The report itself is very simple, only one matrix control exists on the
> > page.
> >
> > I did not install the server environment myself however I have been able
> > to
> > determine that Reporting Services SP2 has been installed - as it has been
> > in
> > my development environment.
> >
> > Any help you could give would be appreciated, thanks.
> >
> > -Chuck

Report Manager Performance (or lack thereof ?)

i am in the process of creating some new reports on a new Reporting Services site

reports developed in VisualStudio2005 pointing an an AnalysisServices Cube on a (development) SQL2005 database

when i Preview the reports in Visual Studio 2005 on my development box, the reports take about 12-15 seconds to run (about 4-5 seconds before the "Report is being generated" logo appears, then another 8-10 seconds before the report appears (report is a series (1-8) of charts))

when i run the same report (with the same report criteria) via the Report Manager (pointing at the same AnalysisServices Cube), it now takes about 45 seconds to run (about 15 -16 seconds before the "Report is being generated" logo appears, then another 30 seconds before the report appears)

(n.b. this is not due to initial Report Manager start-up delays, the timings are for the second and third run of the report)

can anyone out there point me in the direction of where to look ?

also

have just had a look at the entries in the ExcutionLog table of the ReportServer database

ran the report - it took c. 30 secs to run & render

in the table

TimeStart 18/04/2007 1:20:48 p.m.

TimeEnd, 18/04/2007 1:20:57 p.m.

TimeDataRetrieval 187

TimeProcessing 539

TimeRendering 210

dont know how reporting services thinks it did it in 9 seconds ?!?!?!?!

Report Manager in Web Site?

In short, how can i get www.roadhouse.com.au/ReportManager deliver reports?
Description:
I developed reports managed to get them work on localhost/ReportManager and
through ASP.NET pages. I want to deploy on to a Web Server which hosts
several websites. I see that i can access reports through
//DevServerBox/ReportManager
but not
www.roadhouse.com.au/ReportManager (Our websites should be able to render
reports to public not just local)Hello,
Have you set Directory Security in your web application properties ?
Is your users needs to be authenticated ?
You have to consider WebApplication ReportServer and Reports.
Jerome Berthaud (MCSD)
http://www.winsight.fr
"AbiBaby" <AbiBaby@.discussions.microsoft.com> wrote in message
news:1BD712F8-A735-4134-8D63-28FBE3A8B1D4@.microsoft.com...
> In short, how can i get www.roadhouse.com.au/ReportManager deliver
reports?
> Description:
> I developed reports managed to get them work on localhost/ReportManager
and
> through ASP.NET pages. I want to deploy on to a Web Server which hosts
> several websites. I see that i can access reports through
> //DevServerBox/ReportManager
> but not
> www.roadhouse.com.au/ReportManager (Our websites should be able to render
> reports to public not just local)
>

Report Manager

Hello
I have developed couple of reports. I am using Sql Server 2000 as datasource
and which is at other machine and not on the development machine.
When I try to access report from my machine I can access the reports using
either http://mycomputerIP/Reports or http://mycomputerIp/RerportServer
I can access the reports.
When the other users try to access reports from their machine, I dont know
somehow they can not access the report using
http://mycomputerIP/Reports
User can see the consol but when they hit the report they gets the error of
page can not be displayed.
What could be the reason for this?
I am running sharepoint on my machine.
I would appreciate if someone could help me here.
Thanks
AmeetIf you have installed Rs on a machine with Sharepoint you must have theses
considerations.
ms-help://MS.RSBOL80.1033/rsadmin/htm/drp_deploying_v1_0lmh.htm
Fernando Hunth
Senior Developer
Huddle Group S.A.
fernando@.huddle.com.ar
Huddle Group S.A. | Enterprise Technology Services
Microsoft Certified Partner
Ciudad de Buenos Aires · Argentina
www.huddle.com.ar
"Ameet" wrote:
> Hello
> I have developed couple of reports. I am using Sql Server 2000 as datasource
> and which is at other machine and not on the development machine.
> When I try to access report from my machine I can access the reports using
> either http://mycomputerIP/Reports or http://mycomputerIp/RerportServer
> I can access the reports.
> When the other users try to access reports from their machine, I dont know
> somehow they can not access the report using
> http://mycomputerIP/Reports
> User can see the consol but when they hit the report they gets the error of
> page can not be displayed.
> What could be the reason for this?
> I am running sharepoint on my machine.
> I would appreciate if someone could help me here.
> Thanks
> Ameet
>

Report Loading Error

I have developed a report and deployed it successfully. After I input all the parameters, the report cannot be displayed and shows the error as follows:

???? (rsProcessingAborted) ??
??? 'tempDB' ?? (rsErrorOpeningConnection) ??
Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection.

The report can be loaded a few times before and cannot be loaded now.

I have checked that the DB security setting of authentication is set to "SQL Server and Windows" already.

Any idea to solve this problem?

msfriend wrote:

I have developed a report and deployed it successfully. After I input all the parameters, the report cannot be displayed and shows the error as follows: ???? (rsProcessingAborted) ?? ??? 'tempDB' ?? (rsErrorOpeningConnection) ?? Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection. The report can be loaded a few times before and cannot be loaded now. I have checked that the DB security setting of authentication is set to "SQL Server and Windows" already. Any idea to solve this problem?

Should be authentication problem. Did you find any solution?

Report Hangs - Security Issue?

Iâ'm running SQL Server 2005 with Reporting Services. I have developed a
number of reports that use data from a fairly obscure financial package that
we use. The data sits on a Unix server and is pulled into SRSS using an ODBC
driver. When the connection to the data is made PowerTCP launches
(www.dart.com). I had deployed a number of these reports and they were
working but no longer work from the Report Manager either on a remote
computer or on the server logged on as the Administrator. The reports still
function in the preview window of the Visual Studio environment. I initially
thought that it could have something to do with the enhanced DCOM security
with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I guess it
may be worth a try. I canâ't definitively pin down a time frame as to when
the reports stopped working (i.e. pre or post SP1). I have combed all the
log files I can think of, but havenâ't discovered anything. One interesting
note is that when I launch the report the server beeps once and then the
report never comes up, it just sits there. I am at my witâ's end so if
someone can shed some light on this I would appreciate it.
Thanks in advance.I don't quite understand but one thing you could try is to add the site to
the safe list in 2003 Server. SP1 locks down accessing other servers unless
they are part of the safe list.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
> I'm running SQL Server 2005 with Reporting Services. I have developed a
> number of reports that use data from a fairly obscure financial package
> that
> we use. The data sits on a Unix server and is pulled into SRSS using an
> ODBC
> driver. When the connection to the data is made PowerTCP launches
> (www.dart.com). I had deployed a number of these reports and they were
> working but no longer work from the Report Manager either on a remote
> computer or on the server logged on as the Administrator. The reports
> still
> function in the preview window of the Visual Studio environment. I
> initially
> thought that it could have something to do with the enhanced DCOM security
> with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I guess
> it
> may be worth a try. I can't definitively pin down a time frame as to when
> the reports stopped working (i.e. pre or post SP1). I have combed all the
> log files I can think of, but haven't discovered anything. One
> interesting
> note is that when I launch the report the server beeps once and then the
> report never comes up, it just sits there. I am at my wit's end so if
> someone can shed some light on this I would appreciate it.
> Thanks in advance.
>|||To clarify, I think the way it works is that when the ODBC driver goes out to
grab data it lauches PowerTCP which establishes a connection to the Unix
server and allows for the data transfer.
Is the safe list you are talking about in Internet Explorer sites? Where do
I configure the safe list you are talking about?
"Bruce L-C [MVP]" wrote:
> I don't quite understand but one thing you could try is to add the site to
> the safe list in 2003 Server. SP1 locks down accessing other servers unless
> they are part of the safe list.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
> > I'm running SQL Server 2005 with Reporting Services. I have developed a
> > number of reports that use data from a fairly obscure financial package
> > that
> > we use. The data sits on a Unix server and is pulled into SRSS using an
> > ODBC
> > driver. When the connection to the data is made PowerTCP launches
> > (www.dart.com). I had deployed a number of these reports and they were
> > working but no longer work from the Report Manager either on a remote
> > computer or on the server logged on as the Administrator. The reports
> > still
> > function in the preview window of the Visual Studio environment. I
> > initially
> > thought that it could have something to do with the enhanced DCOM security
> > with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I guess
> > it
> > may be worth a try. I can't definitively pin down a time frame as to when
> > the reports stopped working (i.e. pre or post SP1). I have combed all the
> > log files I can think of, but haven't discovered anything. One
> > interesting
> > note is that when I launch the report the server beeps once and then the
> > report never comes up, it just sits there. I am at my wit's end so if
> > someone can shed some light on this I would appreciate it.
> >
> > Thanks in advance.
> >
>
>|||Yes, it is in IE, Tools, Security tab, Safe Sites
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:396E5C0F-470A-4A7C-A73A-894C4C57164E@.microsoft.com...
> To clarify, I think the way it works is that when the ODBC driver goes out
> to
> grab data it lauches PowerTCP which establishes a connection to the Unix
> server and allows for the data transfer.
> Is the safe list you are talking about in Internet Explorer sites? Where
> do
> I configure the safe list you are talking about?
> "Bruce L-C [MVP]" wrote:
>> I don't quite understand but one thing you could try is to add the site
>> to
>> the safe list in 2003 Server. SP1 locks down accessing other servers
>> unless
>> they are part of the safe list.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rob" <Rob@.discussions.microsoft.com> wrote in message
>> news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
>> > I'm running SQL Server 2005 with Reporting Services. I have developed
>> > a
>> > number of reports that use data from a fairly obscure financial package
>> > that
>> > we use. The data sits on a Unix server and is pulled into SRSS using
>> > an
>> > ODBC
>> > driver. When the connection to the data is made PowerTCP launches
>> > (www.dart.com). I had deployed a number of these reports and they were
>> > working but no longer work from the Report Manager either on a remote
>> > computer or on the server logged on as the Administrator. The reports
>> > still
>> > function in the preview window of the Visual Studio environment. I
>> > initially
>> > thought that it could have something to do with the enhanced DCOM
>> > security
>> > with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I
>> > guess
>> > it
>> > may be worth a try. I can't definitively pin down a time frame as to
>> > when
>> > the reports stopped working (i.e. pre or post SP1). I have combed all
>> > the
>> > log files I can think of, but haven't discovered anything. One
>> > interesting
>> > note is that when I launch the report the server beeps once and then
>> > the
>> > report never comes up, it just sits there. I am at my wit's end so if
>> > someone can shed some light on this I would appreciate it.
>> >
>> > Thanks in advance.
>> >
>>|||Thanks for your efforts, but I still can't get it working. I'll have to find
a work around.
"Bruce L-C [MVP]" wrote:
> Yes, it is in IE, Tools, Security tab, Safe Sites
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:396E5C0F-470A-4A7C-A73A-894C4C57164E@.microsoft.com...
> > To clarify, I think the way it works is that when the ODBC driver goes out
> > to
> > grab data it lauches PowerTCP which establishes a connection to the Unix
> > server and allows for the data transfer.
> >
> > Is the safe list you are talking about in Internet Explorer sites? Where
> > do
> > I configure the safe list you are talking about?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> I don't quite understand but one thing you could try is to add the site
> >> to
> >> the safe list in 2003 Server. SP1 locks down accessing other servers
> >> unless
> >> they are part of the safe list.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> >> news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
> >> > I'm running SQL Server 2005 with Reporting Services. I have developed
> >> > a
> >> > number of reports that use data from a fairly obscure financial package
> >> > that
> >> > we use. The data sits on a Unix server and is pulled into SRSS using
> >> > an
> >> > ODBC
> >> > driver. When the connection to the data is made PowerTCP launches
> >> > (www.dart.com). I had deployed a number of these reports and they were
> >> > working but no longer work from the Report Manager either on a remote
> >> > computer or on the server logged on as the Administrator. The reports
> >> > still
> >> > function in the preview window of the Visual Studio environment. I
> >> > initially
> >> > thought that it could have something to do with the enhanced DCOM
> >> > security
> >> > with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I
> >> > guess
> >> > it
> >> > may be worth a try. I can't definitively pin down a time frame as to
> >> > when
> >> > the reports stopped working (i.e. pre or post SP1). I have combed all
> >> > the
> >> > log files I can think of, but haven't discovered anything. One
> >> > interesting
> >> > note is that when I launch the report the server beeps once and then
> >> > the
> >> > report never comes up, it just sits there. I am at my wit's end so if
> >> > someone can shed some light on this I would appreciate it.
> >> >
> >> > Thanks in advance.
> >> >
> >>
> >>
> >>
>
>