Hi, Does Microsoft Provide Certification in RS.Where do i find the information for the same. Thanks,...more >>

Dear all, Several general questions: 1.) Does Report Manager support I.E.6 only (how about 5.5, or 5.0) 2.) Does Report Manager support Netscape? 3.) Reports are only show on browser? Since Crystal Report .Net can embed the report into windows application through crystalreportviewer, does ...more >>

I want to Concatenate multiple rows into one string to show on the report. Can someone help plz. ...more >>

All of a sudden I am having problems with cascading parameters. This report, under development, was working fine earlier in the week. I've started over and each time I get the same problem. I've been working with cascding parameters for some time and nver seen this. I've tried everything but...more >>

I have a report that requires the use of cursors within a function because we don't have control over the design of the database. So, the datasource for the report is as follows: 1. Report calls a Stored Proc 2. Stored Proc runs this statement: Select.... dbo.Function()... 3. Inside the Funct...more >>

I'm looking to display a list of records with 2 per row. Record1 Record2 Record3 Record4 What's the best way to do this?...more >>

Hi, I have a report that has two drill downs that drill to about 5000 records and due to this I am having time out problems while exporting to excel. For now, we have worked around the timeout problem but what I would like to know is whether or not there is a way to disable the excel option...more >>

I am experiencing a problem when we are rendering a large report in Excel format, I get the following error thrown by the ExcelRenderer: Number of rows in the excel sheet exceeded the limit of 65536 rows. Has anyone seen this issue? I searched this forum and the SP2 docs. Thanks, Mike...more >>

Sorriy if this shows up twice. I posted it already but didn't see in the list. I have some customers that are experiencing the text displaying somewhat broken up on a report with a chart in it on an aspx page. If I right click on the report on the page the properties show the chart is in PNG...more >>

We have some customers that are seeing some characters displayed kind of broken up on a chart displayed on an aspx page. They can make out what the text says but we would like stop that. If you right click on the chart on the aspx page and look at properties, the type is a PNG format. I was t...more >>

I know when you render a report as html you lose the report interactivity, but I recently saw a web cast where they had a code example that allowed you to get and control the pages being displayed. They said the code was available in the spring 2005 MSDN Events CD. However I haven't been abl...more >>

I've got a textbox bound to a text sql server field that contains about four paragraphs of information. When I export to pdf the page breaks don't work correctly. It starts a new page unless the entire contents of the field will fit on the existing page. I would like it to fit what it can o...more >>

I am using an embedded image of a signature on my report. It is a small ..jpg. When I run and print the report, everything is ok. When I try to export it to pdf, the report stops rendering the report when it gets to the image. I am using Adobe v.7. I tried this using Adobe v.5 and the wh...more >>

Hello, We are starting to explore Reporting Services, and I have a question on report delivery. I know normally reports would be created, say in VS .NET, and then published to the report server. From there, users can open the browser-based Report Manger to view them. I was wanting t...more >>

Help! I'm trying to figure out how to change the values on the properties control box dynamically. Things such as Hidden, size, font. With the RS format of <name>!<fieldname>.Value, how are such things called? Example code (which doesn't work because of compile problems: =iif(Fields!T...more >>

Hi, I have a solution using owc (2000) and now we have to support printing owc pivottables. Printing from browser had not been useful and we've tried to show a sql report instead of a OWC component. So we could print it directly. But I've not been able to show the reports with minimum interact...more >>

I have a table with a few columns in my report and I would like to make some of the rows show up in bold in the report if the value in one of the column is within a particular range. Can I do this using Expressions. If so, can someone post a sample expression or let me know if there is another...more >>

Hello Is it possible to disable pagination? I use the reportviewer component but i want to see all my data on one page and i don't use drilldowns? If you can disable it how do you do that? grtz ...more >>

I have a report I'm working on (data dictionary) where the team wants to be able to do the following: 1) Choose "All Tables" and get a report listing all tables with each tables column names & properties underneath the proper table (ie, the columnName param would be greyed out if this is ch...more >>

Hi, In my reports i usually have 1 tabel. Now, when i run my report, all of my data (wich can be quite large) is spread out over serveral pages (you can see on top 'page 1 of 15' eg). Is there a way i can put everything on one page (so i get page 1 of 1). It doens't matter that it's not ove...more >>

Hi, we have upgraded to SP2 of reporting services and have found the printing to be working well and a couple of the other issues that we were waiting on have been fixed aswell. I only have one other problem now that is preventing us from rolling out reporting services to our users - Linked r...more >>

How can I stop word wrap happening? If the data is too big for the column then I want it truncated. Any ideas?...more >>

1.Is there any way to reomove Reporting services help icon from the HTML Viewer toolbar ?? (Actaully i am calling reports inside an ASP Page ... Inside the report i am displaying HTML viewer toolbar .. I want to remove Reporting Service help icon from the HTML Viewer ToolBar) I am usi...more >>

I'd like the user to decide how to group the report. For this I have the parameter KStar and a piece of custom code. Under 'Edit group' I use the expression: =Code.GetGroups(Parameters!KStar.Value ) In the code window I have a function that starts like this: Public Shared Function GetGroup...more >>

I have two parameters for my report, one for choosing column to sort and the other for choosing direction(Ascending or Descending). In my tables property i use "=Fields(Parameters!MySortVariable.Value).Value" in Sort on: Expression. But how do I use my variable for direction? (I can't put an e...more >>

I use Dynamic Query: ="Select dbo.UserList.UserID FROM dbo.UserList WHERE dbo.UserList.IncidentID = " & Parameters!IncidentID.Value While I built the solution I had: The expression for the query ‘DataSource2’ contains an error: [BC30648] String constants must end with a double quote. ...more >>

I have a report that allows the user to select which columns they want to see on the report. The other columns are hidden. However, when I render to PDF, although the columns are collapsed the overall width of the report remains as though all columns were shown. I had hoped SP2 would correc...more >>

Hi, Anyone knows where to download the above? The kb article doesn't have a link to download it. -- Best Regards, Kit Kai MVP (asp.net) SgDotNet Council Member Visit Us @ http://www.sgdotnet.org My Blog: http://community.sgdotnet.org/blogs/kitkai ...more >>