|
|
|
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 Using a report in searches: parameters? Posted by Diego F. at 2/1/2006 4:59:22 PM Hello.
I need to use RS in my web application and I intend to use the URL
integration to call the reports. I know more or less how to do it, but my
only trouble is to use it in search pages.
As the search result is a variable set, I need a way to pass the search
parameters to the report....more >>
How to Dynamically set the width of report body. Posted by S Girase at 2/1/2006 4:06:53 PM I have a report where we display a certain number of columns based on
some condition. If I display all the columns then the report looks okay
but if I display fewer columns then there is empty space on each row
which would have otherwise been occupied by the hidden columns of the
table. Is there...more >>
scopeing problem in an aggregate function Posted by gacar101 at 2/1/2006 3:05:27 PM I have a matrix with two column groups. I need to be able have the user
select from my boolean parameter and change the scope on my aggregate
function. I already have my boolean parameter setup. the two groups are
called matrix1_Year and matrix1_Hub. i used the following expression in my
...more >>
sub-report or drilldown Posted by Jim Abel at 2/1/2006 1:33:29 PM I would like suggestions as to the “best practice†of generating a report
that has a large number of rows returned from a single query to improve the
performance.
The current query has about 75,000 rows returned to the result set as it
currently stands. This takes about 8 minutes to rende...more >>
Custom Date Format Posted by newsgroups NO[at]SPAM bendcycling.org at 2/1/2006 1:20:05 PM I need to change the date format from mmddyyyy to yyyymmdd and I'm not
quite sure how to accomplish it. Obviously there are default date
views, but yyyymmdd is not one of them. I'm guessing I need to create
an expression. Can someone help?
Thanks,
tp
...more >>
How to show a rectangle in a SQL report Posted by SDRoy at 2/1/2006 12:12:43 PM Does anyone know how I can display a rectangle in the rendered SQL report?
I need this to assist the users of the report to have an area in the printed
report column so that they could do a manual check mark or some kind of a
mark on the rows of the report. I tried to place an image but it slow...more >>
RS2005 Print Legal Posted by jhcorey NO[at]SPAM yahoo.com at 2/1/2006 12:03:42 PM Hello,
I'm trying to automate printing to legal size paper from the web
ReportViewer control.
In my Report Properties / Layout I have Page Width= 14in and Page
Height= 8.5in.
When the report renders I hit the print icon. It shows that the report
will print to landscape,
but the paper si...more >>
Multi Value Parameters and Stored Procedures Posted by Roland Müller at 2/1/2006 11:28:36 AM Hi all, I want to submit a MVP from a Report to the SQL Server. 2 Problems:
1: "exec @mvp" does not work because the MVP is recognized as more
parameters due to the Commata in the string
2. The procedure cannot work with an "select * where parameter in (MVP)"
when as string like 'a','b','c' ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
file share Posted by Pete Fuller at 2/1/2006 10:42:49 AM hi
i do not get any errors, but i do not see my reports in the shared folder.
here is my configuraiton table
title ext folder render username pwd write
param1 param2
19051, pdf, \\sqlrpt2\krbi ,NULL ,kr_net\pfuller, rewt, NULL, 19051 ,
12/31/2005
18629...more >>
User!UserID is not UPN Posted by Matt at 2/1/2006 10:03:26 AM I am using RS2005. I display the logged in user on reports when they are
rendered in HTML by using the User!UserID parameter. It always displays as
"DOMAIN\username" no matter how I am logged in. That is fine when I log in
as "DOMAIN\username" but when users login with the User Principal Na...more >>
How do I use a comma separated parameters list Posted by DragonVic at 2/1/2006 6:18:31 AM SQL allows me to use the IN statement, I need to use it with reporting
services using parameters, is it posible? The Idea is to dump a comma
separated list into the parameter box and have it procesed by RS.
ie. SELECT * FROM USERS WHERE ID IN(@ID_LIST)
@ID_LIST = '1,2,3,4...'...more >>
Using web part Report Viewer in SPPS 2003 Posted by Pasquale at 2/1/2006 5:31:22 AM I want to use the Report Viewer web part inside SPPS 2003.
In order to do it, I have created a page including this web part and then
I have specified the Url address of Report Manager; but when I write
the path of my report, this is always incorrect.
The format of Url address of Report Manager i...more >>
Multi-valued parameters against DB2 Posted by Robert Hamlin at 2/1/2006 5:19:30 AM It seems like multi-valued parameters against DB2 are not supported with
Reporting Services 2005, it only works if using SQL Server, Oracle or
Analysis Services.
Are there any workarounds to solve this in RS2005 ?
...more >>
Reporting Services and SQL Express Posted by Saracen at 2/1/2006 3:16:27 AM Hi, I have the following scenario:
I have a server machine which has SQL Server Standard and Reporting Services
running on it. We build our reports using the reporting designer and publish
those reports. Once published we can run those reports which will generate a
report against the Server D...more >>
Using SQL selection keyword IN Posted by John Mason at 2/1/2006 3:00:34 AM I am trying to use a parameter to filter data for a report. I am using the IN
keyword in the WHERE clause, i.e. WHERE (fee.fee_earner IN (@feeEarners))
When I run the report I cannot seem to enter any values that the SQL
recognises, e.g. if I want to search for 'ASX' and 'LOC', I enter 'ASX' , ...more >>
Problem with subreport Posted by FaensenD NO[at]SPAM rki.de at 2/1/2006 1:07:15 AM I have created a report that worked fine until I added a subreport. The
subreport has a parameter 'ParentId' that is set to Fields!Id.Value
which is the Id of the parent record.
In the preview I get an error message:
"An error occurred during local report processing.
An internal error occured...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |