OK, here is what I tried:

Page Header (textbox63)

=IIF(Left(ReportItems!RefText2.Value,3)="PUR","PURCHASE ORDER","RETURN ORDER")

textbox63 is in the Page Header. A second textbox in the page header references a textbox in the main body:

Page Header

=...

Thanks for that.

Phil.

The requirement changed (surprise, surprise) so this thread is no longer valid.

Regards,

Phil.

Thanks to all that have given time to this request.

Kind Regards,

Phil.

Thanks guys. All sounds complex 🙂

Many Thanks,

Phil.

Thanks for the update, I will see if I can work out how to modify from your example.

Many Thanks,

Phil.

Thanks for the reply. Maybe I do not follow but I would not be able to hard code the SalesOrderId values?

Many Thanks,

Phil.

Thanks John I will take a look. I used the standard controls available within MS VWD 2008(no coding on my part!).

Many Thanks,

Phil.

Hi John / Chris. It appears it was a setting on MS Visual Web Developer 2008. On the grid view when configuring the parameters there is an option to display...

Chris here are a few results:

exec bsp_intranet_productdesc_search @ProductId=N'FAL',@ProductDescription=N' '

exec bsp_intranet_productdesc_search @ProductId=N'FAS',@ProductDescription=N' '

exec bsp_intranet_productdesc_search @ProductId=N' ',@ProductDescription=N'TRANSMITTER'

exec bsp_intranet_productdesc_search @ProductId=N'FAS175C',@ProductDescription=N' '

If I enter a ProductID but leave the Product Description blank (i.e. no...

OK, I will give that a go and report back.

Phil.

Hi Chris that is better than it was but I am unable to leave one of the fields blank. If I do the query does not return any values, however...

Hi Chris, I will give that a go. I thought it was going to be simple 🙂

Thanks,

Phil.

OK still trying to get this working. My stored proc is as follows:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROC [dbo].[bsp_intranet_product_search]

@ProductIdNVARCHAR(100),

@ProductDescription NVARCHAR(300)

AS

SELECT DISTINCT TOP 100 ProductId,ProductDescription,CrossReference,ISNULL(CONVERT(VARCHAR,SUM(QuantityOutstanding)),'0')AS Quantity,'£' + CONVERT (VARCHAR(12),StandardPrice,1)AS StandardPrice

FROM Products...

I used the default instance.

Phil.