ActiveX in Reporting Services report

Hi there. I've read on the web that Reporting Services report can support
ActiveX controls in the client area of the report (or at least that's what I
interpreted). I'm able to add an in-house developed ActiveX control to the
toolbox in Visual Studio but the control is grayed out and will not allow me
to drag it to the main area of the report. Has anyone successfully created a
VB6 ActiveX control that works in Reporting Services? If so, what do I need
to do to allow the control to be used in the report? Here's what I'm trying
to do: I've got an ActiveX control that shells out and executes an exe on
the client machine (the exe I am shelling out to start is a DDE bridge
application).Close dev studio and reopen it - if you have installed SP1 with it open,
sometimes it will gray it out.
=-Chris
"DSlattery" <DSlattery@.discussions.microsoft.com> wrote in message
news:2FD0E033-0709-49A3-B877-2C50FA1780FC@.microsoft.com...
> Hi there. I've read on the web that Reporting Services report can support
> ActiveX controls in the client area of the report (or at least that's what
> I
> interpreted). I'm able to add an in-house developed ActiveX control to
> the
> toolbox in Visual Studio but the control is grayed out and will not allow
> me
> to drag it to the main area of the report. Has anyone successfully
> created a
> VB6 ActiveX control that works in Reporting Services? If so, what do I
> need
> to do to allow the control to be used in the report? Here's what I'm
> trying
> to do: I've got an ActiveX control that shells out and executes an exe on
> the client machine (the exe I am shelling out to start is a DDE bridge
> application).|||Hi Chris. Thanks for responding. I've tried to close and re-open VS but the
control is still disabled. I'm relatively certain I've installed the latest
service pack for Reporting Services.
The version I have is
Microsoft SQL Server Report Designer
Version 8.00.878.00
I've also tried other ActiveX controls with the same results.
"Christopher Conner" wrote:
> Close dev studio and reopen it - if you have installed SP1 with it open,
> sometimes it will gray it out.
> =-Chris
> "DSlattery" <DSlattery@.discussions.microsoft.com> wrote in message
> news:2FD0E033-0709-49A3-B877-2C50FA1780FC@.microsoft.com...
> > Hi there. I've read on the web that Reporting Services report can support
> > ActiveX controls in the client area of the report (or at least that's what
> > I
> > interpreted). I'm able to add an in-house developed ActiveX control to
> > the
> > toolbox in Visual Studio but the control is grayed out and will not allow
> > me
> > to drag it to the main area of the report. Has anyone successfully
> > created a
> > VB6 ActiveX control that works in Reporting Services? If so, what do I
> > need
> > to do to allow the control to be used in the report? Here's what I'm
> > trying
> > to do: I've got an ActiveX control that shells out and executes an exe on
> > the client machine (the exe I am shelling out to start is a DDE bridge
> > application).
>
>|||Sorry, ActiveX controls in reports are not supported.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"DSlattery" <DSlattery@.discussions.microsoft.com> wrote in message
news:5CF40528-C7E7-453F-81BE-C02B8D85493B@.microsoft.com...
> Hi Chris. Thanks for responding. I've tried to close and re-open VS but
the
> control is still disabled. I'm relatively certain I've installed the
latest
> service pack for Reporting Services.
> The version I have is
> Microsoft SQL Server Report Designer
> Version 8.00.878.00
> I've also tried other ActiveX controls with the same results.
> "Christopher Conner" wrote:
> > Close dev studio and reopen it - if you have installed SP1 with it open,
> > sometimes it will gray it out.
> >
> > =-Chris
> >
> > "DSlattery" <DSlattery@.discussions.microsoft.com> wrote in message
> > news:2FD0E033-0709-49A3-B877-2C50FA1780FC@.microsoft.com...
> > > Hi there. I've read on the web that Reporting Services report can
support
> > > ActiveX controls in the client area of the report (or at least that's
what
> > > I
> > > interpreted). I'm able to add an in-house developed ActiveX control
to
> > > the
> > > toolbox in Visual Studio but the control is grayed out and will not
allow
> > > me
> > > to drag it to the main area of the report. Has anyone successfully
> > > created a
> > > VB6 ActiveX control that works in Reporting Services? If so, what do
I
> > > need
> > > to do to allow the control to be used in the report? Here's what I'm
> > > trying
> > > to do: I've got an ActiveX control that shells out and executes an
exe on
> > > the client machine (the exe I am shelling out to start is a DDE bridge
> > > application).
> >
> >
> >sql

ActiveX and RDL

Is there any element that is supported by RDL that will allow an ActiveX control to be embedded into a Reporting Services report?

The ActiveX control doesn't need to be scripted, but only listed as an object tag with some parameter tags within it. I'm looking for something like this:

<ActiveXControl Name="Control1">
<ClassID>...</ClassID>
<Parameters>
<Parameter>
<Name>Param1</Name>
<Value>Value1</Value>
</Parameter>
</Parameters>
</ActiveXControl>

I understand that an ActiveX control doesn't really make sense in any context outside of HTML, but the ability to do this would be very valuable to a lot of consumers I think. I am already aware of CustomReportItem, but I've been told the functionality of that element is limited to outputting an image.

Does such a construct exist?

Thanks.

For a while, we actually had this in RDL but we cut it because you could not do data binding for the control. We were also concerned about security and the cross-platform issues. We might bring it back in the future but no workaround for SQL 2005.

Active Directory User Data

Hi. I'm new to SQL Reporting Services and totally self taught so far.
I am trying to find out if there is a way from within a report to find
out the Active Directory user name or possibly other data from AD about
the user running the report from the web. I want to be able to look at
the user and rstrict the data they are allowed to see based on AD
characteristics. This is for a school district and I want teachers to
be able to go to the web page, run a report, but return only data fro
their students. Thanks in advance for any help.You get the AD username by from the global constant User!UserID. It returns
the username in the form of domain\username.
If you store the AD username of each teacher and a reference to what
students belong to them, you can use this for a query to only return the
data from their students.
I've never tried to query data in the Active Directory through Reporting
Services, but if you look at SQL tutorials, you might find something on how
to query AD data from the usual SQL server tools.
You need to check for information on ADSI
Here are a few links. I haven't tried them myself, but it might give you a
start
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q299410
http://www.databasejournal.com/features/mssql/article.php/2176561
Kaisa M. Lindahl Lervik
<jwilloz@.paplv.esu3.org> wrote in message
news:1161810778.724236.40460@.k70g2000cwa.googlegroups.com...
> Hi. I'm new to SQL Reporting Services and totally self taught so far.
> I am trying to find out if there is a way from within a report to find
> out the Active Directory user name or possibly other data from AD about
> the user running the report from the web. I want to be able to look at
> the user and rstrict the data they are allowed to see based on AD
> characteristics. This is for a school district and I want teachers to
> be able to go to the web page, run a report, but return only data fro
> their students. Thanks in advance for any help.
>

Active Directory Reports

I'm not sure this is an actual reporting services question but has someone else created reports for active directory in Reporting Services

I want to create a report with users and their respective manager. I have this working in reporting services but I just want the manager name how could I strip out all the other information in the manager field?

SELECT personalTitle, manager, name, employeeid, distinguishedName
FROM 'LDAP://dc=xxx,dc=xxx,dc=xxxt'
WHERE objectClass = 'user' AND objectCategory = 'Person'
ORDER BY name

I get this as the manager name, I just want his name

CN=Smith\, Kurt,OU=Financial,OU=DataControl,OU=Users-Groups,DC=xxx,DC=xxx,DC=xxx

Thank you,

There should an AD property that gives you the name as entered. As a last resort, you can call a custom function to parse the name, e.g.

= Code.MyFunction(Field!name.Value)

|||

Hi thank you, I had tried a function in the bids tool by calculating a new member using this

=Mid(Fields!manager.Value,4,(InStr(Fields!manager.Value,",OU=")-4)) and this works fine on my desk top but when I attemtp to deploy it I get an error

