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

    How do divide ALL my numbers by 1000?

    I tested and, funny thing, the numbers were all kept divided by 1000 both in PDF and in Excel. They weren't when exporting to Excel Data Only, but in the regular Excel export keeping all formats, the numbers were divided by 1000. They were not just SHOWING that way, but I made sure that the...
  2. Razor1973

    How do divide ALL my numbers by 1000?

    Well, the formatting might not be kept when exporting to Excel, but it should show exactly as it shows in Crystal Reports when exported to PDF... I hope! I will test tomorrow.
  3. Razor1973

    How do divide ALL my numbers by 1000?

    Actually, that was it! Go to that thread if you're interested in the solution. Thanks!
  4. Razor1973

    How do divide ALL my numbers by 1000?

    Actually, that was it! Go to that thread if you're interested in the solution. Thanks!
  5. Razor1973

    How do divide ALL my numbers by 1000?

    By the way, this scarlet person is up to something --> http://www.dbforums.com/showthread.php?p=6231866#post6231866
  6. Razor1973

    How do divide ALL my numbers by 1000?

    By the way, this scarlet person is up to something --> http://www.dbforums.com/showthread.php?p=6231866#post6231866
  7. Razor1973

    How do divide ALL my numbers by 1000?

    Thanks for your feedback, satinsilhouette. I apologize. I am using CR XI SP2. We do not use a repository or BOE server. Also, as I said in my original post, dividing the amounts at the data source is not an option. I am not using an ODBC connection to a database where I can create views. I...
  8. Razor1973

    How do divide ALL my numbers by 1000?

    Thanks for your feedback, synapsevampire. I apologize. I am using CR XI SP2. About your suggestion of using views, I will reiterate what I said in my original post. Dividing the amounts at the data source is not an option. I am not using an ODBC connection to a database where I can create...
  9. Razor1973

    How do divide ALL my numbers by 1000?

    Subject is self-explanatory, but I will provide more details. I have created a set of reports and my client now wants to see all figures in thousands. Dividing the amounts at the data source is not an option, before this is suggested. Long story. I have had no choice but to create ONE...
  10. Razor1973

    How do divide ALL my numbers by 1000?

    Subject is self-explanatory, but I will provide more details. I have created a set of reports and my client now wants to see all figures in thousands. Dividing the amounts at the data source is not an option, before this is suggested. Long story. I have had no choice but to create ONE...
  11. Razor1973

    Formula in a cross-tab that uses a value from a previous column

    lbass, no-can-do, right?
  12. Razor1973

    Formula in a cross-tab that uses a value from a previous column

    And how many of those colX do you make? If you specify a number, then you're not allowing for unlimited years, as my report requires. Also, say you know for a fact they will not be more than 20 years and you create 20 fields. How do you place them on a letter-size report so that, if the...
  13. Razor1973

    Formula in a cross-tab that uses a value from a previous column

    lbass, thanks again. Maybe I didn't make myself clear enough. I am sorry. You are assuming these years will be contiguous and I will have some sort of date range parameter. No. The data returned will contain the years and it could be 1998, 2001, 2002, 2004 and 2006 or something like that...
  14. Razor1973

    Formula in a cross-tab that uses a value from a previous column

    lbass, first of all, thank you so much for taking your time in creating such a detailed response. It shows a great deal of dedication to helping others. Before I go further into the details of your alternative, I see what may not qualify it as a solution to my problem and that's the fact that...
  15. Razor1973

    Formula in a cross-tab that uses a value from a previous column

    XI SP2
  16. Razor1973

    Formula in a cross-tab that uses a value from a previous column

    This is an extremelly simplified model of my environment, but should explain my problem. I basically have the following fields in my table: Year (numeric) Employee (text) Sales (numeric) I want to create a cross-tab that has Employee as a row header (no problem), Year as a column header (no...

Part and Inventory Search

Back
Top