Search results for query: *

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

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

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

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

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

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

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

yes, thats exactly right.

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

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

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

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

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.

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

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

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

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

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

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

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