Help on report layout

Question

User-431851830 posted

Hi,

I have an requirement to create a report with the following layout in excel. Any help is appreciated.

Last   Name	First Name	Address	License	type	Number	NPI
Test LN1	Test FN2	TestAdd1
			LN1	Type1
			LN2	Type2
					No1
					No2
						111111
						22222
Test LN2	Test FN2	TestAdd2
			LN3	Type3
			LN4	Type4
					No3
					No4
						33333
						444444

Answer 1

User-431851830 posted

Any help?

Answer 2

User1644755831 posted

Hello erobinson,

Is this how you also want to render the report or just when you export to the excel? If you want to render and export it same like this. then I would suggests that in your tablix you set the datasource and format the blanks on the sql it self I mean where ever you need the spaces just put those columns null in the SQL server. you wont be needing to format anything on SSRS if your dataset looks like this.

With Regards,

Krunal Parekh

Answer 3

User-431851830 posted

Hi Krunal,

Could you please provide some more sample on the tablix format?

Do I have to use one dataset or multiple dataset?

Any sample code or example you can provide?

Thanks.

Rob

Answer 4

User1644755831 posted

Hello erobinson,

Please see this tablix examples:

https://msdn.microsoft.com/en-us/library/ee208912(v=sql.105).aspx

https://msdn.microsoft.com/en-us/library/ee208845(v=sql.105).aspx

https://msdn.microsoft.com/en-us/library/ee240480(v=sql.105).aspx

Do I have to use one dataset or multiple dataset?

This completely depends on your requirement usually we set dataset as datasource which have one or more datatables.

http://www.sqlservercurry.com/2011/04/sql-server-designing-tablix-report-in.html

With Regards,

Krunal Parekh