I have encountered a problem where repeated items are only rendered to the
first page. Apparently this is a known issue, but the workaround of using
the page header doesn't work for me, unless I'm missing some way to overlap
the header and the body of the report.
I am trying to display a watermark behind the body of the report in a very
pale font, and controlling whether it is hidden via logic in the report.
To do this I used a texbox in the body of the report, allowing the following
table to overlap the watermark textbox. I also set RepeatWith to repeat on
the table it overlaps. This previewed fine on Page 1, but not on subsequent
pages.
I have tried putting the watermark textbox on a page header, table header
etc but could not make it overlap with the table in the body of the report,
even using rectangles etc.
I would appreciate any suggestions.
Scott.Hi Scott,
Thanks for your post.
From your descriptions, I understood that you would like to realize
watermark in each page of your reports but only the first page turn out to
be normally. Have I understood you? Correct me if I was wrong.
As you have noticed that it is an known issue of us and I am afraid you
could only make watermark in page header and make it overlaps there.
Watermakr in the body will not been shown in the following pages.
If I misunderstood the issue, to get a better picture of the problem we
would like to reproduct the issue on our end. To expedite the process,
please provide us the detailed reproduce steps.
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Thanks for the reply.
You have described the problem correctly. I cannot repeat a text box in the
body of the report using RepeatWith. I can repeat a text box in the page
header, but as you point out, it will not overlap the table in the body of
the report.
Can you confirm that the original problem (can't repeat in the report body)
is a bug in Reporting Services 2000 and SP1? If so, is it likely to be fixed
in SQL Server 2005? Perhaps it is already fixed in Beta 2. I have a copy,
but have not yet tried it.
Is there a workaround available in my situation where I need to overlap with
a table in the report body?
Your advice is appreciated.
Scott.
""Mingqing Cheng [MSFT]"" wrote:
> Hi Scott,
> Thanks for your post.
> From your descriptions, I understood that you would like to realize
> watermark in each page of your reports but only the first page turn out to
> be normally. Have I understood you? Correct me if I was wrong.
> As you have noticed that it is an known issue of us and I am afraid you
> could only make watermark in page header and make it overlaps there.
> Watermakr in the body will not been shown in the following pages.
> If I misunderstood the issue, to get a better picture of the problem we
> would like to reproduct the issue on our end. To expedite the process,
> please provide us the detailed reproduce steps.
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Scott,
Thanks for your prompt updates!
I will do more research to see whether there is any workaround or it will
be fixed in SQL Server 2005 via internal ways, I will keep you updated as
soon as I find anything valueable to add.
Anyway, I would like to set your expectation that SQL Server 2005 or its
related issues are not offically supported yet. If you want to interact
this issue further with the Microsoft SQL Server division product team
members, I suggest you go the newsgroup below
Welcome to the Microsoft SQL Server 2005 Beta 2 Newsgroups
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
cid=us
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Thanks Mingqing,
I understand that SQL Server 2005 is beta and unsupported. I am currently
using Crystal .NET as supplied with VS 2003 and would like to migrate to
Reporting Services. However, I will not be able to do this until I have a
resolution to this issue. My real question is whether this bug will be
corrected for the commercial release of SQL Server 2005, or perhaps even in a
fix to SQL Server 2000.
I will also need the Reporting Services control for Windows Forms which
apparently will be available in VS 2005 Beta 2. If I can confirm
functionality in the beta versions, I will start the migration process to
ensure I am ready for the commercial release of these products next year.
Looking forward to your response on the SQL Server 2005 question.
Thanks again,
Scott.
""Mingqing Cheng [MSFT]"" wrote:
> Hi Scott,
> Thanks for your prompt updates!
> I will do more research to see whether there is any workaround or it will
> be fixed in SQL Server 2005 via internal ways, I will keep you updated as
> soon as I find anything valueable to add.
> Anyway, I would like to set your expectation that SQL Server 2005 or its
> related issues are not offically supported yet. If you want to interact
> this issue further with the Microsoft SQL Server division product team
> members, I suggest you go the newsgroup below
> Welcome to the Microsoft SQL Server 2005 Beta 2 Newsgroups
> http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
> cid=us
>
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>|||Hi Scott,
Thanks for your patience and cooperation!
I have talked with our development team and here is the answer from them.
Unfortunately, overlapping items isn't supported in HTML, which is only
supported working in PDF. The problem with RepeatWith in PDF is really a
known issue, however, they haven't decided yet whether it will be fixed in
SQL Server 2005 as a large code change would be required and the time is
limited.
Your alternate approach (using a background image) should work if you make
your image the same size as the usable page (the page size minus the
margins, page header and page footer) and mark it to repeat.
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||When you say "using a background image", do you mean a gif or jpg image for
example? I am trying to use text as a watermark, so this approach is not
really workable unless I make the text static and produce a graphic file
external to RS.
Is it possible to use an external file as a background image in the report.
That way I could perhaps choose between a number of files at runtime, or
maybe try to generate the file on the fly. Is this feasible?
Scott.
""Mingqing Cheng [MSFT]"" wrote:
> Hi Scott,
> Thanks for your patience and cooperation!
> I have talked with our development team and here is the answer from them.
> Unfortunately, overlapping items isn't supported in HTML, which is only
> supported working in PDF. The problem with RepeatWith in PDF is really a
> known issue, however, they haven't decided yet whether it will be fixed in
> SQL Server 2005 as a large code change would be required and the time is
> limited.
> Your alternate approach (using a background image) should work if you make
> your image the same size as the usable page (the page size minus the
> margins, page header and page footer) and mark it to repeat.
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Yes, with SP1 of RS 2000 you can use external images from network protocols
(e.g. http:) or network shares. Make sure to follow the instructions for
configuring the unattended execution account for the report server if you
follow that path. See:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
Alternatively, you could embed several images in the report and use
expressions to switch among them.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott" <scott@.msdn.com.au> wrote in message
news:B0CD4750-C75F-4E02-9269-1730450FCA4C@.microsoft.com...
> When you say "using a background image", do you mean a gif or jpg image
for
> example? I am trying to use text as a watermark, so this approach is not
> really workable unless I make the text static and produce a graphic file
> external to RS.
> Is it possible to use an external file as a background image in the
report.
> That way I could perhaps choose between a number of files at runtime, or
> maybe try to generate the file on the fly. Is this feasible?
> Scott.
>
>
> ""Mingqing Cheng [MSFT]"" wrote:
> > Hi Scott,
> >
> > Thanks for your patience and cooperation!
> >
> > I have talked with our development team and here is the answer from
them.
> >
> > Unfortunately, overlapping items isn't supported in HTML, which is only
> > supported working in PDF. The problem with RepeatWith in PDF is really a
> > known issue, however, they haven't decided yet whether it will be fixed
in
> > SQL Server 2005 as a large code change would be required and the time is
> > limited.
> >
> > Your alternate approach (using a background image) should work if you
make
> > your image the same size as the usable page (the page size minus the
> > margins, page header and page footer) and mark it to repeat.
> >
> > Thank you for your patience and corperation. If you have any questions
or
> > concerns, don't hesitate to let me know. We are here to be of
assistance!
> >
> >
> > Sincerely yours,
> >
> > Mingqing Cheng
> >
> > Online Partner Support Specialist
> > Partner Support Group
> > Microsoft Global Technical Support Center
> > ---
> > Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> > This posting is provided "as is" with no warranties and confers no
rights.
> > Please reply to newsgroups only, many thanks!
> >
> >|||Robert,
Thanks for the feedback. It sounds like this approach might work for static
background images, but really I want to have some dynamic text in the
watermark. Basically, the watermark is only visible if the user is
unregistered, and I would like to show an expiry date of the evaluation
period. I thought there may be some way to dynamically render an image from
the text, to display as a background, but that's what this text box is
supposed to do anyway!!!
I'm a bit disappointed with the response that this bug probably won't make
it in to SQL 2005, when it seems to have been a known issue in Reporting
Services for some time. It really hurts me to say this, but I think I will
have to have to stick with Crystal until this issue is resolved. You don't
know how much I was hoping to find a better reporting solution.
If you have any updates on a fix for this issue in SQL 2005 I won't be
*very* grateful if you would let me know.
Scott.
"Robert Bruckner [MSFT]" wrote:
> Yes, with SP1 of RS 2000 you can use external images from network protocols
> (e.g. http:) or network shares. Make sure to follow the instructions for
> configuring the unattended execution account for the report server if you
> follow that path. See:
> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
> Alternatively, you could embed several images in the report and use
> expressions to switch among them.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Scott" <scott@.msdn.com.au> wrote in message
> news:B0CD4750-C75F-4E02-9269-1730450FCA4C@.microsoft.com...
> > When you say "using a background image", do you mean a gif or jpg image
> for
> > example? I am trying to use text as a watermark, so this approach is not
> > really workable unless I make the text static and produce a graphic file
> > external to RS.
> >
> > Is it possible to use an external file as a background image in the
> report.
> > That way I could perhaps choose between a number of files at runtime, or
> > maybe try to generate the file on the fly. Is this feasible?
> >
> > Scott.
> >
> >
> >
> >
> > ""Mingqing Cheng [MSFT]"" wrote:
> >
> > > Hi Scott,
> > >
> > > Thanks for your patience and cooperation!
> > >
> > > I have talked with our development team and here is the answer from
> them.
> > >
> > > Unfortunately, overlapping items isn't supported in HTML, which is only
> > > supported working in PDF. The problem with RepeatWith in PDF is really a
> > > known issue, however, they haven't decided yet whether it will be fixed
> in
> > > SQL Server 2005 as a large code change would be required and the time is
> > > limited.
> > >
> > > Your alternate approach (using a background image) should work if you
> make
> > > your image the same size as the usable page (the page size minus the
> > > margins, page header and page footer) and mark it to repeat.
> > >
> > > Thank you for your patience and corperation. If you have any questions
> or
> > > concerns, don't hesitate to let me know. We are here to be of
> assistance!
> > >
> > >
> > > Sincerely yours,
> > >
> > > Mingqing Cheng
> > >
> > > Online Partner Support Specialist
> > > Partner Support Group
> > > Microsoft Global Technical Support Center
> > > ---
> > > Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> > > This posting is provided "as is" with no warranties and confers no
> rights.
> > > Please reply to newsgroups only, many thanks!
> > >
> > >
>
>|||The closest you can get today to achieve the dynamic background image /
watermark is to write a custom assembly which takes a string parameter (i.e.
the watermark message) and generates an image on-the-fly and returns it.
After you have implemented the custom assembly you would perform these steps
in report designer:
* Add a reference to the custom assembly through the VS menu: Report -
Report Properties - References
* Add an image to your report
* Set the image type to Database
* Set the image mimetype to e.g. image/png
* For the image value use an expression like
=MyCustomAssembly.GenerateImageFromText(Fields!ExpirationDate.Value)
Notes:
* the custom assembly has to return the image as byte[].
* you should follow the links provided below about custom assemblies and
code access security in RS because e.g. you may need to assert security
permission inside the custom assembly when using certain .NET classes and
methods for generating an image.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_rdl_6d0i.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/dngrfCodeAccessSecurityInSQLServer2000ReportingServices.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott" <scott@.msdn.com.au> wrote in message
news:2C5BACB1-3986-4019-83D5-38DB1CAD2258@.microsoft.com...
> Robert,
> Thanks for the feedback. It sounds like this approach might work for
static
> background images, but really I want to have some dynamic text in the
> watermark. Basically, the watermark is only visible if the user is
> unregistered, and I would like to show an expiry date of the evaluation
> period. I thought there may be some way to dynamically render an image
from
> the text, to display as a background, but that's what this text box is
> supposed to do anyway!!!
> I'm a bit disappointed with the response that this bug probably won't make
> it in to SQL 2005, when it seems to have been a known issue in Reporting
> Services for some time. It really hurts me to say this, but I think I
will
> have to have to stick with Crystal until this issue is resolved. You
don't
> know how much I was hoping to find a better reporting solution.
> If you have any updates on a fix for this issue in SQL 2005 I won't be
> *very* grateful if you would let me know.
> Scott.
>
> "Robert Bruckner [MSFT]" wrote:
> > Yes, with SP1 of RS 2000 you can use external images from network
protocols
> > (e.g. http:) or network shares. Make sure to follow the instructions for
> > configuring the unattended execution account for the report server if
you
> > follow that path. See:
> >
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
> >
> > Alternatively, you could embed several images in the report and use
> > expressions to switch among them.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Scott" <scott@.msdn.com.au> wrote in message
> > news:B0CD4750-C75F-4E02-9269-1730450FCA4C@.microsoft.com...
> > > When you say "using a background image", do you mean a gif or jpg
image
> > for
> > > example? I am trying to use text as a watermark, so this approach is
not
> > > really workable unless I make the text static and produce a graphic
file
> > > external to RS.
> > >
> > > Is it possible to use an external file as a background image in the
> > report.
> > > That way I could perhaps choose between a number of files at runtime,
or
> > > maybe try to generate the file on the fly. Is this feasible?
> > >
> > > Scott.
> > >
> > >
> > >
> > >
> > > ""Mingqing Cheng [MSFT]"" wrote:
> > >
> > > > Hi Scott,
> > > >
> > > > Thanks for your patience and cooperation!
> > > >
> > > > I have talked with our development team and here is the answer from
> > them.
> > > >
> > > > Unfortunately, overlapping items isn't supported in HTML, which is
only
> > > > supported working in PDF. The problem with RepeatWith in PDF is
really a
> > > > known issue, however, they haven't decided yet whether it will be
fixed
> > in
> > > > SQL Server 2005 as a large code change would be required and the
time is
> > > > limited.
> > > >
> > > > Your alternate approach (using a background image) should work if
you
> > make
> > > > your image the same size as the usable page (the page size minus the
> > > > margins, page header and page footer) and mark it to repeat.
> > > >
> > > > Thank you for your patience and corperation. If you have any
questions
> > or
> > > > concerns, don't hesitate to let me know. We are here to be of
> > assistance!
> > > >
> > > >
> > > > Sincerely yours,
> > > >
> > > > Mingqing Cheng
> > > >
> > > > Online Partner Support Specialist
> > > > Partner Support Group
> > > > Microsoft Global Technical Support Center
> > > > ---
> > > > Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> > > > This posting is provided "as is" with no warranties and confers no
> > rights.
> > > > Please reply to newsgroups only, many thanks!
> > > >
> > > >
> >
> >
> >
![Crying [:'(]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vrq2loG2m81nHPe9lSQ4E-9wEgipjf3iP-zvEz2EwtHqGJSnRI-0ll5PrdV1Lc7mmecsjDlEU52aoHgDMI478g41qx7grE_QOx6EqSeUw1p6eiaIXytw=s0-d)
with this task ..please help me friends..