HowTo - displaying Inventory info on a HTML page

[UNCTarheels]

I have managed to get CE 8 and MAS working. I was able to view a report through CMC/ePortfolio.

Now, my problem is that I want to display inventory information from MAS onto the web page, such as current price, on hand, and bin location. I wanted to use a CR 8 report for this.

How do I add the code to the HTML to request the report, pass the inventory number, and return the results when the page is first loaded or are popups better?
A little bit you, a little bit me. [hippie]

 

[synapsevampire]

Why not use an Inventory Number parameter in the report and let CE prompt for it and do the work for you?

If the inventory code is already known, just hardcode it into the report and execute the report from within CE.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[UNCTarheels]

I think that is the best way. We are lucky in that we only have a little over 500 products.

My concern is whether to load the info onto the page when the page loads or to use a popup. I think that popup will be better, especially if we have many items on a page.

A little bit you, a little bit me. [hippie]

 

[synapsevampire]

You can just import the inventory numbers into the parameter picklist directly from the table it resides in, then just hardcode the following into the record selection criteria:

(
If {?Code}[1] <> 'All'
and
{?Code}[1] <> ''
then
({MyTable.MyCode} in {?Code})
else
if {?Code}[1] = 'All'
or
{?Code}[1] = '' then
True
)

note: I use IN if you're allowing for multiple selections, otheriwse omit the [1]'s and use =.

I added in the selection 'All&quot; as this can make the prompt more user friendly, and I intentionally build the record selection this way to try to get CR to pass the SQL to the database.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[UNCTarheels]

The owner wants the information to display by the inventory pictures or to display the information on a popup. The information is segregated onto different web pages, which is by manufacturer, type of product, and then a listing of products. If I cannot display the information on the webpage, then the owner wants the information to be displayed on a popup when the user clicks on the picture or hyperlink that says availability/price.

A little bit you, a little bit me. [hippie]

 

[synapsevampire]

Since you haven't shared your setup for the report, I can't advise.

I suggest that you just place the data alongside/above/below, I don't think that popups are a built in function other than a hyperlink (sort of), subreport (sort of) or alert.

Supply the layout of the report, and be specific.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[UNCTarheels]

There are really no requirements, except to provide real-time data. My plan was to use either asp or vb to pass the inventory number to the report, return the report, and either strip the data that I need to open the report in a frame/popup.

I will be accessing a linux server running WCS, which accesses a w2k server with CE installed. A little bit you, a little bit me. [hippie]

 

[synapsevampire]

How are you obtaining the inventory number that you wish to show data for, from interacting from a user?

This is what I consider part of the requirements, as is &quot;The owner wants the information to display by the inventory pictures or to display the information on a popup.&quot;

If you don't have other requirements, then it may be prudent to try to obtain them now, otherwise you're doomed to guessing and rewriting.

You might consider using drill downs or subreports to expand upon data too.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[UNCTarheels]

The requirement is that when someone clicks on the picture of the inventory item or on a hyperlink, display the available quantity and the current price.

The inventory item number will be imbedded in the web page. The user should not have to enter the inventory item number.

I am thinking of linking the picture to an asp page, which calls the report, passes the #, and returns the information.

I guess that the problem that I will have is in determing the url of the report. I am using wcs on an apache web server and CE on a Windows 2000 server. A little bit you, a little bit me. [hippie]

 

[synapsevampire]

Perhaps you can simplify the amount of code required by using a Crystal Report in CE to show the item#/picture, and then use a drill down (or if you must, a subreport) linked by the # to display the particulars.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com