DB-Cross Percent instead the count

JotaPlayssonJotaPlaysson
edited July 2012 in FastReport 4.0
I Have two tables and i need cross then, but instead show the count, i would like show the percentage of the value, but i cant performe this, someone can help me?

Thanks

Comments

  • JotaPlayssonJotaPlaysson
    edited 6:46PM
    Is it possible? I already search a lot, but I don't found nothing...
  • technisofttechnisoft
    edited 6:46PM
    JotaPlaysson wrote: »
    Is it possible? I already search a lot, but I don't found nothing...
    Can you calculate the percentage as part of the query?
  • JotaPlayssonJotaPlaysson
    edited 6:46PM
    I can, but i'm afraid of my query become very slow, cause it brings very information from a table with very information too.
  • technisofttechnisoft
    edited July 2012
    JotaPlaysson wrote: »
    I can, but i'm afraid of my query become very slow, cause it brings very information from a table with very information too.
    Indexes on the tables and possibly using stored procedure for the %age calculation, for the processing of 0 values if there are anyentering the equation, should be able to cope with your concerns.
    What is your database engine?
  • JotaPlayssonJotaPlaysson
    edited 6:46PM
    I'm using Postgree. I'll search about the stored procedure,maybe it solve my problem, because I made the query bringing the percent and it taked a acceptable delay, but when i put in DBCross the datas was not correct. I did not understand what happened...

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2025