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 > july 2004 > threads for friday july 16

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

Tooltip on image
Posted by creative NO[at]SPAM mailcity.com at 7/16/2004 9:22:12 PM
I have a matrix with image in the cells. I added a Sales_USD field as a tooltip to the image. I published the report. But the tooltip doesn't work... What could I be doing wrong?...more >>

Any valid solution to Fields refreshing at run time?
Posted by Chiara at 7/16/2004 9:05:03 PM
Hi I have a stored procedure that returns changing result set all the time: Create proc stp_test @colName varchar(1024) , @tableName varchar(1024) As Set @cmd = 'select ' + @colName + 'from ' + @tableName Exec @cmd Go In the Data folder of my report, i switch to Generic Query Design...more >>

Parameters to reports that only show is previous parameters filled
Posted by Justin30519 at 7/16/2004 7:16:01 PM
I don't know if I can do this with Reporting Services. I have ten parameters to a stored procedure. However, each parameter only shows when the previous one is selected. For sake of this discussion, the queries from which the parameters come are completly unrelated. Initially, only the pull-down...more >>

RDL from SQL200 to Yukon
Posted by Mark Goldin at 7/16/2004 6:37:56 PM
I am trying to open a SQL 2000 report in Yukon. I am getting: Deserialization failed: The Report element was not found. Is there any way to open this report? Thanks ...more >>

forms authentication problem
Posted by Vincenet Nicotina at 7/16/2004 4:53:40 PM
I've searched the newgroups, and have found others who had this problem, but their solutions don't seem to work for my case: I installed the forms authentication sample and it works fine on my local machine. I then installed it on my production server, and http://machinename/reportserver wor...more >>

Report Execution slow Vs. QA execution
Posted by Kevin Lloyd at 7/16/2004 4:37:04 PM
I'm using Profiler to report a user issue that a report is running slow. The report uses a sproc passing parms. RS executes this through sp_executesql, which is fine, and i'm testing my QA execution using the same sp_executesql statement that RS is using (for consistency in testing). The proble...more >>

Auto generate report without clicking on the "View Report"
Posted by creative NO[at]SPAM mailcity.com at 7/16/2004 3:34:12 PM
Is there a way to automatically generate the report when the users changes the parameter selection - without clicking on the "View Report" button? Thx...more >>

Group By Consecutive Values
Posted by Nytr0x at 7/16/2004 3:30:54 PM
Hi I've been puzzling over this one for ages, Imagine a dataset like: ShiftStartDate, ShiftEndDate, NameID, Name, AbsenceCode 1-Jan 07:00 1-Jan 15:00 00001 Fred S 2-Jan 07:00 2-Jan 15:00 00001 Fred S 3-Jan 07:00 3-Jan 15:00 00001 Fred ...more >>



Images are fuzzy...
Posted by Brian Harris at 7/16/2004 3:04:01 PM
So, I actually have RS up and running and I've solved all the other issues with permissions and such. But a small problem is occuring that I'd like to get help with. I have images in some of my reports. I've embeded some of them directly into the report and used a URL for others. The problem i...more >>

FileShareProvider delivery extension credential encoding
Posted by Jay Hackney at 7/16/2004 3:02:57 PM
I receive the following error when I try to provide a username and password to the FileShareProvider delivery extension through the data-driven subscription query: ReportingServicesService!dbpolling!5d8!07/14/2004-17:20:23:: NotificationPolling processing item 951ca046-a4a7-4657-be85-04512f3e8...more >>

To email greyed out
Posted by Bryan Murtha at 7/16/2004 2:54:27 PM
When I go to reporting services admin. And I try to schedule a report to be emailed. The two fieled is greyed out. What is causing this? Sorry, I know this is probably a stupid question. Thanks, Bryan...more >>

ParameterValueClass for setting Parameters Property of ReportViewer
Posted by Bob Feller at 7/16/2004 1:16:31 PM
I am trying to set the ReportViewer (the one that runs as a .net control) Parameters property, which is looking for an array of ParameterValue objects. Where is the ParameterValue object defined? I cannot find it in the ReportViewer, or the Web Services. Any ideas how to pass a set of paramenet...more >>

Style Sheet Fun
Posted by fzuma NO[at]SPAM yahoo.com at 7/16/2004 12:56:14 PM
I'm looking for a style sheet solution (i've seen the 3 choices posted prior to SP1). I installed SP1 a few days back and noticed that one of the enhancements is New Access URL Parameters. Found here: http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_...more >>

Show percentage values in chart
Posted by Mark at 7/16/2004 12:51:03 PM
What is the right way of showing percentages in the chart?...more >>

Chart question
Posted by Mark at 7/16/2004 12:33:02 PM
How can I show a data label and actual number for chart data?...more >>

