Friday, March 30, 2012
Report Designer vs. Report Builder
Modeler model? In other words make a report that is deployed from Visual
Studio editable using Report Builder, or even the other way around.
--
Tom GarthTom,
It is been my experience that you can't. I have tried a number of different
things with no luck.
"Tom Garth" wrote:
> Is it possible to associate a VS Report Designer report with a VS Report
> Modeler model? In other words make a report that is deployed from Visual
> Studio editable using Report Builder, or even the other way around.
> --
> Tom Garth|||you can't
you can open an RDL created in report builder into VS
you can can create a new report in VS based on a report builder model
but you can't allow a user to edit a report created into VS with report
builder.
"Tom Garth" <TomGarth@.discussions.microsoft.com> wrote in message
news:2930040A-8541-49F0-B6C4-174C47AF8DED@.microsoft.com...
> Is it possible to associate a VS Report Designer report with a VS Report
> Modeler model? In other words make a report that is deployed from Visual
> Studio editable using Report Builder, or even the other way around.
> --
> Tom Garth|||Thanks to you both. You have confirmed cause my frustation. It is very
unfortunate that this is so, but... oh well.
--
Tom Garth
"Tom Garth" wrote:
> Is it possible to associate a VS Report Designer report with a VS Report
> Modeler model? In other words make a report that is deployed from Visual
> Studio editable using Report Builder, or even the other way around.
> --
> Tom Garthsql
Report Designer using Report Model as data source
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dan Krish" <DanKrish@.discussions.microsoft.com> wrote in message
news:2C2DD0D5-F184-46ED-9311-9DCA8602B1D5@.microsoft.com...
> can we use Report Designer to build reports off a Model?
>
Friday, March 23, 2012
Report Builder?
the message show me : Table dose not have a primary key.
So, the table wants to build as a report model must have primary key?
If I want the table that has no primary key and build as report model,
how could I do?
Thanks for any advice!
AngiIt is possible to manually create an entity, bind it to the table, add
fields etc.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angi" <enchiw@.msn.com> wrote in message
news:ua5mb4BtFHA.2912@.TK2MSFTNGP09.phx.gbl...
>I have a table with no Primary Key and during build the report model,
> the message show me : Table dose not have a primary key.
> So, the table wants to build as a report model must have primary key?
> If I want the table that has no primary key and build as report model,
> how could I do?
> Thanks for any advice!
> Angi
>
Report Builder: Is there a way to filter a filter?
We have a report model that connects to a single table. Some of the columns of the table contains blank values which is regarded as a valid value in our reports.
We have a requirement that the filter selection should not contain any blank values. They do not want to include a blank value for the users to choose but if the users decide not to use a filter, those blank values should still be included in the report.
Does anyone have any suggestions on how to do this in RB? We already made this work in RS2k5 but we can't seem to find any way to do this in RB.
Thanks,
Joseph
No, there is no way to control the list of values presented to the user. It is always a list of all existing values in the underlying database.
Report Builder: how to create a static report?
I have created a report based on a report builder model using Visual Studio.
This report will replace the default drill report.
so after I have published my report in report server, I'll modify my model
(model properties) to setup the drill through report of my customer entity.
When I save the new config I receive this error:
rsInvalidModelDrillthroughReport
/Models/DrillReports/Report1 is not a valid drill report.
so the question is, how to create a valid drill report'
there is some particular parameters to setup?
the help don't describe this.
any sample anywhere?
thanks.
Jerome.ok
I have missed some properties.
Now all works fine!!!!
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:ezZS2LuFGHA.140@.TK2MSFTNGP12.phx.gbl...
> hi,
> I have created a report based on a report builder model using Visual
> Studio.
> This report will replace the default drill report.
> so after I have published my report in report server, I'll modify my model
> (model properties) to setup the drill through report of my customer
> entity.
> When I save the new config I receive this error:
> rsInvalidModelDrillthroughReport
> /Models/DrillReports/Report1 is not a valid drill report.
> so the question is, how to create a valid drill report'
> there is some particular parameters to setup?
> the help don't describe this.
> any sample anywhere?
> thanks.
> Jerome.
>
Report Builder: Filter drop down list unspecified
over to another server and changed the data source for it. I can still build
a report that returns the correct data, but when I add a filter to the report
data, the ddl for the filter never loads the data and says 'unspecified'.
I'm not sure what the problem could be. Any ideas? ThanksAfter doing some hunting around I found this:
One of the most commonly used features in ad-hoc reporting is filtering. To
add filters to a report, select a field, and then click the Filter button. If
the InstanceSelection attribute enables drop-down, filter values will be
automatically populated. In article
http://msdn2.microsoft.com/en-us/library/aa964121.aspx#adhocrptsol_topic5
This is not the issue asthe InstanceSelection property is properly configured.
"Jason" wrote:
> I have a report model which functioned correctly until I copied the project
> over to another server and changed the data source for it. I can still build
> a report that returns the correct data, but when I add a filter to the report
> data, the ddl for the filter never loads the data and says 'unspecified'.
> I'm not sure what the problem could be. Any ideas? Thanks
Report Builder, limiting the Dimensions
Hi,
I created a report model based over the cube. The problme is, it retrieves all dimensions from the cube regardless those are checked or not even in the prespective.
It does work with Measure but not with Dimensions.
Appreciate if some one can drop a line here and help me out.
Thank you
Imran
You need to make manual changes to the model for this to happen.
1. Create a new Report Builder project.
2. Save the auto-generated SMDL file from Report Manager.
3. Add it to the Report Builder project.
4. Open the model in the Model Designer and select the root Model node.
5. On the right pane, right-click on the perspective desired and choose Edit.
6. In the Edit Perspective dialog box, unselect all dimensions that you don't need.
7. When you are done, go back to the Report Manager and update the model (click the Update button).
HTH
|||The model is generated from the cube... It is not over the relational database where I can create and edit prepectives.
Imran
|||I understand your scenario. You can still make manual changes to a model generated from UDM by following the steps in my previous post.
|||Ok...
I limit the Dimension as you mentioned but now I cann't generate the report... The reason is, somehow all the Dimensions need to be selected in the Model...else it is not going to work.... Updating the Model back to original state rectify the problem.
Any help?
Thank You
Imran
|||Can you provide repro steps with the AdventureWorks cube and include a report definition of a Report Builder report that cannot be generated?
|||Report Builder models generated against an Analysis Services cube cannot be edited using Model Designer. Also, modifying the report-model (.smdl) file directly is not supported.
Source: http://msdn2.microsoft.com/en-us/library/aa964121.aspx
Even if try to modify the report builder model using other way, we canot get the achieved results.
--Imran
|||I am well aware of the Report Builder-SSAS limitations and the fact that the modifying the report-model is not supported. However, when nothing else helps you don't have much choice unless you take the unsupported road, do you? You should be able to open the smdl file in a Report Builder project, make the changes I mentioned, and update the model back successfully. If something doesn't work, please let us know what it is and provide repro steps if possible.
Report Builder, limiting the Dimensions
Hi,
I created a report model based over the cube. The problme is, it retrieves all dimensions from the cube regardless those are checked or not even in the prespective.
It does work with Measure but not with Dimensions.
Appreciate if some one can drop a line here and help me out.
Thank you
Imran
You need to make manual changes to the model for this to happen.
1. Create a new Report Builder project.
2. Save the auto-generated SMDL file from Report Manager.
3. Add it to the Report Builder project.
4. Open the model in the Model Designer and select the root Model node.
5. On the right pane, right-click on the perspective desired and choose Edit.
6. In the Edit Perspective dialog box, unselect all dimensions that you don't need.
7. When you are done, go back to the Report Manager and update the model (click the Update button).
HTH
|||The model is generated from the cube... It is not over the relational database where I can create and edit prepectives.
Imran
|||
I understand your scenario. You can still make manual changes to a model generated from UDM by following the steps in my previous post.
|||Ok...
I limit the Dimension as you mentioned but now I cann't generate the report... The reason is, somehow all the Dimensions need to be selected in the Model...else it is not going to work.... Updating the Model back to original state rectify the problem.
Any help?
Thank You
Imran
|||Can you provide repro steps with the AdventureWorks cube and include a report definition of a Report Builder report that cannot be generated?
|||Report Builder models generated against an Analysis Services cube cannot be edited using Model Designer. Also, modifying the report-model (.smdl) file directly is not supported.
Source: http://msdn2.microsoft.com/en-us/library/aa964121.aspx
Even if try to modify the report builder model using other way, we canot get the achieved results.
--Imran
|||I am well aware of the Report Builder-SSAS limitations and the fact that the modifying the report-model is not supported. However, when nothing else helps you don't have much choice unless you take the unsupported road, do you? You should be able to open the smdl file in a Report Builder project, make the changes I mentioned, and update the model back successfully. If something doesn't work, please let us know what it is and provide repro steps if possible.
Report Builder, limiting the Dimensions
Hi,
I created a report model based over the cube. The problme is, it retrieves all dimensions from the cube regardless those are checked or not even in the prespective.
It does work with Measure but not with Dimensions.
Appreciate if some one can drop a line here and help me out.
Thank you
Imran
You need to make manual changes to the model for this to happen.
1. Create a new Report Builder project.
2. Save the auto-generated SMDL file from Report Manager.
3. Add it to the Report Builder project.
4. Open the model in the Model Designer and select the root Model node.
5. On the right pane, right-click on the perspective desired and choose Edit.
6. In the Edit Perspective dialog box, unselect all dimensions that you don't need.
7. When you are done, go back to the Report Manager and update the model (click the Update button).
HTH
|||The model is generated from the cube... It is not over the relational database where I can create and edit prepectives.
Imran
|||I understand your scenario. You can still make manual changes to a model generated from UDM by following the steps in my previous post.
|||Ok...
I limit the Dimension as you mentioned but now I cann't generate the report... The reason is, somehow all the Dimensions need to be selected in the Model...else it is not going to work.... Updating the Model back to original state rectify the problem.
Any help?
Thank You
Imran
|||Can you provide repro steps with the AdventureWorks cube and include a report definition of a Report Builder report that cannot be generated?
|||Report Builder models generated against an Analysis Services cube cannot be edited using Model Designer. Also, modifying the report-model (.smdl) file directly is not supported.
Source: http://msdn2.microsoft.com/en-us/library/aa964121.aspx
Even if try to modify the report builder model using other way, we canot get the achieved results.
--Imran
|||I am well aware of the Report Builder-SSAS limitations and the fact that the modifying the report-model is not supported. However, when nothing else helps you don't have much choice unless you take the unsupported road, do you? You should be able to open the smdl file in a Report Builder project, make the changes I mentioned, and update the model back successfully. If something doesn't work, please let us know what it is and provide repro steps if possible.
sqlReport Builder, limiting the Dimensions
Hi,
I created a report model based over the cube. The problme is, it retrieves all dimensions from the cube regardless those are checked or not even in the prespective.
It does work with Measure but not with Dimensions.
Appreciate if some one can drop a line here and help me out.
Thank you
Imran
You need to make manual changes to the model for this to happen.
1. Create a new Report Builder project.
2. Save the auto-generated SMDL file from Report Manager.
3. Add it to the Report Builder project.
4. Open the model in the Model Designer and select the root Model node.
5. On the right pane, right-click on the perspective desired and choose Edit.
6. In the Edit Perspective dialog box, unselect all dimensions that you don't need.
7. When you are done, go back to the Report Manager and update the model (click the Update button).
HTH
|||The model is generated from the cube... It is not over the relational database where I can create and edit prepectives.
Imran
|||I understand your scenario. You can still make manual changes to a model generated from UDM by following the steps in my previous post.
|||Ok...
I limit the Dimension as you mentioned but now I cann't generate the report... The reason is, somehow all the Dimensions need to be selected in the Model...else it is not going to work.... Updating the Model back to original state rectify the problem.
Any help?
Thank You
Imran
|||Can you provide repro steps with the AdventureWorks cube and include a report definition of a Report Builder report that cannot be generated?
|||Report Builder models generated against an Analysis Services cube cannot be edited using Model Designer. Also, modifying the report-model (.smdl) file directly is not supported.
Source: http://msdn2.microsoft.com/en-us/library/aa964121.aspx
Even if try to modify the report builder model using other way, we canot get the achieved results.
--Imran
|||I am well aware of the Report Builder-SSAS limitations and the fact that the modifying the report-model is not supported. However, when nothing else helps you don't have much choice unless you take the unsupported road, do you? You should be able to open the smdl file in a Report Builder project, make the changes I mentioned, and update the model back successfully. If something doesn't work, please let us know what it is and provide repro steps if possible.
Wednesday, March 21, 2012
Report Builder, Getting Started Pane: OK greyed out
Hi all,
I'm working on a new SSRS implementation, and have created a Report Model against an SSAS database. I launced Report Builder and can see and select the model in the list, but the OK button at the bottom of the pane is greyed out so I'm unable to actually start building a report against it. Any ideas on what I need to change to make the button work? I have already verified that I have full access to the data source as well as the model, in addition to the underlying SSAS DB, so I don't believe it is a permissions issue... But I'm certainly open to any suggestions.
Thanks!
You are probably running into this (from http://support.microsoft.com/kb/899825):
In Report Builder, when you select a report model that was generated from an Analysis Services cube, you must select a perspective that is contained within the model. You must not select the top-level model itself. If your report contains items that are not within a single perspective, an error may occur when you try to render the report.
Brian
Report Builder Query Timeout?
Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.
Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.
This feature is under consideration for the next release.
|||I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:
An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]
This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?
Any information would be great!
|||I am getting the same error message.
"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
How can I resolve this timeout issue?
|||"You can specify a query timeout in Report Designer"How?
|||
I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?
Report Builder Query Timeout?
Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.
Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.
This feature is under consideration for the next release.
|||I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:
An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]
This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?
Any information would be great!
|||I am getting the same error message.
"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
How can I resolve this timeout issue?
|||"You can specify a query timeout in Report Designer"How?
|||I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?
Report Builder Query Timeout?
Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.
Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.
This feature is under consideration for the next release.
|||I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:
An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]
This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?
Any information would be great!
|||I am getting the same error message.
"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
How can I resolve this timeout issue?
|||"You can specify a query timeout in Report Designer"How?
|||
I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?
Report Builder Query Timeout?
Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.
Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.
This feature is under consideration for the next release.
|||I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:
An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]
This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?
Any information would be great!
|||I am getting the same error message.
"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
How can I resolve this timeout issue?
|||"You can specify a query timeout in Report Designer"How?
|||
I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?
Report Builder Query Timeout?
Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.
Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.
This feature is under consideration for the next release.
|||I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:
An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]
This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?
Any information would be great!
|||I am getting the same error message.
"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
How can I resolve this timeout issue?
|||"You can specify a query timeout in Report Designer"How?
|||
I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?sql
Report Builder Query
Hi Experts,
I have a report model on top of a cube. I have a calculated metrics called Policy Count and different amounts in cube.
When i try to create report in report builder with Policy count, amounts and different dimensional attributes it doesnt work.
The problem is report builder allows me to select either Policy count in the report or the amount field.
Have anyone faced this problem.
The same report works in cube browser.
Regards'
Neeraj
Make sure your calculated and non-calculated measures are housed in the same measure group folder. To move the calcualted measure to a measure group's folder, go to the Calculations tab in the Cube Designer. There is a Properties button in the toolbar which will allow you to choose the calculated member and which measure group to associate it with. (Don't set the display folder.) Deploy your cube and rebuild your Report Model off the DSV.
B.
Report Builder Query
Hi Experts,
I have a report model on top of a cube. I have a calculated metrics called Policy Count and different amounts in cube.
When i try to create report in report builder with Policy count, amounts and different dimensional attributes it doesnt work.
The problem is report builder allows me to select either Policy count in the report or the amount field.
Have anyone faced this problem.
The same report works in cube browser.
Regards'
Neeraj
Make sure your calculated and non-calculated measures are housed in the same measure group folder. To move the calcualted measure to a measure group's folder, go to the Calculations tab in the Cube Designer. There is a Properties button in the toolbar which will allow you to choose the calculated member and which measure group to associate it with. (Don't set the display folder.) Deploy your cube and rebuild your Report Model off the DSV.
B.
Report Builder Processing Error
Am having a problem processing reports using Report Builder. Have created the Data Source, DSV and Report Model and deployed them (following Report Builder walkthrough instructions in BOL). Building the report through the Report Builder app is also no problem. However when I try and process the report I always get the same error:
Report Execution Error Keyword not supported: 'provider'.
The Report might not be valid or the server could not process the data
-
Cannot create a connection to data source 'dataSource'. (rsErrorOpeningConnection)
-
An error has occurred during report processing. (rsProcessingAborted)
Have tried building reports using several different models off several different DBs with the same results. Has anyone else seen the same?
I know that in the April CTP Report Builder was not fully functional. Just want to know if this is just a CTP glitch or something I am missing. Either way I am very impressed with what RB is going to offer the ad-hoc reporting world. Really happy that MS will be including it with Standard as well as Enterprise.
Cheers,Please ignore - my fault! Error was being thrown because I used '.' as the server name (lazy way of saying localhost) in my data source.
Everything worked as soon as I typed the full name of the server and redeployed all objects.
Apologies for time wasting.
Cheers,sql
Report Builder page header
title to the report, but it doesn't repeat on subsequent pages. How can I get
it (or something) to repeat at the top of every page?
Thanks
VernI have the exact same question. If anyone could point me in the direction of
the answer in this newsgroup it would be greatly appreciated.
"Vern Rabe" wrote:
> SSRS 2005. When I create a report in Report Builder from a model, I can add a
> title to the report, but it doesn't repeat on subsequent pages. How can I get
> it (or something) to repeat at the top of every page?
> Thanks
> Vern