Cross tab, how to highlight cell value by value from DB

zgortanzgortan
edited 2:53PM in FastReport 4.0
Hello,

Is possible in to highlight cell value by different value from DB?
For example: DB has following values:
1, A, 100, 1
1, B, 120, 1
1, C, 110, 2
2, A, 90, 1
2, B, 150, 2
2, C, 120, 1

in frxDBCrossView I have: 
A   B   C
1  100 120 110
2   90 150 120

... so is possible to highligh cell("1","C") and ("2","B") e.g. to Red (because 4th field in DB is 2 (not 1))? ... or how in OnPrintCell event read field from database 4th column field?
Thanks in advance!

Comments

  • gpigpi
    edited 2:53PM
    Try to write user function to select 4th field from table
  • zgortanzgortan
    edited 2:53PM
    gpi wrote: »
    Try to write user function to select 4th field from table

    Thanks for reply ... but I still don't know how in FR to loop each field from dataset ... DBSet.FindFirst, .FindNext... doesn't work.
    Is possible to get one example?

    Regards...
  • gpigpi
    edited 2:53PM
    See a Developer's manual "Custom Functions Connection to Report"
    You can select 4th field from DB in user function. Use first, second and third fields as parameters of user function
    Call user function in cross OnPrintCell event

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 2024