Problem with sqlexpress

hi:

I set up a DSN via Adim tools, then I specify the connection string as "DSN=UserAppSample;Trusted_Connection=True".

When I run my aspx page, it says:

ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQLServer]Cannot open database "UserAppSample" requested by the login. Thelogin failed.

It asks for login, but I use windows authentication. So what is wrong with this? :(

This is a SQL permission issue. You need to check the SQL Server logins, make sure the account which runs the application has proper permission on the UserAppSample database.

Problem with SqlDataSource using sub-query and date as parameters

I am creating a search page for master detail tables. The search criteria is mainly on the header table. However, there is also one criteria which is in detail table, let said product number.

In my SqlDataSource, I setup the SQL like this.

select fieldA, fieldB, ..., fieldZ from masterTable where (1 = 1)

Then, the additional search criteria is appended to the SqlDataSource select command once the user click the search button. If user wants to search product number, the following will be appended

and exists (select 1 from detailTable where pid = masterTable.id and productNo = @.productNo)

The problem is when I provides both the sub-query criteria and 2 date fields criteria. The page will raise an timeout exception. I don't have any clue on this as I can copy the SQL and run it inside the SQL Server Management Studio. The result come up in a second.

Any suggestion on tackling this problem? Thanks!

hi,

U can avoid this by diffarent options...By above information I can explain like this

1 use UNION

2 Use Primary Key in your every Subquery Query followed by the Search.

3 Use Joins with valid Key Elements.etc

or send the required result columnes and the Table Design

bye

murthy

|||

Hi Murthy,

1. use UNION

I don't know how should I use UNION in master-detail structure. Please give more detail.

2. The primary key is already used in the where clause of the subquery. The column pid means the primary key ID in master table.

3. Use Join

The use of join is not desirable. I have to group the records back together afterward. I just want to search the master table but use detail record as criteria. If I join them without group, the master record will repeat themselves in the result.

Actually, I'm strange about the performance difference by using ADO.NET and SQL Server management studio.

|||

Hi,

OK

Do this Use "#' table with one primary key ID as the Column column in all the condictions

and finally join all the Table with the key Elements..

Ex:

select <Key>,<Search column 1 > into #TableA from <Master table> where <Condition>

select <Key>,<Search column 2 > into #TableB from <Master table> where <Condition>

.....

....

and Finally

select <Search Column1>,<Search Column2>.<Search Column3>,... from #TableA, #TableB, #TableC...where #TableA.Key=#TableB.Key,#TableA.Key=#TableC.key etc

drop all temp table

your result is ready now...

|||

This approach seems making the simple request into a complex one.

Problem with SqlCacheDependency

I've set up a SqlCacheDependency in my Asp.Net application, but the dependency invalidates the cache immediately every time the page is hit.

I think the problem may be with my SQL Query, but it seems to me to meet the requirements on the Special Considerations When Using Query Notifications page on MSDN. Could someone take a look at this query and tell me if I've done something wrong? Thank you.

Here's my query:

Code Snippet

USE [chameleon]

GO

SET ANSI_NULLS ON

GO

SET ANSI_PADDING ON

GO

SET ANSI_WARNINGS ON

GO

SET CONCAT_NULL_YIELDS_NULL ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET NUMERIC_ROUNDABORT OFF

GO

SET ARITHABORT ON

GO

ALTER PROCEDURE [dbo].[usp_customers_by_site_id]

@.site_id INT

AS

SELECT

customers.customer_id,

customers.name,

customers.po_prefix,

customers.dt_created,

customers.created_by AS auid,

customers.po_required

FROM dbo.customers

WHERE customers.site_id = @.site_id

AND customers.is_active = 1

and here's the code in my Asp.Net site where I try to use the SqlCacheDependency:

Code Snippet

public List<Customer> GetCustomersBySite(int siteID)

{

List<Customer> customers = new List<Customer>();

if (HttpRuntime.Cache["CustomersBySite" + siteID] != null){

customers = (List<Customer>)HttpRuntime.Cache["CustomersBySite" + siteID];

}

else

{

using (SqlCommand command = new SqlCommand("usp_customers_by_site_id", Connection)){

command.CommandType = CommandType.StoredProcedure;

command.Parameters.Add("@.site_id", SqlDbType.Int).Value = GetDBValue(siteID, false);

SqlCacheDependency dependency = new SqlCacheDependency(command);

try{

Connection.Open();

SqlDataReader reader;

reader = command.ExecuteReader(CommandBehavior.SingleResult);

while (reader.Read()){

customers.Add(PopulateCustomer(reader));

}

HttpRuntime.Cache.Insert("CustomersBySite" + siteID, customers, dependency, DateTime.Now.AddMinutes(Configuration.CacheDuration), System.Web.Caching.Cache.NoSlidingExpiration);

}

finally{

Connection.Close();

}

}

}

return customers;

}

My apologies. I posted this in the wrong forum.

-Brad

Problem with sql server connection sting

Hi,
I am testing a asp page using sql server as the backend database. However, I
cannot connect to the database from asp. I have the following error coming
and I have also added the connection string that goes with the asp page.
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'sa'.
/aspsqlserver/logonprocess.asp, line 16
cn = "Provider=SQLOLEDB.1;User ID=sa;password=;Initial Catalog=test;Data
Source = TSU_SUPER"
I do not user any password to get into the sql server. I can open it from
my Enterprise Manager without using the userid sa and any password. With thi
s
situation, any help is appreciated. Thanks in advance.Am Mon, 5 Jun 2006 09:24:01 -0700 schrieb Jack:

> Hi,
> I am testing a asp page using sql server as the backend database. However,
I
> cannot connect to the database from asp. I have the following error coming
> and I have also added the connection string that goes with the asp page.
> Error Type:
> Microsoft OLE DB Provider for SQL Server (0x80040E4D)
> Login failed for user 'sa'.
> /aspsqlserver/logonprocess.asp, line 16
>
> cn = "Provider=SQLOLEDB.1;User ID=sa;password=;Initial Catalog=test;Data
> Source = TSU_SUPER"
> I do not user any password to get into the sql server. I can open it from
> my Enterprise Manager without using the userid sa and any password. With t
his
> situation, any help is appreciated. Thanks in advance.
Maybe this helps:
http://support.microsoft.com/kb/307002/EN-US/
bye, Helmut

Problem with SMO on a ASP.NET page

Hi !

I have done an EXE which copy a database using SMO. When i double click my exe everything is working fine. If i tried to execute my EXE in a ASP.NET web page the process is start but doesn't do anything. If i tried other EXE i've made it's working fine so the problem seems to come from SMO. Did i have something to add to my code if i want to use it in a webpage ?In common no, did you try to debug the SMO application / library which you wrote ?

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks !

I've figure out what was the problem. To be able to use my EXE in my web application i've got to add those lines

myServer.ConnectionContext.LoginSecure = False

myServer.ConnectionContext.Login = "****"

myServer.ConnectionContext.Password = "*****"

Now my EXE is working fine when i'm calling it from my webapplication

Problem with setting up IIS - You are not authorized to view this page

I am trying to set up IIS on our server (Windows 2003 with SQL Server 2000) and when I try to run a query in a browser I keep getting the following messsage:-
You are not authorized to view this page
I have followed the tutorial (XMLStartup.doc) which was placed in C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples\xml\XMLStartup on installation, but still get the above message when I get to the point of querying the database.
Is there something I am doing wrong or is there some security measure I have not taken into account yet that is preventing me from runing queries?
any help appreciated - Thanks
The problem is probably not in SQL Server but in NTFS and IIS permissions. The IUSR_<server name> user or your local account user (if you are surfing from the server) must have NTFS permissions to read the page you are trying to access, both in IIS and NTFS. Check the NTFS security first and disable "simple file sharing" in WinExplorer if it's by any chance turned on and set the propper permissions on the files you are trying to access.

Problem with saving Chinese.

Hi.. I'm trying to save text into SQL 2000 database.

When user enter text in text box , the text save into variable , and show it in confirm page , after save the text to database, all the text turned into "??"

I try to view the data in SQL enterprise Manager / Web Matrix / ASP web page gridview , all of them showing the text fields in "??"

Then I try to add record which come with SQL 2000 enterprise Manager.After save the record , the chinese also turned into "??"

Is there something I need to set for database or server?

Is your datatype VARCHAR, TEXT or CHAR as the datatype on the table columns?

If VARCHAR change to NVARCHAR. If TEXT change to NTEXT. If CHAR change to NCHAR.

If you are using stored procedures (and you should be), you will to amend the parameter declaration on them.

You might want to change the collating sequence on your database to one more appropriate to Chinese (if collating sequence is meaningful for that language), but otherwise you should not need to change anything at the database level.

If this reply provides the anser to your question, please mark as such.

|||all the text are stored in varchar... I'll try to change it to nvarchar|||

yea... it works when I change all the text field type to nnvarchar..

Problem with ReportViewer Control

I have an ASP.NET web site with form authentication.

When I use a ReportViewer control in a page (with a masterPage) and my report (ServerReport and Remote processingmode) has DateTime parameters I can't see that calendar gif in order to select a date. Same thing with a DropDownList bound to a dataset for another paramater (I can't see that arrow from the right side of DropDownList so I can't dropdown it).

When I want to see the report with a browser direct from my Reports site it works fine. Only in reportviewer has this simptoms.

IE has some errors in script

1. 'RSClientController' is undefined

2. 'ClientControllerctl00_contentPanel_ReportViewer1' is null or not an object.

3. 'DropDownParamClass' is undefined.

I found other posts with the same simptoms:

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=327473&SiteID=1

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=358590&SiteID=1

but the solution found there doesn't apply to me.

Any suggestions ?

Hi Sorin,
I have the same problem regarding Reporting Service. Is this problem has been solved ? Could you please advice me how to solve the problem?

Best Regards,

Joko|||A work around could be to use a IFrame and changing its source to the report you would like to display.

Problem with ReportViewer Control

I have an ASP.NET web site with form authentication.

When I use a ReportViewer control in a page (with a masterPage) and my report (ServerReport and Remote processingmode) has DateTime parameters I can't see that calendar gif in order to select a date. Same thing with a DropDownList bound to a dataset for another paramater (I can't see that arrow from the right side of DropDownList so I can't dropdown it).

When I want to see the report with a browser direct from my Reports site it works fine. Only in reportviewer has this simptoms.

IE has some errors in script

1. 'RSClientController' is undefined

2. 'ClientControllerctl00_contentPanel_ReportViewer1' is null or not an object.

3. 'DropDownParamClass' is undefined.

I found other posts with the same simptoms:

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=327473&SiteID=1

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=358590&SiteID=1

but the solution found there doesn't apply to me.

Any suggestions ?

Hi Sorin,
I have the same problem regarding Reporting Service. Is this problem has been solved ? Could you please advice me how to solve the problem?

Best Regards,

Joko
|||A work around could be to use a IFrame and changing its source to the report you would like to display.

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 reordering of rows

I am using MSSQL 2000, I need to display a cv page in which a person projects are displayed the way he enters them into the database and he should be able to reorder the projects according to the proirity. I have no clue how to do this ? I am a newbie in asp.net,C# field.

I searched info on google and forums but didn't find anything related to my understanding. I'am displaying all his projects using a Projects table in which i have four columns ProjectID, ProjTitle, ProjDirector, ProjDescription. i want the user to be able to reorder the
projects row by moving a task up or down based on priority.Any help will be greatly appreciated .. I am really stuck and frustated with this task ..please help me friends..

Thank you very much

can you please help me friends in the above problem...

Thank you

|||

Can two projects have the same Title? I would immagine that would be confusing -- if Title is supposed to be unique, then make it the PK. Also, your column names contain the prefix "Proj" -- unecessary.

To answer your question, though, simply add a column called Display_Sequence. Then your insert statement would be

INSERT INTO Projects
(Title, Director, Description, Display_Seq)
SELECT 'My Project', 'Jim Jones', 'This is my project', MAX(Display_Seq)
FROM Projects

Problem with PAGE HEADER

Dear All

I am Sundaraguru from India.

I have problem with Reporting services header showing time..

I designed the one report. That report Size is 8inch x 41 inches..

What are problems i having in this reports:

1. Report header is not coming in second pages. ( For report header i am not using the report header area, Because the header informations will varying based on the data's. That's Why I placed in the detail sections)

2. While Seeing the preview time it is showing only 11 page ( for 2 record) after exporting to PDF format it showing 32 pages.

How i can solve the above problem.. I have to get is all the page's i have to show report header in all the pages.

I am using SQL Server 2005 , & VS.Net 2005 With November 2006 CTP

And Send your valuable suggestions to following mail id's sundaraguru_s@.apollohealthstreet.com and sundharmail@.yahoo.co.in.

Advance Thanks

Kind Regards
Sundaraguru S

Dear All,

I got the Solution

I place the Repeatable information to the one separate rectangle.. Right the Rectangle -> General -> Data Region (Combo) Select the dataset. (If the Selected dataset is contains then detailed information). And set the hidden property for the rectangle

Add the header and footer information and refer the hidden rectangle contained control informations(Using ReportItems("").Value ).

Kind Regards

Sundaraguru S

Problem with PAGE HEADER

Dear All

I am Sundaraguru from India.

I have problem with Reporting services header showing time..

I designed the one report. That report Size is 8inch x 41 inches..

What are problems i having in this reports:

1. Report header is not coming in second pages. ( For report header i am not using the report header area, Because the header informations will varying based on the data's. That's Why I placed in the detail sections)

2. While Seeing the preview time it is showing only 11 page ( for 2 record) after exporting to PDF format it showing 32 pages.

How i can solve the above problem.. I have to get is all the page's i have to show report header in all the pages.

I am using SQL Server 2005 , & VS.Net 2005 With November 2006 CTP

And Send your valuable suggestions to following mail id's sundaraguru_s@.apollohealthstreet.com and sundharmail@.yahoo.co.in.

Advance Thanks

Kind Regards
Sundaraguru S

Dear All,

I got the Solution

I place the Repeatable information to the one separate rectangle.. Right the Rectangle -> General -> Data Region (Combo) Select the dataset. (If the Selected dataset is contains then detailed information). And set the hidden property for the rectangle

Add the header and footer information and refer the hidden rectangle contained control informations(Using ReportItems("").Value ).

Kind Regards

Sundaraguru S

Problem with page breaks and large amount of text

What have folks here done with large amounts of text in a table with regard to page breaks? I've found that in a PDF the page break happens before the large block of text starts regardless of where it starts on the page. Even if there is 3/4 of the page empty it will always page break.

This also happens in preview mode in VS2003 as well. The weird thing is that the second page is very long, almost twice as long as the regular page. The third page is ok. This should be a 2 page report but because of the page break it's a 3 page report. I can post samples if required.

Any help is appreciated.

Thanks

Richard.

Here's an example. To illustrate, I'm just pulling back the Article Title and the Article Details. I made the table background dark just so to distinguish it from the rest of the page.

http://www.1uvaknd.com/pagebreaktest.pdf

This is in VS2003 preview mode. Take a look at page 2. The page size is huge in comparison with the other pages.

http://www.1uvaknd.com/pagebreaktest_page1.jpg
http://www.1uvaknd.com/pagebreaktest_page2.jpg
http://www.1uvaknd.com/pagebreaktest_page3.jpg

Anyone else run into this?

Thanks

Richard.

|||

If you ever resolved this I would be interested in your resolution as I am having a very simular issue.

Thank You

Ed

|||

EdneyHolder:

I have come up with a solution/workaround. Put all the tables into a List object. Then take the large text column out of the table and place it in the list object itself. As long as the large text column is NOT in a table but in a List object - it seems to work much better.

Richard.

Problem with page breaks

Hello All,

I face the following problem.

I have a report with a list and under that list i have a table and a chart that sums the values from the dataset.

In my list properties i have set that their should be a page break after the list (meaning that my table and chart

should start a new page).

In my listgroup properties is hava also set a page break after each group.

Now when i preview my report in visual studio, the groupdetails are displayed in one page and the summed table and chart are on a second page. when i do a print preview, i get 3 pages but my sum table is on the second page under the last groupdetail and the chart is 3rth page.

When i publish my report on the reportserver and i do the same through my browser, i get the same error.

Why doesn"t the page break after each group doesn't work ?

Why does the page break after the list doesn't work ? is this a bug ?

Is there a way to set a pagebreak manually on the report for example in a hidden textbox ?

Any suggestions, tricks, help .....

Vinnie

Hello again ...

It seems i always find the answer to my proper questions .. but always when i have posted an item on this forum.

So i solved my problem based on the following article :

http://www.eggheadcafe.com/articles/20040823.asp

I draw a rectangle under my list and but my table and chart in this rectangle.

Then i set the PageBreakAtStart property to True.

This did the trick .... Isn't it simple ... if you know how to .....

Greetings

Vinnie

|||Hi Vinnie,

Thanks for this, I was also facing the same problem and tried exactly the same but this worked only first time. In the subsequent iterations of this report the rectangles start overlapping each other and I can't figure out why.
Do you have any suggestion for this?

Thanks
Anshu
anshu.bathla@.gmail.com

Problem with Page break and Visibility expression

Hi,
I am using sql server 2005 sp1 reporting services.
Currently creating a report, which contains several sub-reports held in
separate rectangles. The rectangles need page breaks to be displayed after
the rectangle. I have checked the â'Insert After Rectangleâ' page break
attribute on the General tab.
The problem is I want the page breaks on the rectangle to work when I set
the visibility attribute to false (this allows the rectangle to display). I
am setting the visibility using an expression and the text in the rectangle
displays properly, but the page breaks do not work.
Can anybody shed any light on this?
Thanks.Hello ringt,
This is a known issue in Reporting Services 2005. I am contacting to the
Product Team to check whether there is any workaround. I appreciate your
patience. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello ringt,
Unfortunately, I have not got any update from the product team. I
appreciate your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hello ringt,
Unfortunately, the product team feedback that there is no workaround now
for this issue. They are addressing in a future release.
If this really impact your business, you could open a CSS case so taht a
Support Professional can work with you in a more timely and efficient
manner.
If there are further questions on the issue, please feel free to let us
know. Have a great day!
Sincerely,
Wei Lu
Microsoft Online Community Support|||You can insert a rectangle into a rectangle, and set a page break in the
inner rectangle and visibility in the outer and paste this nested rectangles
in between subreports. It Visible expression is True, the page break will
work. if Visible expression is False , it will ignore a Page Break. I have
Master report with a few subreports which need to be separated by page
breaks and shown/hidden depending on the input parameters and this approach
worked for me.