Search results for query: *

I found some info on the portal about calling a custom crystal from flex in ES and I have been able to get a test report to work, but I want to pass a parameter value to the report automatically without having to prompt the user. here is my code for calling the report from a button added to the...

We use Logicity http://www.logicitysuite.com/ All the viewers are probably pretty much the same. It just depends on what functionality you need. We also use Event Manager to distribute a lot of reports.

Thanks! That worked. If I can dovetail this into one more question then I think I'll have everything I need... I did some looking on-line trying to find a command to clear all the values from a form and reset the focus to a specific field. Is there a single command that will do this, or is...

I think that in order to really use Macola to it's fullest you almost have to have advanced distribution (assuming you are a manufacturing or distribution business and not service based)... Otherwise you don't have a good view into anything that is happening with your inventory. Are you using...

Ok, I'm very, very, very new to using FLEX in Macola (ES v 9.5.500) and have very little VB experience... I am doing some testing in OE0101 because I want to add flex to prevent users from entering an order if a customer is over their credit limit (not just put the order on hold like Macola...

2 options I've used other than adding to the MES menu (for users that don't have Macola access). 1-Set up a one step work flow in Synergy that accepts the parameters, then have event manager run the report and email to the user based on the parameters they entered. 2- Try...

Thanks for your help. We ended up having to add a button to the form and call the Macola search from the button then write the returned value to our field. And it looks like you are correct about the tab order. No matter what we tried we couldn't get it set.

Hi, thanks for your response (and sorry for my mistype on the ppordfil_sql table, I think I had POs on the brain at the time). Without getting into a ton of the details we don't want to use a user def field because (and it definately will work with the searches) as a majority of our user fields...

I am working with one of our developers to add a custom field to PP0301M. He has the code written so that when we manually enter a value it writes back to the appropriate field in the ppordhdr_sql. However, we want to add a Macola search to the field but have not been able to do so. Just...

This one is driving me crazy. I created a new report that only pulled from the sp and published it to enterprise and it works ok for any date range. So I created a copy of my crystal report and removed the additional parameters (other than the dates needed by the sp) and published it to...

Here is the code for my procedure. If I just execute it in SQL I do not get the error: CREATE procedure [dbo].[ProductionByItem_sp_NEW] @StartDate datetime, @EndDate datetime as SELECT t1.start_dt, t1.item_no, t1.item_desc_1, t1.item_desc_2, t1.ord_no, t1.ord_status, t1.ord_qty...

I am getting the error "Invalid argument for database" when refreshing a report in Crystal Enterprise. I am on Crystal 11 and am using both a stored procedure and table links in the report. The SP requires a date range parameter. It always works fine when running from Crystal on my desktop...