We are using vantage version 8.00.808C. Not sure about the version of progress. What I am wanting to achieve is to create the equivalent of a sql Stored Procedure on the progress server, and use it as a data source for a Crystal Report (we are using ver X of CR). If that cannot be done, is it...
Does anyone know how to actually write a "Stored Procedure" For a progress database? Or if that is even possible? We are doing Crystal reports off of a Progress database and are only able to use the table-linking wizard that crystal provides, but it would be nice to be able to base the reports...
Anyone know if it is possible to use a "LIKE" predicate in a Crystal Reports SQL Command? Simple syntax example would be appreciated. I know it is possible in a formula, but I'm wondering if it is supported in the actual Sql Command builder area.
Mark
Hello,
I'm customizing the Part Entry form in Epicor Vantage v8.05 and have added a dropdown (combo) to populate with custom OEM records. The records themselves need to come from some User defined table I would guess, in order to appear there when the user adds or edits a Part. I know there is...
Actually I think I solved it based off your advice enbw..i was using a "System" DSN but switched to a file DSN, then went to where the odbc dsn file was saving and entered in a PWD=ourpassword line and that seems to work (knock on wood). Based on that file DSN, the reports run through Vantage...
Help! I am under the gun to deliver some Customized Crystal Reports (that are found inside Epicor's Vantage ERP System) and which will be run from there. Most of the changes made are cosmetic, but some require doing ODBC subreports to get at desired data that isn't part of the report's data...
ok, i think i resolved my own issue. It appears that i had to log in as the local admin and copy the domain user's profile to the "Defualt User" specifying "Everyone" so that any domain user logging into the box will get the same profile. THis resolved the powerdesigner...
Argh!!! I have installed Powerdesigner 9.5 on a new PC (xp Pro) under the administrator account (trying to build an image to port to other identical PCs), but when a domain user logs in, they can open pd95 just fine and create a physical data model, but they cannot script it. Gives errors like...
PogoWolf, Thank you for the reply. I like the last alternative, but i have already given the cookie a name and value, for ex:
Response.Cookies("Login")("UserID") = (value from database)
Response.Cookies("Login")("CompanyID") = (value from database)...
I was previosly using cookies in an internet application that I am building and noticed that when a user opens multiple instances of the same app in the browser on their computer simultaneously, the user credentials are getting undesirably switched, presumeably due to the use of cookies in the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.