Databases
StackOverflow2013
Postsdbo
POHow do I dynamically modify a report using Crystal Reports?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I dynamically modify a report using Crystal Reports?
    text
    copied!<p>I want to know I can dynamically modify an existing Crystal Report <em>(using C# and Crystal Reports 2008)</em> so that it can report on fundamentally different data (from the same database) using the same layout. The reason is that we are building an application that allows the user to specify:</p> <ol> <li>A filter so that only the data they are interested in is displayed (i.e., whereclause). <ul> <li><em>[e.g., Only display buildings in NYC]</em></li> </ul></li> <li>Specify what tables are displayed <ul> <li><em>[e.g., Show buildings and floors but not rooms]</em></li> </ul></li> <li>Specify what fields are displayed <ul> <li><em>[e.g., Show building id, number, name, address and floor number]</em></li> </ul></li> <li>Change how a section is grouped <ul> <li><em>[e.g., Group by building use, build year, etc]</em></li> </ul></li> <li>Change the the fields used in a chart <ul> <li><em>[e.g., Area by Building Use, Occupancy by Building Use, Area by Building Id]</em></li> </ul></li> </ol> <p>Because of the flexibility of the UI there are many different kinds of "questions" the user can try to report on and I do not want to create a report for every possible combination. For an example of what I am trying to accomplish see the image below. The report on the left depicts buildings grouped by area. The report on the right depicts buildings grouped by site.</p> <p><a href="http://img119.imageshack.us/img119/9052/performancereportcomparbt7.png" rel="nofollow noreferrer">Report Comparison http://img119.imageshack.us/img119/9052/performancereportcomparbt7.png</a></p> <p><em>EDIT:</em></p> <p>I will attempt to be using report parameters to modify the report as suggested by Philippe Grondier. I have had success in doing this by suppressing groups. When a group is suppressed the groups slide up to fill the blank area so that everything lines up without blank space. However, the same behavior is not true of individual text objects. When a text object is suppressed the output for that field is an empty space. What I would like to do is suppress a text object such that the entire line is suppressed which would result in all the entries below it "bumping" up by one line. How can I achieve this?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload