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 > 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 >>



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 >>


DevelopmentNow Blog