Search results for query: *

Hi I found under the database security itself and tried some permissions, I finally for the tables to appear. Thanks for the reply the prompt about permissions pointed me in the right direction, Thanks

Hi Due to it being a server it does not have excel for instance loaded so hard to see if it shows tables. I created an ODBC connection and it connected fine. I tried to apply it to Crystal but could not find any suitable connection to use that could see the ODBC lists. So a little stuck now...

Hi The database is SQL server DB It is on a remote server that I am working on How do I see if the user as sufficient rights in SQL???? I will test and ODBC link now and get back on that one Thanks

Hi I have created a connection to a database in Crystal. In options I have it ticked so it should show tables. The connection works, but when I go into the data area I have DBO - Showing no tables (I expect to see the DB tables here) Information Schema - Information listed below here SYS -...

Hi We presently are running Vantage V8 through Progress. We create BAQ (business queries) and link these into Crystal reports (using V1). In general this works perfectly. However the report we have been working on, shows the information in the report perfectly, but when we run it form our...

Hi I took the -2 out but still got same "String Length is less than 0 or not an integer" But this is when I run our application, as before it works ok in CR. If I take out the -2 I do get a L on the second row DIE No: 1804 Lot No : 51360 L Heat no: L677 With the -2 in it works ok in...

Hi Also I have tried IF strinvar = "" but still get same problem. Thanks

Hi I tried putting in this formula (I changed the x to u as I think the variable was used elsewhere in t he report) stringvar u := {BAQReportResult.Memo.MemoText}; stringvar y := left(u,instr(u,chr(13))-1); stringvar z := right(u,len(u)-instrrev(u,chr(13))); "Die No: "+y+"...

I am using a crystal linked inot Vantage (epicor), but the question was relating to Crystal.

Hi LB Do you have any other ideas on this at all or perhaps another way to achieve our goal. Thanks

Good comments from Mike and good advice. The one we use actually runs automatically every day and emails to someone (using 3rd party software), but as Mike suggests it must have the network locations avaialble where the files are. Good luck with it..

Please ignore this post of course the DISTINCTCOUNT works. Thanks

Hi we ahve a group in one of our reports on odernumber I have a formula in to count in COUNT({BAQReportResult.OrderHed.OrderNum}) This gives me a result of 8, but we have only 6 rows. I believe the ordernum may be repeated for extra order lines Is there away to just count it once for each...

Hi yes you can connect to 2 data sources. I ahve connected to SQL databse and an excel spreadsheet at the same time (using the database expert or set databse location, excel can be found under Access/Excel (DAO) or you could use ODBC (RDO) and select Excel. It is a good tip to have a common...

Hi There would never be more than 3 elements in the field. I tried this formula extractstring({BAQReportResult.Memo.MemoText}," "," ") This did not return any value at all. Thanks

Hi Tested this and it show in the application like this ABC def GHI Thanks

Hi LB I have made a small beakthrough I think. I changed the formula to this if ubound(split({BAQReportResult.Memo.MemoText},chr(13)))>= 1 then "Die No: "+split({BAQReportResult.Memo.MemoText},chr(13))[1] //+" "+ //"Lot No: "+split({BAQReportResult.Memo.MemoText},chr(13))[2]...

Hi I have just tried your suggestion and again with no success.... you are correct the code we have tried this far shows ok on the CR but not on our application and of course it may well be the application, however, it is our main business system and we run many CR with formula and thse come...

Hi On the crystal report chr(13)) comes back with the number 5.00 chr(10)) comes back with the number 0.00 Thanks

Hi I have tried all combinations but still no luck. If I change the first row to (10) it does not even show on the crystal report stringvar array x := split({BAQReportResult.Memo.MemoText},chr(10)); This is how my formula looks now stringvar array x :=...