How to create a report with Crystal Reports parameters?

Asked

Viewed 2,788 times

6

How to create a report with parameters in Crystal Reports? Create the report for me has no problems, but now I need to filter it according to some parameters of the system table.

Can someone help me with some example?

2 answers

1

It is quite simple to use parameters as a filter:

  1. Right click on Parameter Field > New...
  2. Fill in the required values. For example, for a Start Date filter (basic):
"NOME": DataInicial
"TIPO": Data
"LISTA DE VALORES": Estático
  1. Right click on report > Report > Select Expert > Record...

  2. Select the field to be filtered with the parameter Start Date > OK

  3. In the check-box where is written "any value", select "Greater or equal to" and in the field in front type the name of the parameter created between {?PARAMETRO}, in the example would look like this: {?}

Ready, filter made.

-1

What data source(s) you are using ?

Depending on the Data Source, a Stored Procedure for example, the CR creates the parameters.

Otherwise, in a query, just create the parameters (Parameter List)

Other than this, Field Explore, Parameter, New

The question is to link to some Filter, but this depends on the Data Source

=================

Yes, but somewhere you need to filter or it makes no sense to have a parameter.

Formulas of Selection __Register

  • So I’m using a normal Oracle database. I Linkei, created the parameter and even assign the value at the time of execution. But I don’t know if you need anything else. No comparison was made for an information filter, I simply created the parameter and assign its value.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.