Parameter Display in Report: Display "Select All" rather than all selections

Dear Anyone,

We have reports in RS that includes a display of selected parameter values in the page footer of the report. When "Select All" is selected in the parameter, all parameter values are displayed in our page footer. We would like to rather display the words "Select All" rather than displaying all of the available selections when select all is selected. Is there a way to do this?

Thanks,
Joseph

If you know the number of parameters in the list, you could compare that number with the count of the parameter collection.
Example:

Set up a text box, and in the expression put:

=iif(Parameters!yourParameter.Count = yourCount, "Select All", Join(Parameters!yourParameter,", "))

That is what I have done. There could be a simpler way, I just haven't stumbled upon it yet!

BobP

|||If only theres a way to determine how many rows or records are returned by the dataset in the parameter.

parameter

Dear all,

May I know is it possible for me to pass the parameters from aspx page to rdl? If so, then how to do that? FYI, the data displayed in my rdl page is depend on the various parameters pass in from that corresponding aspx page. Thanks

Levine

What exactly do you mean?

|||

I have a class file in visual studio 2005 and I'm thinking of using it to pass the parameters to my rdl (sql server 2005) but I don't know how to made the rdl accept (get) the parameters pass to it. Thanks

|||

by the way.. did you use reportviewer control with rdlc or rdl?

If you are using rdlc then this is how i understand

tell me if i'm wrong, did you mean that you want to display a dynamic data (rdlc) in your page depending on the parameter?

scenario:

In my page ,I have drop down list for year wherein a user can choose an options, if user select an specific option then it will display the data in reportviewer based on the year selected?

|||

this is easy

First it is necessary to ccreate aReportParameter object (be sure you have a reference toMicrosoft.Reporting.WebForms). The contructor takes two string parameters one for the Name and one for the Value. A new parameter would look like the code below.

ReportParameter myReportParameter = new ReportParameter("Id",
Request.QueryString["Id"]);

Next, parameters on the ReportViewer are set using theSetParameters method. It takes an array of ReportParameter, so you would have syntax like the following.

MyReportViewer.ServerReport.SetParameters(
new ReportParmeter[] { myReportParameter });

you can use report viewer control which you can download from this linkhttp://www.gotreportviewer.com/

|||

Hello,

Thanks for the help. But what I'm trying to do is to create a rdl file which can accept the parameters which are passed from aspx page. May I know is it in a way that the rdl will have a "container" to get those parameters? Thanks again :)

Levine

|||

Have you tried using aspnet Reportviewer control?

parallelism sql 2000

Dear friends,
I've been reading some docs about parallelism but I'm still not sure how it
works. My doubt is:
To work with parallelism, do I need to use partitioned tables/index? If yes,
how?
I'm using a dell power edge 6000 with 4 processors.
kind regards
BertoliYou don't need to have partitioned tables to use parallelism. All you need
are multiple CPU's. Parallelism is the striping of a query across multiple
CPU's. In many cases, this speed up the query. In a minority of cases, it
slows down the query. However, you can turn off parallelism for that query
by using OPTION (MAXDOP 1).
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Bertoli" <bertoli@.bertoli.com.br> wrote in message
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
Dear friends,
I've been reading some docs about parallelism but I'm still not sure how it
works. My doubt is:
To work with parallelism, do I need to use partitioned tables/index? If yes,
how?
I'm using a dell power edge 6000 with 4 processors.
kind regards
Bertoli|||SQL Server will parallelize queries as it is able (if you allow it to do
so). You do NOT need to create partitioned tables to use this feature.
Keith Kratochvil
"Bertoli" <bertoli@.bertoli.com.br> wrote in message
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
> Dear friends,
> I've been reading some docs about parallelism but I'm still not sure how
> it
> works. My doubt is:
> To work with parallelism, do I need to use partitioned tables/index? If
> yes,
> how?
> I'm using a dell power edge 6000 with 4 processors.
> kind regards
> Bertoli
>|||tks guys
Bertoli
"Bertoli" <bertoli@.bertoli.com.br> escreveu na mensagem
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
> Dear friends,
> I've been reading some docs about parallelism but I'm still not sure how
it
> works. My doubt is:
> To work with parallelism, do I need to use partitioned tables/index? If
yes,
> how?
> I'm using a dell power edge 6000 with 4 processors.
> kind regards
> Bertoli
>|||You can get more info from BOL by searching for
* Max degree of parallelism
Thanks
Ajay Rengunthwar

parallelism sql 2000

