Print Lable base on Parameters

[Ed Dror]

Hi there,

I'm using Access 2003 And SQL 2000

I have a report base on Stored Procedure:

ALTER proc usp_PivotFinal @Company char(3) , @First char(3), @Last Char(3) ,
@AcctF Char(4), @AcctL Char(4) AS
SELECT Company, Bldr, Tract, Acct, Subacct, Lot, LastDate, B, U, M, P, K, C
,S, GrossProfit
FROM dbo.vPivotFinal
WHERE Company = @Company and Subacct Between @First and @Last And Acct
Between @AcctF and @AcctL


As you can see I have 3 parameters
1. Company
2. Sub Account From to
3. Account From to

My second parameter could have interval from 0 to 399 and from 400 to 999

Now I want to create a Label in report header that show

"Production" for 0 to 399 and "Repair" for 400 to 999

but the problems is in access I can't see the Parameters as an object, and
object range ?

Thanks you an advanced.

Ed Dror

 

[David Lloyd]

Ed:

The following KB article may be a good reference, depending on your exact
needs.

http://support.microsoft.com/default.aspx?scid=kb;en-us;208630

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi there,

I'm using Access 2003 And SQL 2000

I have a report base on Stored Procedure:

ALTER proc usp_PivotFinal @Company char(3) , @First char(3), @Last Char(3) ,
@AcctF Char(4), @AcctL Char(4) AS
SELECT Company, Bldr, Tract, Acct, Subacct, Lot, LastDate, B, U, M, P, K, C
,S, GrossProfit
FROM dbo.vPivotFinal
WHERE Company = @Company and Subacct Between @First and @Last And Acct
Between @AcctF and @AcctL


As you can see I have 3 parameters
1. Company
2. Sub Account From to
3. Account From to

My second parameter could have interval from 0 to 399 and from 400 to 999

Now I want to create a Label in report header that show

"Production" for 0 to 399 and "Repair" for 400 to 999

but the problems is in access I can't see the Parameters as an object, and
object range ?

Thanks you an advanced.

Ed Dror