Problem with Search on Newsgroup

When searching, I only get results back for this month (March 2005)!! Has
anyone else encountered problems with the search tool on the newsgroup'Use google instead.
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs?hl=en&lr=&ie=UTF-8&oe=UTF-8
"Aparna" <Aparna@.discussions.microsoft.com> wrote in message
news:3AFAB874-5334-436C-98A0-B8A28C6241E9@.microsoft.com...
> When searching, I only get results back for this month (March 2005)!! Has
> anyone else encountered problems with the search tool on the newsgroup'

Problem with SA account

Hi, all experts here,

Thank you very much for your kind attention.

I encountered a problem with SA account log on. This problem occured after I detached one of the database, and when I tried to connect to the server with SA account, the problem occured, the error message is: Cannot open user default database. Login failed. Login failed for user 'sa'. (Microsoft SQL Server, Error:4064)

I then logged on to the server with windows authentification as administrator of the machine, and I have changed the password for SA account as my new password, but when I tried to log on as SA with my new password, the problem still remained.

Would please any experts here give me som advices for why is that and what else could I try to figure it out?

Thank you very much and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

To answer my own question, I logged on as Windows authentification, and change the password for SA account via its properties dialogue, it works fine now.

But still not sure why it did not work when I executed the query to change its password with statement: alter login sa with password='new password' unlock.

Would any experts here know what is the problem with the above statement? Thanks a lot and it is much appreciated to hear from you for that. Thanks a lot.

With best regards,

Yours sincerely,

|||

Why because , each login has a defualt database... if that database is detached/deleted/offline/recovery mode then that login will not be able to login. Generally, you should never keep a user database as default database of SA. keep some system database as default database. Let me tell u , this was nothing related to Password.

Madhu

|||

Madhu is correct. You can change the default database using ALTER LOGIN. Please refer to BOL on ho wto use this statement: http://msdn2.microsoft.com/en-us/library/ms189828.aspx.

Let us know if you have any further question, we will be glad to help.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Hi, thank you all for your very kind advices. It's been very helpful.

With best regards,

Yours sincerely,

Problem with SA account

Hi, all experts here,

Thank you very much for your kind attention.

I encountered a problem with SA account log on. This problem occured after I detached one of the database, and when I tried to connect to the server with SA account, the problem occured, the error message is: Cannot open user default database. Login failed. Login failed for user 'sa'. (Microsoft SQL Server, Error:4064)

I then logged on to the server with windows authentification as administrator of the machine, and I have changed the password for SA account as my new password, but when I tried to log on as SA with my new password, the problem still remained.

Would please any experts here give me som advices for why is that and what else could I try to figure it out?

Thank you very much and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

To answer my own question, I logged on as windows athentification, change the password for SA account via LOGINs properties. It works fine now.

|||

The reason that it worked when you changed it in the GUI is because when you opened the edit account window in the GUI you also changed the default database.

To get around this in the future log into the SQL Server with osql (the command line tool) and specify the -d flag with a name of a database such as master and you can get connected. You can then change the default database using the sp_defaultdb procedure or ALTER LOGIN (if SQL 2005).

|||

Hi, Mrdenny,

Thanks a lot for your kind advices.

With best regards,

Yours sincerely,

Problem with report manager find command

