SAP Knowledge Base Article - Public

1877142 - How to add field horizontally in Crystal Reports dynamically

Symptom

For Example:

There is a need to show the information related to the customers in a report. Since the number of Customers changes, need to find a way to dynamically add the varying information related to a customer.

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011

Resolution

Use the below steps to resolve the issue:

1. Create a formula : @test with the syntax as shown below:

numbervar n;

stringvar s;

for n := 1 to {Field} do

(

s := s + "field " + totext(n,0) + " _________ ";

if Remainder ( n , 5 ) = 0 then ('5' is the number of fields you want to show horizontally)

s := s + chrw (13) ;

);

s;

2. Drag and drop the formula in the detail section.

Keywords

add field horizontally , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03