Results 1 to 11 of 11

Thread: [RESOLVED] string saving and presentation

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    May 2013
    Posts
    1,126

    Resolved [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.

  2. #2
    Addicted Member Wolfgang Enzinger's Avatar
    Join Date
    Apr 2014
    Location
    Munich, Germany
    Posts
    160

    Re: string saving and presentation

    Quote Originally Posted by codesearcher View Post
    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

  3. #3

    Thread Starter
    Frenzied Member
    Join Date
    May 2013
    Posts
    1,126

    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.

  4. #4
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

    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?

  5. #5

    Thread Starter
    Frenzied Member
    Join Date
    May 2013
    Posts
    1,126

    Re: string saving and presentation

    Yes crystal have that option.

  6. #6

    Thread Starter
    Frenzied Member
    Join Date
    May 2013
    Posts
    1,126

    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.

  7. #7
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

    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?

  8. #8

    Thread Starter
    Frenzied Member
    Join Date
    May 2013
    Posts
    1,126

    Re: string saving and presentation

    I tried but its not display on the report as I have typed on the textbox line by line.

  9. #9
    PowerPoster
    Join Date
    Feb 2006
    Posts
    24,482

    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:

    Name:  sshot.png
Views: 156
Size:  12.6 KB

    Here I asked for borders on report items, which sort of helps you see how they "grew" as required.

  10. #10
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

    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.

  11. #11
    PowerPoster
    Join Date
    Feb 2006
    Posts
    24,482

    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
  •  



Click Here to Expand Forum to Full Width