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 Shaun E 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: *

  • Users: Horns
  • Content: Threads
  • Order by date
  1. Horns

    Excel: Importing/copying data from another Excel file

    I have some 700+ results from a market research i'm trying to gather into a single Excel document. Theres some manual input/tasks required for each so theres no 'easy' fix i'm sure, but what I want to do is have the bulk copied over automatically. What, in practice, i'm hoping to do is [in my...
  2. Horns

    Selection date troubles

    I need a report to give me all the info where the record date is within 6 months. I have a Start Date parameter field where the user will enter the start date i.e 01/04/03 I now need crystal to subtract 6 months from that. so Effectivly the only data CR extracts is betwwen 01/04/03 and...
  3. Horns

    Correct address

    Our database has an address table (ADDR), within this table are a few fields a few of which are - ADDRTEXT, ADDRTYPE, EFFDATE and REFKEY. ADDRTEXT is the address text ADDRTYPE is a code '0' for customers perminant address, '1' for temporary address, '2' for site address etc... EFFDATE is the...
  4. Horns

    simple calculation

    How would I go about finding the sum of a formula field? I have my formula field displayed in the group footer#2 I now need a sum of this formula field displayed as a total in group footer#1. The formula I'm using is : Sum ({@Fomula Field}) then when I check this formula I get the following...
  5. Horns

    Selection conditions

    I have a report that needs to show the differences between two users. The problem I have is that the users can either have there own access rights or inherit them from a 'role' (all stored within the same table) How do I say in crystal speak 'If USER.ROLE is null then display USER.ACCESS...
  6. Horns

    Group Orientation

    Is it possible to change the orientation of groups? Ie instead of the default top to bottom have groups side by side (in a kind of landscape setting?) Cheers

Part and Inventory Search

Back
Top