Showing posts with label unfortunately. Show all posts
Showing posts with label unfortunately. Show all posts

Tuesday, March 20, 2012

reports in rich client

I am currently tasked with plugging our Reporting Services reports into a rich client application. Unfortunately, I am constrained to use RS2003 -- since we can't force our customers to upgrade SQLServer just yet -- which means I can't use the ReportViewer control that i hear comes bundled with 2005 beta. I have to throw together a kind of homegrown report viewer.

A couple of strategies i have in mind are
1) having an IE control hitting the Report Manager
2) having a PDF viewer control being fed reports rendered and delivered via web services

Has anyone done this? Any horror or success stories? Any thoughts on which option is best, or other options I may have overlooked?

Solution in RS 2000 (not 2003 :-)) is to embed a browser control in your application. Use your UI to drive the URL of the browser control to view the appropriate report.

The problem is that you need to set the URL to the report server, not the report manager. This mean each client knows where the report server is - this could become a maintenance problem, but is surmountable.

Regarding horror stories - we've seen that when you do this, the client print control does not work well. You might choose to disable that capability.

Hope that helps,

-Lukasz


This posting is provided "AS IS" with no warranties, and confers no rights.

reports in rich client

I am currently tasked with plugging our Reporting Services reports into a rich client application. Unfortunately, I am constrained to use RS2003 -- since we can't force our customers to upgrade SQLServer just yet -- which means I can't use the ReportViewer control that i hear comes bundled with 2005 beta. I have to throw together a kind of homegrown report viewer.

A couple of strategies i have in mind are
1) having an IE control hitting the Report Manager
2) having a PDF viewer control being fed reports rendered and delivered via web services

Has anyone done this? Any horror or success stories? Any thoughts on which option is best, or other options I may have overlooked?

Solution in RS 2000 (not 2003 :-)) is to embed a browser control in your application. Use your UI to drive the URL of the browser control to view the appropriate report.

The problem is that you need to set the URL to the report server, not the report manager. This mean each client knows where the report server is - this could become a maintenance problem, but is surmountable.

Regarding horror stories - we've seen that when you do this, the client print control does not work well. You might choose to disable that capability.

Hope that helps,

-Lukasz


This posting is provided "AS IS" with no warranties, and confers no rights.

Monday, March 12, 2012

Reports based off MDB

i have set up a report package that unfortunately uses an MDB as the
datasource (it will be upsized to SQL server soon); however, when any user
attempts to view/generate the reports they get the following error:
Reporting Services Error
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'Accreditations_DB'.
(rsErrorOpeningConnection) Get Online Help
Unspecified error
The report(s) run fine off my test machine (i am the admin for the report
server).
any suggestions?
thanks,
benYou could put the MDB on a share and set that path in your connection
string. Or every user can have the MDB in the same path on each of their
local machines.
--
| Thread-Topic: Reports based off MDB
| thread-index: AcWXcPgArs6cX3IkSE6p/O0qCf3ZDQ==| X-WBNR-Posting-Host: 205.210.222.129
| From: =?Utf-8?B?QmVu?= <ben_1_ AT hotmail DOT com>
| Subject: Reports based off MDB
| Date: Tue, 2 Aug 2005 07:46:30 -0700
| Lines: 17
| Message-ID: <2C049966-34CD-4AEC-98D8-F24B6FB91CDD@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:49442
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| i have set up a report package that unfortunately uses an MDB as the
| datasource (it will be upsized to SQL server soon); however, when any
user
| attempts to view/generate the reports they get the following error:
|
| Reporting Services Error
| An error has occurred during report processing. (rsProcessingAborted) Get
| Online Help
| Cannot create a connection to data source 'Accreditations_DB'.
| (rsErrorOpeningConnection) Get Online Help
| Unspecified error
|
| The report(s) run fine off my test machine (i am the admin for the report
| server).
|
| any suggestions?
| thanks,
| ben
||||Both those options are options that we are trying to avoid. I think it has
something to do with credentials because i stored my login and pass in the
datasource and checked the "impersonate" option and that seemed to work.
""Brad Syputa - MS"" wrote:
> You could put the MDB on a share and set that path in your connection
> string. Or every user can have the MDB in the same path on each of their
> local machines.
> --
> | Thread-Topic: Reports based off MDB
> | thread-index: AcWXcPgArs6cX3IkSE6p/O0qCf3ZDQ==> | X-WBNR-Posting-Host: 205.210.222.129
> | From: =?Utf-8?B?QmVu?= <ben_1_ AT hotmail DOT com>
> | Subject: Reports based off MDB
> | Date: Tue, 2 Aug 2005 07:46:30 -0700
> | Lines: 17
> | Message-ID: <2C049966-34CD-4AEC-98D8-F24B6FB91CDD@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:49442
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | i have set up a report package that unfortunately uses an MDB as the
> | datasource (it will be upsized to SQL server soon); however, when any
> user
> | attempts to view/generate the reports they get the following error:
> |
> | Reporting Services Error
> | An error has occurred during report processing. (rsProcessingAborted) Get
> | Online Help
> | Cannot create a connection to data source 'Accreditations_DB'.
> | (rsErrorOpeningConnection) Get Online Help
> | Unspecified error
> |
> | The report(s) run fine off my test machine (i am the admin for the report
> | server).
> |
> | any suggestions?
> | thanks,
> | ben
> |
>