Users must have permission to the Execute Report Definitions task (normally obtained via the System Users role) for the Report Builder button to be displayed. -----Original Message----- From: Jay@discussions.microsoft.com Posted At: Friday, October 21, 2005 4:01 PM Posted To: microsoft.publ...more >>

Hi, My HTML reports have this code line after every page: <DIV style="PAGE-BREAK-AFTER: always"><HR></DIV> I'm trying to get a HTML report without this page breaks. Anybody knows how? Thanks!!!...more >>

Anyone out there know how to bring in the global variable value for where the report was run from, whether it's the core report or a linked report? There already is a global variable for Report Folder but that displays where the core object sits so if you have a linked report sitting in a dif...more >>

I use asp.net page to view the reports. Some of my reports take parameters and I set them default to '%' as while cards. When a report link is clicked, the report is executed and rendered when the new page is open. Some of them returns really quite some records so it takes a while to have ...more >>

I'm trying to use an OLAP cube as my data source (built using SSAS 2005) The cube has a parent-child dimension and a fact table. I would like to display the parent-child data in a report . Does anyone know how to build an MDX query that would give me the ID and the ParentID from the dimension t...more >>

I have a table with hierarchical data where I am toggling the recursive items underneath. I am setting the initial Visibility setting for the details group based on the recursive level. My visibility expression looks like "=IIF(Level("PathName_Details_Group")=0,False,True)" and I have the Vi...more >>

Hi All, I have installed RS Webparts in my sharepoint site and I can view the list of reports in the Report Explorer part and when I click the selected report I can execute the report and see the report in Viewer Part. Now I need to Implement some security settings for the report. Say I hav...more >>

Hello, is it possible to center an image on a report (RS 2000)? regards Wim Kunz www.caesar.nl ...more >>

How to get SQL Reporting Services installed? I read a white paper about having IIS and ASP.net installed, but assuming I did that, where can I see the Reporting Services feature? -- TS...more >>

How do I add a date picker to my report for date range purposes? Thank you....more >>

I have a report grouped on the user. The report calculates various utilization totals based on the username. Some users have a Utilization = 100% for only 12 or 17 hours and other have a Utilization = 100% for 40 hours. At the group level, I can calculate the utilization with the followin...more >>

I have tried for an entire month attempting to create and align 3 columns in my report. Instead of having 5 pages of employee address information, I would like to have 2 pages by using columns or snaking the information. Could someone please help me on this issue? I am willing to pay for ...more >>

Is it possible to have SQL Server 2000 RS and SQL Server 2005 RS on the same machine? -- Regards <<<Bryan Avery>>>...more >>

Hello, I Have a dimension, which represents a certain potential. I've sorted the dimension , and created a calculated member which results of a sum from certain potentials. I am creating a report on which that dimension acts as rows. The problem is that I need the calculated member to show...more >>

I'd like to limit the number of rows in my detail section based on a parameter. For example, if I might have region and state as groups, and for each store I wanted to show the top 5 products (obviously different products in each store) by number sold. But it could be 10 instead of 5 depend...more >>

I have a badly designed database. The SKU consists of a style and colour. Both of those are variable length. There are some spaces between the 2. The colour always has a '-' preceeding it. I can use string functions to break it up for display no problem. However, I need to link to a table to g...more >>

Hi We having problems running our scheduled reports. A domain admin had originally scheduled them under her network username which as i said had domain admin rights. Those domain rights where taken away from her username and then we created a sql user name to run the report, since then ...more >>

Hi All, I have Reporting Services installed in my machine, when I want to Subscribe a report, when I go to Report Manager - and click - My Subscriptions I get this message. "There are no items to show in this view. Click Help for more information about this page." How do I ac...more >>

I have a report that has a detail section hidden until the user clicks the '+' sign to expand it and see the details. This has worked in the past and works in design view for this report, however when deployed to report manager and brought up in IE it will not expand. I have tried deleting the r...more >>

Hi all, I have two reports which when I push the view button does not show the report, I need push 2 times for view the report. When I open the report the first time It works fine, but when I change some parameter value I need push 2 times the butoon to update the details. Other reports wo...more >>

I select my own colour for each of the series of my graph. It render correctly in the VS preview. After deployment the colour of the graph is randomly selected per series. For a test I added a textbox with background colour one of my own colours (normal green) and that works perfectly. It i...more >>

Hi All, I want to set font style bold for particular word in a single statment within and single text box, means i've Textbox1 which contains "This is Test String" value. Now i want word "Test" in Bold effect. Is it possible in MRS ? -- Thanks & Regards Malkesh...more >>