Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


all groups > sql server reporting services > march 2006 > threads for thursday march 9

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

rsAccessDenied for authorised user.
Posted by s.bussing NO[at]SPAM symax.nl at 3/9/2006 10:53:16 PM
Hi, as many people in this group, I have the problem that some users cannot access the report we designed. They receive the message: The permissions granted to user '{domain}\{userID}' are insufficient for performing this operation. (rsAccessDenied) The strange thing here is that I granted ...more >>

Paging using Web Services
Posted by PVV at 3/9/2006 9:30:17 PM
We are developing a Web Application for which we have written a class to render reports that consumes web services provided by Reporting Services. We invoke "Render" method of web service for displaying report in aspx page. Paging is achieved using "Section" config of HTMLDeviceInfo passed t...more >>

Report Blank on Render?
Posted by Eric_H at 3/9/2006 4:01:33 PM
Hello Everyone, I have a Sql Server report which, when there is no data returned in the dataset, goes entirelyt blank. Static text is wiped out, no page header, nothing, just a blank screen. How can I at least get my static text to stay there? Thanks. ...more >>

Empty DataSet Problem
Posted by Tom Bean at 3/9/2006 3:22:17 PM
I am having problems with a report that has subreports nested 2 deep. If the query for top level subreport returns an empty data set, a blank page with the message "An internal error occurred on the report server. See the error log for more details. (rsInternalError)" is displayed. If the ...more >>

hlp ... new with sub-report
Posted by MJT at 3/9/2006 1:50:27 PM
I dont like to use subreports and havent ... but now I have a legit need for one. I have a report which has to use 2 data sources but correlate them. There will be a summary table followed by detail for the summarized resource and then another table needs to follow that which is also contain...more >>

IIF Count
Posted by d4 at 3/9/2006 1:26:50 PM
Cannot get this to work, any suggestions? (Need to count where values are as below) =Count(iif(LCase(Fields!Exceptions.Value Like) "*center*" AND (LCase(Fields!Server.Value) Like "ser*" AND Fields!Production.Value = "1", 1, Nothing))) ...more >>

Invalid attempt to read when no data is present
Posted by GORAMS at 3/9/2006 12:31:27 PM
I am getting this error message when I go to run my report. I have another report that is almost identical and when there is no records to return it doesn't generate an error message. Anyone have any ideas? Thanks in advance....more >>

data driven subscription & User id
Posted by MJT at 3/9/2006 12:10:30 PM
I have a report that makes use of the global user id parameter. I was going to set it up as a data driven subscription but as long as I have that parameter in the report ... the option to schedule that report is not even allowed. Why is that?...more >>



Results on Data Tab
Posted by MJT at 3/9/2006 12:00:22 PM
How come sometimes I can select/copy the data results returned from running a query in the data tab and other times it will simply highlight the first cell and I see a circle with a line thru it if I move off that cell? I need to be able to save the result off as MRS pulls it so I can verify ...more >>

Report Builder
Posted by Kevin Antel at 3/9/2006 11:40:59 AM
What permissions do I need to give to a user in order to have access to the Report Builder component? ...more >>

SSRS 2005 Report Charts Look & Feel Boring!!!!!!
Posted by dba123 at 3/9/2006 11:34:19 AM
I need to extend the look & feel of the boring out of box palettes that the SSRS 2005 reports are using. Anyone know how I can do this? ...more >>

Change Text to a date
Posted by Jeanne Conde at 3/9/2006 11:30:14 AM
I have a text field that I need to display in a data format currently the text field is shown as this yyyymmdd I need to display it in a date format as mm/dd/yyyy I have tried just using the date format, but it is not recognized as a date. Any suggestions how to write an expression to manipul...more >>

External web service as datasource for Reporting Service report
Posted by ehausig NO[at]SPAM yahoo.com at 3/9/2006 11:18:53 AM
Hello, I would like to make some Reporting Services reports from a datasource that is a web service. Is this possible? I am using SSRS 2005. Any suggestions or directions would be greatly appreciated. photogulliver ...more >>

Filtering Dataset based on Row of Previous/Parent Dataset
Posted by Chris Taylor at 3/9/2006 9:57:32 AM
Hello, I'm trying to filter a dataset based of criteria defined in a parent dataset. To better explain what I'm trying to do is I have a list of orders, and sometimes there are returns with those orders. So I need to look up in a separate dataset in RS if there are any credits and place...more >>

Questions about Linked Reports
Posted by Rob 'Spike' Stevens at 3/9/2006 9:21:32 AM
Ok, I've been doing SRS for a while now, but I have never had a reason on 2 years to create or even look into linked reports, but I think I just found one. The powers that be want me to create a report - ok, no big deal. They want the identical report to be located in 2 seperate folders in...more >>

SSRS - Report Model - How do filter data based on a user's AD Grou
Posted by Greg at 3/9/2006 9:11:32 AM
I am trying to restrict the data that individual users see by their AD Secuity Group membership. Is there a way to do this and if so, how? ...more >>

text box calculation
Posted by Zim at 3/9/2006 7:37:33 AM
is it possible to preform calculations on text box names ie textbox3 = textbox1 - textbox2?...more >>

Adding spaces inside text box values
Posted by Pasquale at 3/9/2006 4:16:27 AM
I need to adding spaces inside the expression of a text box (in table header or in page header). For example: = "string 1" & " " & "string 2"; this expression returns only one space between string 1 and string 2. Many thanks...more >>

Bookmarks
Posted by Eric at 3/9/2006 1:47:27 AM
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 >>

Printing Page size problems via Render - weird????
Posted by Craig at 3/9/2006 12:00:00 AM
Hi, I have a printing problem which I am hoping someone can answer for me. I have written a report that just fits on the page. When I go the the report website and run the report it looks great and I can print from there and it fits on the page wonderfully. However I want to be able to ru...more >>


DevelopmentNow Blog