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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|