I am using sql server reporting services with service pack 2 applied. One of
my users has encountered a strange problem using the find command after a
report has been run.
If you try to use the find command in the report manager to locate a string
that is in the last group on a page, it will report "The search text was not
found". The find command works fine for test in all other groups on the
report. If you export the report to pdf, the acrobat search function will
find the text. I have tested several of my reports they all seem to have the
same problem.
Has anyone else had this problem with the find command in the report
manager? Any idea how to fix it?Hi,
Welcome to use MSDN Managed Newsgroup Support.
To state the problem clearly, would you tell me how you are searching the
string in report manager?
Do you use the Ctrl-F to find a string in a report via browser? If so,
which browser and what version do you use?
The Search for Feature in the Report Manager Page can only search published
reports, folders, shared data sources, and resources.
Thank you for your patience and cooperations. Please let me know your
results with this so that I can provide further association. I look forward
your reply.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
======================================================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.|||Thanks for the input. I will try to be more clear.
Here is the procedure I am using. First I am run the report in Internet
Explorer 6. I type the search string into the text box which appears between
the zoom factor (100%) and the word find. When I hover my mouse over the
text box a tool tip pops up and displays "find text". Finally, I click on
the word "Find".
Normally the report will jump to wherever the search string is first found
in the report, regardless of which page it appears on. As I stated earlier
if the search string appears in the last group on a page, for some reason it
will not be found.
I noticed today that the problem only seems to occur if the last group on
the page spans onto the next page. If the last group on the page finishes on
the page you can successfully find items in that group.
"Wei Lu" wrote:
"Wei Lu" wrote:
> Hi,
> Welcome to use MSDN Managed Newsgroup Support.
> To state the problem clearly, would you tell me how you are searching the
> string in report manager?
> Do you use the Ctrl-F to find a string in a report via browser? If so,
> which browser and what version do you use?
> The Search for Feature in the Report Manager Page can only search published
> reports, folders, shared data sources, and resources.
> Thank you for your patience and cooperations. Please let me know your
> results with this so that I can provide further association. I look forward
> your reply.
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> ======================================================> 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 Guess,
Thank you for update. I understood your concern is that you are trying to
search the string in a report with a html viewer and you can not find it if
the string in the last group. If I misunderstood your concern, please feel
free to point it out.
In the reporting service, this Search feature searches for content in the
report by typing a word or phrase that you want to find (the maximum value
length is 256 characters). The search is case-insensitive and begins at the
page or section that is currently selected. Only visible content is
included in a search operation. This search feature is based on javascript.
So I'd like to know if you use the Ctrl-F to search the string, will you
find it properly? Is this string visible or not?
Also you may want to insert a page break after the table to test.
Further, if you installed the Sample, you may check if the issue occurs on
¡"product catalog" sample report.
Thank you for your patience and cooperations. Please let me know your
results with this so that I can provide further association. I look forward
your reply.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
======================================================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 you efforts.
To answer your question, the text is visible. If I use Ctrl-F, it does find
the text as long as I am currently on the page where the text appears. In my
experience, the find/next commands in the report manager will find a string
on the current page as well as all other pages (both before and after the
current page) except in the circumstances described in my earlier posts.
The problem I am having does occur in the Product Catalog sample report.
For example on page five, the last line of the report has product no. of
"BK-M38S-56". The find command will not find this product no.. If I use
Ctrl-F it will find the product no., as long as I am on page 5. In fact I
can not use the find/next commands to locate any product no. in the
"Mountain-400" section on page 5.
The sample reports are on my local machine. The earlier reports I tested
were on our application server. I am curious to know if you experience the
same problem on page 5 of the product catalog.
I tried adding a page break after the table in the Product Catalog sample
report. It did not make any difference.
"Wei Lu" wrote:
> Hi Guess,
> Thank you for update. I understood your concern is that you are trying to
> search the string in a report with a html viewer and you can not find it if
> the string in the last group. If I misunderstood your concern, please feel
> free to point it out.
> In the reporting service, this Search feature searches for content in the
> report by typing a word or phrase that you want to find (the maximum value
> length is 256 characters). The search is case-insensitive and begins at the
> page or section that is currently selected. Only visible content is
> included in a search operation. This search feature is based on javascript.
> So I'd like to know if you use the Ctrl-F to search the string, will you
> find it properly? Is this string visible or not?
> Also you may want to insert a page break after the table to test.
> Further, if you installed the Sample, you may check if the issue occurs on
> ¡"product catalog" sample report.
> Thank you for your patience and cooperations. Please let me know your
> results with this so that I can provide further association. I look forward
> your reply.
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> ======================================================> 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 Guess,
I have searched in our internal knowledge base, it is a known issue in
Reporting Service and is fixed in SQL Server 2005 Reporting Services.
For now, if it has much business impact on you, I recommend that you open a
Support incident
with Microsoft Customer Service and Support (CSS) so that a dedicated
Support Professional can work with you in a more timely and efficient
manner. If you need any help in this regard, please let me know.
For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
If there are further questions on the issue, please feel free to let us
know. Have a great day!
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
======================================================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.

Problem with RepeatWith to display watermark on each page.

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!
> > > >
> > > >
> >
> >
> >

Problem with ProClarity report 'Export' options

Hi, all here,

Thank you very much for your kind attention.

I encountered a problem with export ProClarity reports. The problem is: under the 'Export' option, there is only 'Export to business reporter'. No other options like: 'Export to reporting service', 'Export to PowerPoint', 'Export to outlook' which actually should be available for ProClarity report 'Export' options tho.

Would please any expert here give me any guidance and advices for that.

Thanks a lot in advance for that.