Warning 1 [rsRuntimeErrorInExpression] The Value expression for the field ‘ManagerName’ contains an error: Argument 'Length' must be greater or equal to zero. C:\mydocs\SQL Server Management Studio\Projects\Active Directory\Active Directory\Active Dir Manager Report.rdl 0 0
Managername is my new calculated column

|||Could you prepare and send a sample report that demonstrates the issue? You can hardcode the dataset if you wish, e.g. using SELECT...UNION.|||

Thank you for the response. It was a data issue with the manager, some of my manager names were blank I had to search for them and replace with values prior to using the other functions: in case your interested first I use IIF

I put in the same values as I plan to strip off with the next calculated member

new field LookforNoManager

=IIF(Fields!manager.Value Is Nothing,"CN=Not Available,OU=",Fields!manager.Value)

then I created this new ManagerName

=Mid(Fields!LookForNoManager.Value,4,(InStr(Fields!LookForNoManager.Value,",OU=")-4))

one way around it I guess.

Now after I upload them I can't connect to the either the OLE DB active directory datasource directly or my linkserver ADSI datasource from the webserver? is there any trick to this definition

Here is my connection string for the linkedserver

Provider=ADsDSOObject;Data Source=lifeeai602\devsqlservices

here is my connecting sting when I tried to define the datasource directly to active directory

Provider=ADsDSOObject

Do I need to change something to point to LDAP?

|||Not sure how you connect. If it works in VS.NET but it doesn't on the server it is probably security. What credentials do you specify on the data source and what provider do you use?|||

Hi,

I use windows integrated security in the development tool and I set that up on the server to access the datasource as well, here is part of the error from the RS logfile

aspnet_wp!processing!5!3/30/2007-14:25:08:: e ERROR: An exception has occurred in data source 'NewDataSource'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'NewDataSource'. > System.Data.OleDb.OleDbException: 'ADsDSOObject' failed with no error message available, result code: DB_E_NOTABLE(0x80040E37).
aspnet_wp!processing!5!3/30/2007-14:25:08:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ...
aspnet_wp!dataextension!5!3/30/2007-14:25:08:: w WARN: CommandWrapper.Cancel not called, connection is not valid
aspnet_wp!processing!5!3/30/2007-14:25:08:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'NewDataSource'. > System.Data.OleDb.OleDbException: 'ADsDSOObject' failed with no error message available, result code: DB_E_NOTABLE(0x80040E37).
End of inner exception stack trace
aspnet_wp!processing!5!3/30/2007-14:25:08:: w WARN: Data source 'NewDataSource': Report processing has been aborted.
aspnet_wp!processing!5!3/30/2007-14:25:08:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'NewDataSource'. > System.Data.OleDb.OleDbException: 'ADsDSOObject' failed with no error message available, result code: DB_E_NOTABLE(0x80040E37).
End of inner exception stack trace

***************************************************************************************

Connection type:

OLE DB

Connection string:Provider=ADsDSOObject;Data Source=lifeeai602\devsqlservices

Windows integrated security

Acrobat Writer and Reporting Services

If I have Adobe Acrobat Professional installed in my Report Server, would I be able to toggle the document propeties of PDF files (Export to PDF) to make it not-printable, not-modifiable?

Is there any .dll that I can overwrite to change the default settings?

thanks

You could try writing your own rendering extension and output the report to PDF manually as well as setting the additional options you wish. Maybe you could hack it by making your extension call the report server via the webserice, retrieving the PDF output and setting the additional settings before returning the modified PDF from your extension.

For more information about writing custom rendering extensions go here http://msdn2.microsoft.com/es-es/library/ms153624.aspx

Acrobat Reader print error

