sql server - How do I properly get a table within a table in SSRS? -


i'm trying create payroll register detail report. there number of sections report, there employee info section(name, id, masked ssn, etc) earnings section(pay type, hours, rate, , dollars, tax section(itemized list of taxes--fed, state, local, etc), deductions section(an itemized list of deductions--health, dental, etc), benefits section(health, 401k, etc). here image of report drawn model:

payroll register detail

for stored procedure, created following temp table:

create table #employeepaydetail( [id] [int] identity(1,1) not null, [employeeid] [nvarchar](30) null, [employeename] [nvarchar](50) null, [employeessn] [nvarchar](50) null, [checknumber] [int] null, [description] [nvarchar](30) null, [units] [decimal](19,5) null, [rate] [decimal](19,5) null, [amount] [decimal](19,5) null, [section] [int] null, [sort] [int] null   ) 

most obvious, however, section field used determine section going put data in.

1=earnings 2=taxes 3=deductions 4=benefits 

the name, ssn, , employeeid denormalized , first(x) used in employeeinfo section.

so thought put list region on body , put 4 tables 1 each section on list. each list filter on section. when tried received error:

the tablix '' has detail member inner members. detail members can contain static inner members.

so next tried put tables within cells of table. supposedly can nest tables. when tried this, received same error. asked google , suggestion got try put these in header section of table rather detail. when tried that, got of data run together.

any suggestions?

your list idea strikes me best. error received occurs when list has no grouping, contains tables. if group list on employeeid think should desired results.


Comments

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

php - .htaccess mod_rewrite for dynamic url which has domain names -

Website Login Issue developed in magento -