If I take out my last table, Signature_Authority, where I'm only pulling three fields, the report will run with about 219 pages.

I'm trying to figure out the average size of...

How can I find that out in query Analyzer.....datalength(spReport)

I'm trying the query in a sproc...spReport, but when I run it in the Report Manager to preview the report, it doesn't...

26930 rows

The report, unfortunately, is suppossed to give the user all the data so they don't have to go in and print for individual IDs.

I'm using a list object for all...

What I did, and it worked, was take some width off the right side by just a "snap", and that solved the issue.  Maybe putting the width on 6.5, even...

ofir shoval,

Thanks!  That's what I found to do in my book!

Thanks Mark.  I'll try it out.  I was told not to worry about this for the report, but I'm sure it'll help in the future.

Well, I got it to work finally.  I knew the report worked since it was a copy, and that original report was working.  I had to set the parameter back...

The problem was my join b/n the two tables.  Needed Left Outer to solve the issue.

This is for a textbox on a report.  Will that not take in the Expression Editor for SQL Server Reporting?

Do I need to go to: Report/Report Properties/Code and do a...

Just tried this for the expression:

=

if isdbnull( Fields!Start_Date.Value ) OR

Fields!Start_Date.Value = cstr("01/01/1900")

then textbox35.text = "X"

end if

....and it basically gave me an error of "Expression Expected"

Can't you use a nested IIF like

=IIF(

Fields!Start_Date.Value = cstr("01/01/1900"), "X",

IIF(

isdbnull(Fields!Start_Date.Value),"X",""))

Basically, I have to check for a smalldatetimefield, and if it's "01/01/1900" or <NUL>, then the textbox has to...

Thanks ofir!  I'll try that.

We may have gotten it to work.  I used the targetserverURL for the hyperlink, and the parameter worked.

Sorry, the link is more like:

"https://server/Reports/Pages/Report.aspx?ItemPath=%2fMigration%2fWPNew

&WPPIDParam=" & strWPPID & "

SP2 definitely did the job!  Thanks!

The "print preview" is terrible, and we're having to constantly juggle things around!

Thanks for the tips!