Blank Field List When Using Stored Procedure
Posted by nataliya NO[at]SPAM iowatelecom.net at 7/16/2004 12:02:48 PM
I am trying to use SQL Server 2000 stored procedure that does not take any parameters in the Report Designer. When I run dataset in Data tab of report designer and try to REFRESH the fields, this doesn't help to get a list of fields. I get no error but no data. So the field list is still empty....more >>

Attaching a table to a matrix:
Posted by Cindy Lee at 7/16/2004 11:54:41 AM
Is there a good way to put a table right next to a matrix, or a matrix, under a matrix. I want to align the cubes and make it look it it's in the same table. But I get some spaceing when I preview or deploy the report. I also tried to put a matrix under another matrix and make the top row non ...more >>

cangrow flag?
Posted by alsamy at 7/16/2004 11:21:02 AM
Since there are CanGrow and CanShrink attributes of a textbox, thus implying that there is a flag of some sort that know when the data is too large for the textbox, is there a way that this ?flag? can be accessed? I do not want my textbox to grow, however, if I knew that the data contained in it,...more >>

Out-of-control Logging
Posted by Bryan Bullard at 7/16/2004 10:55:35 AM
This morning I found out that reporting services was logging out-of-control. In one day I have about 2 Gigs of the last four lines: <Header> <Product>Microsoft SQL Server Reporting Services Version 8.00.878.00</Product> <Locale>en-US</Locale> <TimeZone>Central Daylight Time</TimeZone> ...more >>

No SRC in IMG tag in HTML Fragment
Posted by Steven Lawrence at 7/16/2004 10:11:33 AM
I am using the web service render command to pull out the HTML fragment to display on a page but the SRC attribute of the IMG tags are all blank. I know the image is available in the RenderStream but how do I link the two together? Is this just an HTML problem? If so where should I look? Th...more >>

HRESULT suspicion
Posted by John Carpenter at 7/16/2004 9:42:40 AM
Hello, A while ago I reported an HRESULT error that I receive when trying to create a report in Visual Studio.net. I have a strange feeling that it could be related to the Corel XMetaL 4 vs.net plugin that I have installed. Although I've tried uninstalling and reinstalling everything...more >>

Newbie - Subscription problem
Posted by Tim at 7/16/2004 8:43:06 AM
I know this has probably been asked many many times, but can someone please help me. Recently, I installed the evaluation version of RS (and SP1). I have been trying to test out the subscription feature, but can't seem to get it working. When I store the credentials as a Windows login, ...more >>

Do i have SP1?
Posted by G at 7/16/2004 8:42:00 AM
I thought i'd upgraded my Report Designer for SP1, but now i'm not so sure. There is no "Prompt the User" checkbox for my parameters. The version number for my RD is: Version 8.00.878.00. Can anyone tell from that whether im SP1 or not? TIA, Brian ...more >>

Document map on Mac
Posted by eppingerr NO[at]SPAM software-answers.com at 7/16/2004 8:15:12 AM
I have seen other posts which indicate issues with the document map and issues with reporting output in general on the Mac. However, I haven't seen that anyone is having the specific problem I am having. I have a report which uses a document map. It works perfectly in IE 6.0 on a PC when ren...more >>

Suppressing Nil Return reports
Posted by Mike Jolliffe at 7/16/2004 3:12:02 AM
hi if there is a report that is run that returns no data, is it possible to suppress the rendering of all of the report headings? maybe even put in a different output in place (such as 'no results returned')? -- Mike Jolliffe ...more >>

Page Footer
Posted by push at 7/16/2004 3:10:02 AM
Simple Query. In the page footer, when i place the Page Number fields on the extreme right of the page design layout window, it actually does not appear ont he extreme right of the preview. Instead it appears as is on the position placed in the layout window. How can i specify for the feld to appea...more >>

Customising home page (reports/pages/folder.aspx)
Posted by Mike Jolliffe at 7/16/2004 3:10:01 AM
hi is it possible to cusomise the reporting home page to add logos, maybe additional text etc? -- Mike Jolliffe ...more >>

Reporting Services and Web Services
Posted by BenW at 7/16/2004 2:31:02 AM
Is it correct that out of the box you can not use a web service as a source like the other sources? -- BenW MCAD...more >>

Problem with install if machine.config username and password are stored in registry
Posted by richard.warner NO[at]SPAM zurich.com at 7/16/2004 2:18:05 AM
Hi, For information. It looks like the SQL Reporting Services install doesn't work properly if you have followed Microsoft's advice and have stored the server's ..net credentials (in the machine.config <processModel> element) in the registry using aspnet_setreg. (You would do this to remov...more >>


DevelopmentNow Blog