Search results for query: *

I am using Crystal Reports to print out packing lists from Mas200. I need to print two copies of each packing list. Is there a way to automatically print two copies without having to select 2 copies each time at the print prompt window?

Mas 200 is the company wide system we use for inventory management, accounting, etc. I currently use crystal reports and am able to access the database through crystal reports by opening a directory named ODBC, then a directory named sotamas90 where all the data tables are. I was able to get...

I have a list of part numbers in Excel, and would like to get other values(qty on hand, qty on order,cost) from the Mas200 database pertaining to those specific part numbers. I would like to "grab" the latest values from Mas200 and put them into Excel, if that makes sense. What would be the...

After looking at this longer I am going about this the wrong way. I need to take the Required date and the recieve date to figure out days early/late. I then need to remove any Saturday's or Sundays that fall into the date range paramater.

I am having a problem with the formula mentioned above. The start and end dates are selected before the report is run and change all the time. I made a formula to calculate the last date in my date range: ToText ( Maximum ( {?Date Range} ) ) When I try and put the result of this formula into...

Are there scheduling templates available with Excel 2000, I can't seem to find any? Anybody know of any basic scheduling templates available for download or through email attachment.

The part number fields are the same in both reports in respect to the actual part number. The bill of material part number is exactly the same as the sales order part number. They are just on different tables. I have tried to link them in the same report but it does not work. Why they are...

The main report is a report I am using currently to find items on order minus items on hand. So the quantities of the main report are generated by a formula, taking the order quantity and subtracting quantity shipped and quantity on hand. I am wanted to get the subreport to work on its own...

Thanks for the help on the maximum formula. I was trying that out, just had a little trouble on the format. On the main report I have a grouping of the part numbers(string, length of 15) and a number(number), driven from sales and inventory tables. P/N Qty FinPart 1...

As I said before, I am relatively new to using crystal reports, and from browsing some of the topics here, it seemed you can pass values from the sub-report to the main report or vice versa using shared variables. This looked like it might work for me, although seeing some of the data I am...

The main report is grouped by part. I used the shared variable because of the problem of the subreport picking up only the last field in details as a value, when linking the part numbers. I think I have a problem that I will not be able to overcome. The main report is driven by two joined...

I am relatively new to Crystal Reports, so the report I am trying to do might be a little over my head or not possible. Currently using Crystal reports Ver. 8, with an ODBC connection. I currently have one main report with two tables linked giving me part numbers that are on order, and...

That was it, thanks for your help. Cut and paste got me good.

I am still having an issue with the page header showing on the report footer subreport pages. I have the two formulas named //{@true} and //{@false} with the correct formulas with each, placed in the correct spots on the report. In the page header section I have "suppress(no drill down)...

i got it thanks, small brain fart. It worked nicely, except now by report header is missing. Also my sub-report goes onto a second page, with no headings attached to it. thanks again -bh

lbass your suggestion below: To eliminate the page header on the report footer subreport pages, create two formulas in the main report: //{@true} to be placed in the report header: whileprintingrecords; booleanvar flag := true; //{@false} to be placed in the report footer_b (where the...

Success at last, thanks for your help. One other thing that has popped up, now that I can see the sub-report information. The page header for the main report continues on the sub-report pages. Any quick fix for this?? thanks again. -bh

Yes the comments are coming from the same table as the sales orders. The sub-report is basically a list of all comments on the sales orders, sorted by sales order number. If the sales order number in not shown in the main report I dont want to see it in the sub-report. I have tried using the...

Thanks for your help so far. I tried your idea, and the subreport was still empty, and it also did not run by itself, I needed to page over on the preview. There is a problem in using the same selection criteria for each report. The date I am using is attached to each line item(part number)...

I have no groupings in the main report. It is sorted by due date not by sales order number as I stated before. The sales order number is repeated if there are more than one line items on the sales orders, however each line item can have a different due date, which is why I did not group by...