Click here to Skip to main content
16,016,744 members
Please Sign up or sign in to vote.
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
Updated 22-Sep-11 10:11am
v2
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.

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
 
Share this answer
 
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
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
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900