I am assuming this is in reference to your earlier question about splitting the data into 2 tables.I actually created report project just to try out your issue. Here's what I did.(1) Layout your report with 2 tables (2) In your data region:declare @spid intCREATE TABLE #TmpResults(rowid int IDENTITY, PlanId int, PlanName varchar(200), InvestmentName varchar(500), InvestmentType char(1), IsPortfolioFundOnly bit, InvestmentId int) Declare @PlanId intINSERT INTO #TmpResults EXEC ICCStatements..rpt_SelectInvestments @PlanId Select @spid = case when max(rowid)%2 = 1 then Cast ((max(rowid)/2) + 1 as Integer) else Cast (max(rowid)/2 as Integer) endFrom #TmpResults select *, @spid as splitvalue from TmpResults
so your result set will have the additional column SplitValue. (3) Create a parameter of type "Internal" , data type int, "From query" and choose the dataset and SplitValue as the label and value. (4) In your Layout, right click on the first table and go to "Filters". Create a filter with =Fields!rowid.Value <= =Parameters!SplitId.Value (where splidid is the name of the internal parameter we created).(5) Similarly, right click on second table and create another filter with =Fields!rowid.Value > =Parameters!SplitId.Value Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ 
The property ‘DefaultValue’ of report parameter ‘s
Posted - 2007-08-02 : 16:48:39
