Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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