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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|