Problema con ReportDesing / Problem with ReportDesing
Quote from joferar333 on November 7, 2021, 9:22 pm@asleycruz, @vadim, @gaev
Estimados estoy en un pequeño problema, al dar el alta a un usuario, intento que me imprima un reporte creado con el diseñador.
El problema se presenta que al poner una particion y traer las variables que debe imprimir me imprime bien pero todos los registros y yo solo necesito que me imprima el registro actual...
Si las variables las coloco sin una particion conectada a la base no me las imprime
Como puedo solucionar esto?
English
Dear I am in a little problem, when registering a user, I try to print a report created with the designer.
The problem occurs that when putting a partition and bringing the variables that it should print, it prints me well but all the records and I only need to print the current record ...
If I place the variables without a partition connected to the base, it does not print them to me
How can i fix this?
Estimados estoy en un pequeño problema, al dar el alta a un usuario, intento que me imprima un reporte creado con el diseñador.
El problema se presenta que al poner una particion y traer las variables que debe imprimir me imprime bien pero todos los registros y yo solo necesito que me imprima el registro actual...
Si las variables las coloco sin una particion conectada a la base no me las imprime
Como puedo solucionar esto?
English
Dear I am in a little problem, when registering a user, I try to print a report created with the designer.
The problem occurs that when putting a partition and bringing the variables that it should print, it prints me well but all the records and I only need to print the current record ...
If I place the variables without a partition connected to the base, it does not print them to me
How can i fix this?
Quote from PaulJonestindall on November 8, 2021, 12:33 pm@joferar333
The Report Designer can be very tricky and some things are very easy to miss. You must be carful which partition you use and the data you want to print.
It sounds like you're placing variables in a Data Body partition without a query or a query containing more than one record.
Sometimes you have to create a temporary table or even a temporary DB file to store the record data (even from multiple tables if you have relationships) to get a single record. Or, alternatively you can SetVar all of your record data to temporary variables without having to query the DB.
SetVar "[name]" "[DB.Table.name]"
SetVar "[address]" "[DB.Table.address]"
SetVar "[phone]" "[DB.Table.phone]"Now you can use the temporary variables to print a single record. You can use these variables in a report title partition if you want.
Do you have an example you can share?
The Report Designer can be very tricky and some things are very easy to miss. You must be carful which partition you use and the data you want to print.
It sounds like you're placing variables in a Data Body partition without a query or a query containing more than one record.
Sometimes you have to create a temporary table or even a temporary DB file to store the record data (even from multiple tables if you have relationships) to get a single record. Or, alternatively you can SetVar all of your record data to temporary variables without having to query the DB.
SetVar "[name]" "[DB.Table.name]"
SetVar "[address]" "[DB.Table.address]"
SetVar "[phone]" "[DB.Table.phone]"
Now you can use the temporary variables to print a single record. You can use these variables in a report title partition if you want.
Do you have an example you can share?
Quote from joferar333 on November 8, 2021, 11:27 pm@pauljonestindall
Thanks very much buddy! Your information is very valuable ...
Thanks very much buddy! Your information is very valuable ...