What kind of grouping do you have in your report? Could you post some sample data (not real please - we don't want to see anything we are not supposed...

I used your data and just copied it to a text file. Then on the Data tab, I chose From Text, and specified during that process that the recorddate...

Wow... from what century did you get that example from?

For starters, your parameters aren't declared. The easy way to reuse parameters is to declare them first and then...

One thing that nobody has mentioned is the fact that you may have to rewrite VBA code. Can work great if your front end and back end are Access,...

(Pretending to be Steve, but not as smart)...

You write to a temp table the same way you write to any other table.

INSERT INTO #tempTable(col1,col2,col3)

VALUES ('col1value','col2value','col3value');

OR

INSERT INTO #tempTable(col1,col2,col3)

SELECT colA, colB, colC

FROM...

I should have realized that you can't use that expression in the filter. I was just trying to point you in the right direction (and that part seems to...

You probably need to change the stored procedure something like this:

SELECT

DM.DriveID,

DM.FromDateTime,

Acct.AccountID,

Acct.Name,

Inc.Description [Incentive],

DPaCT.ProcedureProjection [Proc_Proj],

DPaCT.ProductProjection [Prod_Proj],

DPaCT.ProceduresPerformed [Proc_Perf],

DPaCT.ProductsCollected [Prod_Coll],

DPaCT.QNS [QNS],

DPaCT.FTD [FTD],

(isnull(DPaCT.ProductsCollected,0))-(isnull(DPaCT.ProceduresPerformed,0)) [DRBC]

,ROW_NUMBER() OVER (PARTITION BY Act.Name ORDER BY Acct.Name) AS rn /* note...

Maybe

=DateAdd(DateInterval.Day, -1, Today)

(wow, makes me hate SSRS!!!)

Something like this?

SELECT x.id

, DENSE_RANK() OVER (ORDER BY x.id) as DenseRnk

FROM

(SELECT 'A123' AS ID

UNION ALL

SELECT 'A124'

UNION ALL

SELECT 'A124'

UNION ALL

SELECT 'A123'

UNION ALL

SELECT 'A127') x

And then do like Phil said and...

What are you trying to accomplish with the >= comparisons here:

where [term]=@term and ([position]=@position)>0

and [value_per_month]=@value_per_month >0

?

if you're trying to validate that the values passed to @position and @value_per_month are...

instead of this:

SELECT * FROM rCTE

ORDER BY Item_NO ASC

insert into the temp table

INSERT INTO #TempTable(Columns)

SELECT columnlist

FROM rCTE

ORDER BY Item_No ASC;

Start here maybe? (MS Log Parser utility)

You might be able to set the VISIBLE property of the control in the report based on the value in it... other than that, I'm not sure how you would...

You do realize that reports are read-only, right? You can prompt for parameters, but only before the report is run. That would be the only place you could modify...

Are you just trying to filter out the records that do or do not meet some criterion? If so, use a Filter and tie it to a parameter value, so...