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 > october 2006 > threads for monday october 30

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

Stacked Bar Chart - Show All Labels on the X Axis
Posted by JonathanG at 10/30/2006 2:05:45 PM
Hi, I was curious if any one could help me figure out a small problem I am having. I am attempting to create a Stacked Bar Chart in Reporting Services. My data set contains a lot of points. With many points, I notice that RS is automatically removing some of the labels on the X-Axis in ord...more >>

Report Model - Custom DataSource
Posted by Klaus Aschenbrenner at 10/30/2006 2:02:41 PM
Hi! We have implemented a custom DataProcessingExtension for Reporting Services 2005. Now we want to implement a Report Model based on this DataProcessingExtension (for the usage in ReportBuilder). Can can I accomplish this, because as the documentation says you can only create a Report...more >>

Best parctices in SSRS 2000 reports development
Posted by Lena at 10/30/2006 1:34:02 PM
Any ideas or known approaches on how to better develop reports. I have about 30 Crystal Reports based on stored procedures. Now I need to develop SSRS 2000 reports. What is the best way to achieve this in terms of layout development? Is there any kind of a style sheet or templates in SSRS...more >>

Can report parameters be sent in subscription emails?
Posted by Winkles at 10/30/2006 10:21:41 AM
Hi all, Is there any way to have the report parameters appear in the subscription email, for both custom and default reports? Currently, the goal is to just get the team project name to appear along with the sent report. The other idea I can think of is to just put a field in the actual r...more >>

subscriptions do not send file attached
Posted by bevarg at 10/30/2006 9:56:40 AM
Hi, We are using forms authentication with reporting services and are trying to setup subscriptions for the reports. Currently, our subscriptions send out the email at the scheduled time with the report link in the body of the email and we receive it. But we never receive the report as an att...more >>

Grouping and summing
Posted by Fab at 10/30/2006 7:49:57 AM
HI, I have a group on two fields (ie SalesPersonId and CustomerID). I want to print a total after any of this values change (ie. If CustomerId changes, a total line for the customerID will be printed but not for the SalesPersonId). How Can I do it with running values ? Best regards ...more >>

conditional IF
Posted by roy mm at 10/30/2006 3:52:09 AM
Hello. I have a query whice look like this: select a,b,c,d from table1; Now - when pressing a cell in the first column we are jumping to another report with the value as parameter (called- p_param);. In the other report the query is: select * from table1 where a=::p_param. What I want to do...more >>

conditional IF
Posted by nicknack at 10/30/2006 3:48:59 AM
Hello. I have a query whice look like this: select a,b,c,d from table1; Now - when pressing a cell in the first column we are jumping to another report with the value as parameter (called- p_param);. In the other report the query is: select * from table1 where a=::p_param. What I want to d...more >>



Working with Matrix - BGcolor & hide column
Posted by nicknack at 10/30/2006 3:02:25 AM
Hello, I have a matrix in my report (rs2005). I added a "subTotal" column to the matrix (by right clicking on a column and chose "subtotal" from the popup menu). Now i want the column to be colored in blue but i can't do it. I can only select the header color (where i'm writting "TOTAL") but ...more >>

Logparser issue with SQL Server 2005 Report Pack for IIS
Posted by SalamElias at 10/30/2006 1:00:01 AM
Hi, I don't know if it is the right place to post this question, I am trying to populate IISLOG DB with IIS log file using the following expression (provided in the package DOC) LogParser "SELECT date, time, strcat(strcat(strcat(TO_STRING(TO_TIMESTAMP(date, time), 'hh'),':00-'), TO_STRING...more >>


DevelopmentNow Blog