Create formatted report using reporting

benyamin jain asked on July 20, 2019 15:31

is it possible to generate report like this using reporting module or custom report?

Image Text

Thanks in advanced

Correct Answer

Brenden Kehren answered on July 22, 2019 15:44

Simply stated, you cannot do what you want without some sort of effort on your end to create complex and/or nested T-SQL queries AND some sort of custom controls within the reporting module. Keep in mind you can use macro syntax in the report builder under the Layout section.

I have 2 suggestions:

is to look at creating your own custom control(s) to do this work based off of the Reporting module controls (webparts and module controls).
Create custom macros to query the data within the report executing.

1 votesVote for this answer Unmark Correct answer

Recent Answers

Brenden Kehren answered on July 20, 2019 16:41

It is possible. Have you looked at the Reporting module? You can pretty much create any report you want as long as you know the SQL to write to get the data.

0 votesVote for this answer Mark as a Correct answer

benyamin jain answered on July 20, 2019 19:04 (last edited on July 20, 2019 19:05)

Thanks Brenden

but as i know we have limited type of reports.

can you provide more information ? how it is possible to generate mentioned layout such that each value displayed in its cell?

0 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on July 22, 2019 12:35

When you will create a table report and set it in the way the data will be in desired cells, then yes - then you can export this table report into Excel.

0 votesVote for this answer Mark as a Correct answer

benyamin jain answered on July 22, 2019 14:12 (last edited on July 22, 2019 14:14)

Thanks Juraj Ondrus

Thank for your reply.

Here i don't talk about exporting but i talk about creating a report that give me a layout like those images.

Image Text

by using custom macro and transformation (ex:InventorySummary.ApplyTransformation) we can generate this layout for our report same as what we do in generating Invoice in eCommerce(this solution need hard coding). On the other hand in reporting module we can created limited set of report types (Tables,Graphs,HTML graphs,Values) that has predefined layout. these types don't allow us to generate a report like image mentions above or at least i could not find any solution. in another word i want to create a report exactly same as above image by using reporting module. is there any way to do this?

Thanks

0 votesVote for this answer Mark as a Correct answer