Bookmarks

Hi,
How I can create an index in a report which are referencing bookmarks in the
report?
I would like to have this format:
[Name / Title of bookmark] [Page Number]
...
[Name / Title of bookmark] [Page Number]
Can I get the page numer with an expression?
ThanksThis is something I asked for in the early days of RS2000,
it was a problem that could only be resolved by using two passes.
Generate the data, save it into a data table adding a row number to
each record. If you know how many rows fit a page you can then generate
the report then construct an index at the end using the row number.
I'm aware this is far from ideal, but I can't think of another way.
The reason it's difficult is that the different rendering methods all
have different ideas about what a page is.
Cheers
Chris
Eric wrote:
> Hi,
> How I can create an index in a report which are referencing bookmarks
> in the report?
> I would like to have this format:
> [Name / Title of bookmark] [Page Number]
> ...
> [Name / Title of bookmark] [Page Number]
>
> Can I get the page numer with an expression?
> Thanks|||Thanks Chris,
But this is not an option because the report isn't based on one dataset or
table, the report format is mixed.
"Chris" wrote:
> This is something I asked for in the early days of RS2000,
> it was a problem that could only be resolved by using two passes.
> Generate the data, save it into a data table adding a row number to
> each record. If you know how many rows fit a page you can then generate
> the report then construct an index at the end using the row number.
> I'm aware this is far from ideal, but I can't think of another way.
> The reason it's difficult is that the different rendering methods all
> have different ideas about what a page is.
> Cheers
> Chris
>
> Eric wrote:
> > Hi,
> >
> > How I can create an index in a report which are referencing bookmarks
> > in the report?
> >
> > I would like to have this format:
> >
> > [Name / Title of bookmark] [Page Number]
> > ...
> > [Name / Title of bookmark] [Page Number]
> >
> >
> > Can I get the page numer with an expression?
> >
> > Thanks
>
> --
>|||Hi Eric,
Based on my research, Chris's suggestion seems to be the only way to do
this. You have to do this with the dataset. Hope you can understand.
You may submit feedback on this via the link below to improve our product.
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Thanks!
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei
Thanks, but how you want to calculate the pagenumber if you havbe different
tables, freetext, charts, etc.
My questions was also about a custom render item.
Because in the SRSS2005 library you have also a class named 'Bookmark' &
'Bookmarks', where all the bookmarks are stored.
It's there no way to access these classes / properties?
Thanks|||Hi Eric,
Thanks for the update.
I don't think you can use the bookmark directly in a report designer.
You can use the class only in your custom rendering extensions for
Reporting Services.
A rendering extension is a component or module of a report server that
transforms report data and layout information into a device-specific
format. SQL Server Reporting Services includes six rendering extensions:
HTML, Excel, CSV or Text, XML, Image, and PDF. You can create additional
rendering extensions to generate reports in other formats.
The Reporting Services Extension Library is a set of classes, interfaces,
and value types that are included in Reporting Services. This library
provides access to system functionality and is designed to be the
foundation on which Microsoft .NET Framework applications can be used to
extend Reporting Services components.
You may find the information in the Reporting Services Extensions section
in SQL Books online.
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for your answer.
I have read the documentation and I'm aware of the rendering extension and
also the custom render item.
>>I don't think you can use the bookmark directly in a report designer.
I was talking about a custom report item, like a rendering extension but one
level deeper.
http://msdn2.microsoft.com/en-us/library/ms345259(SQL.90).aspx
>>You can use the class only in your custom rendering extensions for
Reporting Services.
And for a custom report item? Or can the item not access all bookmarks,
because the report wasn't yet rendered fully?
Thanks