all groups > sql server reporting services > december 2005 > threads for thursday december 29
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
:( Please Help Needed on Printing Report in RS
Posted by Raj at 12/29/2005 10:58:17 PM
Hi All Experts,
I caught in a big problem, previosly our application was using Crystal
Report, but on my suggestion Project Manager changed the reporting tool
for next client and we are decided to use RS and removed CR from our
application.
There are 50 Reports, we designed it well and we don... more >>
'ALL' member when using MDX query
Posted by john.r.carter NO[at]SPAM bankofamerica.com at 12/29/2005 8:08:22 PM
When I try to generate a matrix report using mdx against an AS2000 cube
I am unable to retrieve the "all" level from my "Providers" dimension.
Does anyone know how I can get the all level included in my report?
Basically the 'Providers' dimension has two member plus the all level.
Member 1 - B... more >>
How to retrieve a report in SQL Reporting Server
Posted by Ayad at 12/29/2005 4:17:35 PM
Is there a way to read the rdl file that is already deployed on the Report
Server to modify it? I have some reports on RS but don't have the original
rdl file.
Thanks
Ayad
... more >>
Integrated Security to RS and SSAS not working
Posted by Raghu at 12/29/2005 3:58:02 PM
Hi,
Here's my setup:
1. ReportServer website is setup to use Integrated Authentication
2. I added a new user group (in computer management) called ReportAdmins
3. I used Management Studio to connect to my Reposting Services, at the top
level, I added the user group I just created, and gave i... more >>
Force list to stay in same place on repeat pages?
Posted by jim_slc at 12/29/2005 3:43:11 PM
Is there some way to force a list (or table) to print in the same place
on repeat pages as it does on the first page?
Say for instance on the first page the list starts 2 inches from the
top, can I make it so on continuation pages the list always starts 2
inches from the top? Instead of startin... more >>
Q: Report Deployment
Posted by JIM.H. at 12/29/2005 3:28:02 PM
Hello,
I have two questions:
1. When I debug my application it seems it deploys reports to report
manager, how can I prevent that from happening, I would like to deploy when I
chose deploy command only?
2. I have a report which has many sub-report, when I deploy sub-reports are
deployed... more >>
Problem accessing Report Server
Posted by Joe S. at 12/29/2005 3:00:02 PM
Installed SQL 2005 and Report Services on Win XP SP2 with IIS 5.1 installed
for testing. Already had SQL 2000 installed so I gave the new install an
instance name of SQL2005. My problem is that I can't access the Report Server
web pages. I have checked and IIS 5.1 is running, report services i... more >>
Problems in Report Presentation
Posted by Brennan at 12/29/2005 1:35:01 PM
Hello:
We are running SQL Server 2000 RS. We are just starting to deploy reports
and we are running into a strange problem.
We have given users access to their reports via various Windows security
groups. When an Sysadmin runs a report, it's runs fine and displays
everything in a timel... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
distributing reports to multiple report servers
Posted by Craig L at 12/29/2005 1:14:37 PM
Hi,
I am trying to figure out how to package and deploy reports to multiple
report servers. We have 200+ clients, and are trying to switch over to
report server, but I can't find any documentation about deploying reports
outside of an organization.
To clarify a little, new releases come ou... more >>
How to remove 'Select a Value' from the drop down list.
Posted by amitmittal77 at 12/29/2005 12:41:42 PM
I am using SQL Server 2005 RTM. In which i am getting 'Select a value' in all
the drop down list.
I don't want 'Select a value' in the drop down list
Please advise how to remove it from the drop down list... more >>
Logon failed when attempting to run report
Posted by Terry at 12/29/2005 10:53:04 AM
When attempting to run a report, the following error appeared.
What does the following error message mean?
Logon failed.
Logon failure: unknown user name or bad password. (Exception from HRESULT:
0x8007052E)
... more >>
Possible to Loop thru dataset using Custom Code?
Posted by Sorcerdon at 12/29/2005 8:49:21 AM
Is there a way to pass a record set into a function of custom code?
If so?
What datatype should I use?
I have been told its impossible to loop thru the dataset...
Can you get the INDEX of the First row and the INDEX of the last row as
a parameter into a custom function?
regards,
Stas K.... more >>
print header on the first page only
Posted by Marie at 12/29/2005 8:20:02 AM
I have a table grouped by id. The detail for a particular group can span
serveral pages.
I have 3 header lines for each group . I want to print all 3 header rows on
the first page of the group and only one of the header rows on the next pages
of the group.
Does any one know how to do t... more >>
Decoded values in report
Posted by Arshad Syed at 12/29/2005 8:05:05 AM
Hi,
I have a report generated from a dataset which has the state and county
codes. I have some other general purpose datasets which have the correspoding
county/state codes and descriptions. How do I link these to the report so
that I can see the descriptions instead of the code? I tried ... more >>
SQL Where Statements vs RS Filtering
Posted by Sorcerdon at 12/29/2005 6:23:09 AM
Lets say Im running many small/big reports.
I want my report to be generated fast.
What's faster?
SQL Store Procedures with Where statements or RS filtering?
Reason for my questions:
SQL cache only caches specific requests - meaning where startdate is x
and end date is y. So if I run the s... more >>
Rendering different reports into a single PDF
Posted by AN at 12/29/2005 3:42:26 AM
I have 2 reports, my requirement is to render these 2 reports into a
single PDF file (kindof like appending the reports). Is this possible
with reporting services?? How? TIA
... more >>
|