I have a couple of Reporting Services reports that I render to PDF and open
them in Adobe Acrobat Reader 5.0.1 for viewing/printing. When I try to print
either report, I get the following popup error message:
The instruction at "0x77f580db" referenced memory at "0x013997c4". The
memory could not be "written".
Upon clicking 'OK' in the popup, Acrobat closes and nothing prints. This
error message occurs on every machine in the company running Adobe Acrobat
Reader 5.0.1. Upgrading to a later version is not an option at this point.
As a control test, I opened a non-Reporting Services created PDF and was
able to successfully print. So, it appears that the error is related to how
Reporting Services renders the PDF.
Any help would be appreciated.
Thank you,
BobKIm just taking a stab in the dark here but do you think the problem could
possibly be that you are using some type of a font that the export does not
support?
It is my understanding that SRS does not embed fonts into PDF but I am not
sure if this throws an error or if it simply defaults to something generic
such as 'ARIAL'.
Not sure..but something to consider.
"BobK" wrote:
> I have a couple of Reporting Services reports that I render to PDF and open
> them in Adobe Acrobat Reader 5.0.1 for viewing/printing. When I try to print
> either report, I get the following popup error message:
> The instruction at "0x77f580db" referenced memory at "0x013997c4". The
> memory could not be "written".
> Upon clicking 'OK' in the popup, Acrobat closes and nothing prints. This
> error message occurs on every machine in the company running Adobe Acrobat
> Reader 5.0.1. Upgrading to a later version is not an option at this point.
> As a control test, I opened a non-Reporting Services created PDF and was
> able to successfully print. So, it appears that the error is related to how
> Reporting Services renders the PDF.
> Any help would be appreciated.
> Thank you,
> BobK|||Thank you ferguslogic! I changed the font on my reports from Arial Unicode
MS to Arial and everything is printing beautifully.
"ferguslogic" wrote:
> Im just taking a stab in the dark here but do you think the problem could
> possibly be that you are using some type of a font that the export does not
> support?
> It is my understanding that SRS does not embed fonts into PDF but I am not
> sure if this throws an error or if it simply defaults to something generic
> such as 'ARIAL'.
> Not sure..but something to consider.
>
> "BobK" wrote:
> > I have a couple of Reporting Services reports that I render to PDF and open
> > them in Adobe Acrobat Reader 5.0.1 for viewing/printing. When I try to print
> > either report, I get the following popup error message:
> >
> > The instruction at "0x77f580db" referenced memory at "0x013997c4". The
> > memory could not be "written".
> >
> > Upon clicking 'OK' in the popup, Acrobat closes and nothing prints. This
> > error message occurs on every machine in the company running Adobe Acrobat
> > Reader 5.0.1. Upgrading to a later version is not an option at this point.
> >
> > As a control test, I opened a non-Reporting Services created PDF and was
> > able to successfully print. So, it appears that the error is related to how
> > Reporting Services renders the PDF.
> >
> > Any help would be appreciated.
> >
> > Thank you,
> > BobK

Accessing SQL Server 8

We're running a point of sale/inventory management system that uses MS SQL Server as the backend. I'm looking to do some reporting and need to query data from the existing inventory databases but the server is not responding via OSQL and the ODBC "Test Data Source" fails.

osql -L reports:

"Servers: CONNPOS"

osql -E -S CONNPOS reports:

