Hi, How I can create an index in a report which are referencing bookmarks in the report? I would like to have this format: [Name / Title of bookmark] [Page Number] .... [Name / Title of bookmark] [Page Number] Can I get the page numer with an expression? Thanks ...more >>

I'm having problems getting external images to show up in a report. As suggested in other posts in this group - the resource is linked to a fully qualified server name. The reporting services is locked down to authenticated users. The image url is to the same server and I've tried settin...more >>

How do I set it up so that people who are inside my local network, but outside my domain to get access to my reports. Any thoughts would be great Jeff...more >>

Hey guys, I would like to determine the network id of the current user so that I can pass that value to a stored procedure that the report references. I tried add the following code in the Code tab of the Report Properties tab: Function GetUserID() AS String Return System.Environmen...more >>

I cannot get this error resolve either for myself or any users, and I'm actually part of the Admin group! Furthermore, a user with whom I'm tring allow to view this report keeps getting prompted for their windows username and password. I thought that since this datasource was set to Windows Au...more >>

Hi, Which is the best way to insert a document (Word, PowerPoint, PDF) into a report, which is also rendered with the masn report? Writing a custom report item? Rendering as image? But how to do a page break? Is there a commercial solution available? I'm using SSRS 2005. Thanks Eric...more >>

All, Hello. Our development team has created a webservice which sends parameters to our report server to generate a report, grabs the data, creates a bitstream out of that data and sends it to IE in a .pdf format report. Now they are asking me if there is a way they can cache & archive th...more >>

I’m adding a Report Parameters to a report and getting duplicate entries in the drop down. So I thought I could create a new dataset with an expression that would only return the value without duplicates. I can’t seem to get that to work. I’ve tried distinct but it returns saying I’...more >>

Hi, In one of my reports I have some fields that are currency fields displayed with the currency format string (C). However, when I export these to Excel (2003) I get the little yellow warning that says Number stored as text. And if I try to do a sum by dragging across the cells and click...more >>

When I try to pass multiple values to a parameter in my dataset, I'm getting this error: Syntax error converting the nvarchar value '474 Or 347' to a column of data type int. Any ideas? ...more >>

Hi, I'm actually trying to build security filters in a report model, but i'm facing problems with the GetUserId function. For example: I create a new attribute in my model and give him the GETUSERID() value. If I display this attribute in the report builder, its value is always empty (in...more >>

1. i am using a sample and trying to add a data. I can do that fine, but the buttons SQL, diagram, verify sql all disapear on the new dataset. I would like to verify sql. What affects their inclusion? 2. In a matrix or table, Is there any property setting or someplace that shows what groupings ...more >>

I've been banging my head for a view days on this and I'm ready for a little humility. :) Here is the simplified recordset: Field1 Field2 Field3 Field4 AAAAA 11111 bat1 3 AAAAA 11111 bat2 4 AAAAA 22222 bat1 0 AAAAA 22222 bat2 ...more >>

I have two questions. Both of my questions are based on my experiences briefly using RS2000. First, has RS2005 managed to fix the problem with returning large (average 50K) records without eating up all the server resources or even crashing the server. This happened when I was using RS2000 ...more >>

Hi post, I have created a simple report using VS.net with an embeded image. when I open the report from my PC the image displays well not a problem.Also for any users this works fine. My PC name is "Personal1" Report server exists on Server: "Server1" url used to access this Report is http:...more >>

Hi, I'm building a report for a client (in SSRS 2000), where I am experiencing the fact that the output on the screen (ie, what is rendered by Report Manager) is very different from the print output (or export output, for that matter). I am using a list, with a couple of tables (with fixed ...more >>

I want to give the ability to my customers to design the reports, without installing Vs2005 to use its designer, since they are not developers... Is there some tool that allows me to design rdlc outside of Vs2005 ide? Thanks in advance. ...more >>

Hi, We get an "Logon Failed" message when running subscriptions; ReportServer service runs using an domain account. Domain account has run-as-a-service, logon-locally and "impersonate a client after authentication" and the apprioriate database rights. What is the "required privilege" (s...more >>

Hi, Everytime we print any report with empty dataset using printing to Excel format RS crashes. This is however not a problem with RS (SP1). Any idea on how to revert back to SP1 or any hot fixes that would overcome this would be greatly appreciated. ...more >>