I have created some reports using Report Builder however they autorun with default values when selected in report manager, cant think many people would want this to happen. Is there a way of getting rid of the default values in RB or preventing auto execute in RM?
View 1 RepliesHi all, when i create a reports deploy on the Report server, i usually choose a filter prompted on Run. The lsit containt for example the list of my customers, but the list in empty like i want (like that, user can put a list from excel by copy-paste). But ... , if the want all the customers, what is the " * " operator to select all my records ?
Thanks for help
Erwan, France
Hey
I've got a few questions regarding prompts on the Report builder
Can I change caption of the prompt? I intend to let the users know what kind of prompt that is, if the date they're choosing is a upper limit or a lower limit
How can I create a Between date prompt? I tried using the From..To but it disabled my option to tranform the Filter into a prompt, and from some reason it didn't let me execute report which had After and Before prompts on the same date field (tried it as some sort of work around)
I tried adding fields from a 3rd level table using the report builder, I.E, I drilled down to the 3rd connected table and I was unable to add fields ... any thoughts?
Thanks!
Ron
In Report Builder, can you link prompt/filter fields to one another? For instance, I have Users and Groups and I want to dynamically fill the dropdown for Users based on the Group(s) chosen in the group prompt/filter. Or show the hierarchy as a expanding tree list for navigating the hierarchy to choose the user/groups to report on.
Another example would be product category & subcategory in adventure works.
And just to throw in a wrench, one of the areas I want to do this has 4 levels to the hierarchy.
Thanks for the help,
Toni
I'm a very basic user to VSS 2005 and I've created a simple report to display our customer master table. The problem is that we have 1000's of customers, but the report must scroll page by page.
I'd like to prompt the user with:
"Customer code starts with:"
Can you tell me how to do this using the field:
=Fields!custnmbr.Value
Here is one scenario. There is Department X which has subdepartments A,B,C,D. A has 5 members and B has some 7 products, C 5 members and D has some 12 members. My problem is I need create a Report model where is if we select X
all the list of subdepartments and their members should be displayed. I.e if we select X then
A
1
2
3
4
5
B
1
2
3
4
5
C and so on..........every thing should be displayed that are under department, i.e subdepartments under that department and the members under each subdepartment of that Department.
The problem here is all those departments and subdepartments are in same table which has columns like,
"DeptId" and "Dept Reporting to" and "EmplID.
When we select "Dept Reporting to" = X, we need to get the result as I specified above
Can anyone please help me out to create a Report Model to generate ad hoc reports
Hi!
We have a "folder hiriarchy" in reporting services with permission for different users to only create reports in their own folder. However, it would be nice if they (in report builder) could open eachothers reports, modify them and then save them in theri own folder. In this case, if they find a useful report that someone else has created, they could just make their own small modifications and save it in their own folder.
The problem is that I cant't seem to find a securitysetting that allow this. Either they can create/modify/delete the reports in a "folder" or they can't even open them in report builder...
Is there a solution to my problem?
regards Andreas
Hello -
I know that you can build a Report Designer report and add URL navigation from a field. I am trying to figure out how to do this with report BUILDER. I haven't been able to do it using the UI and editing the RDL directly to match what I see in a similar report Designer report is being ignored (if I did it right).
I can put the URL into the DSV & Model as a field/attribute, but displaying the a field with a URL in it doesn't make it "clickable".
Does anyone have a trick for this? Or know that there is definately no way to do it?
Thanks in advance,
Toni Fielder
I have a development server setup with Report Builder that our users have been testing out. They have a number of reports that they have created on this dev server.
We now have our live environment all setup and I'd like to move their Report Builder reports to the new server for them so they don't have to recreate them.
Is this possible? If so, how?
Thanks.
I have a very simple report model with two tables in it but having millions of rows.
I have developed a report on this report model, which will return atleast half million rows.
I have published this report to report server and trying to access the report through the report manager. It never returns the result. Fails with tme out expired error. I have 64 bit machine and 2 GB RAM. The report is expected to return atleast 500 MB data. As per the SSRS documentation it the memory should be three times to process the report. It does not work.
If I develop the same report using the report designer, I get the results returnd within a minute.
If I use the above mentioned Report Model as my data source, again I get the results within less than minute.
So what is it the report builder report is doing additional? It is strange that the same report model when used as data source returns the same number of rows within less than minute and the report developed and uploaded to report manager using report builder fails with time out expired error?
What is that the Report builder doing internally? Can I change some configuration for report builder report to work for large reports? I have already changed the memory settings in the report config and machine config files.
Your early response is appreciated.
Virendra
Hi.
I get a problem when I want to preview a report in Report Builder. I just launch Report Builder by the url [1] (RS is on a server, and I work on a laptop). Then I choose a model and create a simple report. When I press "Run Report", I get an error message saying: "The permissions granted to user 'mydomainmyusername' are insufficient for performing this operation. (rsAccessDenied)". But my user are assigned to content manager...
If I then save the report to the Report Server, I can access the report through e.g. the Report Manager without any problems.
Why doesn't the preview functionality work for me? Are there some settings I need to set, or is it a bug in Report Builder?
Regards, Tomsi
[1] http://<servername>/reportserver/reportbuilder/reportbuilderlocalintranet.application
Is it possible to create cascading parameters with in Report Builder? I have done this with Report Designer but i need a solution with Report Builder.
(I need the structure: First the user selects the state, afer the postpack the cirties of the state are listed in another dropdownlist for selection).
Thanks in advance
Hello everyone,
I've come across an unusual error on some of our machines. I'm trying to track down why only certain ones will give an error. I thought it might have something to do with .NET 2.0 not being installed, but I assume that they wouldn't even be able to launch Report Builder if this is the case. I'm at the point now where I've been told these machines have .NET 2.0. I plan on trying to verify soon, but I thought I'd get everyone's opinion on what it could be.
With even the simplist report (just 1 field dragged onto the report) the following error appears: "Report execution error The report might not be valid or the server could not process the data." When I clicked on the details, the following appears: "The numeric portion of 0pt cannot be parsed as a unit of type Point. ----- The type initializer for 'Microsoft.ReportingServices.Design.Constants' threw an exception."
This model was created with Business Intelligence Development Studio and we're using SQL 2005 Enterprise.
Anyone have any thoughts on what this could be or how I can better troubleshoot it?
Thanks,
Dan
Hi,
I need to create letter type reports using the report builder, is this possible?. I am trying to create a letter that embeds some variable fields, i.e,. name, address, contact number. I can't seem to find a way to create page headers, and embed report data fields within text. Is this not possible within the report builder? it seems that the only thing you can do within the report builder is add fields to their predesignated areas. I am being forced to use the report builder instead of the report designer in order to give the end user the ability to make modifications to the report/letter. This is very frustrating. not being able to allow the user to edit report designer files, and then having force them to use report builder which doesn't seem to support some simple features..
Any suggestions would be appreciated...
Hi,
I have environment that use SSRS 2005 ad hoc reporting.
One of the users (out of 200) is unable to open or save reports in the report builder.
the user succeed to open the report builder, when he try to save report that he build from shema he get error. as well when he try to open an existing report that build in the report builder he also get an error,
On open the error is:
The numeric portion of 2pt cannot be parsed as a unit of the type point.
The Initilizer for 'Microsoft.ReportingServices.Design.Constants' threw an exception
On Save the error is:
System.IO.StreamReader: Deserialization failed: The type initializer for 'Microsoft.ReportingServices.Design.Constants' threw an exception. Line 2, position 2
Please note that I succeed with second user to create ad hoc report on the first user
computer. I also failed to with the first user to create ad hoc on another computer.
It seems like permissions issue
Thanks,
Assaf
I've created a Report Builder Column chart with months as the x-axis
(category) and revenue as the y-axis (value). This correctly displays
the revenue for each month, but I'd like to display a running total of
the revenue for the year.
I'm currently displaying:
Jan $2
Feb $1
Mar $4
I want to display:
Jan $2
Feb $3
Mar $7
I know this is possibly using the RunningTotal formula in Reporting
Services, but I'd like to do this in Report Builder so the users can
change and create their own graphs with running totals. Is there a way to do this in Report Builder?
Thanks.
Hello - I am having difficulty enabling the automatic click-through functionality for my model. I have two entities - Customer & Incident. Incident is a role/FK/OptionalMany relationship to customer.
I've read through earlier postings on this subject (below) and have verified that the #Incidents attribute in my incident entity has the EnableDrillThrough=true.
My test report is simple - Customer Name (from customer) and #Incidents (from incident). When I run it, the click-through option is not available (the cursor stays as an arrow and doesn't change to a finger).
Are there other properties or settings that I need to be working with? I have SP2 (9.0.3042) installed on our Standard edition of SQL 2005. I know Infinite Click-Through is not in Std edition, but a few levels should be, correct?
Thanks in Advance,
Toni
Other related postings -
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1260819&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=657279&SiteID=1
I am using Report Builder 3.0 and i have report which has a drill down group. The report opens in a collapsed form.This report has interactive sorting on a column. But,when we drill down and sort the column, the group collapses and the details disappear.
In some posts, i have seen that instead of interactive sorting, people recommended a parameter. But i have to do interactive sorting only.
Hi all,
I'm trying to get empty cells from an OLAP cube to display in a report designed using the Report Builder. Of the three report types, only the Table report shows the empty cells. Is there any option/setting that I need to enable to get this to work for the Matrix or Chart reports? Something like the "Show Empty Cells" option that is available in the pivot table used by BI Dev Studio?
Any help appreciated.
Hi
Does any body know that creating free form rports using Report Builder is possible?
Free-form report - in the sense - that user should be able to drag the fields from the leftside fields pane and drop on body as we do in report designer using BI studio.
I could not figure out a way to do so. Is this a limitation?
Thanks
Raj Yennam
I cannot figure out how to display the 'Report Builder' icon in the toolbar for a user.
I've tried setting the different security roles, but the icon doesn't display.
Thanks.
I run these stored procedure to build the report and I am able successfully to build the report but I need some prompts to in the report to get the specific data .
ALTER
PROCEDURE [dbo].[Sharepoint_Ticket_Report]
@StartDate
DATETIME,
@EndDate
[Code] ....
And for prompts how to create created_by and message_type dropdowns as shown in picture.
Dear all specialists,
I am encountering a situation that the report buider feature cannot be shown on other user login. Would you guide me to solve this issue ?
Thanks for your help
Gary Ho
In a typical Database, there are tables, views, stored Procedures, user Defined Functions.
We could use tables and views in designing the Report Model.
We cannot use Stored Procedures, I tried that.
Please could somebody tell me if we could use User Defined Functions?
What if a view is already using a user defined function, is the function automatically includid in the Model Design?
Thank you,
Where can I find a comparison between the report builder and designer? I would like to implement an end-user solution and as part of the exploration process I failed to completely understand the capabilities and disadvantages in each of the modules (I€™m talking about the end-users functionality for the given reports €“ not for the designer€™s usability of any sort)
Thanks
Ron
I have a new setup of report server. I have deployed three reports that I have also scheduled to run and save as an Excel spreadsheet to a network locations. The reports do not run and I get the error message below. Does anyone have any ideas? Anyone run into this issue before
ReportingServicesService!dbpolling!10!02/29/2008-17:29:07:: i INFO: NotificationPolling finished processing item 33d62282-2a03-483c-bd47-f41ec78c01d5
ReportingServicesService!library!4!02/29/2008-17:29:07:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., AuthzInitializeContextFromSid: Win32 error: 110;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.
ReportingServicesService!library!4!02/29/2008-17:29:07:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!subscription!4!02/29/2008-17:29:07:: i INFO: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The report server has encountered a configuration error. See the report server log files for more information. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.
at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper, String reportPath)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
I am trying to develop a data model that will filter data based on the user logged in. SUSER_SNAME()
I have a list of User Id's in a look up table, a where clause in a view that filters the data based on who is logged in. This works fine and the data even seems to be filtered when I explore the data in the Data Source View. How ever when I publish the data model to the reporting services site and use report builder the user logged in is no longer recognized. All I am really trying to do is set up report builder so that users can generate reports and only have access to thier data via a customer number. I just can't allow users to see other users data and I don't want to set up a different datasource view for each user. Does any one have any experience with this?
We are useing merge replication with MSSQL Server 2000 for our two location, we have more than 6 database in replication on has issue following error and few time not updated data due to this error -
The process is running and is waiting for a response from one of the backend CONNECTION
With regards
R.MAll
Hi,
When i select datasource in Report Builder, i am able to see all the available DataSources.
Eg: I have selected one datasource from the list and which has 3 tables(table1, table2, table3) associated to that datasource.
when i drag and drop table1 fields to report, i am not able to see the other 2 tables(table2 & table3)
Is there any property or relationship do i need to maintain?
Thanks,
SR.
Hello,
Does anyone know how to pass the userid (domainaccount) of the person runnig the report to the proc underneath. With asp.net calling Crystal Reports, this was simple.
Jeremy
Hi anyone:
I'm actually developing a report with some dates on it. I want that when I run this report, a prompt (a window) appears requesting a date (or at least it could be good if a list appears and I can select one of them). Do you have any idea about how can I do that?.
Thanks in advance,
Pat
Hi,
When I call certain reports from an ASP application, some prompt for password and some are not.
I wonder why is this happen?
Under the Directory Security of Reports under IIS 6, I already enable Anonymous Access for IUSR_XXXX with the correct password.
I also assign IUSR_XXXX as Browser in Report Manager of Reporting Services.
The enviroment is Windows Server 2003 standard edition, IIS 6, SQL Server 2005.
Thanks in advance.
Best regards,
Pop
How to run a DTS job from command prompt? Any help is appreciated!
Thanks.