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!

  • Congratulations IamaSherpa 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: *

  1. PerrinA

    Display only one field

    I have a report which is displaying each field around thirty times. I need it to display each field only once. I tried to find the other fields within the table that are causing it to repeat but it takes much to long to search for. Is there anyway to write a selection formula that only allows...
  2. PerrinA

    Exporting to Excel: Number Format Issue

    In Excell your cells are formated to give you commas. All you have to do is select the cells that have the problem, right click on them and click on Format Cells. Once here click on the Number tab. There you can either choose to make the Cells General, which wouldn't put the comma in but...
  3. PerrinA

    Data from excell

    I tried making it a subreport, but I couldn't use the data in formulas. Is this normal or am I doing something worng?
  4. PerrinA

    Data from excell

    Is there anyway for me to get data out of MS Excell without creating a new report? I have some data that needs to be placed in a report on a monthly basis, but the data is only found in excell. I need to have crystal call the data from excell, if that is possible. Thanks, Jason
  5. PerrinA

    What is in a field?

    I need to include a field in my report, but am unsure of what it's called. I know the data values that will be in the field. There are over three hundered fields for me to search through. Is there any way I can find the field I'm looking for? -Jason
  6. PerrinA

    Password doesn't work

    I need to add a database to a report. But when I go to add it it pops up a box and asks for Microsoft Access Password. The normal access password fails to work. If anyone knows how to get by this, please tell me. -Jason
  7. PerrinA

    Getting data from user

    I have a report that is supposed to print Sales Reports by county. The problem is, the only data is in zip code. I was wondering if there is a way to let the user enter a county name so that I can use an if/then/else statement to limit the zipcodes shown. -Thanks Jason
  8. PerrinA

    Question mark

    I just started working with Crystal Reports and need to edit a report made by our previous IT guy. I understand most of what is going on but I need to know what a ? means. Thanks -Perrin
  9. PerrinA

    Adding a page

    I have a large amount of data I need to put into a report. Is there anyway to make the report two pages wide and X pages long(however long it ends up being)? Or do I have to make to seperate reports?
  10. PerrinA

    Exporting to Excell

    I have a report which has the jobs we have done in the lat couple of years. I'm exporting the report to Microsoft Excell 2000 and want to but it all in one document, but on different worksheet pages. Is there anyway I can do this? Thank you for your help.
  11. PerrinA

    Combining Numbers and Strings

    Is there a way to combine numbers and strings? I wnat to combine a string value with a random number. Any suggestions would be greatly appreciated. Aybara Wolf
  12. PerrinA

    Display date as a serial number

    What do you mean by serial number exactly? Aybara
  13. PerrinA

    No rowset was returned for this table, query or procedure.

    I am using version 8.5. The database is in Excell.
  14. PerrinA

    No rowset was returned for this table, query or procedure.

    When I try to Previewcertain files i get this error: No rowset was returned for this table, query or procedure. When I hit okay I get this error: Error detected by database DLL. I'm guessing that this problem has come up before and if it has can someone direct me to the solution. Thank you. Aybara.
  15. PerrinA

    How to divide dates

    I haven't worked with Crystal Reports much and need some help. I have a spreadsheet with peoples birthdays and their names. I can get Crystal to ouput their age in days but not years. Can I get Crystal to divide the number by 365, or is there a way to covert the date to years? Thank you for...

Part and Inventory Search

Back
Top