Search results for query: *

Hi I am in the middle of creating a database and wondered if I could have your help. One of the forms in the database will be used for staff to input the number of hours spent on particualr tasks in the course of a day. I would like a field at the bottom that sums these up and validates the...

Hi there I'm currently writing up a report in RS but need some SQL that will enable me to strip out some text from a string. The field in questions highlights the status of our client accounts. Where the account is no longer in use the field will show "Finished - ********" where the stars...

Thanks 'J, that worked a treat.

Hi there I currently use Crystal 9. I am designing a report that requires certain parts of a text field to be stripped out. My company classifies its customers with a status. They are either current (receiving service) on hold or finished. For the On Hold and Finished statuses the list to...

I created two formula fields: @Fiscal Year: year((currentdate)+61) @ Financial Year: if {table.date} in date ({@Fiscal Year}-2,11,1) to date ({@Fiscal Year}-1,10,31) then "Financial Year"+" "+right(totext({@Fiscal Year}-2,0,""),2)+"/"+right(totext({@Fiscal Year}-1,0,""),2) else if...

Hi There My company is in the middle of moving away from Crystal to start reporting on MSRS. When moving the reports across I write the SQL in Microsoft SQL Server Management Studio before building the report in Visual Studion. A lot of the clients we deal with have different financial years to...

Hi there I'm currently using Crystal 9 and require a formula that will select records that fall in to the companys current and previous financial years. The financial year runs from 1st Nov to 31st Oct, so initially the report would need to look at records dated from 01/11/06 to 31/10/2008...

Hi there I'm currently using Crystal 9. I need to be able to extract the postcode sector from each postcode that is held in a database. All of the postcodes held have a space between the two seperate parts, i.e. XXXX YYY, or XXX YYY. The postcode sector would be the XXX Y or XXXX Y part of the...

Hi there I'm in the middle of converting crystal reports across to MSRS. One particular report has a formula field that looks for a particular string of characters in a field and returns an integar based on that if it finds it or not. I was wondering if this is possible of MSRS. At present the...

Hi there. I'm currently using Microsoft Visual Studio 2005 to design reports that were previously done through crystal. I'm having difficulty recreating a formula field based on the If condition. The following is a shortened version of what I have used in Crystal: if {Table.Product} =...

Hi there. I'm currently using Crystal 9. I need to create a report that provides details of Customers Registered and Customers Ending the Service over two financial years (Financial year being Nov to Oct) by sales region and contract. The difficulty I'm having is that each customer has a...

HI I'm currently using crytal 9 and have been asked to design a report that will display a table and corresponding graph that shows sales data for a particular region for from the current and previous financial years (the financial year is 1st Nov to 31st Oct). The set up of the table should be...

I currently use CR9 and have a report showing the number of sales invoices invoiced by month to each customer. The report is set up using an SQL expression on the invoice date so that it only pulls data for the financial year (Nov to Oct). However, I've been tasked with regionalising this sales...

Hi there I'm pretty new to Crystal reports (currently using version 9). I have been asked to provide a report thats produces sales figures from various contracts over the company's financial year (November 1st to October 31st). So far I have been using a between filter in the selction expert on...