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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by beebass

  1. beebass

    Sum Field In A Form

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

    Stripping out text to the right of a character

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

    Stripping out text from a string

    Thanks 'J, that worked a treat.
  4. beebass

    Stripping out text from a string

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

    Microsoft Reporting Services SQL for Financial Year

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

    Microsoft Reporting Services SQL for Financial Year

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

    Selecting data from a specific rolling date period

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

    Extracting Postcode Sectors From Postcodes

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

    Converting IF IN statement from Crystal to MSRS

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

    Calcualted/Formual Fileds in SSRS

    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} =...
  11. beebass

    Formula Required Using Using Two Specific Sets of Dates

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

    Formula to compare sales data from 2 financial years

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

    SQL Expression functionality

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

    Financial Year Date Formula Required

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

Part and Inventory Search

Back
Top