Report Model Project: Multiple Data Sources

I have setup a "Report Model Project" with multiple data sources, and
imported tables from each of these into my data source view. When I try to
use the wizard to create a report model I get an error on the "Completing the
Wizard" stage when I click "Run".
An error occurred while executing a command.
Message: Invalid object name 'dbo.<table name>'.
Command:
SELECT COUNT(*) FROM [dbo].[<table name>] t
The <table name> will always relate to the first table it attempts to
process from the secondary (non-primary) data source. I figured this out by
setting up the project from scratch with the opposite data source as primary.
It seems like it is looking in the primary data source for the table that it
should be trying to use the secondary data source to query.
Any help is appreciated. :)A report model can only reference one data source in this release. Data
source views are more flexible than supported by report models.
-Carolyn
"Greg T. Smith" wrote:
> I have setup a "Report Model Project" with multiple data sources, and
> imported tables from each of these into my data source view. When I try to
> use the wizard to create a report model I get an error on the "Completing the
> Wizard" stage when I click "Run".
> An error occurred while executing a command.
> Message: Invalid object name 'dbo.<table name>'.
> Command:
> SELECT COUNT(*) FROM [dbo].[<table name>] t
> The <table name> will always relate to the first table it attempts to
> process from the secondary (non-primary) data source. I figured this out by
> setting up the project from scratch with the opposite data source as primary.
> It seems like it is looking in the primary data source for the table that it
> should be trying to use the secondary data source to query.
> Any help is appreciated. :)

Report Manager http/https - mixed links

Hi,
I have setup reportserver with default settings (non https) and afterwards in IIS added a certificate and https support.
Know I am able to work really well and secure over the internet, but some links in report manager pointing to http://server.domain.com/reports instead of https:
For example if i call a report and then in the top there are (view, properties,...)
- View is HTTPS
- Properties is HTTPS
- History is HTTP
- Subscription is HTTP

I have read some articles - mentions I should configure https, but
- in Report Configuration you could not setup HTTPS
- in rsreportserver.config i have entered the https link version but did not change anything
- in RSWebApplication.config the Reportserverurltag is blank - so i did not change anything

Thanks for any help

HANNESCan you check to make sure that in the RSReportServer.config file the SecureConnectionLevel is set to 3?|||after this switch i received an error - SSL/TSL trust relationship could not be established, but then i entered the full qualified certifcate name in report server configuration and now its working fine

may thanks
HANNES|||

You noted you entered the fully qualifed certificate name in the report server configuration and it is working....where exactly did you enter this information in the report server configuration? Are you speaking of the 'Report Server Configuration' application, or some other config file that affects the report server configuration?

Thanks

hmayer wrote:

after this switch i received an error - SSL/TSL trust relationship could not be established, but then i entered the full qualified certifcate name in report server configuration and now its working fine

may thanks
HANNES

|||

As far as I remember I have modified the RSWebApplication.config config file in the reportmanager directory of report server.

I have modified the ReportServerUrl tag to something like this <ReportServerUrl>https://fullqualifiedhostname/ReportServer</ReportServerUrl> (matching the certificate name.

LG, HANNES

Report Manager http/https - mixed links

Hi,
I have setup reportserver with default settings (non https) and afterwards in IIS added a certificate and https support.
Know I am able to work really well and secure over the internet, but some links in report manager pointing to http://server.domain.com/reports instead of https:
For example if i call a report and then in the top there are (view, properties,...)
- View is HTTPS
- Properties is HTTPS
- History is HTTP
- Subscription is HTTP

I have read some articles - mentions I should configure https, but
- in Report Configuration you could not setup HTTPS
- in rsreportserver.config i have entered the https link version but did not change anything
- in RSWebApplication.config the Reportserverurltag is blank - so i did not change anything

Thanks for any help

HANNESCan you check to make sure that in the RSReportServer.config file the SecureConnectionLevel is set to 3?|||after this switch i received an error - SSL/TSL trust relationship could not be established, but then i entered the full qualified certifcate name in report server configuration and now its working fine

may thanks
HANNES|||

You noted you entered the fully qualifed certificate name in the report server configuration and it is working....where exactly did you enter this information in the report server configuration? Are you speaking of the 'Report Server Configuration' application, or some other config file that affects the report server configuration?

Thanks

hmayer wrote:

after this switch i received an error - SSL/TSL trust relationship could not be established, but then i entered the full qualified certifcate name in report server configuration and now its working fine

may thanks
HANNES

|||

As far as I remember I have modified the RSWebApplication.config config file in the reportmanager directory of report server.

I have modified the ReportServerUrl tag to something like this <ReportServerUrl>https://fullqualifiedhostname/ReportServer</ReportServerUrl> (matching the certificate name.

LG, HANNES

Report Manager http/https - mixed links

