Report Model Wizard

I created a data soure view that has tables from two data sources (both sql databases). when I try to generate a report model using this data source view, I get an "invalid object name" error for the first table it encounters that is not from the "primary" data source for the view. Is there something I need to do so the report model retrieves the connection strings for both data sources? Any help is greatly appreciated. Thank you in advance!Did you ever figure this out? I'm having the same problem.|||Cross-database report models are not supported in Model Designer. You can get around this by creating a view on top of the second table. We should probably give you a more informative error (or add support for it).|||Thank you for the reply.. I'm not sure I understand the workaround though. I am trying to do a proof of concept for my department and we have several data sources that I need to report from. Any help I can get is truly appreciated. I've been reading up on the different BI tools available with SQL server 2005 and it seems that maybe my best bet is to work on a data integration project... not sure which route to go. I do have a very good understanding of our database schema, its just a matter of how I can simplify it for end users to be able to write their own reports.|||I think I might have misread your original question. Are the two databases on the same server? If not, you will need to use the Linked Server feature of SQL to make this work. There are some performance implications with cross-server joins that may mean that you should pull the two sources into a single database using Integration Services,|||I actually have both cases... But I can't even get the view to work for two databases on the same server.. can you shed some light on that scenario?|||

Yudi,

If the databases are on one instance on one server, you can use the full name of the table to access the data in a named query. For instance,

SELECT col1, col2, col3 FROM table1

would be the first named query in the original database. In another named query you could use

SELECT col1, col2, col3 FROM DB1.dbo.table2

Provided you have the correct permissions on that database, you will be able to see the data in both databases. I use that technique and it works fairly well.

R

sql

Report Model Wizard

I created a data soure view that has tables from two data sources (both sql databases). when I try to generate a report model using this data source view, I get an "invalid object name" error for the first table it encounters that is not from the "primary" data source for the view. Is there something I need to do so the report model retrieves the connection strings for both data sources? Any help is greatly appreciated. Thank you in advance!Did you ever figure this out? I'm having the same problem.|||Cross-database report models are not supported in Model Designer. You can get around this by creating a view on top of the second table. We should probably give you a more informative error (or add support for it).|||Thank you for the reply.. I'm not sure I understand the workaround though. I am trying to do a proof of concept for my department and we have several data sources that I need to report from. Any help I can get is truly appreciated. I've been reading up on the different BI tools available with SQL server 2005 and it seems that maybe my best bet is to work on a data integration project... not sure which route to go. I do have a very good understanding of our database schema, its just a matter of how I can simplify it for end users to be able to write their own reports.|||I think I might have misread your original question. Are the two databases on the same server? If not, you will need to use the Linked Server feature of SQL to make this work. There are some performance implications with cross-server joins that may mean that you should pull the two sources into a single database using Integration Services,|||I actually have both cases... But I can't even get the view to work for two databases on the same server.. can you shed some light on that scenario?|||

Yudi,

If the databases are on one instance on one server, you can use the full name of the table to access the data in a named query. For instance,

SELECT col1, col2, col3 FROM table1

would be the first named query in the original database. In another named query you could use

SELECT col1, col2, col3 FROM DB1.dbo.table2

Provided you have the correct permissions on that database, you will be able to see the data in both databases. I use that technique and it works fairly well.

R

Report Model with XML datasource

Is there a way to create a Report Model with XML / WebService as datasource?

I am able to generate reports that connect to a WebService through Report Designer, but unable to find similar functionality in Model Designer.

JDee,

Here's a link for setting the Report Service XML datasource. I hope this works for you.

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

Ham

|||I'm interested in the same possibility. As far as I've understood, it's possible to generate models only from relational data sources. It would be a great surprise for me if not.|||RS 2005 supports only SQL Server (2000 and up), Analysis Services 2005 and starting with SP2 Oracle as data sources.|||Yes, from my understanding models are generated from relational data sources. I believe XML can represent relational database (http://www.w3.org/XML/RDB.html). I think a data provider which supplies XML as data source would be a neat feature in the upcoming versions.

Report Model with XML datasource

Is there a way to create a Report Model with XML / WebService as datasource?

I am able to generate reports that connect to a WebService through Report Designer, but unable to find similar functionality in Model Designer.

JDee,

Here's a link for setting the Report Service XML datasource. I hope this works for you.

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

Ham

|||I'm interested in the same possibility. As far as I've understood, it's possible to generate models only from relational data sources. It would be a great surprise for me if not.|||RS 2005 supports only SQL Server (2000 and up), Analysis Services 2005 and starting with SP2 Oracle as data sources.|||Yes, from my understanding models are generated from relational data sources. I believe XML can represent relational database (http://www.w3.org/XML/RDB.html). I think a data provider which supplies XML as data source would be a neat feature in the upcoming versions.

Report Model Generator freezes VS2005

Hi,

I'm trying to generate data source model from appropriate relational

data source view with Report Model Wizard. But at the end of "Step 2:

processing rules on relations" Visual Studio devenv process aquires all

CPU resources and freezes VS.

What's wrong with my view? May be it contains some features that aren't supported by model generation process.

Regards,

Anatoly.

что произойдет если оставить машину в таком состоянии на какое-то время?
какая версия репорт сервера?
попробуй приаттачить DSV, кстати какой размер DSV файла?

