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 > september 2006 > threads for monday september 25

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

Parameter refresh problem...
Posted by sitexcite NO[at]SPAM hotmail.com at 9/25/2006 11:18:41 PM
Guys, Hopefully, this is a simple problem. I am new to SSAS 2005 - I have created several reports that I can view and filter fine using http://localhost/ReportServer. I have created a web page with a Report Viewer control in it and I have LinkButtons set up to load one report or another like ...more >>


2005 report designer and 2000 report server
Posted by moondaddy at 9/25/2006 10:39:37 PM
Is it possible/ok to write a report with sql 2005 report designer and deploy the report to a SQL 2000 Report Server? -- moondaddy@noemail.noemail ...more >>

Stored Procedures and Multi Valued Paramters
Posted by Navan Man at 9/25/2006 5:31:01 PM
I am having trouble passing through multivalued parameters to a stored procedure. I have created a UDF as to present the parameters as a string but when I am not sure how to call the stored procedure. Could you please tell how do I call the stored procedure from the Data tab in Visual studio...more >>

PostgreSQL Database and Reporting Service?
Posted by wiseteufel via SQLMonster.com at 9/25/2006 4:58:01 PM
Hello all - I have reporting services installed on SQL server 2000 database and have developed many many great reporrts on it. However, I have the need now to address datasources from PostgreSQLdatabase open-source database and I wonder if RS would work with PostgreSQL ODBC and if the onl...more >>

when is SSRS going to stop being beta?
Posted by aaron.kempf NO[at]SPAM gmail.com at 9/25/2006 4:20:41 PM
I mean seriously here. I believe that Microsoft has standards-- when it comes to office software; about copying and pasting; and hitting F2 in order to change a value or rename. I just dont think that MS has followed their own best practices on SSRS; I mean; does anyone at MS have _ANY_ rea...more >>

UserID from linked report
Posted by Steve at 9/25/2006 12:39:01 PM
I have a report that uses the User!UserID to restrict the rows of a query, which works fine. However, it appears that when I run a linked report it does not use the UserID of the person running the linked report. Does anyone know if the base report is supposed to inherit the security contex...more >>

How to keep report from disappearing when parameters are changed
Posted by cosmo at 9/25/2006 11:29:10 AM
If you change the parameters on a report, but don't hit View Report yet, the current report still disappears and you have to hit View Report again to see the report. It seems like even just changing a parameter causes a postback to the report, which I don't want happening to the users unless the...more >>

Matrix question
Posted by Brian L at 9/25/2006 10:56:02 AM
I have a matrix issue with the colum ordering. What I want is for the month-yr columns to be in order, starting with 1-2006 --> 12-2006 but I cannot determine how to order them correctly. can someone point me in the right direction?...more >>



Use RS to generate map?
Posted by dw at 9/25/2006 9:40:02 AM
Hello... We use SQL 2005 RS and some users have asked if we could generate a map that plots all of the data points (people or resources). I have searched around but cannot find anything that has an example or even indicates that this is possible. I would assume that we might have to get s...more >>

Reports take "too long" to run!
Posted by Jim at 9/25/2006 9:17:26 AM
I've been developing SSRS reports for a few years now and have not been immune to client claims that a report takes "too long" to run. Obviously "too long" is relative but I have always been of the midset that in general, the closer to real time and greater the amount of data a report inclues,...more >>

runningvalue syntax
Posted by Dan D. at 9/25/2006 7:21:01 AM
Using RS2000 and SS2000 SP4. I'm trying to add the total for each group so I can get a grand total and RunningValue seems like the right function to use. I tried using =RunningValue(Fields!CompanyName.Value,Sum,Nothing) but I get the error "‘textbox2’ uses a numeric aggregate function ...more >>

Calendar Control
Posted by echeeze at 9/25/2006 6:18:02 AM
We use the RS 2005 Calendar control for date/time parameters on our reporting. Unfortunatley we have been running into a performance problem becuase the Calendar control does a round trip to the server once a date is chosen. On many of our desktops, this round trip is very evident. Is the...more >>

MDX query in reporting Services does not display the member All
Posted by KarenM at 9/25/2006 2:26:02 AM
I have the following MDX in reporting services for a dataset: SELECT non empty {[Plant].Members} on rows , non empty{[Measures].qty } on columns from Sales This query in the MDX Sample applications displays as follows: All Plant 111245.09 ABC 120.50 DEF 1189.9...more >>

Starting angle in pie chart
Posted by Henrik Skak Pedersen at 9/25/2006 12:00:00 AM
How can I set the starting angle/point of the first pie in my pie chart? Thanks Henrik Skak Pedersen. ...more >>

SSRS 2000: Page cannot be displayed error
Posted by NCW Support at 9/25/2006 12:00:00 AM
Hi all, I am encountering a page cannot be displayed error when I try to access a report that has been deployed onto a remote server. I developed the report in VS2003 on my local machine, and when I click on the preview tab in VS2003, it runs the report and returns me the data. Building ...more >>


DevelopmentNow Blog