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 > august 2005 > threads for wednesday august 31

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

problems with updating datasets in visual studio .net
Posted by Limor Bellison at 8/31/2005 11:23:03 PM
Hi, I have a strange problem since yesterday. I'm trying to change datasets in my project and I save changes. when I close the Report and open it again I see that the changes where not saved. Also the visual studio keeps getting stuck and I have to close it and open it again. I have notice...more >>


Combined line and column graph?
Posted by Cindy Lee at 8/31/2005 5:11:23 PM
I have a great column graph, but I was wondering if there were any options on the graph so I add a trend line? Or maybe there's an option I'm missing on the line graph. ...more >>

First, Last, Middle ???
Posted by PeteMitchell at 8/31/2005 1:33:08 PM
I have a Matrix that always displays two rows of data. One row show values from Jan 1 of the current year. The second row shows values for today. In the foot I show the % the values have changed so YTD with the following formula: =(Last(Fields!Core.Value) - First(Fields!Core.Value)) / Fi...more >>

RS2005 and SQL Server 2000
Posted by Scott Duckworth at 8/31/2005 1:29:38 PM
Can RS2005 run on/with SQL Server 2000? ...more >>

Export Just Data to Excel
Posted by Alec Hardy at 8/31/2005 1:28:02 PM
We would like to have a way to export just the data displayed in a report to Excel. We have looked at CSV export, but find it doesn't export well. We would like to remove the headers from the report when it exports. The only way we have found to do this is to create a separate report withou...more >>

Vs Report Viewe r2005
Posted by Fritz at 8/31/2005 12:36:01 PM
I am using the report viewer that came with visual studio beta 2. With this report viewer there seems to be no way to send paramters to the viewer or specify a render format automatically. Is there anyway to send parameters to the vs 2005 report viewer ?...more >>

One Date field with different dates
Posted by Shan at 8/31/2005 11:50:36 AM
I want to search on a date field with user input. How can I make it to where it will give user a startdate and an enddate box? Remember I have only one date field. SELECT COURSE_NBR, ATTEND, COMPL_DATE FROM EH_MEMINFO_1 WHERE (COURSE_NBR LIKE @COURSE_NBR) or ...more >>

Passing parameters to a dataset
Posted by John Smith at 8/31/2005 11:16:53 AM
I am a newb in Reporting services and need to create a parameterized report. I have already created a report parameter and now I need to apply it in the report output. I assume that I have to somehow pass this parameter to the dataset that is used to display the data. I am putting = 'Parame...more >>



RS Web parts: Change web part title?
Posted by Kaisa M. Lindahl at 8/31/2005 10:42:14 AM
Maybe I should have asked in one of the SharePoint groups, but maybe someone in this group knows what's wrong. Anyway, in a SharePoint Portal server 2003 portal, I've created a page with the Reporting services web parts. As the company in question is Norwegian, I want to change the title of th...more >>

How to MOD and TRUNCATE in vb .net
Posted by MJ Taft at 8/31/2005 10:03:06 AM
we have the following formula in a business objects report that we to convert to use in reporting services - I have no clue how to perform the MOD or TRUNCATE in vb .net =If(<Agent_Calls>=0) Then "00:00:00" Else FormatNumber(Truncate((<TOTALTALKTIME>/<Agent_Calls>/3600) ,0) ,"00") & ":" &...more >>

Using parameters
Posted by Shan at 8/31/2005 9:17:04 AM
I have a scenario where I want user to input data for search. Statement looks like Select course_nbr, attend From table_1 Where (course_nbr = @course_nbr) This only allows user to input exact course number and then the query will return a result. I want to be able for user to input ...more >>

Report parameter - date format
Posted by Franklin at 8/31/2005 5:57:01 AM
I have developed few reports using reporting services (service pack 2), but still facing some problem in the date parameter and would look for help / share here. Thanks advance! 1) How RS treat the date format? YYYY-MM-DD (the data is correct when i use this format) DD/MM/YYYY...more >>


DevelopmentNow Blog