Dear friends,
I've been reading some docs about parallelism but I'm still not sure how it
works. My doubt is:
To work with parallelism, do I need to use partitioned tables/index? If yes,
how?
I'm using a dell power edge 6000 with 4 processors.
kind regards
BertoliYou don't need to have partitioned tables to use parallelism. All you need
are multiple CPU's. Parallelism is the striping of a query across multiple
CPU's. In many cases, this speed up the query. In a minority of cases, it
slows down the query. However, you can turn off parallelism for that query
by using OPTION (MAXDOP 1).
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Bertoli" <bertoli@.bertoli.com.br> wrote in message
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
Dear friends,
I've been reading some docs about parallelism but I'm still not sure how it
works. My doubt is:
To work with parallelism, do I need to use partitioned tables/index? If yes,
how?
I'm using a dell power edge 6000 with 4 processors.
kind regards
Bertoli|||SQL Server will parallelize queries as it is able (if you allow it to do
so). You do NOT need to create partitioned tables to use this feature.
--
Keith Kratochvil
"Bertoli" <bertoli@.bertoli.com.br> wrote in message
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
> Dear friends,
> I've been reading some docs about parallelism but I'm still not sure how
> it
> works. My doubt is:
> To work with parallelism, do I need to use partitioned tables/index? If
> yes,
> how?
> I'm using a dell power edge 6000 with 4 processors.
> kind regards
> Bertoli
>|||tks guys
Bertoli
"Bertoli" <bertoli@.bertoli.com.br> escreveu na mensagem
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
> Dear friends,
> I've been reading some docs about parallelism but I'm still not sure how
it
> works. My doubt is:
> To work with parallelism, do I need to use partitioned tables/index? If
yes,
> how?
> I'm using a dell power edge 6000 with 4 processors.
> kind regards
> Bertoli
>|||You can get more info from BOL by searching for
* Max degree of parallelism
Thanks
Ajay Rengunthwar

Paging Advice Needed

Dear Group

A while ago I've asked how paging is possible and have read the articles on
aspfaq.com. Great work, esp. the speed comparison of all the different
techniques. Thank you to everyone who has responded to my post. Somewhow
Google didn't let me reply to the thread!

All of the methods described work perfectly fine until I'm trying to
implement a WHERE or ORDER BY DESC on a particular field. E.g. Create all
pages but sort on a date field DESC doesn't start with the lowest date on
the first page and the highest date on the last page but all dates mixed up.

As a workaround I'm at first using a cursor to populate a temporary table
e.g. SELECT * FROM MyTable WHERE MyField1 = Condition ORDER BY MyField2
which only contains the data I would like to use to create the pages. I'm
using a cursor since I read that a normal SELECT to poulate the temporary
table doesn't always guarantee that rows are inserted in the correct order.

Next I'm creating the individual pages with the Count and Page.Rank method
off the temporary table.

This method is not the best in performance and I'm sure there must be
another
way to perform paging with filtering and sorting. I'm grateful for any tipps
you have.

Thanks for your time & efforts!

MartinHi!
Just letting you know that I've found an answer to my problem at
http://weblogs.asp.net/pwilson/arch...0/10/31456.aspx

titled 'Sorting and Paging in SQL Server' (including Filtering).
It's easy to use and pretty fast!

Martin

"Martin Feuersteiner" <theintrepidfox@.hotmail.com> wrote in message
news:c5rqu3$efu$1@.titan.btinternet.com...
> Dear Group
> A while ago I've asked how paging is possible and have read the articles
on
> aspfaq.com. Great work, esp. the speed comparison of all the different
> techniques. Thank you to everyone who has responded to my post. Somewhow
> Google didn't let me reply to the thread!
> All of the methods described work perfectly fine until I'm trying to
> implement a WHERE or ORDER BY DESC on a particular field. E.g. Create all
> pages but sort on a date field DESC doesn't start with the lowest date on
> the first page and the highest date on the last page but all dates mixed
up.
> As a workaround I'm at first using a cursor to populate a temporary table
> e.g. SELECT * FROM MyTable WHERE MyField1 = Condition ORDER BY MyField2
> which only contains the data I would like to use to create the pages. I'm
> using a cursor since I read that a normal SELECT to poulate the temporary
> table doesn't always guarantee that rows are inserted in the correct
order.
> Next I'm creating the individual pages with the Count and Page.Rank method
> off the temporary table.
> This method is not the best in performance and I'm sure there must be
> another
> way to perform paging with filtering and sorting. I'm grateful for any
tipps
> you have.
> Thanks for your time & efforts!
> Martin

page setup on crystal report 8.5

dear babu,
i want to ask you a question on crystal report 8.5.
i'm using crystal report viewer from visual basic 6.0 to view reports but i'm found problems to setup page margin until this time. can you help me for a while ??

how to view page setup on my crystal report viewer so end user have flexibility to customize the margin ??

thanks for your help.

emmileI think you cannot do that at run time
You need to design it in Design time