I have two datasets in report builder 2.0. The first datatset is at top with just one row. Second data set has same number of columns but around 100 rows. I succeed with freezing the columns of second dataset when scroll for 100 rows. But i need to freeze the first dataset at the top (just above the second one), so that when i scroll the 100 rows of second dataset, i can see the above table and columns of second dataset all the time.Is there is something in report builder for this? Any help is appreciated. Thanks, Punia

Sorry, I cannot think of any way you can do this in report builder. If you can combine your two datasets into a single dataset then you probably could do it. Or, if you are using SQL Server 2008R2 or later, you can use the lookup function so that your report only has one table in it and the lookup function calls data from your secondary dataset. That would probably be your best bet. then your table would probably have several header rows, one of those rows would contain your lookup functions to produce the row you would like frozen. reply back if this does not make sense. Gene

Hi There This could be achievable please do the following Create your separate report for first dataset which is on topCreate a report for your second data set and create header row Set the fixed headerrow property to trueCreate another row on top of your header rowInsert sub report inside that header report and point to the first reportYou are done J I am putting screenshot for your help Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Thanks Syed. I want the report exactly as your screen shot. I tried to do it the way you said. But i got error. Actually i have to add new columns now in below dataset, so number of columns are not exactly the same as of top dataset (Top datset with one row has 10 columns, Below dataset with 100 rows has 17 columns).So for different data sets will it be the same procedure? Also I don't understand where to drag the subreport ? i mean which cell of tablix?

Hi there you do not need to as both reports are working independently to each other you have added a report on the top row of your header row by just merging the cell Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Hi Syed, I do exactly the same way. I insert one column above the column of second report and merge it. Then i drag the subreport into that row. And then browse the subreport in subreport properties. But when run the report. In top row where i drag the subreport, it says: Error: Subreport could not be shown. Any thoughts? Thanks for help Punia

Hi There Please make sure sub report is running independently Does it require any parameter then you need to pass those parameter as well Please right click on header row of your report and insert row above the header row and then insert sub report Did you run the sub report separately? Is it working ? Please reply Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful please see this link too http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/2dbf25de-e457-4574-aeae-096bf5117ea4/

You are right, There was some problem in top report, i fix that, Now it runs. Thanks. But can i freeze the top report and top column row of below second report. so that when i scroll the rows for below report, i can see the top report (subreport) and header row of below report as well. Also can i use the same parameters for both the reports? Thanks, Punia

Hi There Please go the main report table and go to properties of that table and Set the fixedheader property to true Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Hi Syed, hmmm... I am adding my snapshot. This is what happens to my report. The numbers for below report are scrolled fine, but the header are somewhat showing weird behaviour.

Thanks Syed. I can fix the header row of main report and it works while i scroll dowm for 100 rows. (without adding the subreport) But setting the same prpoerties doesnt works out for subreport (added above the header row of main report). Did it worked for you? Thanks, Punia

Hi Syed, There is little change in the report, there will be only one header row now. My problem got solved. I didnt use subreport as per new requirement. Below are the steps that follow. Step1 - I create two datsets. One for all records(datasets1 with around 100 rows to be scrolled down), other one (dataset2 with one row to be freezed ). Step 2 Create the matrix for dataset1, and then add the row above the row group (go for Outside group above option) Step 3 right click the cell for each added column and go to expression. Step 4 click on Datasets in Category, and select the dataset2 from Items, click on the column name what you want to display) Step 5 In Advanced mode, go to row group click the first static option and go fixed data (true), Keep with group (none), repeat on new page(true). But for Second row static property go for fixed data (true), Keep with group (after), repeat on new page(true). Thanks for you help. I really appreciate that. Punia

Hi There In my case it does both my sub report as well as my header row move when I scroll down Please have a look on the attached picture, you can see something in the background of the top row(in which I have embedded the sub report) If you have any questions pelase let me know Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi There It seems that it is working for you as well which is good. The issue which you are facing as far as I can think of is related to the width and height of your sub report please removes all the space, header row footer row everything from that sub report then this problem hopefully resolved. Your report will be look like this report with just one line of details Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

not sure my friend.