Are you setting the page size to 11 x 8.5 in the lay out options for the report. Also make sure that you are not overflowing the margins. I found...

You might want to refer to the following article before setting AutoShrink options

http://qa.sqlservercentral.com/columnists/mpearson/autocloseandautoshrinkjustdont.asp

The report is set to 14 x 8.5. I have played with the margins, but maybe not enough. I'll try that and post if it works. Visually it looks as...

The performance is NOT slow. It is in the design/layout mode when laying out the report that it is slow(insert more detail lines or whatever).  I can mess around with...

I set my printer preferences to landscape and that seemed to work. Thanks

yes, it prints landscape, unfortunately the report was exported in portrait, therefore it does me no good. In other words, only half the columns appear per page and there are...

The following worked. The only difference that I see is that I removed the blank line before the body of the function.??

Thanks for the assistance.

Public Function CalcPercent(totals as double, fldValue...

try select '''' + convert(varchar(10),getdate(),120) + ''''

or

select  convert(varchar(10),getdate(),120)  to get the date without quotes

We had the same problem, only our users were starting to get timeout errors. These connections are actually orphaned connections.  I've tried killing these in the past, but did not...

Interesting stuff. This database really belongs to another person in my organization. I checked and he is not backing up the log. I seem to remember reading somewhere that the...

So where do you find this free Reporting tool?  I found a trial edition but nothing that was totally free?

If you are doing multiple things in the stored procedure, it may actually be returning multiple recordsets and the results you are really looking for will have to be accessed...

Antares686

So basically you are saying that if any record is returned by the subquery regardless of what it is then it will evaluate to true. So by adding the...

You will note in my previous posts I said that the join of the sub query to the main query DID work.

At any rate, it is working, but...

If you run the following query Upc 0000000000500 is not returned. So why when you are saying and exists (which it does not) does it get returned in the original...