I am a member of all the roles (Browser, Content Manager, My Reports, Publisher, Report Builder). If I login with a Local Administrator account, I can see and use it fine. Any ideas? ...
I'm looking into the idea of rolling out the web-based SSRS Report Builder to our end users to allow them to create their own reports against our production application databases. From what I have seen so far, this tool is easier to use than the VS Biz Intel Studio report designer, plus it is easier to install, and deploying the reports...
I'm looking for a graphically oriented D&D type tool/utility that can be used to build ad hoc reports from data contained in XML data files. The users are technical, but not developers -- so XSLT is right out... Eclipse' BIRT does this kind of thing, but something more lightweight is preferred. ...
I'm starting to look into SSRS Report Builder 2.0, and I see in the documentation that it supports connections to SQL 2005. Does anyone know if the reports made against SQL 2005 can then be upload to the SSRS 2005 website and ran from the site? Or, can they only be run from the SSRS 2008 website if they were generated in Report Builder...
Hi, I'm looking at the report builder from 2005. I know I can prompt a filter so the user can filter the data themselves. But what if they don't want that? how can I set the filter optional. so either they see everything or they use the filter. Now I only can have a filtered report. ...
Hi, I am creating a Report Model Project in Visual Studio 2005. In the data source view, I am adding the entities that represent subsets of the data of my tables. For some tables, there is a 1-many relationship. For example, Entity A has a Primary Key of A_ID, and links to Entity B through this field which is present in both A and B. F...
I currently have a query that looks like this: SELECT NON EMPTY ([Measures].[TOTAL]) ON 0, NON EMPTY (([ENROLL DATE].[CALENDAR].[YEAR].[" + Parameters!EnrollDate.Value + "] * [DIM ENROLLMENT].[ENROLLMENT].[ENROLLMENT PROG].ALLMEMBERS)) ON 1 FROM (SELECT (([DIM ENROLLMENT].[ENROLLMENT].[TERMINATION REASON].[Still Enrolled])) ON 0...
Using ReportBuilder 7.X Question Is it possible to Control Print to File. I need to change the Length of a field at print time Example: label2 In the setup - I set its length to 800 which is the max possible this field should ever be. However, in many cases the record is less than that and i need to set it to the calculated size be...
Is there a way using ReportBuilder to set the size of a report such that there will be no scrollbars displayed in the Report Viewer Web Part for a smallish report? ...
We have a need to be able to dynamically change the Data source for a report built/managed in Report Builder. Basically its the same DB structure but each client has their own DB so depending on the parameter for the ClientID it needs to dynamically go to the appropriate DB. Anybody have any good solutions for this? Thanks in advance,...
I've got a Delphi 2007 VM which includes a reasonably up-to-date Report Builder and Dev Express Suite. I use it for a particular project for a particular client. For that same client, I also have a D5 VM which just so happens to use a (different, older) version of Report Builder and a different (older) version of some of the Dev Express...
I have a report that has parameters StartDate and EndDate. I would like the EndDate parameter's time part to default to the end of the day when selected from the drop down. For instance, if a user selects 5/15/2008 from the dropdown, the value shown in the box should be '5/15/2008 23:59:59' not '5/15/2008 12:00:00' Its pretty easy to d...
I have two saved shared data sources that are virtually identical but have different names and have been deployed to the report server at different times. They both live in the DataSources folder on the report server and I have rights assigned at the folder level. One is named PDB and one PDB2. They both use the same SQL Server account...
Working on Reporting Services 2008 on .rdl files. I have the choice to work with VisualStudio2008 or the application "Report Builder" ? Do they provide same fonctionnalities ? Can I switch from one to other without any issue ? What application do you prefer ? Thanks ...
Hi All, I cannot get my dataset to recognise a parameter supplied to it. I have created a report parameter "ProjectID". (In Report Parameter Properties, Name="ProjectID", Prompt="ProjectID"). In Dataset Properties|Parameters, Parameter Name="ID", Parameter Value="[@ProjectID]". When I click on the Filter button in Query Designer, th...
I'm trying to change the default page size, margins and grid spacing for new reports in Report Builder 1.0. The defaults are American (i.e. Letter paper size and Inches). I need to change this to UK (A4, cm). In the VS2005 report designer this can be done by modifying report.rdl in C:\Program Files\Microsoft Visual Studio 8\Common7\...
In report Builder 2.0 when i attempt to display on the report a parameter that has the parameter property "Allow Multiple Values" checked it displays "#Error". Displaying a parameter that does not have this checked (ie. can have only a single value) works OK. Has anyone done this? ...
Has anyone ever successfully gotten forms authentication to work with report builder? I have a client who wants to use report builder outside my company's domain. Would forms authentication work for this? ...
I'm trying to show a tablix of data where the result of a sum changes in each row. I have the rows grouped by date and sorted in descending order such that the most recent date is first. What I want to do is compare each row's sum with the sum of the previous row, e.g. Date Sum PrevValue ---------- --- -------------- 2009-09...
Hello, we are currently using SQL Server Reporting Services and we would like to use Report Builder so our customers can create reports themselves. I have created a User on the server. I have added this user to the SQLServerMSSQLUser and SQLServerReportServerUser groups. I have given this User db_datareader access to the required databas...