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

    Bizarre Settings!

    Hi, Whilst technically not solved, I have found a way around this problem. In Control Panel>ODBC Settings I have several System DSN's, including Test1_database, UAT_database, Test2_database. the Login was always, for example, "username" and "password". All I have done to fix this, is left...
  2. NattyCat

    Crystal Reports Wizard in MS Access

    Am using MS Access and have the Crystal Reports 9 add-in wizard. I have created a quick report and it is now saved on my desktop. I now want to create a button on a form that, once pressed, will open the report in the Crystal Reports viewer. I've created a button with the wizard, chose...
  3. NattyCat

    £ symbol changing to $ symbol in Enterprise

    I have taken two steps to resolve this. a) format field->Number->Customize->Currency Symbol->Check the Enable Currency Symbol and ensure currency symbol is £ b) File->Options->Fields->Currency set to £ Despite these two actions, when the report is loaded into Enterprise (V10) the report...
  4. NattyCat

    £ symbol changing to $ symbol in Enterprise

    sorry i didn't put the version - it's version 9 crystal and v10 enterprise. I have already set the currency symbol in the report and it's set to £. This still doesn't work as soon as it gets to enterprise it returns to a $ sign. Nat
  5. NattyCat

    £ symbol changing to $ symbol in Enterprise

    Hi, I have a report that has 5 subreports. Each subreport has a shared variable to parse the total to the main report. There is then a formula that adds all the values together to give a grand total. I have pressed the "currency symbol" sign to give me a £ sign on all the totals in the...
  6. NattyCat

    £ symbol converting to $ in Enterprise

    Hi, I have a report that has 5 subreports. Each subreport has a shared variable to parse the total to the main report. There is then a formula that adds all the values together to give a grand total. I have pressed the "currency symbol" sign to give me a £ sign on all the totals in the...
  7. NattyCat

    Help Translating SQL to Crystal Basic

    Hello, I have an SQL query that I'm using to ensure that names are populated as best as they can be where one or more of the fields are not poplated. ie, if there is no title, or no inititals, or no first name etc. For reasons I can't go into, I cannot just create a view and use the view in...
  8. NattyCat

    Bizarre Settings!

    yes, thats exactly right.
  9. NattyCat

    Bizarre Settings!

    We use a CRM system, called Onyx. We have Test SQL databases, Live databases, UAT databases and Development databases. Each database is kept synchronised with log shipping and dts services. We also have test, development, production (live) and UAT versions of the Onyx CRM screens. The user...
  10. NattyCat

    Bizarre Settings!

    I develop reports in Crystal 9 or 10 I use Crystal Enterprise 10 against SQL Server 7 databases Due to the implementation of the first phase of our project, we have several environments that we develop/work in. We have sql databases entitled Test 1, Test 2, UAT, Pre-Production, Production...
  11. NattyCat

    Bizarre Settings!

    Hi Turkbear, The reports are deployed to versions of Crystal Enterprise on all the environments. So, the users use the Production environment, where they have a list of reports that they can run via the web interface of Crystal Enterprise. The reports are packaged up and deployed to all the...
  12. NattyCat

    Printing Friday's Data on Monday

    I figured this one out, and I used: (if dayofweek(currentdate) = 2 then {ReconciliationStatementTbl.CreateDate} = currentdate -3 else {ReconciliationStatementTbl.CreateDate} = currentdate -1)
  13. NattyCat

    Printing Friday's Data on Monday

    Hi, I have a report which is restricted to {transaction date} = current date -1 However, on Monday, I need it to show the previous Friday's data, not Sunday's. Ideas please? Thanks.
  14. NattyCat

    Max or Min of a Date Field

    Crystal 9, SQL Server 7 I have a field {last run date} and I'm trying to display the earliest date that appears in that field. I've used a formula: {@min date} minimum (database.last run date} but this is returning blanks, even though i know I have a date of 9th feb and 14th feb in that...
  15. NattyCat

    Record Selection Query

    Crystal 9, SQL Server 7.0 I have a report where the user wishes to choose a Region and Postcode, but may leave one or the other blank. So, the user may choose {?Region} = "South East" and {?Postcode Prefix} = "TN" which will return all TN postcodes in the South East Region. However, I need...
  16. NattyCat

    Date Range Formulas

    Hi, Thanks for getting back to me. The records returned are still not working as the records are not being restricted if I leave all the parameter fields blank. I think there may have to be a statement to restrict the records if all of the parameters are left blank, which they often are. I...
  17. NattyCat

    Date Range Formulas

    Crystal 9, SQL Server 7.0 I have a total mind block, can someone help? I'm writing a report that has to return data for 5 months ago. Ie, if I run the report on 1st January, it must return the full months data for the whole month of August. It will be going back over years (2005-2004) so I...
  18. NattyCat

    Date Range Record Selection

    Crystal V9, SQL Server 7. I think my brain is leaking, as I simply cannot get it to function and create (what I think is) a simple formula. Can anyone give me a quick solution while I see if some caffiene kicks my grey matter into gear? I have a report that is scheduled to run on the 23rd of...
  19. NattyCat

    Report Returning no data in Enterprise

    Thanks Vampire, The above would make sense if it wasn't for the fact that there are 140 other reports listed, all written by me on the same machine, same printer and all running on CE using the same settings...its bizarre and we're scratching our heads thoroughly! Nat
  20. NattyCat

    Report Returning no data in Enterprise

    Crystal Reports version 9 Crystal Enterprise Version 10 SQL Server 7 datasource. Hi, I have a report, written against a sql server database, which contains a subreport. This report is a "letter" - it basically says "you said you were going to give us xx amount, but we've only received xx...

Part and Inventory Search

Back
Top