-
Jun 1st, 2016, 07:05 AM
#1
Thread Starter
Frenzied Member
[RESOLVED] string saving and presentation
Scenario:
Db is mysql
Report used is crystal report
Field is text data type
Vb6 textbox is multi line
I want to save a paragraph of multiline from textbox to text field and retrieve it to crystal report presentation.
My issue now is, how can I present it to crystal report as having been typed line by line in a multiline textbox ?
Im not sure if this is vb6 issue if will be resolved thru vb6 or on reporting, so i just post it here.
-
Jun 1st, 2016, 07:24 AM
#2
Re: string saving and presentation
Originally Posted by codesearcher
Scenario:
Db is mysql
Report used is crystal report
Field is text data type
Vb6 textbox is multi line
I want to save a paragraph of multiline from textbox to text field and retrieve it to crystal report presentation.
My issue now is, how can I present it to crystal report as having been typed line by line in a multiline textbox ?
Im not sure if this is vb6 issue if will be resolved thru vb6 or on reporting, so i just post it here.
See if this gets you in the right direction: http://www.enzinger.net/MultiLn.html
(it's in German, though the code should be self-explanatory.)
HTH, Wolfgang
-
Jun 1st, 2016, 07:36 AM
#3
Thread Starter
Frenzied Member
Re: string saving and presentation
I am not sure how the function will work if i get the data directly from database to crystal report.
-
Jun 1st, 2016, 10:08 AM
#4
Re: string saving and presentation
Been so long since I used Crystal I can't be of much help with that. Last time I touched it was before the release of VB6.
On the VB side the one factor that may make a difference is does that multi-line text have line breaks in it or does it rely on word wrapping?
If I'm not mistaken in the tool i use for reporting it is as simple as setting the fields can grow property to true. Does Crystal have that option?
-
Jun 1st, 2016, 04:55 PM
#5
Thread Starter
Frenzied Member
Re: string saving and presentation
Yes crystal have that option.
-
Jun 2nd, 2016, 11:52 PM
#6
Thread Starter
Frenzied Member
Re: string saving and presentation
Do we have an answer for this problem ? For example, I typed on the textbox a paragraph like so:
1. Sentence 1
2. Sentence 2
3. Sentence 3
and save it to database with table field type TEXT. Then I will display that to crystal report as I have typed it on textbox like above.
-
Jun 3rd, 2016, 12:09 AM
#7
Re: string saving and presentation
Do we have an answer for this problem ?
You tell us.
Did you try setting the can grow option on the report?
Did you try saving the data to the database?
Did you try anything at all?
If so what results did you get?
-
Jun 3rd, 2016, 12:17 AM
#8
Thread Starter
Frenzied Member
Re: string saving and presentation
I tried but its not display on the report as I have typed on the textbox line by line.
-
Jun 3rd, 2016, 01:16 AM
#9
Re: [RESOLVED] string saving and presentation
I don't see any "problem" here and the suggestions look fine. Have you even tried them?
This seems to work pretty much the same way using a VB6 DataReport instead of some random 3rd party reporting software:
Here I asked for borders on report items, which sort of helps you see how they "grew" as required.
-
Jun 3rd, 2016, 08:25 AM
#10
Re: [RESOLVED] string saving and presentation
Random 3rd party reporting software?
I'm not sure what that is supposed to mean. Crystal surely isn't random as it comes with some versions of VB, only VB6 has it's own reporting tool.
The tool I use is not some random reporting tool either. It is imo the best tool on the market and that is why I use it.
-
Jun 3rd, 2016, 01:04 PM
#11
Re: [RESOLVED] string saving and presentation
You just keep thinking Butch, that's what you're good at.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|