Report is Being Generated

I have a report with 12 parameters. They all have a default setting. When
I go to preview the report in the IDE it automatically starts to generate
the report with the user having to hit the view report button. Is there a
way to keep the report from auto generating without user interaction?I have a report with 12 parameters. They all have a default setting. When
I go to preview the report in the IDE it automatically starts to generate
the report without the user having to hit the view report button. Is there
a
way to keep the report from auto generating without user interaction?
"Chris" <cexley@.enableconsulting.com> wrote in message
news:Oak73TDdGHA.4900@.TK2MSFTNGP02.phx.gbl...
>I have a report with 12 parameters. They all have a default setting. When
>I go to preview the report in the IDE it automatically starts to generate
>the report with the user having to hit the view report button. Is there a
>way to keep the report from auto generating without user interaction?
>|||Unfortunately this is by design. If all the parameters have defaults it
immediately starts rendering. You need to have at least one parameter that
the user has to select.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <cexley@.enableconsulting.com> wrote in message
news:Oak73TDdGHA.4900@.TK2MSFTNGP02.phx.gbl...
>I have a report with 12 parameters. They all have a default setting. When
>I go to preview the report in the IDE it automatically starts to generate
>the report with the user having to hit the view report button. Is there a
>way to keep the report from auto generating without user interaction?
>|||Thanks for the response. I think it is bad design, and should be a property
(IsAutoGenerate comes to mind).
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:u7YDbYDdGHA.5048@.TK2MSFTNGP03.phx.gbl...
> Unfortunately this is by design. If all the parameters have defaults it
> immediately starts rendering. You need to have at least one parameter that
> the user has to select.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Chris" <cexley@.enableconsulting.com> wrote in message
> news:Oak73TDdGHA.4900@.TK2MSFTNGP02.phx.gbl...
>>I have a report with 12 parameters. They all have a default setting.
>>When I go to preview the report in the IDE it automatically starts to
>>generate the report with the user having to hit the view report button.
>>Is there a way to keep the report from auto generating without user
>>interaction?
>

Report Generator & CustomRollupColumn

Hi

I have have a dimension level that uses a CustomRollupColumn. I am not able to generate reports with the Report generator.

Because the generator creates a MDX that uses the function exists. An this functions ignore my members with a CustomRollupColumn.

Is there a way to confure the my model in order to use the Report generator?

Is something rong with my dimension?

Thanks

Can someone use the report generator with CustomRollupColumn

I just one to know it is possible and I just have to redesign my dimension?

Thanks!

Report GenerationObject reference not set to an instance of an object

I started a new thread as I was able to get more information on the error Im getting when I attempt to generate the report in report manager. Ive seen some solutions but nothing seems to work for my particular case. I am hopefull that this can be resolved "WITHOUT" ininstalling and reinstalling SSRS so any information would be helpful.

Here is the Soure Error and Stack Trace info:

Server Error in '/Reports' Application.

---

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]

Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces) +18

Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e) +358

Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +482

Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +958

Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84

Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +143

Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +75

System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Hi,

Can you tell us what you are exactly trying to do, this way we can find out were you could be potentially going wrong...

Can you also look at your event log or the reporting services log files -this will give you more detail of the error caused...

One possible cause could be your connection and dataset, check these out.

Hope this helps.

|||

I can log into the report manager no problem-- its when I try to generate any report that I have this issue. The only thing that changed is I had to take the database offline for about a week and then brought it back online. All other permissions, roles etc have remained the same. When I try and generate the report I get the error in the middle of the screen and things are out of place -- print icon is where the report should be so is the refresh icon. I have included the info from the event viewer-- thanks in advance for any info that may help me avoid having to uninstall and reinstall ssrs

Event code: 3005

Event message: An unhandled exception has occurred.

Event time: 3/27/2007 8:48:19 AM

Event time (UTC): 3/27/2007 2:48:19 PM

Event ID: 68829be2d597449ca27166b54403c3a1

Event sequence: 2677

Event occurrence: 98

Event detail code: 0

Application information:

Application domain: /LM/W3SVC/1/root/Reports-2-128189799508346487

Trust level: RosettaMgr

Application Virtual Path: /Reports

Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\

Machine name: HDSWEBK

Process information:

Process ID: 5360

Process name: w3wp.exe

Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:

Exception type: NullReferenceException

Exception message: Object reference not set to an instance of an object.

Request information:

Request URL: http://............./Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.2047.00

Request path: /Reports/Reserved.ReportViewerWebControl.axd

User host address: 128.138.29.6

User: AD\mcdermk

Is authenticated: True

Authentication Type: Negotiate

Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:

Thread ID: 6

Thread account name: NT AUTHORITY\NETWORK SERVICE

Is impersonating: True

Stack trace: at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)

at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)

at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)

at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)

at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)

at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Custom event details:

For more information, see Help and Support Center at

Report generation time between users and admin

Hi,

When we generate a report with an account that is in the admin group it takes 2-3 seconds but when we do it with another user it takes over 2 minutes... any reason for this?

(The "Report is being generated" thing, by the way)

Not sure if my question is clear, I've been looking and searching for the past 2 hours but can't find anything remotly close to that problem... any help would be appreaciated!

Thanks

Wacky guess:

Are temp files for the two accounts going to different places, for example there is a "home" drive for normal users that is not local?

>L<