1. Víctor Vázquez
  2. Valentina Reports ADK
  3. Donnerstag, Februar 23 2023, 01:21 PM
  4.  Abonnieren via E-Mail
Let's see if you can help me with a small problem..
I am using Valentina 12 purchased with Omegabundle with No. 220720 00176749 and with the Report I have a problem that I did not have when I used Crystal Reports from Visual Basic:
There is some way so that certain numeric fields with a zero value do not print the zero.
I am attaching an example of an invoice in which I would not be interested in some fields appearing if they have a zero value. And framed in red are the examples of those fields that should not appear when the fields have a zero value.
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Víctor,

Numeric fields - come from the database, not the result of an expression, summary, etc, right?

Then you can use print_if with SQL expression in the format:
field_name > 0

Like on the screenshot.
Anhänge
Kommentar
There are no comments made yet.
Víctor Vázquez Akzeptierte Antwort
Thank you very much Sergey

Yes, I had already tried using the "print_if" ` expression because it seemed like the most logical function for what I wanted (and is very similar to what I did in Crystal Reports for Visual Basic), but it gave me a strange SQL error that I did not understand...
But seeing that you advised me to use that expression, I examined the error further and managed to solve it. The problem is that in the list I use 2 tables that are linked and I had a field that was called the same in both tables... and that was the error that was causing me in the Query SQL. I have changed the name of that field in one of the 2 tables and the problem has been solved !!!. It was a mistake on my part.

Thank you very much for your help, because it already had me desperate

The truth is that every time I like Valentina Reports more and more and I find myself happier with the product.
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories