Create SSRS Report

(0) Share

Report

Posted on by Voltes

596

Hi guys,

Just want to get an advice, if I want to create SSRS report in FO, a summary like, something like this :

As this is using different tables all together : SalesTable for the sales summary, InvoiceTable (custInvoiceJour) for the invoice summary, etc. In the making of the report it self, I understand I need to create temporary table. Should I create tables for each summary or to create 1 table to hold all those information ? Understand the columns are different.

So, what actually the best approach here ?

Thanks,

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

GirishS 27,827 Moderator on at

Like (2)

Report

Hi Lars volt,

Its better to go with different tables. Because the sales summary will have item id and also sales settlement will have item id, So it will be hard to find out which line belongs to the sales summary and sales settlement and show on.

But if you want to go with single table you must create one seperate enum field like "Sales summary", Sales settlement etc. While inserting lines for the each you need to insert that enum value also.

So in the report design you can add filter valurs to the respective grids(Sales summary, Sales settlement etc) with enum values.

Thanks,

Girish S.

Was this reply helpful? Yes No
Voltes 596 on at

Like (1)

Report

Great advice. Thanks Girish.

Was this reply helpful? Yes No
Suggested answer

Arunraj Rajasekar 1,743 on at

Like (1)

Report

Hi Lars Volt,

You can accomplish this with a single temp table. In this design, how you categorise the records in the table is critical.

For example, if the first three reports contain the Itemid and customerId, you can create a field in the temptable called ID and enter the itemid and customerid into that field.

Use one more field to sort the records for each section, as Girish suggested.

Create one tablix with four rows for report design. Insert one tablix for each summary within each row.

Was this reply helpful? Yes No
Voltes 596 on at

Like (0)

Report

Hi, I like the idea of creating 1 temp Table only.

May I ask some further question, like how exactly the filtering ?

I created a based enum for the report section, lets called it MyReportSection with elements : Header, SalesSummary, PaymentSummary.

In SSRS, I put a Table layout, then in Filters, I'm thinking I should add the condition of the section, should I need to separate them in some blocks in the report, right ? So for the next section, I will add another Table with the other filter condition. Am I right to think this way ?

How to put the Base enum value inside the filter, btw ?

As above, the "ReportSectionName" is the field that holds the report section either "SalesSummary" or the others.

Is this correct and what value I should give ?

Thanks,

Was this reply helpful? Yes No
Verified answer

GirishS 27,827 Moderator on at

Like (1)

Report

There is a similar design available in the standard. Refer to PayrollPayStatementReport where there will be a multiple Tablix and each Tablix have filters specified.

Thanks,

Girish S.

Was this reply helpful? Yes No