Column Help

[Edward]

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!!

[Katia]

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

[Edward]

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!

[Edward]

I'm not sure if it makes a difference or not, but all of the reports we've created are .TRDX.

[Katia]

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

[Edward]

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!

[Katia]

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:

• Reporting (also comes as part of the DevCraft license)
• Report Server

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