Hello!

When you're trying to alternate the details, I use the following:

= iif (rownumber(Nothing) mod 2, "White", "Gainsboro")

When you're going off a group band, I use this:

= iif (RunningValue( Fields!YourField.Value , CountDistinct,...

Thanks Ray!

Yeah, that was what I got to fix the issue:

IF @GroupLeader = ''

SELECT     fields FROM  tblmain LEFT OUTER JOIN

(SELECT     Person AS GLPerson, WPID FROM  SigAuth WHERE Title = 'GL') GRPLDR ON tblmain.WPID = GRPLDR.WPID

ELSE

SELECT     fields FROM ...

I have the following for my report but get an incorrect syntax near ELSE and THEN:

IF @GroupLeader = '' THEN

                                             SELECT  GRPLDR.GLPerson FROM         dbo.Main LEFT OUTER JOIN

                                            (SELECT     Person AS GLPerson, WPId   FROM   SigAuth WHERE     ...

Thanks for the reply!

If I do:

WHERE     (GRPLDR.GLPerson LIKE @GL + '%') OR (GRPLDR.GLPerson IS NULL)

....then if I run the report for let's say "Clinton" for the person's last name, it...

Hi Antares686,

The column colNumber is actually a string since the user can define whatever format they need to be able to recognize it.

Does the report run in the designer?

I agree with Nigel! Something about the width of the report layout makes the page go to another page....but it shows as blank if you're right on the line...

Thanks Mike!

yeah...good ol' "OUO"...gotta love it!

I may get away with just having instruction to turn the page over so it can print regularly, and the user has to turn the...

It's a government report, and the report spec says it has to have a certain string value on the last page's back side.

On the last page of the report, I have to print on the back of this page.

I'm doing MSDN and Google searches w/ no hits!

Thanks!

my bad...should have mentioned it's an ntext column

Sorry...line should have been:

UPDATETEXT Testtbl.Task @ptrval 0 8

...since the start will be at the "amp;" (0), and for each character it's 2 bytes (8), and with saying nothing for the...

ah...sweet!

We're using the URL method!

Thanks for the help!

thanks for the reply Richard!

So..is this for the rspreviewpolicy.config file?

Yeah, haven't had the best luck with that format.  Subreports haven't been coming through with it either!