|
|
|
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 |
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 SQL Reporting Services - Disable Report Parameter Posted by Augustin Prasanna at 12/8/2004 10:53:02 PM Hi,
We use SQL Reporting Services Report Manager console to generate reports.
On click of an hyperlink, we open up the reports web service passing the
necessary params. Values to one of the report parameters are passed from the
application (currently logged in user's ID). The report param...more >>
Change in MHTML rendering in SP1? Posted by Jonathan Levine at 12/8/2004 7:29:01 PM Greetings.
I recently installed SP1, and am having some trouble with my Custom Delivery
Extension.
My extension renders to MHTML, converts the resulting stream to a
CDO.Message, then manipulates the resulting object. After installing SP1, I
get an exception during this process.
I a...more >>
Can a Custom Security Extension help me here? Posted by ryan at 12/8/2004 5:25:06 PM I am hoping someone can tell me what I am trying to do is even possible
before I waste several hours of development time. I have read all relevant
posts in this newsgroup, and the Microsoft provided Forms Authentication
example
(http://msdn.microsoft.com/library/default.asp?url=/library/en-...more >>
Cannot Get Parameter to Display in Page Header Posted by pittpanther at 12/8/2004 3:05:08 PM I have started a simple report that has two datasets. The first dataset just
returns all of the production orders. The second dataset is the main source
of the reports data and has production order as its parameter. For this
parameter, I have chosen the first dataset as the report parameter...more >>
Table made invisible causes location change in adjacent textboxes Posted by Danielle at 12/8/2004 2:05:07 PM Depending on a parameter value, I either hide or show a table report item.
This table has a Left property of zero inches. Just to the right of the
table, I have textboxes with a Left property of 3 inches. When the table is
hidden, the textboxes appear at the zero inches location on the repo...more >>
Using Report Totals Calculation Within a group Posted by AdamB at 12/8/2004 1:39:08 PM A have a Group, let's call it Menu Category. For a given Menu Category in
this group, I need to calculate the percentage of this category's sales
compared with Total Sales (which would be all the Menu Categories combined).
How can I (from within my group), go outside the group to calculate T...more >>
Question about Running Totals in a Matrix Posted by Mark at 12/8/2004 1:17:06 PM I am having problems specifying a running total within a matrix. I have
monthly values in the columns of the matrix so that I am displaying Month To
Date (MTD) sales numbers in the data. I would like to use a running total
across months to get a YTD report. I am trying to add a row group to th...more >>
Dataset Dynamic Query Posted by GH at 12/8/2004 12:05:08 PM I am trying to implement the setting of a parameter to the default value of
'-All-' using the IIF function in the WHERE clause.
I received a processing error then backed off and checked a basic 'SELECT
select list FROM tablename WHERE columnname = value' query. It ran in
Preview just fine....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
installation trouble Posted by aaron_kempf NO[at]SPAM hotmail.com at 12/8/2004 11:59:02 AM ok i am working on Win2k pro.
i want to be able to develop reports and then move them to the production
server.
I can't use MSDE, or Std Edition on my machine-- so I finally settled on
Developers' edition of SQL OLTP.
The CD that I have only had a Std Edition of RS; and I couldn't get RS ...more >>
Permissions can't see the contents or properties tabs on the HOME Posted by Andy998 at 12/8/2004 11:53:03 AM I have installed RS in development with no problems, but after installing on
a production server, I can not see the Content tab on the home page and can
not create folders. DBA's are not allowed to be administrators on
production servers. I went into site settings and created a new role
a...more >>
Best Way to 'Program' for SRS Posted by Hunter Hillegas at 12/8/2004 10:59:03 AM My background is as a Java programmer.
I am using SRS to create some reports. I am having a hard time getting used
to only dealing with the output from the database server. I'm used to having
access to objects, methods, etc...
I am trying to determine if I am better off just writing stored...more >>
Passing parameters in url Posted by BrianW at 12/8/2004 10:21:06 AM I can't seem to pass parameters in my url. I've seen several posts dealing
with this and my syntax matches:
http://trweb03/Reports/Pages/Report.aspx?ItemPath=%2fMarketing%2fFishbowl+Redemptions¶mStore=30¶mStartDate=1/1/04¶mEndDate=11/1/04
There is no error. It just comes up with...more >>
New error arithmetic overflow Posted by Paul Strauss at 12/8/2004 9:57:05 AM Just recently I have been getting this error on several computers with
reports that were running fine. I will install RS SP1 but what is going on.
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot read the next data row for the data set Productivity...more >>
Querying 2 datasets Posted by Sujay at 12/8/2004 9:49:01 AM Guys,
Here is my problem:
I have two datsets one created by Sybase and one ony by SQLserver.
Now, I want to query these two dataset with some criteria and merge into one
to create a 3rd dataset , similarly as we query two tables in SQL server.
This way I can use my 3rd dataset as my report fie...more >>
Language Localization Posted by Eddie at 12/8/2004 9:25:03 AM Scenario:
User selects the desired language in the application. The web app uses this
to determine the language. The application does not use the browser's set
language.
Problem:
HTML viewer works using the browser's set language. And works darn great if
I may add.
Question:
Is there...more >>
Null Posted by Asim at 12/8/2004 9:05:04 AM Hi there,
I have a report (Matrix styled) in which i would like to replace
"blank" spaces with zeroes. How would I write an expression for that, I am
getting error messages when i write
IIF (ISNOTHING(SUM(FIELDS!Discharges.Value),0, FIELDS!Discharges.Value
Thanks for any help on this...more >>
View RS Configuration to see what SQL DB it uses Posted by gougler at 12/8/2004 8:59:28 AM What is the easiest way to see what configuration DB particular SQL
Reporting Services server is connecting to? thanks.
...more >>
Custom Data Extension Posted by TechnoSpyke at 12/8/2004 8:04:33 AM I know that SRS Enterprise Edition (EE) is needed to implement a custom
security extension. Do I need Enterprise too if I want to implement a
custom data extension?
TIA.
...more >>
expression Posted by Sandy at 12/8/2004 7:29:04 AM How to call a custom function from an expression under iif.can anybody please
help....more >>
Field Format Expression Posted by DJONES at 12/8/2004 7:23:02 AM I'm attempting to pass format values to a report field from a Db. I've tried
two approaches by placing the following in the format expression:
1.
=iif(Fields!type.Value="p","p",iif(Fields!type.Value=n,"n",iif(Fields!type.Value=n00,"n00",iif(Fields!type.Value=n0,"n0","n00"))))
2.
=Fields!ty...more >>
referencing fields in the code window Posted by slk55guy at 12/8/2004 7:15:02 AM Hi, how do I reference a report field in a custom function which is written
in the code window (Report Properties/code tab)? i.e.
Function Something
If Fields!FIELD1_Company.Value = Nothing Then
Return ""
End If
End Function
This example will not work but it's similar to my ...more >>
Security Posted by Bungle at 12/8/2004 7:03:04 AM Hi
Does anyone know how to extract the security part of reporting services
out into a custom web app. I am pulling the reports out but need the
other administration bits in order to use one app for everything.
Thanks
...more >>
Edition of Report Server DB not supported Posted by Scott at 12/8/2004 6:48:24 AM I'm receiving the following message when trying to install the
Reporting Services:
"This Edition of the Report Server Database is not supported on the
edition of SQL Server 2000 you have chosen. Please choose another SQL
Server that matches the requirements."
Any suggestions appreciated.
...more >>
Problem in Export to PDF or Excel Posted by May Liu at 12/8/2004 2:55:05 AM My report contains some Korean wording. When I export to PDF, the Korean
word appear as ?. Then I export the report in Excel format, there is no
problem in the Korean wording. But when I try to print it, the default page
orientation is 'Landscape' and there is default left and right margin ...more >>
Subcription problem Posted by May Liu at 12/8/2004 2:55:04 AM I try to create new subscription, the following message box is shown.
Subscriptions cannot be created because the credentials used to run the
report are not stored, the report is using user-defined parameter values, or
if a linked report, the link is no longer valid.
Can anyone help me ???...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |