Source language: Translate to:

turn around a Report Designer problem

General questions about NeoBook

Moderator: Neosoft Support

turn around a Report Designer problem

Postby michi » Tue Nov 25, 2014 11:39 am

Hi all, I'm working on a project that let my software's users to create and print labels.

Initially I thought that a possible and very kind solution was to use Report Designer, so my software can be pass field value to the report when the user print a label, but there are some problems:

1. users must be able to print also barcodes on labels, and Report Designer doesn't support them.
2. users must be able to create labels for products that will be export to Africa and Asia, therefore in arabic.

I think that a possible solution is to use Microsoft Word. Users create the labels as they want using Microsoft Word. Then my software (somehow):
1.open hidden the word file
2. find and replace variable fields
3. print to the specified printer.

This solution solve barcode and arabic problems, but how to make that? Maybe calling a javascript action?

My Neobook project is linked to a production software (also created in Neobook), so at the end user only linked a label to an order's product, and software auto-complete fields and print labels.

Anyone can help me?

Thank you in advance guys,
Michi

Started to use Neobook in 2003 when I was 12 to make interactive books. Coders saw me and smiled.
Nowadays I'm still using Neobook to create advanced and powerful softwares. Coders see me and say: «how did you make that?»
michi
 
Posts: 33
Joined: Wed Jun 25, 2014 3:01 am
Location: Italy

Re: turn around a Report Designer problem

Postby Neosoft Support » Tue Nov 25, 2014 12:08 pm

You might be able to do something in HTML/JavaScript and print it using the WebBrowser object. You would have to experiment to see if this would work or not.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5593
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Re: turn around a Report Designer problem

Postby michi » Tue Nov 25, 2014 12:38 pm

and using vbscript?

something like that?

Code: Select all
Const wdReplaceAll  = 2

Set objWord = CreateObject("Word.Application")
objWord.Visible = True

Set objDoc = objWord.Documents.Open("c:\label.doc")
Set objSelection = objWord.Selection

objSelection.Find.Text = "&FieldExample"
objSelection.Find.Forward = TRUE
objSelection.Find.MatchWholeWord = TRUE

objSelection.Find.Replacement.Text = "ValueOfTheField"
objSelection.Find.Execute ,,,,,,,,,,wdReplaceAll
objDoc.PrintOut()


(I found it on the web)

I think that could work, but how set printer... or better how find a good manual for msword commands with good example? Other ideas?
Michi

Started to use Neobook in 2003 when I was 12 to make interactive books. Coders saw me and smiled.
Nowadays I'm still using Neobook to create advanced and powerful softwares. Coders see me and say: «how did you make that?»
michi
 
Posts: 33
Joined: Wed Jun 25, 2014 3:01 am
Location: Italy

Re: turn around a Report Designer problem

Postby dpayer » Tue Nov 25, 2014 2:30 pm

michi wrote:and using vbscript? something like that?
Code: Select all
Const wdReplaceAll  = 2
Set objWord = CreateObject("Word.Application")
objWord.Visible = True




Michi, your code would require everyone to have Word installed on their computer, wouldn't it?

David P.
David Payer
Des Moines, Iowa
USA
User avatar
dpayer
 
Posts: 1380
Joined: Mon Apr 11, 2005 5:55 am
Location: Iowa - USA

Re: turn around a Report Designer problem

Postby michi » Wed Nov 26, 2014 4:58 am

Yes... I haven't other ideas
Michi

Started to use Neobook in 2003 when I was 12 to make interactive books. Coders saw me and smiled.
Nowadays I'm still using Neobook to create advanced and powerful softwares. Coders see me and say: «how did you make that?»
michi
 
Posts: 33
Joined: Wed Jun 25, 2014 3:01 am
Location: Italy


Return to General NeoBook Discussions

Who is online

Users browsing this forum: No registered users and 2 guests