CustomReportItem Element in an RDL

I have 3 related questions, thanks ahead of time for any help...
1 - Does anyone know of any documentation and/or examples on how to use the
CustomReportItem Element in an RDL doc? MS has a PDF available about the
RDL specification, RDLDEC03.PDF, but it is not very clear on how to use it.
2 - Is there a way to write your own custom Report Item that could be added
to the toolbox?
3- Specifically, when a report is rendered as HTML, we want to add a
checkbox and a bit of JavaScript to allow users to select/deselect report
records. Is there another way besides 1 or 2?
Thanks again!#1, #2:
The currently available RDL spec describes the CustomReportItem element as
defined in RS 2000. The specification is getting changed/extended in RS
2005. We are planning on making a comprehensive sample for implementing a
design time control (report designer) and a runtime control (report server)
available when RS 2005 gets released.
#3:
This is only possible if you write your own custom rendering extension (on
top of RS 2000 or RS 2005). You cannot do your own Javascript just through a
CustomReportItem processing/runtime control.
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott LaFave" <slafave@.trendmls.com> wrote in message
news:eDKv2%23$TFHA.2812@.tk2msftngp13.phx.gbl...
>I have 3 related questions, thanks ahead of time for any help...
> 1 - Does anyone know of any documentation and/or examples on how to use
> the CustomReportItem Element in an RDL doc? MS has a PDF available about
> the RDL specification, RDLDEC03.PDF, but it is not very clear on how to
> use it.
> 2 - Is there a way to write your own custom Report Item that could be
> added to the toolbox?
>
> 3- Specifically, when a report is rendered as HTML, we want to add a
> checkbox and a bit of JavaScript to allow users to select/deselect report
> records. Is there another way besides 1 or 2?
> Thanks again!
>|||hi,
About #2, is there a step by step RS 2000 example code ?
Thanks.
> #1, #2:
> The currently available RDL spec describes the CustomReportItem element as
> defined in RS 2000. The specification is getting changed/extended in RS
> 2005. We are planning on making a comprehensive sample for implementing a
> design time control (report designer) and a runtime control (report
server)
> available when RS 2005 gets released.
> #3:
> This is only possible if you write your own custom rendering extension (on
> top of RS 2000 or RS 2005). You cannot do your own Javascript just through
a
> CustomReportItem processing/runtime control.
>
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Scott LaFave" <slafave@.trendmls.com> wrote in message
> news:eDKv2%23$TFHA.2812@.tk2msftngp13.phx.gbl...
> >I have 3 related questions, thanks ahead of time for any help...
> >
> > 1 - Does anyone know of any documentation and/or examples on how to use
> > the CustomReportItem Element in an RDL doc? MS has a PDF available
about
> > the RDL specification, RDLDEC03.PDF, but it is not very clear on how to
> > use it.
> >
> > 2 - Is there a way to write your own custom Report Item that could be
> > added to the toolbox?
> >
> >
> > 3- Specifically, when a report is rendered as HTML, we want to add a
> > checkbox and a bit of JavaScript to allow users to select/deselect
report
> > records. Is there another way besides 1 or 2?
> >
> > Thanks again!
> >
> >
>

CustomReportItem

Hi,
I am trying to find out information on how to use the CustomReportItem node.
The online documentation (and RDL specification) talks about accessing a
RichTextControl as an example but does not give details on full
implementation required. If CustomReportItem is currently supported
(searching this board seems to imply it is not supported in current release?)
can someone point me in the direction of a code example or guide on how to
use this node if one exists.
Thanks,
RichardThe structure/implementation for CustomReportItem will change significantly
in RS 2005. The functionality will be available in the upcoming RS 2005 Beta
3 (actually is already in the last community preview releases of SQL 2005).
Not sure if the documentation will be already contained in the RS 2005 Beta
3 BOL release though.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"R.Shiels" <R.Shiels@.discussions.microsoft.com> wrote in message
news:6D369D32-9B26-43C7-A1D7-48BEA896B75B@.microsoft.com...
> Hi,
> I am trying to find out information on how to use the CustomReportItem
node.
> The online documentation (and RDL specification) talks about accessing a
> RichTextControl as an example but does not give details on full
> implementation required. If CustomReportItem is currently supported
> (searching this board seems to imply it is not supported in current
release?)
> can someone point me in the direction of a code example or guide on how to
> use this node if one exists.
> Thanks,
> Richard
>

Customizing report columns count at runtime

Hello all. In my application I have some rdl file that determines
general look of my report. Also I have a table that has 20 columns I
have stored proc that returns dataset that also has 20 columns but may
have filled less than 20 columns (5 for example). The problem is how
to hide another (20-n) columns.
Now I simply pass params to report and hide columns according to these
params.In this case I have normally rendered report on screen and I'm
experiencing problems with printing: I have my "n" columns printed
normally then long space and table end line ( in another printed
page ) what looks ugly.
So my question is: can I dynamically manage columns count ( without
having to generate rdl programatically :) ), for example pass report
param "ColumnsCount" and then have so much columns as I want (also
apply binding values for these columns)
or
is there a method how to hide my (20-n) columns and minimize table so
I do not have that big white space and ugly line after it.
Any ideas?
Thanks in advanceOn Apr 30, 4:15 am, mblishch <mykhaylo.blis...@.gmail.com> wrote:
> Hello all. In my application I have some rdl file that determines
> general look of my report. Also I have a table that has 20 columns I
> have stored proc that returns dataset that also has 20 columns but may
> have filled less than 20 columns (5 for example). The problem is how
> to hide another (20-n) columns.
> Now I simply pass params to report and hide columns according to these
> params.In this case I have normally rendered report on screen and I'm
> experiencing problems with printing: I have my "n" columns printed
> normally then long space and table end line ( in another printed
> page ) what looks ugly.
> So my question is: can I dynamically manage columns count ( without
> having to generate rdl programatically :) ), for example pass report
> param "ColumnsCount" and then have so much columns as I want (also
> apply binding values for these columns)
> or
> is there a method how to hide my (20-n) columns and minimize table so
> I do not have that big white space and ugly line after it.
> Any ideas?
> Thanks in advance
You should be able to toggle visibility of the columns in the report
via an expression. Right-clicking the column in the table control and
selecting properties and select the tab for visibility and then enter
an expression that checks for the sum of the column's value. Something
like this should work:
=iif(Sum(Fields!ColumnItemX.Value) > 0, "true", "false")
Also, you might want to make sure that for individual cells, the
shrink to fit (or similar wording) is selected and that you
conditionally set border styles based on if the column is visible
(via, Properties -> Border Style: =iif(Sum(Fields!ColumnItemX.Value) >
0, "Solid", "None"))
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant