Skip to main content

Displaying Multiple Columns in Crystal Report.

Problem: Display data horizontally in Crystal report.
 If you Want  to display horizontally data in crystal report you can use Multiple columns option  for example if you want to display following data horizontally
Student ID           Name
C0801                    Name1
C0802                    Name2
C0803                    Name3
C0804                    Name4
C0805                    Name5
Like this
Student ID           Name     Student ID             Name                                  
C0801                    Name1  C0802                    Name2
C0803                    Name3  C0803                    Name4
C0805                    Name5  C0806                    Name6
You can easily break rows into several columns horizontally according to your needs.
Solution: Displaying data horizontally in Crystal report.
For achieving multiple columns you need to create Mail Lable report in report wizard although this option is also available in Standard report Format but I found some difficulties therefore I have tested in Mail Lable and its work fine here for.

After creation you can see there is detail section that displays half as it is open in standard  reports here is  what  we use multiple columns help us to achieve our goal.

Now right click on detail section and go to section expert here you find layout tab in which you can resize colums according to your needs.

There are four columns showing.
You can see here is options  Across then Down and Down then  Across on the given example I have used across then down  as follows.
Student ID           Name     Student ID           Name                                  
C0801                    Name1  C0802                    Name2
C0803                    Name3  C0803                    Name4
C0805                    Name5  C0806                    Name6

Format with multiple columns options is only available on detail section.


Popular posts from this blog

Add Image in Navigation Drawer Android Studio Template

I have to add Image in one of my project in slider Menu ,
I have used Android Studio Template Navigation Drawer  for material design .
For adding header on top of the list I have modified few lines in code: below are the simple steps:

Create an Android Studio project and select  Navigation Drawer Activity as shown below
Now your project structure is like this:

Now open activity_main.xml  and add LinearLayout and image view as shown below highlighted lines

< xmlns:android=""xmlns:tools="" android:id="@+id/drawer_layout"android:layout_width="match_parent" android:layout_height="match_parent" tools:context=".MainActivity"> <FrameLayout android:id="@+id/container" android:layout_width="match_parent"
android:layout_height="match_parent" />


Using GIT with Android Studio on windows with terminal or toolbar

Today We are going to learn how we can create a git repository using android studio.
Android Studio Makes it very simple just follow the below steps and your project is on git :
First we setup our PC ::

Download git from :

install it.

for git repository online I am using Bitbucket  , bitbucket allow us to host private repository free you can also use github but your project should be public if you want to use it free.

Here I am going to use bitbucket:
Create repository
After creating repository  you will see screen like this

Now open AndroidStudio Create new project.
after creating the project clcik on VCS on menu strip  and enable git as shown below

Now your project git enabled ;
You can see terminal in andoid studio we can use it for git commands.
Now check terminal and write git status if it  give you below message :
'git' is not recognized as an internal or external command, operable program or batch file.
then you have to follow below steps …

Crystal Reports ToWords() and Propercase() function

I have to convert amount into words like 2150 to two thousand and fifty only .
for achieving this i have used towords() function in crystal report,

i have just create new formula

ToWords({abc.amount},0)+" Only"
 it returns me result but in lower case so i have converted into upperCase  like this
UpperCase(towords({abc.amount},0)) +" Only"
it returns me TWO THOUSAND AND FIFTY ONLY but i need First letter capital of every word
then i used
ProperCase(ToWord({abc.amount},0)+" Only"

ProperCase() give me following result

Two Thousand And Fifty Only

Hope it will help someone :)
HappyCoding :)