Search results for query: *

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

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

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

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

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

Crystal 9, SQL Server 7. Hi, I'm creating a report showing information about employees who have been transferred from one payroll to another. In the main report, i'm showing the information for the "FROM" contract/payroll as: Contract number (from) Payroll number (from) Payroll name (from)...

Hi, Am using Crystal Version 9 against SQL Server 2000. I have one field, which contains the following: "15006543,1234432,777765200001" (these represent account numbers in a banking system) I need to split this string and return rows. I need to do this so that I can use a subreport to...

OK I fixed the "bad date format string" error - it WAS to do with null values. Here's a different problem. using this forum, I found the following formula: numberVar dur := 999; //replace the 999 with your field. numberVar days; numberVar hrs; numberVar min; stringVar result; days :=...

I'm using Crystal 9, against SQL Server 7. I am creating a report which shows instances of failed user logins, which is reporting against our system's Audit Trail Log. I have one field called "Input" which has a long sequence of data, which I have stripped out into individual fields. The Data...

I am using the formula below to convert a string date and a string time into a datetime field. datetime(date({Asgnmnt.DATEACKNOW}) & " " & time({Asgnmnt.TIMEACKNOW})) Am getting the Bad Date Format String error...can anyone help urgently?