Hi,
I have setup reportserver with default settings (non https) and afterwards in IIS added a certificate and https support.
Know I am able to work really well and secure over the internet, but some links in report manager pointing to http://server.domain.com/reports instead of https:
For example if i call a report and then in the top there are (view, properties,...)
- View is HTTPS
- Properties is HTTPS
- History is HTTP
- Subscription is HTTP

I have read some articles - mentions I should configure https, but
- in Report Configuration you could not setup HTTPS
- in rsreportserver.config i have entered the https link version but did not change anything
- in RSWebApplication.config the Reportserverurltag is blank - so i did not change anything

Thanks for any help

HANNESCan you check to make sure that in the RSReportServer.config file the SecureConnectionLevel is set to 3?|||after this switch i received an error - SSL/TSL trust relationship could not be established, but then i entered the full qualified certifcate name in report server configuration and now its working fine

may thanks
HANNES|||

You noted you entered the fully qualifed certificate name in the report server configuration and it is working....where exactly did you enter this information in the report server configuration? Are you speaking of the 'Report Server Configuration' application, or some other config file that affects the report server configuration?

Thanks

hmayer wrote:

after this switch i received an error - SSL/TSL trust relationship could not be established, but then i entered the full qualified certifcate name in report server configuration and now its working fine

may thanks
HANNES

|||

As far as I remember I have modified the RSWebApplication.config config file in the reportmanager directory of report server.

I have modified the ReportServerUrl tag to something like this <ReportServerUrl>https://fullqualifiedhostname/ReportServer</ReportServerUrl> (matching the certificate name.

LG, HANNES

Report History

Hello,
Is it possible to setup Reporting Services so that when each report is run
the snapshot is saved for historical reporting purposes?
So far the only way I can create historical reports is by manually clicking
on the "New Subscription" button.
Ideally we need a solution that will allow us to save reports that are run,
back them up nightly, weekly or monthly, and have the potential to restore
them if necessary.
Anyone have ideas?
Much Appreciated!
Benjamin PierceReport Manager allows a number of History options. Please review the
Properties section for a given report.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Benjamin Pierce" <bpierce@.opentext.com> wrote in message
news:%23UvX%23ZEZEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Is it possible to setup Reporting Services so that when each report is run
> the snapshot is saved for historical reporting purposes?
> So far the only way I can create historical reports is by manually
clicking
> on the "New Subscription" button.
> Ideally we need a solution that will allow us to save reports that are
run,
> back them up nightly, weekly or monthly, and have the potential to restore
> them if necessary.
> Anyone have ideas?
> Much Appreciated!
> Benjamin Pierce
>

Report generates incorrect results

Hey, after tinkering around with this VB 2005/Crystal setup for a while, I finally narrowed down the issue with the problem I'm having.

Using the SQL query Crystal gives me, I am trying to use VB.NET to pull data from a DSN server and into a DataSet, which I am trying to merge with the rpt file using the report.SetDataSource option. The problem is, with that particular query, the results generated pages in the report in the THOUSANDS. Typically, this report never goes over 10 pages. The thing is that when I generate the report within Crystal itself, it's fine... 10 pages or less.

After some fooling around with the VB code, I found that the problem was in the query! It seems that when I pull certain fields and inject them into the report, it systematically loads every possible value from those fields into each group (company tickets), and with so many fields this happens with, there becomes a compound effect. So what was 50+ bloat pages then becomes thousands.

I am wondering what the issue could possibly be with the query Crystal gives me (which works in Crystal) that when I try to bind the same data from a DataSet with the rpt template, it inflates the report with garbage data. Anyone have any similar occurrances or suggestions?Bump|||Maybe is how Crystal evaluates the records (whilereading, beforerading??) or maybe somehow one field was moved a detail section and before was on a header. I assume queries are the same...

Robert

Report from - Report to

Hi,

I have a report setup on reporting services which has several subscriptions attached. The report is run every business day, each hour (8am till 7pm), but the only problem I currently have, is with the report from and report to fields. Is there a proper way to set these up for the automatic distribution, so that the subscription that runs at 8am, will report data from the day before 7pm till 8am?

thanks!

Lionell

Can you clarify your ask? I think what you want is possible, but I'm not sure whether you want a distribution list (data-driven subscription) or you want the 8:00 AM report to be different than the other reports (parameterized report or distinct .RDL).

|||

It's a standard report, not a data-driven subscription. The 8:00 AM report needs to report data from the last time the report was run the previous day until 8:00AM of the current day.

Is there a @.LastTimeRun function which can be used? This probably needs to be put into the report right? Or can it be configured through the web based report manager?

Every report that runs needs to report data from a certain period, for example the 8:00AM report will report from 7pm previous day till 8:00AM current day. Next report will be run at 9:00AM and report data from 8:00AM till 9:00AM and so on.

Hope this explains it better.

regards

Lionell