Figured out...

In Design view, right-click the design surface outside the border of the report and click Report Properties.

REPLACE([PRODUCT],"\""," ")

--------------------------------------------------------------------------------

Works!

The reason I have another IIf in the denominator is because we have Previous year again in denominator and this denominator can be zero too. If I do not use...

Wonderful !

Thank you so much. You made my day:)

I am able to get values when I pass parameters but how do I get it without typing any values.?

Did you try the matrix layout? That option can help this type of data.

Changing : Consumecontainerwhitespace to true helped get all data on one page 🙂

Now it displays fine in the header but when I export it in pdf ,

the first page shows data on the header but the 2nd page is a copy of...

Create one Report and add two data sets.

when you click on details > it will prompt you to choose the dataset.

No Worries,

I changed all margins(Top, Bottom,Left,Right) to 0 and it worked.

Setting the margins did help. But now I get one extra(Last) page in the pdf.

It only shows header.

How can i get rid of this?

Anything we can do in 2008?

The main report has a Product Id # in a pivot format giving monthly data and the subreport has all the attributes of the Product.

Yes its 2008.

Here is the script:

CREATE TABLE [dbo].[AnniversaryData](

[AnniversaryNumber] [varchar](10) NOT NULL,

[ARAmt] [decimal](24, 2) NULL,

[AnniversaryStartDate] [date] NULL,

[AnniversaryEndDate] [date] NULL,

[InvoiceDueDate] [date] NULL)

CONSTRAINT [AnniversaryData] PRIMARY KEY CLUSTERED

(

[AnniversaryNumber] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE ...