locked
print value on report RRS feed

  • Question

  • User388251979 posted

    http://i68.tinypic.com/fuaujc.png

    i have this report 

    i fill name , profession , address and Date from my database 

    i have problem to fill the part of Tasks conclusion  which  based on tasks 1,2,3 and 4

    if the four tasks with value  "A "  the output will be  Excellent

    if task 1 , 2,3  "A"  the output will be  Very good 

    so please any help at  this 

    Tuesday, January 12, 2016 10:43 AM

All replies

  • User-219423983 posted

    Hi Mido15,

    I think one key point of your needs above is how to get the final result. If I’m wrong, please let me know. If so, you could have a look at the following suggestions.

    1. Combine the first four columns to a new column to get a string value;
    2. Refer to the following thread to get the count of “A”, then you could get the result according to the count.  “4” is “Excellent” and “3” is “Very good”.

              http://stackoverflow.com/questions/9789225/number-of-times-a-particular-character-appears-in-a-string

    After getting the output result, you could bind it to your report.

    Best Regards,

    Weibo Zhang

    Thursday, January 14, 2016 7:54 AM