spliting crystal report field

Question

0.00/5 (No votes)

See more:

hi all
i hv database column named "medicine name" and the values are like "A,B,C,D"

when i created a report for printing that particular column
the report filed shows like
Medicine Name
A,B,C,D

but i want like
Medicine Name
A
B
C
D

please help me
thanx in adv

Posted 22-Sep-11 10:09am

bkthebest

Updated 22-Sep-11 10:11am

v2

Add a Solution

Comments

André Kraak 22-Sep-11 16:12pm

Please share any relevant code with us, seeing the code might us help understand the problem your are facing.

If you wish to change your question use the Improve Question button.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Arun Kumar K S · Accepted Answer · 2011-09-22T16:48:00

Solution 1

If your database counm name is MedicineName and your row values are
A
B
C
D
You don't need to do anything more

Place Your Medicine Name label on Section2(Page Header)
Place your MedicineName textbox on Section3(Detail section)
that will automatically appear in row by row (And check its properties for any changes in that)

Otherwise you need to create a dataset in your arranged data and assign to report
Search in google for Creating crystal report from dataset

Posted 22-Sep-11 16:48pm

Arun Kumar K S

Comments

Sudhir Kumar Srivastava lko 23-Sep-11 1:00am

It is also possible to create formula or function in the report.

bkthebest 23-Sep-11 1:18am

thanks arun
but the values are in single column and single row like
A,B,C,D
i do my homework means searching on google.....
but still cant het solution..
please help me

Arun Kumar K S 23-Sep-11 1:28am

This are some examples creating Crystal report from Dataset
http://www.codeproject.com/KB/cs/CrystalReportNDataTable.aspx
http://www.codeproject.com/KB/cs/CreatingCrystalReports.aspx

Create your report in data table and add to dataset

Arun Kumar K S 23-Sep-11 1:33am

split your "A,B,C,D" on the basis of "," using string split function in C#
And create A data table using that values,Also pls mention Exact table name,column name etc in Datatable for refering crystal report field

bkthebest · Accepted Answer · 2011-09-23T07:24:00

thanks for replies.....
i have got the solution as

just take a unbound(string) field in crystal report
and make formula using "Replace" function like

Replace({your field name},",",chr(13))

this code break the line when it get comma in string
eg:A,B,C,D is original string and when formula applied it changed into
A
B
C
D
chr(13) is ascii code for enter key