Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

mgsbos input per line?

Status
Not open for further replies.

santango

Programmer
Jul 8, 2004
18
CA
have a report that indicates all the products to be ship (between 20 to 100 lines of products normally) every time I need to manually enter the final weight of each packed product

I need the sintax in vbs for crystal I reported xi that I would have to use.

Thanks
 
Please post your software version.

Try rereading your second line, it doesn't make sense.

Crystal doesn't use VBS, it has 2 different languages within, Basic and Crystal.

If you're using VBS in some external application, then post meaningful information, your post is unintelligible and you confuse technical terms.

State your environment, software used, example data and required output.

-k
 
Sorry for my terrible english, this is about what i need

on the 2 if i need the input box so i can inter manualy the weight of this parts

cr11 sqlbase(gupta 8.1) win2000 server.


If NOT IsNull({PART.WEIGHT}) Then formula = {PART.WEIGHT}*{@BACK_ORDER}


If IsNull ({PART.WEIGHT}) Then formula = 2 '(ON THE PLACE OF 2 I NEED TO INPUT MANUALY THE WEIGHT) *{@BACK_ORDER}

 
You can create a parameter of type numeric which prompts at the beginning of the report.

If you have several different weights to enter, it probably won't prove a very user friendly interface within Crystal.

The formula you seek might be:

If NOT IsNull({PART.WEIGHT}) Then
{PART.WEIGHT}*{@BACK_ORDER}
else If IsNull ({PART.WEIGHT}) Then
{?MyWieghtParameter}*{@BACK_ORDER}

Crystal doesn't prompt for every row, although you might embed lots of on demand subreports to attempt this, it's a horrible idea.

Crystal isn't an interactive program, it's designed to produce information

You might consider running the report for each product, then you can enter eahc products weight and get the output for just that product, but I'm guessing what you need is an application development tool.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top