Wednesday, March 21, 2012

Formatting Drill Down Reports

Morning all,

I'm using report builder to create reports on Employee information. When the report is viewed through Report Manager you get the automatically generated drill down reports wherever there is a relation in your data model. This i'm sure everyone knows.

My question is, when navigating through these automatically created reports is there anyway to format the output, I only ask because the reports created are often created with two colomns which span the entire web page the first column is left justified and the second is right justified creating a huge gap in the middle. Couple this with the fact that there are no borders seperating the rows and the rows become very hard to match up.

Any info is much appreciated, thanksWhile creating a model, you can see entities having attributes. Select entities and open property window which will display all the available properties for entities. Now select property defaultdetailedattributes, here you can select fields to be displayed for drilldown reports.

You can set attribute size by selecting available attribute in the entity. Select attribute> properties > width for adjusting field size for drillthrough reports.

By default, model will take width of each fields same as in database schema. It may possible that some fields are long in size e.g. String data fields

I hope this will be helpful to you

No comments:

Post a Comment