Hi there!
I have a question about the interactive behavior in the reports.
Is it possible to add interactive sorting capability for the report.
By this I mean that a user can click on the column header of the
report and the report will be sorted in the appropriate way.
Another question is about drilldown reports.
Lets consider the situation when, we a have a group
and no data in that group. The group column ( e.g. Employee
name ) was selected as the field on which some other columns depend.
We have a drilldown and a "+" sign. So the question comes if there is no
data in the group, how we can disable "+" sign or not show it?
TIA
--
Vadym StetsyakVadym Stetsyak wrote:
> Hi there!
> I have a question about the interactive behavior in the reports.
> Is it possible to add interactive sorting capability for the report.
> By this I mean that a user can click on the column header of the
> report and the report will be sorted in the appropriate way.
> Another question is about drilldown reports.
> Lets consider the situation when, we a have a group
> and no data in that group. The group column ( e.g. Employee
> name ) was selected as the field on which some other columns depend.
> We have a drilldown and a "+" sign. So the question comes if there is
> no data in the group, how we can disable "+" sign or not show it?
> TIA
> --
> Vadym Stetsyak
There is a slightly grubby hack that will allow you to (sort of) sort
on the column headers. I want to add this to the sorting/grouping
article at
http://highlyobscure.net/howto/sorttablewithparameters/sorttable.htm
but haven't had time. Basically you add a rectangle to the column
header with 2 more textboxes in it, to link to ascending and descending
sorted reports. Note that in SP1 you can't put little images of arrows
in the textboxes because RS errors out if you do; you have to use text.
If you're familiar with parameter-based sorting (and it sounds like you
are) you can skip the article above and go straight to
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=6
a347b53-5594-40f9-861d-876beabeda16 , a great sample.
As to the second question, I dunno. Let us know if you figure it out
8-).
hth
Highly Obscure
Monday, March 19, 2012
interactivity in RS
Labels:
behavior,
capability,
database,
interactive,
interactivity,
microsoft,
mysql,
oracle,
report,
reports,
server,
sorting,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment