Long text starts on next page

I have a table where a cell gets populated with a lot of data. When data is
longer than the page it would page break into the next while leaving a huge
white space on the previous page. how can i make it page break in the middle
of the text when it needs to instead of the whole cell getting moved to the
next page.A textbox has an implicit keep-together flag set on it which dictates the
behavior you are seeing. It is not currently possible to modify this
behavior.
Workarounds include breaking the text into multiple textboxes.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marvin" <Marvin@.discussions.microsoft.com> wrote in message
news:22A08267-61CB-4EBF-A9A4-C3351FB61F4A@.microsoft.com...
>I have a table where a cell gets populated with a lot of data. When data is
> longer than the page it would page break into the next while leaving a
> huge
> white space on the previous page. how can i make it page break in the
> middle
> of the text when it needs to instead of the whole cell getting moved to
> the
> next page.|||I have used the workaround you suggested but many reports we use pull data
dynamically from a database that is often 60-100 lines long. We get a lot of
page breaks between table & group header rows which not only makes the report
messy but wastes a lot of paper. we also tried using a list with several
textboxes in it and set the keeptogether proprty of the list to true but now
the top textbox gets separated from the one below it if the one below it
needs to span pages. Any other ideas? Thanks.
"Donovan Smith [MSFT]" wrote:
> A textbox has an implicit keep-together flag set on it which dictates the
> behavior you are seeing. It is not currently possible to modify this
> behavior.
> Workarounds include breaking the text into multiple textboxes.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Marvin" <Marvin@.discussions.microsoft.com> wrote in message
> news:22A08267-61CB-4EBF-A9A4-C3351FB61F4A@.microsoft.com...
> >I have a table where a cell gets populated with a lot of data. When data is
> > longer than the page it would page break into the next while leaving a
> > huge
> > white space on the previous page. how can i make it page break in the
> > middle
> > of the text when it needs to instead of the whole cell getting moved to
> > the
> > next page.
>
>

Long running report fails with http error

Hi,
I have a report that takes about an hour to run. When I run it, it runs for
an hour or so with "Generating Report", then the result page is the standard
IE "Action Canceled" page, and there is a javascript error. The javascript
error is Permission denied.
All other reports running on this server (which don't take as long to run)
are fine. I've checked IIS settings and blown the connection timeout to 9000
seconds.
It's as if the report is taking too long...
I've set all the URL stuff in the config files, but like I say, its only one
out of about a hundred reports that is failing.
Any ideas?
SteveHi,
I think this is something to do with your queries some where it is not
optimized. Just check whether the same query / procedure runs in your
management studio.
Amarnath
"Steve" wrote:
> Hi,
> I have a report that takes about an hour to run. When I run it, it runs for
> an hour or so with "Generating Report", then the result page is the standard
> IE "Action Canceled" page, and there is a javascript error. The javascript
> error is Permission denied.
> All other reports running on this server (which don't take as long to run)
> are fine. I've checked IIS settings and blown the connection timeout to 9000
> seconds.
> It's as if the report is taking too long...
> I've set all the URL stuff in the config files, but like I say, its only one
> out of about a hundred reports that is failing.
> Any ideas?
> Steve

Long report on one page?

I have a very long report that I would like to appear all on one page. I want to be able to scroll from the top to the bottom without having to use the little page selector. How do I do this?

I got it to work for one report so I know it's possible. I just can't figure out why it works for that report and not for other reports.

Thanks,

Greg Van Mullem

Has anyone even tried this?
|||

Hi,

Can you try with giving the report size - height as long as you expect the report to be? That will show the report in one page. However, if you try to print that report, it will compact the content and print all the content in one page (depends on what paper size you use)

Regards.

|||Interesting idea. I will give it a try. However, I still think there is an easire/better way. I have a long report where I did nothing special but it appears all on one page. Unfortunately I don't know what I did...

Thanks,
Greg
|||I assume you are using HTML or report preview. You can set the InteractiveHeight property on the Report to 0 in order to have everything on one page. You could also get this if you have toggleable or conditionally hidden items in the report.sql

Long report on one page?

I have a very long

report that I would like to appear all on one page. I want to be able to

scroll from the top to the bottom without having to use the little page

selector. How do I do this?

I got it to work for

one report so I know it's possible. I just can't figure out why it works for

that report and not for other reports.

Thanks,

Greg Van

Mullem

Has anyone even tried this?|||

Hi,

Can you try with giving the report size - height as long as you expect the report to be? That will show the report in one page. However, if you try to print that report, it will compact the content and print all the content in one page (depends on what paper size you use)

Regards.

|||Interesting idea. I will give it a try. However, I still think there is an easire/better way. I have a long report where I did nothing special but it appears all on one page. Unfortunately I don't know what I did...

Thanks,
Greg|||I assume you are using HTML or report preview. You can set the InteractiveHeight property on the Report to 0 in order to have everything on one page. You could also get this if you have toggleable or conditionally hidden items in the report.

logon.aspx won't render images or style

Hello - we are using the custom security extension and SSL on our reporting site. Everything works great except for the logon.aspx page. It functions fine but it won't display the embedded styles or images on the page. Any clue why that would be? We get a white page with broken image links.

Our uilogin.aspx page shows styles and images. We've cut and pasted this code directly into logon.aspx but it still doesn't work. I have verified that the files are in the ReportServer folder.

Thanks for any help you can give.

OK, we figured out a workaround. We have to use a URL to the Report Manager to be able to reference any resourced items like images and style sheets. Here's our image reference that works:

<LINK REL="stylesheet" TYPE="text/css" HREF="https://rpmreports.mycompany.com/reports/pages/LOGIN_SCREEN.CSS">

sql

Login with different Roles

Hello readers

I have a problem with the following:

I made a login page in Visual Web Developer 2005 and I used the ASP.net Configationtool in the Website menu. Made some couple test accounts to login and made a role: "Beheerders". Made 1 of my test accounts a "Administrators".

So my problem is when I log in with the account with the "Beheerders" role, i go to the page of the "normal user". I tried to look in many sites, I could find some nice aid but not 100% the one that could solve my problem.

This is my code i programmed in the seperatefile of Login.aspx

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports Login

PartialClass Login

Inherits System.Web.UI.Page

ProtectedSub Login1_LoggedIn(ByVal senderAsObject,ByVal eAs System.EventArgs)Handles Login1.LoggedIn

Dim userinfoAs MembershipUser = Membership.GetUser(Login1.UserName)

Dim UserRol()AsString

UserRol = Roles.GetRolesForUser(userinfo.UserName)

If (Roles.IsUserInRole("Beheerders") =False)Then

Response.Redirect("~\Index.aspx")

EndIf

EndSub

ProtectedSub Login1_LoggedIn()

EndSub

ProtectedSub Login1_LoginError(ByVal senderAsObject,ByVal eAs System.EventArgs)Handles Login1.LoginError

'Parameters instellen voor InvalidCredentialsLogDataSource

InvalidCredentialsLogDataSource.InsertParameters("ApplicationName").DefaultValue = Membership.ApplicationName

InvalidCredentialsLogDataSource.InsertParameters("UserName").DefaultValue = Login1.UserName

InvalidCredentialsLogDataSource.InsertParameters("IPAddress").DefaultValue = Request.UserHostAddress

InvalidCredentialsLogDataSource.InsertParameters("Password").DefaultValue = Login1.Password

'Er was een probleem bij het aanmelden

'Nakijken of gebruiker bestaat in de databank

Dim userInfoAs MembershipUser = Membership.GetUser(Login1.UserName)

If userInfoIsNothingThen

'Ongeldige gebruikersnaam...

LoginErrorDetails.Text ="Geen gebruiker met naam """ & Login1.UserName &""" in de databank !"

Else

'Nakijken of gebruiker Lockedout of Approved is

IfNot userInfo.IsApprovedThen

LoginErrorDetails.Text ="Uw account is nog niet goedgekeurd!"

ElseIf userInfo.IsLockedOutThen

LoginErrorDetails.Text ="Uw account is geblokkeerd wegens te veel mislukte aanmeldpogingen!"

Else

'Het wachtwoord was verkeerd

LoginErrorDetails.Text ="Verkeerd wachtwoord - """ & Login1.Password &""""

EndIf

EndIf

'Record wegschrijven naar datasource

InvalidCredentialsLogDataSource.Insert()

EndSub

EndClass

Thanks for your help.

Regardings

Griffin1987

I believe your problem here is that in the loggedIn event, the cookie is not actually set yet. To get the name of the user, use the name from the control which I think is

login1.UserName

Login Page Using SQL DB

I apologize because this question is probably so amazingly simple it sounds retarded, but I am a 100% newbie to ASP.NET --

I am using WebMatrix to create an ASP.NET login page (coding in VB), and I have a SQL server with a table in it called "LoginInfo". That table has three fields, "PrimaryKey", "UserID" and "PIN".

Basically, the goal is that the user goes to the page and enters their UserID and PIN into two different boxes and then pushes a button and it logs them into the page. My problem is, I have the UserID/PIN text boxes, I have the button, I have the SQLDataConnection (I just dragged the table from the Database onto the page and it made it for me), but I don't know what to do at all now.

How do I have the UserID text box check against the UserID's pulled from the table in the SQL server, and how do I have the PIN numbers check against the PIN numbers pulled from the SQL table, and then if they match up let the user into the site?

I'm sorry if this is a lengthy question to answer or if it is so simple its irritating, as I said I am a complete newbie.Have you gone through theASP.NET Web Matrix Project Guided Tour? There is a section called "Build an End-to-End Application" which containsCreate Login page that should help you.

Terri|||Thanks a TON tmorton, you're the best. This is a great resource I hadn't known about. I just read the entire thing for the login page and it's excellent. I will be reading many of the other tutorials also.

Thanks a million!|||There are lots of other resources for ASP.NET Web Matrix, and here are 2 more free ones that should not be missed:

Inside ASP.NET Web Matrix, which is a .PDF file containing a free online book by Alex Homer and Dave Sussman.

The .NET Show: ASP.NET Web Matrix with Microsoft's Scott Guthrie and Nikhil Kothari.

And also, there is a forum here specifically for ASP.NET Web Matrix:view forum 30

Glad to help!

Terri

login page problem with reportviewer for winforms

Hi,
My reportserver has forms authentication (for web based users).
When I now try to open a report in the winform report viewer I get an error
on the viewer about the login page. How can I pass the login credentials via
code to the reportserver?:
System.Net.WebException: The request failed with the error message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a
href='/ReportServer/pages/UIlogon.aspx?ReturnUrl=%2fReportserver%2fReportExecution2005.asmx'>here</a>.</h2>
</body></html>Hello bartVDA,
Thank you for posting.
Regarding on the windows form's reportViewer control, it is
programmatically requesting the report content from reportServer
application rather than interactively like the webbrowser control. Also,
since the form based authentication require the client-side always use
webbrowser to interactively request the report, this will break the winform
reportviewer(also webform reportviewer). BTW, for wniform application, you
can also consider directly lauch webbrowser to display the report through
the actual URL or use a webbrowser control in it though they're not as good
as the well encapsulated reportviewer.
Regards,
Steven Cheng
Microsoft Online Community 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.

Login Page just refreshes with ASP.NET 2.0 Login Control

I am try to login using the ASP.NET 2.0 Standard Login Control. When I enter the correct userId/Password and hit the Login button, the page just refreshes, no error is displayed. But if I enter wrong userid/password..it give me an error.

Also I check the Membership.ValidateUser() returns true, that means the user is validated, but still I am able to redirect to ReturnURL.?

Is there something wrong with the Authentication, or Creating a cookie. Can somebody shed some light on this,

I have the following machine configuration

Windows XP Pro Service Pack2
IIS 5.1
SQL Server 2000
Visual Studio 2005
DISABLE ANONMYOUS ACCESS IN IIS
ENABLE WINDOWS AUTHENTICATION

I am getting the following output :

Membership.ValidateUser(Login1.UserName, Login1.Password) : - True
HttpContext.Current.User.Identity.Name : - // is blank
User.Identity.IsAuthenticated :- False
User.Identity.AuthenticationType :- // is blank

NOTE : The applicationName is same in web.config as well as in the aspnet_Applications table in SQL Server 2000 membership database.

Do you have an error logged in the SQL Server error log file (name starts with ERRORLOG)?

If not, then you should post the question on an ASP forum.

Thanks
Laurentiu

Login Page just refreshes with ASP.NET 2.0 Login Control

I am try to login using the ASP.NET 2.0 Standard Login Control. When I enter the correct userId/Password and hit the Login button, the page just refreshes, no error is displayed. But if I enter wrong userid/password..it give me an error.

Also I check the Membership.ValidateUser() returns true, that means the user is validated, but still I am able to redirect to ReturnURL.?

Is there something wrong with the Authentication, or Creating a cookie. Can somebody shed some light on this,

I have the following machine configuration

Windows XP Pro Service Pack2
IIS 5.1
SQL Server 2000
Visual Studio 2005
DISABLE ANONMYOUS ACCESS IN IIS
ENABLE WINDOWS AUTHENTICATION

I am getting the following output :

Membership.ValidateUser(Login1.UserName, Login1.Password) : - True
HttpContext.Current.User.Identity.Name : - // is blank
User.Identity.IsAuthenticated :- False
User.Identity.AuthenticationType :- // is blank

NOTE : The applicationName is same in web.config as well as in the aspnet_Applications table in SQL Server 2000 membership database.

Do you have an error logged in the SQL Server error log file (name starts with ERRORLOG)?

If not, then you should post the question on an ASP forum.

Thanks
Laurentiu

Login Page

Hi,

i created my own table.it includes usr_name,usr_surname,usr_email,usr_password

and i have login form.it includes 2 texboxes.1 for login(email) and the other for password.How can i query the user on database if user on db and his password matches with his username.dont advice me to try asp.net membership please..i want to create my own.i am using sql,asp.net codebehind:vb.
if you give example with stored procedure it can be more useful for me.

thanks,

create procedure [dbo].[login_verify](@.user varchar(30),@.pwd varchar(20),@.msg varchar(30)
out) as
select @.user=username,@.pwd=password from users where username=@.user and
password=@.pwd
if @.@.rowcount=0
set @.msg='Invalid User or Pasword'
else
set @.msg='Hello world'

or

in aspx page

Function login_verify(ByVal user As String, ByVal pwd As String) As Boolean
con = New SqlConnection
con.ConnectionString = ConfigurationSettings.AppSettings("ConnectionString")
st = "select username,password from users where username =" & "'" & user & "'" & " and password= " & "'" & pwd & "'"
cmd = New SqlCommand(st, con)
Try
con.Open()
dr = cmd.ExecuteReader
dr.Read()
If dr(0) = user And dr(1) = pwd Then Return True Else Return False
Catch ex As Exception
Response.Write("Invalid Login or Password")
End Try
con.Close()
End Function

Thank u

Baba

Please remember to click "Mark as Answer" on this post if it helped you.

|||

Hi there,

take a look at this article I think it can be helpful.

http://support.microsoft.com/kb/910440

Regards,

Fernando

|||

thnx

Login Page

I am looking for a way to make my website secure. I use IIS on
Server 2000 to host my website. I would love to use windows
authentication tied into a login page. I hope to accomplish a secure
login page and all the pages after that are secure also. I am using
Dreamweaver MX currently to design my page. I am open to all
suggestions. Please help me.Not sure what this has to do with SQL Server?
You can mark a site, virtual directory, or folder as secured by Windows
Authentication by turning off anonymous access. You do this in the Internet
Information Services applet in the control panel (this may differ since you
didn't tell us what operating system you use). This affects the entire site
/ virtual directory / folder, not a specific page.
Followups set to microsoft.public.inetserver.iis
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Nathan Thompson" <ngthompson@.comcast.net> wrote in message
news:fdd8855c.0403091051.7552db14@.posting.google.com...
> I am looking for a way to make my website secure. I use IIS on
> Server 2000 to host my website. I would love to use windows
> authentication tied into a login page. I hope to accomplish a secure
> login page and all the pages after that are secure also. I am using
> Dreamweaver MX currently to design my page. I am open to all
> suggestions. Please help me.