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 friday march 10

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

Line break after group
Posted by Dutch at 3/10/2006 3:04:26 PM
I need to insert a line break in a detail row after certains groups of data. example: Week Day Detail 1 Mon 1 1 Tue 1 1 Wed 2 1 Thu 2 1 Fri 1 2 Mon 1 2 Tue 1 2 Wed 2 2 Thu 2 2 Fri 1 I need it to have a line break after week 1, 2, etc. Also, the detail column has aggregates, ru...more >>

Missing DEVENV.EXE (SQL Server Business Intelligence Dev Studio)
Posted by Serghios at 3/10/2006 2:51:16 PM
Hi, I have installed SQL 2005 and all components. However the SQL Server Business Intelligence Dev Studio is missing. I have reinstalled and still have the same issue. Any help appreciated. Serghios...more >>

How do I resolve this? Urgent please reply asap !
Posted by SDRoy at 3/10/2006 1:12:26 PM
Hello: Can someone please tell me how to convert this Crystal report formula to an expression in SQL reporting ? @VoidAmt = if {payment.status} = 'VOID' THEN {paycheck.checkamt} * -1 ELSE 0 In crystal report field I have Sum(@VoidAmt). How do I convert this as an expression in SQL repo...more >>

Change ReportServer database
Posted by Rick at 3/10/2006 1:02:27 PM
We have installed Reporting Services on a new server using the local database. Now we want to point to a ReportServer database on another database server. How can we change the server used for the ReportServer database to point to a different server? Thanks -- Rick...more >>

Dynamic Server Path
Posted by Sunny at 3/10/2006 11:05:27 AM
I have images shown on a report that are stored on a server. Problem is when developing the server path is different from my live server. So whenever we deploy the report on the server i have to make a change manually to the path of the images....i need to make this dynamic. How can i do this....more >>

obtaining an image from another server
Posted by Brandon at 3/10/2006 11:00:47 AM
Hello, My report gets an image off another server. It works fine in testing, but when I deploy it to my production server the image doesnt show up. I put a try/catch around the code and output the error to a text field in my report, only to see the following: System.UnauthorizedAcce...more >>

RS/AS 2005 Reports on Cube datasource, drilldown not working
Posted by DTK at 3/10/2006 8:59:07 AM
I have an AS 2005 cube created. I am able to generate reports in RS 2005 by setting the report datasource to point to my cube. I have tried to setup a report to drillthrough to another report ( also based on the same cube datasource ) via the TextBox Navigation/Jump To Report setting. ...more >>

Page size and relative lengths?
Posted by David at 3/10/2006 8:51:21 AM
Is that a way to set my page size as a relative (px,em,ex,%) lenght instead of an absolute (in,pt,pc,mm,cm) lenght? ...more >>



Reporting Services DB Best Practice.
Posted by Kevin Antel at 3/10/2006 7:18:10 AM
Ok, so, I see in an early post, that I need to ask a bigger question. I have a production SQL 2005 Standard Server. I have another SQL 2005 Standard server that is used for reporting services only. What is the best method for updating that reporting services DB on a 15 - 30 minute cycle. ...more >>

error message for blank reports
Posted by bevarg at 3/10/2006 6:36:28 AM
When requesting reports, if a user supplies values in the parameters for which there is no data on the database, how can I stop him/her on this screen with an error popup display box or a message on the report like 'no records available for the specified criteria' instead of generating a blank r...more >>

How to deplory reports using visual studio and Forms Authentication?
Posted by Patrick Dinger at 3/10/2006 6:13:49 AM
Hi, i successfully installed the forms authentication example on my report server. The problem i am facing now is that i am no longer able to deploy my reports using visual studio to the report server as i did before. Is there a possibility to still use visual studio for deploying? If not,...more >>

Querying Active Directory thru Custom Code
Posted by Gio at 3/10/2006 4:11:35 AM
Hi, I'm trying to retrieve user email from AD through Custom Code (stolen from an existing asp page) and then to display it in a report (... =Code.UserMail(User!UserID)...) But I get this error: "Cast from type 'Field' to type 'String' is not valid." Thanks for any help! Here's my custo...more >>

Send an email to a different address for each group in a report?
Posted by klar02 at 3/10/2006 12:25:00 AM
Is there a way to send an email to a different email address for each = group in a report? I would like to send a monthly report card to each = Nurse Unit at our hospital. There would be many nurse units so I don't = want to have to schedule a separate job for each unit. Any ideas? Andy...more >>

Error! Must declare the varaible
Posted by MVA at 3/10/2006 12:00:00 AM
Hi Can someone help me with the following problem? I have a report that needs two parameters at runtime. If I execute this report on the same server as RS with a data source that is connected to a database on the same server as the RS server. Then the report execute without any problems. Th...more >>


DevelopmentNow Blog