Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Depending on the kind of update (and objects concerned by the update), you can use either the free craxdrt.dll (Designer Runtime Library.) or the not free craxddrt.dll (Designer Design and Runtime Library). I forgot the details but you will surely find them on the net.</p> <p>Your questions:</p> <ol> <li>Filter: it is possible to update the SQLQueryString of the report object at runtime or to update predeclared parameters so that they will be added to the 'Where' clause. I think adding parameters is limited to the craxddrt dll but updating existing ones can be done with the craxdrt dll. You can use the CR interface to update these parameters, or do it through code: one idea would be to update these values in your client interface (from the active form for example) and update them programmatically. Please check <a href="https://stackoverflow.com/questions/382256/crystal-reports-default-parameters#382492">here</a> for an example.</li> <li>Hidding tables: I don't think that 'hidding tables' makes any sense, as you will need your tables to have all your relations available to calculate your summary values. Thus you can propose to your users the possibility to view/hide details or to view/hide your different grouping levels. This can easily be done with the free craxdrt library and the 'areas' collection/'suppress' method of the report object.</li> <li>Once again, playing with the different areas of the report seem to be the best solution here</li> <li>I advise you not to think about it! Changing data order can lead to unpredictable results, specially when you calculate intermediate summaries at the group level. Depending on your requests, you could stick to proposal (2), by displaying of not a specific group on the report, or, for simple forms (1 group only), programmatically update at runtime a parameter that will be used in the group definition formula.</li> <li>Back to proposal (2): build a complete report will all expected data to be displayed, then hide/show the different sections of the report.</li> </ol> <p>There is another code example available <a href="https://stackoverflow.com/questions/204611/crystal-report-datasource-remap#217756">here</a>, showing you how to change the report connection to a different database/different tables at runtime.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow do I dynamically modify a report using Crystal Reports?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USPhilippe Grondier
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I dynamically modify a report using Crystal Reports?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks! I am going to try proposal (2), using parameters to hide undesired sections; however, I am having difficulties making this work for text fields. Details in the original posting.
      singulars
      1. PO
      1. USRyan Taylor
    2. COProposal (2) was the correct solution. Ultimately I created group/detail sections for each text object where the sections where suppressed if the field was blank. Additionally, the text objects where suppressed based on a passed in parameter. This had the effect that I wanted. Thanks for the help!
      singulars
      1. PO
      1. USRyan Taylor
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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