This feature is added in Report Builder 3, unfortunately it isn't available for report builder 2.

Hey Wendy

There is limitation in header display when exporting report to Word.

check this link for Word Limitations,

http://technet.microsoft.com/en-us/library/dd283105(v=sql.105).aspx

•Word does not repeat header rows on page two and greater, although...

You can go to Tablix properties and tick on "Keep together in one page if possible." That way all rows will appear in one page.

Right click on the parameter you just created and go to parameter properties.

Select Available Values.

click on Get Values from a Query.

Select the Dataset which you created to get Distinct...

Hi

I haven't used 20012 version, am still using 2008R2 and the workaround for this issue is,

Remove Page header and whatever parameter values you want to dispay, paste it in...

Try this, it may help...

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/942ef65d-97c8-4e56-b794-4d6a72ab519a/ssrs-2008-r2-matrix-column-group-page-break-for-different-excel-spreadsheet-tab?forum=sqlreportingservices

Hi,

I'm not sure if I've understood the problem but as per my understanding, you can create 20 data sets for each individual table. It need not be related... You should...

I can't believe but finally my script with 7-zip worked in SQL Server.

As per one of Tessiturian's suggestion, i used,

exec master..xp_cmdshell '\\dell\tessitura\source\7-zip\7zG.exe a "\\dell\tessitura\source\sso_pacingdata.zip" "\\dell\tessitura\source\sso_pacingdata.txt" -y'

To look at it...

Finally after so many days of R&D, i've scheduled the zipping task on Windows Task Scheduler and its solved my problem. I defnitely wanted to use master..xp_cmdshell on SQL Server...

Actually WINZIP is installed on my computer and also SQL Server but still doesn't work.

Will 7zip work same as WINZIP? does it need any command lien add-on etc? I can...

I've create batch file:

@Echo off

"\\keenm\c$\WinZip\WZZIP.exe" "\\Dell\Tessitura\Source\sso_pacingdata.zip" "\\Dell\Tessitura\Source\sso_pacingdata.txt"

---------------

Now i run

master..xp_cmdshell 'Text_Zip_Cmd.Bat'

It runs perfectly from command prompt but in SQL i get folloing error.

ERROR(\\keenm\c$\WinZip\WZZIP.EXE,103): WinZip is not installed.

You must install WinZip in...

All permission setup is done as per your suggestions but it still doesn't work. Now i feel may be my syntax is wrong.

Declare @cmd varchar(260)

Set @cmd = 'C:\"Program files"\WinZip\winzip32.exe \\Dell\Tessitura\Source\sso_pacingdata.zip...

Yes Pradeep, I created a batch file and it works fine from Command Promt. But that batch file doesn't work in SQL.

Zip file is in C drive, probably that is...