With best regards,

Yours sincerely,

Hi Helen:

The ProClarity "export to" options are usually established on installation of the ProClarity Professional. In the installation process you can choose to install the "Integration with Office" components which provide the Export to Excel, Outlook, and Powerpoint. You can verify that this functionality was NOT installed by looking in the subfolder:

C:\Program Files\Common Files\ProClarity\Client\Office

I have three folders here: "Excel", "Outlook", and "PPoint". Each folder contains a .DLL and supporting files for each flavor of export. If you don't have the folders then re-installing the ProClarity Professional with the correct components selected should suffice to fix the problem. If the folders DO exist then something else is wrong. Your shortest route to fixing the situation may be to uninstall the ProClarity Professional and reinstall with the correct components selected.

Hope this helps.

PGoldy

|||

Hi, Pgoldy,

Thank you very much for your guidance and help.

Yes, I have had a look at the folder(C:\Program Files\ProClarity\Client\), but no 'Office' existed there. So yes would try to resinstall the software as you recommended. Thank you very much.

With best regards,

Yours sincerely,

|||

Sorry, please ignore this post.

With best regards,

Yours sincerely,

Problem with parameter default when redeploying report

I've written a rss script file to automate publishing of reports to
our server. I've encountered a problem when republishing reports that
have a default value set for a parameter.
If I change the default value of the parameter in the report rdl and
then try to republish, that parameter's default value is not getting
changed on the server. If I add or remove parameters then the server
gets updated correctly. It's only if I change the default value that
the update is not happening.
I've tried with both the CreateReport and SetReportDefinition
functions. The only way I've gotten this to work is to delete the
report and then republish but this is not an acceptable solution
because it also deletes report history and subscriptions.
I'm using RS2005.
Any help is appreciated.Default values for parameters are a little like datasources, in that you
have to explicitly indicate that you want to override a previous definition
of a datasource when you re-publish a report to a server. Basically the idea
is that your testbed, from which you publish, may not be the same as the
server environment, and you want to keep those things separate, and I'm
saying that parameters' defaults are treated like datasources in this
respect.
OK so far?
If you were handling this interactively using the Report Manager interface,
and assuming you have appropriate rights, you know that you can see the Data
Sources and configure them from the Properties tab of a report. Again, the
assumption is not made that the data source information for this report is
re-deployable and automatically written from your test bed.
Similarly, if a report has parameters, when you have selected the Properties
tab, you should see a Parameters item in the left-hand menu along with Data
Sources. Here you can set the default values differently from how they are
currently set -- I don't really understand whether "Override default" works
all the time or not, you will see it in the dialog, though. Never mind.
Here is where you can fix whatever you don't like about how the report got
re-published.
However, you say "I've tried with both the CreateReport and
SetReportDefinition functions", indicating that you are using web services
rather than interactively publishing. I understand this -- just consider
the above explanation a way to conceptualize *why* the parameters work the
way they do and require a separate step, rather than the way you expected.
I think that you may need to use the .SetReportParameters method here,
explicitly providing the new information to indicate that, yes, you want to
change the default values. If not, it may be the .SetProperties method.
I hope this works for you -- if not, you may be able to use the explanation
above to figure out the correct web service approach <s>.
>L<
<bruce42@.gmail.com> wrote in message
news:1175872439.784150.127590@.e65g2000hsc.googlegroups.com...
> I've written a rss script file to automate publishing of reports to
> our server. I've encountered a problem when republishing reports that
> have a default value set for a parameter.
> If I change the default value of the parameter in the report rdl and
> then try to republish, that parameter's default value is not getting
> changed on the server. If I add or remove parameters then the server
> gets updated correctly. It's only if I change the default value that
> the update is not happening.
> I've tried with both the CreateReport and SetReportDefinition
> functions. The only way I've gotten this to work is to delete the
> report and then republish but this is not an acceptable solution
> because it also deletes report history and subscriptions.
> I'm using RS2005.
> Any help is appreciated.
>|||So, from what you're saying, it's intentional that the parameter
defaults are not being overriden. You mention an "override defaults",
can you be more specific? I can see an "OverwriteDataSources" if I
publish straight from VS, but I've found nothing regarding overwriting
parameter defaults.
I'm familiar with the SetReportParameters method, what I'm trying to
do is avoid writing specific scripts for each report that I need to
publish. The rss script I use to publish now is a generic script that
I can use against any of my reports. Setting the default values
manually via the report manager interface is not really an option for
me. For one reason, it introduces the possibility of me setting
values differently than what was actually used in our test
environment, and two, we are using query based defaults and the report
manager interface doesn't give you enough detail to even be able to
make these changes (i.e. it doesn't show dataset or value field).
Currently the best idea I have for how to resolve this issue is to
publish my report to a temporary location (where it does not already
exist), loop through all of the parameters and capture the defaults, I
can then publish the report to it's normal location and do a
SetReportParameters using the default values I collected. I'm not
especially happy with this approach, it feels a little kludgy to me,
but at least it keeps me from having to write report specific rss
scripts.
Any other ideas?
thanks for your response...
-bruce
On Apr 6, 12:43 pm, "Lisa Slater Nicholls" <l...@.spacefold.com> wrote:
> Defaultvalues for parameters are a little like datasources, in that you
> have to explicitly indicate that you want to override a previous definition
> of a datasource when you re-publish a report to a server. Basically the idea
> is that your testbed, from which you publish, may not be the same as the
> server environment, and you want to keep those things separate, and I'm
> saying that parameters' defaults are treated like datasources in this
> respect.
> OK so far?
> If you were handling this interactively using the Report Manager interface,
> and assuming you have appropriate rights, you know that you can see the Data
> Sources and configure them from the Properties tab of a report. Again, the
> assumption is not made that the data source information for this report is
> re-deployable and automatically written from your test bed.
> Similarly, if a report has parameters, when you have selected the Properties
> tab, you should see a Parameters item in the left-hand menu along with Data
> Sources. Here you can set thedefaultvalues differently from how they are
> currently set -- I don't really understand whether "Overridedefault" works
> all the time or not, you will see it in the dialog, though. Never mind.
> Here is where you can fix whatever you don't like about how the report got
> re-published.
> However, you say "I've tried with both the CreateReport and
> SetReportDefinition functions", indicating that you are using web services
> rather than interactively publishing. I understand this -- just consider
> the above explanation a way to conceptualize *why* the parameters work the
> way they do and require a separate step, rather than the way you expected.
> I think that you may need to use the .SetReportParameters method here,
> explicitly providing the new information to indicate that, yes, you want to
> change thedefaultvalues. If not, it may be the .SetProperties method.
> I hope this works for you -- if not, you may be able to use the explanation
> above to figure out the correct web service approach <s>.
> >L<
> <bruc...@.gmail.com> wrote in message
> news:1175872439.784150.127590@.e65g2000hsc.googlegroups.com...
>
> > I've written a rss script file to automate publishing of reports to
> > our server. I've encountered a problem when republishing reports that
> > have adefaultvalue set for aparameter.
> > If I change thedefaultvalue of theparameterin the report rdl and
> > then try to republish, thatparameter'sdefaultvalue is not getting
> > changed on the server. If I add or remove parameters then the server
> > gets updated correctly. It's only if I change thedefaultvalue that
> > the update is not happening.
> > I've tried with both the CreateReport and SetReportDefinition
> > functions. The only way I've gotten this to work is to delete the
> > report and then republish but this is not an acceptable solution
> > because it also deletes report history and subscriptions.
> > I'm using RS2005.
> > Any help is appreciated.- Hide quoted text -
> - Show quoted text -|||Hi Bruce,
>> Any other ideas?
Forgive my lateness of reply (I will CC your e-mail to make sure you see
this) -- I don't get to the forum all that often.
AFAIK you are correct about not having the Overwrite parameter option to
match the Overwrite datasources when you publish straight from VS. When I
mentioned the "override defaults" I was talking only about the interactive
manager interface.
I do agree with you not only that it is confusing but also that, in most
cases, it is not advisable to set values differently in the test environment
than you would set in production. However -- bear with me, I am trying to
envision what was supposed to be the purpose of this "feature" -- we can
imagine that the designers of this system thought it *was* a good idea to
have an "override defaults" so that you could manage the report differently
on different servers, whether for test versus production or deployment of a
generic report to different customers.
For example there might be a sample size used for the test box that would be
different from production, or some sort of customer-specific value that you
wanted to use to brand a generic report.
Now to address your question...
For your generic script purposes, you might need to do something similar to
reflection to "publish" each report.
So far, I'm just restating something that you may have already tried with
your "publish to a temporary location". You could obviously pull the
parameters out of the appropriate Catalog field on the server, or use
GetReportParameters, if you've done that.
However, you don't really need to do that. Remember that the parameters
exist in the RDL, without publication, as a set of XML nodes. So, without
temporarily publishing anywhere, you should be able to read them out of the
RDL and issue the appropriate calls to set them properly on the target.
I hope this makes sense. If you like, you can e-mail me to discuss further
if it doesn't <g>. Again, I don't get here all that much...
>L<
<bruce42@.gmail.com> wrote in message
news:1176117653.014697.204110@.w1g2000hsg.googlegroups.com...
> So, from what you're saying, it's intentional that the parameter
> defaults are not being overriden. You mention an "override defaults",
> can you be more specific? I can see an "OverwriteDataSources" if I
> publish straight from VS, but I've found nothing regarding overwriting
> parameter defaults.
> I'm familiar with the SetReportParameters method, what I'm trying to
> do is avoid writing specific scripts for each report that I need to
> publish. The rss script I use to publish now is a generic script that
> I can use against any of my reports. Setting the default values
> manually via the report manager interface is not really an option for
> me. For one reason, it introduces the possibility of me setting
> values differently than what was actually used in our test
> environment, and two, we are using query based defaults and the report
> manager interface doesn't give you enough detail to even be able to
> make these changes (i.e. it doesn't show dataset or value field).
> Currently the best idea I have for how to resolve this issue is to
> publish my report to a temporary location (where it does not already
> exist), loop through all of the parameters and capture the defaults, I
> can then publish the report to it's normal location and do a
> SetReportParameters using the default values I collected. I'm not
> especially happy with this approach, it feels a little kludgy to me,
> but at least it keeps me from having to write report specific rss
> scripts.
> Any other ideas?
> thanks for your response...
> -bruce
> On Apr 6, 12:43 pm, "Lisa Slater Nicholls" <l...@.spacefold.com> wrote:
>> Defaultvalues for parameters are a little like datasources, in that you
>> have to explicitly indicate that you want to override a previous
>> definition
>> of a datasource when you re-publish a report to a server. Basically the
>> idea
>> is that your testbed, from which you publish, may not be the same as the
>> server environment, and you want to keep those things separate, and I'm
>> saying that parameters' defaults are treated like datasources in this
>> respect.
>> OK so far?
>> If you were handling this interactively using the Report Manager
>> interface,
>> and assuming you have appropriate rights, you know that you can see the
>> Data
>> Sources and configure them from the Properties tab of a report. Again,
>> the
>> assumption is not made that the data source information for this report
>> is
>> re-deployable and automatically written from your test bed.
>> Similarly, if a report has parameters, when you have selected the
>> Properties
>> tab, you should see a Parameters item in the left-hand menu along with
>> Data
>> Sources. Here you can set thedefaultvalues differently from how they are
>> currently set -- I don't really understand whether "Overridedefault"
>> works
>> all the time or not, you will see it in the dialog, though. Never mind.
>> Here is where you can fix whatever you don't like about how the report
>> got
>> re-published.
>> However, you say "I've tried with both the CreateReport and
>> SetReportDefinition functions", indicating that you are using web
>> services
>> rather than interactively publishing. I understand this -- just consider
>> the above explanation a way to conceptualize *why* the parameters work
>> the
>> way they do and require a separate step, rather than the way you
>> expected.
>> I think that you may need to use the .SetReportParameters method here,
>> explicitly providing the new information to indicate that, yes, you want
>> to
>> change thedefaultvalues. If not, it may be the .SetProperties method.
>> I hope this works for you -- if not, you may be able to use the
>> explanation
>> above to figure out the correct web service approach <s>.
>> >L<
>> <bruc...@.gmail.com> wrote in message
>> news:1175872439.784150.127590@.e65g2000hsc.googlegroups.com...
>>
>> > I've written a rss script file to automate publishing of reports to
>> > our server. I've encountered a problem when republishing reports that
>> > have adefaultvalue set for aparameter.
>> > If I change thedefaultvalue of theparameterin the report rdl and
>> > then try to republish, thatparameter'sdefaultvalue is not getting
>> > changed on the server. If I add or remove parameters then the server
>> > gets updated correctly. It's only if I change thedefaultvalue that
>> > the update is not happening.
>> > I've tried with both the CreateReport and SetReportDefinition
>> > functions. The only way I've gotten this to work is to delete the
>> > report and then republish but this is not an acceptable solution
>> > because it also deletes report history and subscriptions.
>> > I'm using RS2005.
>> > Any help is appreciated.- Hide quoted text -
>> - Show quoted text -
>