all groups > sql server reporting services > september 2004 > threads for wednesday september 15
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
What does the ReportServer and ReportServerTempDB dbs contain ?
Posted by anandsagar NO[at]SPAM gmail.com at 9/15/2004 11:43:59 PM
I am developing reports on my desk computer, deploying on another
computer (the reporting service server) which has the actual SQLServer
database for the . What actually happens when I deploy the product ?
Is there anything that gets written in the Reporting Service database
? Any entries go int... more >>
Reporting Services User Problems...
Posted by Joel D Kraft at 9/15/2004 9:23:57 PM
What I learned this week is that Reporting Services security is annoying as
hell. :-)
I'm curious if there is any logical reason that you cannot create a
subscription out of
a report that references the User!UserID? Perhaps I can see why some other
values
in User! may not be available, b... more >>
Subtotal at the End Of Each PAGE
Posted by John at 9/15/2004 8:33:14 PM
Can someone Please help me.
I need to have a Subtotal at the end of EACH PAGE.
Please give me a sample, or a link or please tell me where to look.
I seached hi and low for 2 weeks now and still could not come up with
a solution.
If this functionally is not available in RS could someone plea... more >>
Localization problem
Posted by Mauricio Cadima at 9/15/2004 6:10:04 PM
Hi
I have a report with a "Jump to report" navigation field to a second report
, some of the parameters to the second report are DateTime values, when my
Local Settings are setted to English (United States) the link works fine,
but when I change my Local Settings to Spanish I get a Type Mismat... more >>
Cumulative Total
Posted by May Liu at 9/15/2004 5:33:28 PM
I try to sum a value in the TABLE FOOTER if this record falls into a
particular condition. But the result is zero.
The formular is as follow:
=Sum(IIf(Fields!EQP_LEN.Value = 20 And Fields!EQP_TYPE.Value = "GP",
Fields!CN_WGT.Value, 0))
If I the formular like this:
=Sum(IIf(Fields!EQP_LEN.... more >>
Streaming HTML reports and images
Posted by Christian Donner at 9/15/2004 5:04:04 PM
I want to stream HTML reports through another application server that
handles authentication, effectively hiding the reporting server from the end
user. I am running into a problem with embedded images. When the client
receives the HTML stream, the browser resolves the image tags and requests
th... more >>
Editions
Posted by Frank at 9/15/2004 5:01:18 PM
Can someone tell me what is the difference between
RS Developer Edition
RS Standard Edition
RS Enterprise Edition
What should I be installing on the reporting service server that I don't
intend to do report development on?
... more >>
GetReportParameters - How can I get the default value of the parameter?
Posted by Bob Thomas at 9/15/2004 4:48:01 PM
I'm using the GetReportParameters method to get the parameters of my report.
I can get the name, type, etc., but I'm unsure of how to get the actual
value assigned to that parameter.
Any suggestions?
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Urgent Help....Create report (RDL file ) Programmatically
Posted by Sumudu Prasad at 9/15/2004 4:21:53 PM
Can any body tel me how to generate RDL file (xml) dynamically for given MDX
query.
Iam using XML/A (XML for Analysis) for execute the mdx query and get the
result set as xml file.
Is there 3rd pary tool or Sample Code for this type of situvation.
bcoz......... this report should be ... more >>
Reasonable size of rdl file?
Posted by Tibor Karaszi at 9/15/2004 4:18:33 PM
I'm working with a report that will produce 5 printed pages with key data
for a company. Each page will contain from 3 to 12 diagrams, there will be
39 diagrams totally in the rdl file. Plus some text boxes etc.
Each diagram has a dataset, plus some support datasets. Totally about 45
datasets (a... more >>
Subscription Clean up
Posted by Matt at 9/15/2004 4:07:31 PM
Hi,
Pardon my ignorance but here goes.
When reporting services runs a subscription, it creates a file in the
INetPub folder or something like that for the emailer to pickup and mail
out. Or something like that.
Once the mail has been sent, is the physical file cleaned up, or should we
h... more >>
Grouping Row Border
Posted by Reg at 9/15/2004 3:15:12 PM
Hi,
I'm trying to achieve the following in a table. Have border after/before the
grouping changes to the next value.
Nov 1 v1 v2 v3 v4
v1 v2 v3 v4
_____________________
Nov 3 v1 v2 v3 v4
_____________________
Is there an easy way to do thi... more >>
Wheres the Document Map in this rdl file?
Posted by Si at 9/15/2004 3:05:06 PM
Hi,
I've got a simple report here which for some reason is displaying the
Document Map even though i've not specifically added it to any of the
expressions.
I've spent ages trying to find out where it's declared/set but to no
avail, anyone here that can assist as it's really bugging me now.... more >>
append items to a dataset
Posted by Loui Mercieca at 9/15/2004 2:51:32 PM
Hi,
I have a dataset, which is used for a listbox to display items. I
need to append new static items to the ones returned by the dataset, without
making any changes to the original db. Can anyone help??
Thanks
... more >>
Can't upgrade to RS SP1
Posted by burt_5920 NO[at]SPAM yahoo.com at 9/15/2004 2:20:02 PM
I was able to install RS on my dev machine with no issues, but the SP1
upgrade package keeps crashing. I was able to upgrade our servers to
SP1, and other developers have been able to upgrade there PCs as well.
The error log says:
[Info] Calling MsiApplyPatch with szPatchPackage =
c:\14763ee... more >>
How to draw circle
Posted by Ponnurangam at 9/15/2004 2:14:17 PM
Hi,
Can someone tell me how to draw a circle other than using an image
Thanks,
Ponnurangam
... more >>
How to Deploy Reports to a Production Environment
Posted by Belak at 9/15/2004 9:58:51 AM
Our situation is that we are developing a set of "master" reports locally
using Visual Studio .NET 2003 (and, of course, the Reporting Services
designer). Once the master reports are finished, we will need to install
these reports to our customers' computers (their computers are not a part of
o... more >>
How to render the same as Report Designer Preview
Posted by Peter Kenyon at 9/15/2004 9:48:26 AM
Hi,
We have a report containing several Matrix controls, carefully positioned so
that they all appear to form a single spreadsheet. The report looks fine
when viewed using the preview window, but when viewed normally there are
large spaces between the matrix controls. Also, some formatting ... more >>
Using Custom Code
Posted by RK Balaji at 9/15/2004 9:05:55 AM
I am using RS against Oracle database (through OLEDB).. I have some
parameters that I need to add to the sql stmt that needs little conditional
statements. So I have added custom code on the report. In the Data tab, I
have
=code.getsqlstmt()
and I return the sql statement from the code. Whe... more >>
Excel Rendering - Urgent
Posted by Benjamin Pierce at 9/15/2004 8:36:19 AM
Hello,
I have a fairly simple report (with a lot of columns) that I'm trying to
export to Excel. Everytime I do this, I get the following error:
"Excel Rendering Extension: Width of excel cell in the excel sheet exceeded
the maximum limit of 1726.5 Points."
I know that 1726.5 equates to ... more >>
Differences between two Columns
Posted by sfibich at 9/15/2004 8:21:00 AM
Has anyone computed a difference between two columns in a matrix agianst
the group by column?
Example
YEAR Diff
2003 2004
Company A 100 200 100
Company B 50 200 150
I posted this question earlier but I don't think I was clear about what
I was asking about. If anyone has any ide... more >>
Print Preview and Export Problem
Posted by Susan at 9/15/2004 7:12:05 AM
my report has a grouping with a page break at the end of
each field. In the Preview Tab everything is Ok but when
Print Preview is clicked only the first group (page) is
Previewed. If I try to export pdf the same only one page.
tiff only one page but a mhtml file displays all pages.
Plea... more >>
stored procedure query
Posted by silvia_gambelli NO[at]SPAM hotmail.com at 9/15/2004 7:09:29 AM
I have this problem:
I want to create a dataset in Reporting Services with CommandType =
storedProcedure.
The stored procedure has a parameter @strWhereClause and is like this:
DECLARE @strSQL VARCHAR(8000)
SET @strSQL = 'SELECT '
SET @strSQL = @strSQL + 'FIELD1,'
SET @strSQL = @strSQ... more >>
Re: Very slow to render preview
Posted by Paul Taylor at 9/15/2004 1:54:13 AM
Anyone have any thoughts on this one?
... more >>
sp3 or sp3a?
Posted by JC at 9/15/2004 1:43:14 AM
Hi,
I'm preparing for an installation and need to check - is
sp3a required or is sp3 sufficient?
Rgds,
JC... more >>
|