Column Help

7 posts, 0 answers
  1. Edward
    Edward avatar
    5 posts
    Member since:
    Oct 2015

    Posted 13 Jan 2017 Link to this post

    I have a report that needs modifying. The last two columns (Transaction Type & Transaction Amount) need to be changed to separate Transaction Amounts by Transaction Type.

    This is what the report currently displays:

    Transaction Type       Transaction Amount

    ABCDE                       500.00

    FGHIJ                        1500.00

    ABCDE-CR                2000.00

    etc.

    So, I need to figure out a way to, within the same report, separate all transactions that end in "-CR" in to another column. 

    So, something like this:

    Transaction Type        Credit Amounts          Non-Credit Amounts

    ABCDE                                                          500.00

    FGHIJ                                                            1500.00

    ABCDE-CR                 2000.00

     

    I would greatly appreciate any suggestion. Also, keep in mind that I am not a programmer when responding.

     

    Thanks!!

  2. Katia
    Admin
    Katia avatar
    693 posts

    Posted 16 Jan 2017 Link to this post

    Hi Edward,

    The described scenario can be achieved with expressions that can calculate the value of the TexBox conditionally. Inside the expression, you can use the combination of conditional built-in functions and text functions.

    Check the attached report demonstrating an example expression allowing to display the value in Credit Amounts and Non-Credit Amounts columns based on the value of TransactionType data field.

    Another option is to add calculated fields (Credit Amount, Non-Credit Amount) to the DataSource component and set their values to the similar expression.


    Hope this will help.


    Regards,
    Katia
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. Edward
    Edward avatar
    5 posts
    Member since:
    Oct 2015

    Posted 17 Jan 2017 in reply to Katia Link to this post

    Hi Katina,

    Thank you for your assistance!

    I was unable to open the sample file. I received an error message stating that it was incompatible. We only use the stand-along Report Designer. Should it be able to open the sample file?

    Thanks!

  4. Edward
    Edward avatar
    5 posts
    Member since:
    Oct 2015

    Posted 17 Jan 2017 in reply to Katia Link to this post

    I'm not sure if it makes a difference or not, but all of the reports we've created are .TRDX.
  5. Katia
    Admin
    Katia avatar
    693 posts

    Posted 18 Jan 2017 Link to this post

    Hi Edward,

    The attached report can be opened with Standalone Designer R3 2016 and later.

    TRDP format is an archived packaged of the report definition and its resources. Standalone Designer produces this format by default as of R2 2016.


    Regards,
    Katia
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  6. Edward
    Edward avatar
    5 posts
    Member since:
    Oct 2015

    Posted 01 Feb 2017 in reply to Katia Link to this post

    Hey Katia,

    Thanks again for your reply and assistance. I have been sidetracked with another project and am now circling back to this one.

    I checked Tererik's website to see where I might download the standalone report designer, however, I couldn't figure out where to get it without purchasing a license. We really only use the report designer.

    Thanks!

  7. Katia
    Admin
    Katia avatar
    693 posts

    Posted 06 Feb 2017 Link to this post

    Hi Edward,

    The trial version of Standalone Designer can be downloaded with the latest trial version of Telerik Reporting - your Telerik account -> Downloads -> Reporting.

    Paid version comes with purchasing one of the two licenses:
    For more detailed information about the licensing is available in Licensing help article. If you have further questions regarding the licensing you can contact our sales team directly.


    Regards,
    Katia
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top