Showing posts with label screen. Show all posts
Showing posts with label screen. Show all posts

Thursday, March 29, 2012

Dynamic report on screen vs. export

I was wondering if it's possible to display a report, but export an expanded version of that report? For instance if I have a report with, say, 6 columns, when the user exports to Excel I want to export 12 columns (6 that were displayed plus 6 additional columns). I tried hiding the additional columns, but they're also hidden in the export. I ended-up creating a separate report all together for exporting, but this is confusing to the user. Is something like this even possible?

Unfortunately renderer-specific formatting adjustments are not supported. You will probably need to construct two versions of the same report (one with the extra columns) and instruct your users to use the appropriate one for the output format.

Sunday, February 26, 2012

Dynamic Crystal Reports w/ .NET

I am trying to replicate the following screen in a Crystal Reports for .NET.

http://bellsouthpwp.net/w/i/wilburton/Schedule.JPG

I am having problems. You cannot create a formula for the position/width of a box or textbox. Also, there doesn't appear to be a way to write code to format the template as each row is processed. Change the width/left of the boxes only changes the template before the data is processed and the report is created.

I talked to Crystal Reports technical support and there only decent suggestion was to use a bar chart. This almost works but due to the flexibility of the charting components I don't think I will be able to get anything reasonably close to this format.

Any ideas?Maybe a chart would work?