[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

I am logged in as the admin which was the account used to install the server and create the databases.

Any suggestions?try pinging it. also check if using ip for the server name will do the trick. here i managed to simulate the error only by stopping the server.|||Have you tried to login using SQL authenthification?
If this succeds, then it means that your user's rights have been removed somehow, if not your connection is down. And I think this is the problem, at least the second message (ConnectionOpen (Connect()) is suggesting that. Probably you were connected to the database, and while beeing connected the connection got lost.
Try disconnecting and reconecting, and check if the server is REALLY running, because it's not necessarily has to run to be reported by the "osql -L" statement.

Best regards!
:cool:|||According to sqlmangr/services panel the server is up and running... I should note that the osql commands were run from the local machine (2000 Server), not from a remote system. I haven't tried SQL auth... just NT.

I did notice that netstat doesn't report ms-sql-* on any TCP ports... hmm.|||Well, looks like we're up and running.

"osql -E -S servername/instancename" works like a charm... I've also established a user DSN as well and the test passed.

Thanks for the help.|||I have run into this sort of thing before. In the server network utility, you will find a checkbox that says something like "Enable Shared Memory Protocol" (not sure of the wording, so that could be pretty wrong). Uncheck that box. Then retry the query. Good luck.|||I am able to connect via OSQL and can execute queries. I have also configured a user DSN for this database via the ODBC Control Panel but can not connect through an ASP script even tho the ODBC data source test passed. Here's the error that is returned to the browser when the script attempts to open a connection:

[Microsoft][ODBC Driver Manager]Data Source Name not found and no default driver specified.

I had selected "SQL Server" as the driver and again, the data source test had passed.

Suggestions?|||Create a system DSN. User DSNs are only available to the user that creates them.

Accessing Reports through a web application?

Hi All,

I have developed few reports in SQL Server 2005 Reporting Services and deployed them on a reporting server.

These reports are accessed through a web application that is deployed on a different server. I am using the Report Viewer control in my web application.

The problem is when I access the reports through my web application, it gives me a Page not found error.

If I have both web server and reporting server on the same machine, then this problem does not come.

I need to have separate web and reporting server. Can anyone please provide help on how to solve this authentication issue. My web application is taking the credentials but the credentials are not getting passed if the reports are deployed on a different server.

Any help will be greatly appreciated!!!

Has anyone tried this before?

Regards!!!

accessing reports securely through ASP

Hej
I'm new to Reporting Services. I'm using RS 2005, ASP 2.0 and VS 2003.
I've created the reports and have been using a URL link in my ASP site to
ReportServer/Pages/ReportViewer.aspx?%2fFOLDER%2fREPORT for viewing the
reports. When the reports are accessed outside the server, the browser
requires username and password. This isn't desired.
Whats the best way to handle this? If I switch to VS 2005 does the
ReportViewer control handle this? Is it possible/safe to change the user
rights for ReportViewer.aspx? Its important not to allow users access to the
Report Manager, but can the rights to viewing individual reports be handled
through there?
I appreciate any advise on the matter.On Mar 14, 2:27 pm, jknurek <jknu...@.discussions.microsoft.com> wrote:
> Hej
> I'm new to Reporting Services. I'm using RS 2005, ASP 2.0 and VS 2003.
> I've created the reports and have been using a URL link in my ASP site to
> ReportServer/Pages/ReportViewer.aspx?%2fFOLDER%2fREPORT for viewing the
> reports. When the reports are accessed outside the server, the browser
> requires username and password. This isn't desired.
> Whats the best way to handle this? If I switch to VS 2005 does the
> ReportViewer control handle this? Is it possible/safe to change the user
> rights for ReportViewer.aspx? Its important not to allow users access to the
> Report Manager, but can the rights to viewing individual reports be handled
> through there?
> I appreciate any advise on the matter.
I believe that there is a way to control (minimally) access to reports
in the Report Manager interface (check the top right-hand side of the
main page). Also you can control user access through the application
(as far as, not showing the user a link to the Report Server, etc).
Sometimes the login is required when the user accesses the Report
Server from Mozilla or Firefox (whereas, w/Internet WExplorer, it may
not happen). Also, you can check the Directory Security for the
Reports and Report Server Virtual Directories in IIS to check for
Windows Authentication, anonymous access, etc (via right-clicking My
Computer, select 'Manage' and go to Services and Applications ->
Internet Information Services -> Web Sites -> Default Web and right-
clicking the Reports or ReportServer Virtual Directory and selecting
Properties and the 'Directory Security' tab). Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer

Accessing Reports on local LAN

Hi,

My reports are deployed on reporting server installed on my machine. Now i want to access the reports on other machines which are on local LAN along with my machine. When i try to access reports from some other machine browser gives error page not found.

Can any one tell me how to do this.

Thanks in advance..

If you can put in what the error is and what type of servers you are running from then we can try and help!

Is your SQL seperate?

Did you enter //servername/reports and try and add it in here?

Have you set up permission to access the server!?

|||

Hey i got the solution.....

First thing is ur Server has to be on domain and not a workgroup computer.

Second thing is you will have to give acess rights to the users u want to see the reports.

Cheers

Siddharth...

Accessing Reports on local LAN

Hi,

My reports are deployed on reporting server installed on my machine. Now i want to access the reports on other machines which are on local LAN along with my machine. When i try to access reports from some other machine browser gives error page not found.

Can any one tell me how to do this.

Thanks in advance..

If you can put in what the error is and what type of servers you are running from then we can try and help!

Is your SQL seperate?

Did you enter //servername/reports and try and add it in here?

Have you set up permission to access the server!?

|||

Hey i got the solution.....

First thing is ur Server has to be on domain and not a workgroup computer.

Second thing is you will have to give acess rights to the users u want to see the reports.

Cheers

Siddharth...

Accessing Reporting Services Reports from Mac

Hi all.
Using a MacMini to access a Reporting Services 2000 installation and getting
some very strange results.
When using Safari I can browse the folders of the server, and can see the
reports, but they will not render at all.
In IE, I can render the reports but encounter missing entries in my
parameterised drop downs, and cannot seem to export to any format, PDF/Excel
etc.
Anyone come across this behaviour before, and know if it's 'by design' or
avoidable at all?
Many thanks,
Paul.I have not heard of very much success at all with using MACs with RS2000. It
might be better with RS 2005 but I don't know.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Paul Paintin" <paul.paintin@.virgin.net> wrote in message
news:eRGt$ZqxGHA.4112@.TK2MSFTNGP05.phx.gbl...
> Hi all.
> Using a MacMini to access a Reporting Services 2000 installation and
> getting some very strange results.
> When using Safari I can browse the folders of the server, and can see the
> reports, but they will not render at all.
> In IE, I can render the reports but encounter missing entries in my
> parameterised drop downs, and cannot seem to export to any format,
> PDF/Excel etc.
> Anyone come across this behaviour before, and know if it's 'by design' or
> avoidable at all?
> Many thanks,
> Paul.
>|||Update: tried accessing RS2005, exactly the same results - no exporting,
blank drop down parameter values.
Paul.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ud7kyPsxGHA.3492@.TK2MSFTNGP02.phx.gbl...
>I have not heard of very much success at all with using MACs with RS2000.
>It might be better with RS 2005 but I don't know.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Paul Paintin" <paul.paintin@.virgin.net> wrote in message
> news:eRGt$ZqxGHA.4112@.TK2MSFTNGP05.phx.gbl...
>> Hi all.
>> Using a MacMini to access a Reporting Services 2000 installation and
>> getting some very strange results.
>> When using Safari I can browse the folders of the server, and can see the
>> reports, but they will not render at all.
>> In IE, I can render the reports but encounter missing entries in my
>> parameterised drop downs, and cannot seem to export to any format,
>> PDF/Excel etc.
>> Anyone come across this behaviour before, and know if it's 'by design' or
>> avoidable at all?
>> Many thanks,
>> Paul.
>|||In article <#HPztdsxGHA.5068@.TK2MSFTNGP02.phx.gbl>,
"Paul Paintin" <paul.paintin@.virgin.net> wrote:
> Update: tried accessing RS2005, exactly the same results - no exporting,
> blank drop down parameter values.
> Paul.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:ud7kyPsxGHA.3492@.TK2MSFTNGP02.phx.gbl...
> >I have not heard of very much success at all with using MACs with RS2000.
> >It might be better with RS 2005 but I don't know.
Hi Paul!
I'm not familiar with Reporting Services. Does it require ActiveX? If
so, this is Windows only and won't work with any browser on a Mac.
If it doesn't require ActiveX, try a different web browser such as
Firefox. Firefox uses a different rendering engine than Safari and we
have found we're able to access more Windows-centric sites with it. As
for IE for Mac, that was discontinued a few years ago and was finally
pulled off Microsoft's website earlier this year.
Hope this helps! bill
--
William M. Smith
(Microsoft Interop MVP - Mac/Windows)

Accessing Reporting Services from a machine which is not the server

Hello,

I plan to install MS SQL Reporting Services 2000 (later probably 2005) on the same server as where the MS SQL Server 2000 database is stored.

However, the developers (people designing the reports) will not have physical access to this server (it is stored in a different office). Remote Desktop is possible though, if no other solution exists.

Are the developers able to use the Report Builder on every machine or is a single license needed for each developer workstation? Or, in other words, what needs to be installed on a computer in order to create different type of reports?

Any comment on what is best or a link is appreciated. Thank you in advance!

Best regards,

Michael Fuchs

You do not need a license for client machines using Report Builder, only for the server itself. You can find out more information here:

http://www.microsoft.com/sql/howtobuy/howtolicensers.mspx

Accessing Reporting Services by other than machine name.

When reporting services is installed the machine name is configured by
default eg: http://MAIN/Reports, however, if I try to access the
reporting services machine by other than the machine name I receive an
error.
I'm trying something along the lines of
http://testing.xxxx.com/reports. Am prompted for the username and
password and can login without any issue, however, I can't display any
of the reports because the URL points to http://MAIN/.... rather
than the fully qualified domain name.
Just wondering what I'm doing wrong.
Thanks in advance,
CNTo further clarify the issue, currently the ReportServerUrl in the
RSWebApplication.config (ReportManager Folder) includes an entry to
allow the ReportServerUrl to be specified.
Original Value <ReportServerUrl>http://MACHINENAME/ReportServer/</ReportServerUrl>
Modified Value <ReportServerUrl>http://www.domainname.com/ReportServer/</ReportServerUrl>
With this change and restarting reporting services everthing works
okay if you login as a basic user/browser (can navigate and view
reports), however, if you then try to login with an administrative
account ... you can't. You continually receive an error message "
There is an error in XML document (1, 1225).
".
If you switch the value in the configuration file back to the machine
name everything is accessible again except the reports can't be
viewed.
Hence my dilema - am I doing something wrong or is this an issue with
the current release of reporting services?
(CN) wrote in message news:<495b624a.0406191428.619fae2a@.posting.google.com>...
> When reporting services is installed the machine name is configured by
> default eg: http://MAIN/Reports, however, if I try to access the
> reporting services machine by other than the machine name I receive an
> error.
> I'm trying something along the lines of
> http://testing.xxxx.com/reports. Am prompted for the username and
> password and can login without any issue, however, I can't display any
> of the reports because the URL points to http://MAIN/.... rather
> than the fully qualified domain name.
> Just wondering what I'm doing wrong.
> Thanks in advance,
> CN|||look at the <ReportServerExternalUrl> tag in the config file
use it like this:
<ReportServerExternalUrl>testing.xxxx.com</ReportServerExternalUrl>
the system will detect if the user access the site from the .com URL or from
the internal (http://main) url and setup the right links etc...
"CN" <charles@.pstgi.com> a écrit dans le message de
news:495b624a.0406191428.619fae2a@.posting.google.com...
> When reporting services is installed the machine name is configured by
> default eg: http://MAIN/Reports, however, if I try to access the
> reporting services machine by other than the machine name I receive an
> error.
> I'm trying something along the lines of
> http://testing.xxxx.com/reports. Am prompted for the username and
> password and can login without any issue, however, I can't display any
> of the reports because the URL points to http://MAIN/.... rather
> than the fully qualified domain name.
> Just wondering what I'm doing wrong.
> Thanks in advance,
> CN|||I get the same error. This is one of those "pray to SP1" things, It think.
Tim Heuer
"CN" <charles@.pstgi.com> wrote in message
news:495b624a.0406200659.517908a1@.posting.google.com...
> To further clarify the issue, currently the ReportServerUrl in the
> RSWebApplication.config (ReportManager Folder) includes an entry to
> allow the ReportServerUrl to be specified.
> Original Value
<ReportServerUrl>http://MACHINENAME/ReportServer/</ReportServerUrl>
> Modified Value
<ReportServerUrl>http://www.domainname.com/ReportServer/</ReportServerUrl>
> With this change and restarting reporting services everthing works
> okay if you login as a basic user/browser (can navigate and view
> reports), however, if you then try to login with an administrative
> account ... you can't. You continually receive an error message "
> There is an error in XML document (1, 1225).
> ".
> If you switch the value in the configuration file back to the machine
> name everything is accessible again except the reports can't be
> viewed.
> Hence my dilema - am I doing something wrong or is this an issue with
> the current release of reporting services?
>
> (CN) wrote in message
news:<495b624a.0406191428.619fae2a@.posting.google.com>...
> > When reporting services is installed the machine name is configured by
> > default eg: http://MAIN/Reports, however, if I try to access the
> > reporting services machine by other than the machine name I receive an
> > error.
> >
> > I'm trying something along the lines of
> > http://testing.xxxx.com/reports. Am prompted for the username and
> > password and can login without any issue, however, I can't display any
> > of the reports because the URL points to http://MAIN/.... rather
> > than the fully qualified domain name.
> >
> > Just wondering what I'm doing wrong.
> >
> > Thanks in advance,
> >
> > CN

Accessing RDL Reports from Visual Basic 6.0 Application

Hai! I don't know is this a silly question. Is it possible to execute and display the rdl (Sql server 2005 reporting services) report from visual basic 6.0 application.

I have a full fledged Visual basic windows application and using crystal reports. I want to create the reports using SQL server 2005 reporting services and access it from my Visual Basic 6.0 Windows application.

Thanks in advance

I'm afraid VB6 support has ended, and so VB6 questions are off topic here. Try www.vbcity.com instead.

Accessing printer settings in the sql reporting services 2000

I am using Visual Studio 2003 and SQL Reporting Services 2000. I am creating a Intranet based application which will be used by our company employees only. I want to know how can I set a printer, paper tray and paper size in the report settings, so that user need not to change the printer settings for each report. In the application some of the reports will be printed on pre-printed paper, some on the plain paper. and i want to print the reports which is not a defaul printer.

I did not find any solution yet... any ideas ... It will be a great help for me..

Accessing Oracle data from Reporting Services 2000

I am receiving this error -

An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'IFSDB'. (rsErrorOpeningConnection) Get Online Help ORA-12638: Credential retrieval failed

When I attempt to run a report that accesses an Oracle database. If I sign on to the report server and run the report, it is successful. When I attempt to run it from any other workstation, I get the above error.

We are running both Oracle and SQL Server on the same server.

Particulars -

SQL Server 2000,

Oracle 9.2.0.6

Windows Server 2003

Thanks for any and all help

First, I suggest to check your Oracle client configuration file (ORA_HOME\network\admin\sqlnet.ora) and consult the Oracle documentation. Most likely you can resolve the error by changing the configuration file line

SQLNET.AUTHENTICATION_SERVICES= (NTS)
into:
SQLNET.AUTHENTICATION_SERVICES=(NONE)

If you then run into other Oracle error messages, it may be causes by insufficient file system permissions to read certain files of the Oracle client installation. See this KB article for details: http://support.microsoft.com/?kbid=870668

-- Robert

Accessing mirrored databases in SqlServer 2005

Using the new sqlserver 2005 mirroring, can client connections be made to the non-principal database for, say, reporting purposes? Does this affect the failover?

Thanks

For reporting only run with safety off and no witness. Either one is enough to disable auto failover, but quorum (2 of 3) is required to run with safety on so with no witness both systems must be up to update the principal server. Safety off allows running with the mirror down and no witness. To use the mirror as a reporting server you can create database snapshots on an active mirror. This allows point in time read only access to the database.

http://msdn2.microsoft.com/en-us/library/ms175511.aspx