Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. madvalpreston

    Cannot see the tables for the databse

    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 -...
  2. madvalpreston

    Epicor Vantage does not show results from crytsal via Porgress

    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...
  3. madvalpreston

    Distinct count on a group

    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...
  4. madvalpreston

    Memo filed not showing in BAQ report design

    Hi I created a BAQ and then created my crsytal report. This shows the details when in crystal. When I run the report from the BAQ report designer it shows all information except the formula I wrote to extract the data in the memo text field. The formula extracts the data so it is aligend...
  5. madvalpreston

    Splitting text from memo field into report

    Hi Not sure how to go about this one We have a table called memo and in here is a text area to add data. What we have is for example 1804 51630 L677 On the report I want it like this Die No: 1804 Lot No: 51630 Heat no: L677 What I can work out is how to extract the information. Line 1...
  6. madvalpreston

    Counting from another formula

    HI We have a complex formula with which I want to sea count on where the result is OTIF. I cannot get it to count no matter what syntax i try in my formula. Please see below tjhe two formulas, the complex and then mine trying to count shared numbervar counter; shared numbervar OversCounter...
  7. madvalpreston

    WhilePrintingRecords

    Hi I am fairly new to crystal formula, and I am looking at some reports a former colleague created. He uses the WhilePrintingRecords option alot. I have tried to find a simple explanation what this does but cant quite understand any explanation thus far. Could someone explain in simple terms...
  8. madvalpreston

    Cannot see or locate server name in Studio Express

    Hi I have loaded Stusio express 2005. It appears to load ok, but when I go to log in Server type : Databse Engine Server Name: Authentication : Windows Authentication Username kir-wks-007\Colin The problem now is it cannot locate a local server name. Any ideas please as I need to have a...
  9. madvalpreston

    conneting to a databse engine locally

    Hi I ahve Microsoft SQL server management studio 2005 loaded on my works laptop. I want to be able to use the studio locally, but it does not recognise my local laptop as a sql server. Is there anyway I can set it so it as a database engine and I can use databses locally. I dont have the CD...
  10. madvalpreston

    cannot get into workbench server admin

    Hi tis is abot of a follow on form a previous thread and is about my install of server and workbench. The machine we use got corrupt and we could not get into the server admin tools, we have unisnstalled using full method, including deleting left folders and the regedit etc.... But when we...
  11. madvalpreston

    Problems connceting to server

    Hi I ahve made some changes to my server and when i try and access it through workbench I am getting this error message.... queryerror executing 'access denied;you need (at least one of) the PROCESS privileges for this operation SHOW PROCESSLIST SQL error:1227 Any ideas how i get round this...
  12. madvalpreston

    cannot conncet to server

    Hi This is a following on thread from how to set up ODBC I created a few days agao. I have Mysql on a computer. I am trying to connect to it from another computer on the network through ODBC. This is the setup on the server. connection Name : localhost Connectio type : Standard TCP/IP...
  13. madvalpreston

    range of check boxes

    Hi we have a quotation form which is all working now. the next stage is we want to when we receive a customer Po do this 1. Have a range of check boxes (perhaps in another form) that have to be ticked (based on a quote number) , for example Is customer name correct is customer address...
  14. madvalpreston

    ODBC in windows network

    Hi We have set our Mysql server on a windows 7 machine and it works fine, we use access for front end. the aim is to link the Mysql tables and then use the rest of access forms etc... locally, which is a standard split databse set up. we now want to link to it using ODBC on other machines on...
  15. madvalpreston

    password forms????

    Hi if we have a main menu with 3 buttons Quote Sales Invoice Is it possible to have some way of blocking a user to access a form OR password the form before it opens. I have a login form for tha database, but this purely to gain access to the database and then log who is netering...
  16. madvalpreston

    sub form change problems

    HI I have a report that as some 20 subreports. I have developed the first report and all layout is perfect. I now need to copy the report including all sub reports but it needs to look at different sub reports, as it is based on a table with 4 different id's which have different text fields...
  17. madvalpreston

    Taking our 0.00 rows

    Hi I have a form that uses 10 fileds for entry. The fields are Building descritption and building price. Not all 10 will be filled in, so in mt report I only want to show the fields that have prices in and I want them all together. Could someone advise how I acheive this, the building...
  18. madvalpreston

    Auto Increment

    Hi Is there a way to start the AI field at a specific number. I would like the live version of a table to start at 1000. Is this possible and how do I achiceve it. It is for a table called tablequote with a field called idqoute Thanks
  19. madvalpreston

    Calcualtion Field

    Hi I have a subform with 10 fields for prices, if I just fill in the first 3, my total field remains balnk unless I fill in all 10 with somthing (0.00 for example). it then toals up no problem. Is it posisble to amke the calcualtion even if the other fields are blank. This is my control...
  20. madvalpreston

    Field Defaults

    Hi I have a table with 3 field that hold prices and I am using an Access front end. The prices are working ok, but I now need to have a default value in them of 0.00 (£0.00) Column Name Datatype Budgetprice Decimal(10,0) Reportprice Decimal(10,0) Totalprice...

Part and Inventory Search

Back
Top