Fill a parameter field in Crystal Reports

Asked

Viewed 1,292 times

1

I have a report from Crystal Reports where I must pass parameters for the search, however one of these parameters must come filled with a default value that is nothing more than a field of type memo of a view from the database. This field must allow the user to edit it so that this result can be entered in the report. In practice I tried the following syntax:

Campo de parâmetro := Tabela.Campo

I realize this code doesn’t work on Crystal.

sql parameters crystal-reports

  • Wouldn’t it be better to have a formula !? Getting the parameter value !?

  • Motta, thanks for the feedback. The problem of being a formula is that in this case I have no way to edit what is written. I believe that the formula, receives the value of the parameter that was preset, in my case this parameter should be filled and opened for amendment and this result will go to the report. I hope I’ve made myself clear.

  • I didn’t understand the problem , if the user passes "XPTO" in the parameter this can be in the report , but if you want to edit the report , this is it ? I’m not sure I understand the problem.

  • Motta again thank you for answering. Imagine this, I have a table called Insumos this table contains the data that is used in a production order. When I report the parameter screen opens with the blank fields, because I am expected to put parameters there to generate the report. In my case, I need one of the parameter fields to be already filled with the information of a table field, this parameter should allow me to edit it, so yes, the edited information to be released in the report. I hope now I’ve made myself clear.

1 answer

1

This is not done in the CR but in the interface layer (when it is the case), in it before you can mount a "form" and in it you do searches in the BD for the parameter assembly, queries to typing tables , cities , Ufs , customers etc.

It cannot be done in CR because there would not be a Data Source for this , in CR the maximum that can be done and set a "default" in the parameter.

How is your interface layer ?

  • Good morning Motta, once again, I am honored by the comments. My user interface layer is SAP B1. Let me ask: Is there any way to insert an SQL query in the default value field of the parameter configuration screen. This would be enough, because, as I use a view that already brings the formatted data from the database, the data would already be entered in the default value as needed.

  • In SAP I don’t know but in the ERP I use (Microsiga TOTVS) you can create a "ASK (SX1)" which is a standard user interface question , in this "ask" if you can suggest values , this "ASK" at the end is passed by parameter to a report Crystal Reports , CR must have such an interface with SAP because they are the same corporation now.

Browser other questions tagged sql parameters crystal-reports

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