Hi Do any one have idea on how to change the chart type in Reporting Services. I'm new to SQL server RS. So if you have any code snippet, please send. It will very help full for me. Thanks and regards Santhamurthy ...more >>

Hello, Am new to reporting services and having problems passing parameters. I am using ASP.Net with .NetFramework 1.1 and am trying out reporting services 2005. I am using an object of the ReportExecutionService along with the render method. I have tried a few differnet examples a...more >>

I need a way to print multiple reports without selecting each report. These reports could have a common parameter to be applied to all reports. -- Thanks for your help...more >>

Hi all, Does anyone have any thoughts on hard coding values into a result set displayed in a grid? I have a dataset that I've built a bunch of grids from in RS 2005. One of the reports I need to create always needs to have all of the months of 2006 displayed regardless of whether there's data. ...more >>

Hi,all I have a datetime parameter, I use calendar to select value,but I want to format it as "yyyy-MM" Any suggest?Can I use expression,how to ? Kevin Chu...more >>

It's along story, but I will try make it as short as I can. RS is installed on the same server with the WebServer. I run this from a domain network PC: http://WebServerName/Reports/Pages/Folder.aspx and I receive this error: The request failed with HTTP status 401: Unauthorized. What I check...more >>

Hi all. I have that problem. I need to pass a parameter to a report. That parameter is a user in a windows domain, so I have the problem that is stored in "DOMAIN\USER" format, and I can't pass the backslash to the url. How can I solve that? -- Regards, Diego F. ...more >>

i am wondering if i have a sql 2000 report that host on the sql 2000 report server, the report viewer from visual studio.net 2005 cannot display the report, am i right? the only way to make it to work is to either upgrade to sql 2005 report server or to have the visual studio.net 2005 to ...more >>

Hi, Maybe this has been answered here but a question that has recently come up is how do we use Windows Auth and Forms Auth together? And maybe if that isn't possible, how can we publish from VS2005 with Forms Auth enabled? Seems the only way to do so is manually upload. It would be ni...more >>

Hi all, I have been working on this report for a while and I am lost. I am getting #'s correctly but I am getting too many part numbers. I was wondering, with a union all query if i can put the where clause on the outside of the union all statement like the order by clause? And if not does any...more >>

I have a text box and I would like the data to truncate if it doesn't fit in a single line. Right now it flows onto a second line. I have CanGrow and CanShrink both set to false. I don't see a property to set the box to single line. Is there a way to do this? ...more >>

I have created an SP that has 3 parameters. I would like to creat a report using this SP. in other reporting tools I have created the report and I had it call an SP instead of using a query. the reporting tools would alway add the paramters to the report and ask for the info. I can't seem ...more >>

I have a main report which is essentially a letter. When the letter is completed, I have a SubReport which are mailing labels. In the sub report I have 2 columns and in the main report I have 1 column. When I run the main report, I only get 1 column of Labels. When I run the subreport I get th...more >>

Right now we're displaying dates like this: 2/6/2006 We'd like to display them like this: 02/06/2006 Currently we have two types of dates we're dealing with. In the first case we have a datetime and we're doing this: =FormatDateTime(Code.GetStartDate(),vbShortDate) in the second we just ha...more >>

Hi! I have data on a report where I am subtotalling by Items on an invoice. So, my subtotal has the sum of all the invoices for that item. I also want to do a calculation that will calculate for each item (that is summarized) % of total sale for all items. Presently, my totals for all items ...more >>

ive created reports with input criteria (dates, text etc) I was wondering if its possible that you could use pre-populated dropdown lists instead? also how do i access my reports from a visual basic form ? cheers mark ...more >>

Hi, I would like to know how to pass ado.net dataset to reporting services 9. I´ve found this article http://msdn.microsoft.com/data/archive/default.aspx?pull=/library/en-us/dnsql2k/html/rsdsetex3.asp but, acording to the sumary, it does apply to "SQL 2000 - Reporting Services". Could a...more >>

Hi All, Can anyone tell me how i can list a batch of values across some columns and then down ? For example if my dataset was returing days of the week I would want to list them like this : Monday | Tuesday | Wednesday Thursday | Friday | Saturday Sunday I've asked this befo...more >>