Showing posts with label lines. Show all posts
Showing posts with label lines. Show all posts

Friday, March 23, 2012

How to Increase the Length of Drop Down Menu Parameters

Is there a way to make the drop down parameters longer so more than
5-6 lines show?
Thanks
BobOn Dec 21, 6:00 am, Bob <b...@.ebearings.com> wrote:
> Is there a way to make the drop down parameters longer so more than
> 5-6 lines show?
> Thanks
> Bob|||On Dec 21, 6:00 am, Bob <b...@.ebearings.com> wrote:
> Is there a way to make the drop down parameters longer so more than
> 5-6 lines show?
> Thanks
> Bob
As far as I know, this flexibility does not exist. If a custom ASP.NET
application is an option, you might consider creating one of those and
use one of the drop-down list/etc controls and then use the report
viewer control, the Reporting Services Web Service or URL access to
integrate the actual SSRS report. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Sunday, February 19, 2012

How to hide specific rows in TABLE?

My report result has 100 lines of records (details) and I only want to
display the first 10 rows and hide the rest of them. How can I achieve
that?
Thanks,
KeithYou can set the visibilty property of the row based on the count of some
distinict item in the details being less than ten.
for example the expression for the visibiltiy property might read:
iif( Count( Fields!UniqueDetailItem.Value, "GroupNameIfNeeded" ) > 10,
True, False )
Hope this helps.
"Keith" wrote:
> My report result has 100 lines of records (details) and I only want to
> display the first 10 rows and hide the rest of them. How can I achieve
> that?
> Thanks,
> Keith
>|||Thanks Rand!
I tried with this expression something like:
=iif( Count( Fields!zzcusteu.Value) > 10, True, False )
But it still doesn't work. It just counted the total # of rows, if >10,
then hide all the rows (I want to the first 10 rows to be visible).
Any idea?
Thanks,
Keith|||Hi:
You can use this expression:
=iif( RowNumber( Nothing) > 10, True, False )
Since Count() return the total number of records, but RowNumber() return
the current row number
Kent
"Keith" wrote:
> Thanks Rand!
> I tried with this expression something like:
> =iif( Count( Fields!zzcusteu.Value) > 10, True, False )
> But it still doesn't work. It just counted the total # of rows, if >10,
> then hide all the rows (I want to the first 10 rows to be visible).
> Any idea?
> Thanks,
> Keith
>