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 Mike Lewis 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. TryingToLearn101

    How to create a line chart on a profit% formula

    Hi all, I am currently using Crystal 2008. I am trying to create a line chart on a profit% formula. The report has 1 group by invoice_date. There are 2 values pulled from the database. They are sales and profit$. I need to calculate profit% per day. So what I did was to summarize my sales and...
  2. TryingToLearn101

    Creating an average and a maximum of summarized group values

    Hello all, I am using Crystal 2008. I have 2 groups - group 1 salesrep and group 2 customer. Each group has a summary for sales. The sales value is a formula. It is not a direct field from the database. I suppressed the details. What I need is to have a maximum and an average for the summarized...
  3. TryingToLearn101

    To prompt user to either do top N or bottom N Group Sort

    Hi all, I am using Crystal 2008. I am trying to create a growing/decline sales report. In this report, I want to have a prompt where user will specify either they want to see growing sales information (with customers who have difference in sales going up) or specify if they want to see...
  4. TryingToLearn101

    To show information of a table regardless if there's information from another table

    Hello all, I am currently using Crystal 2008. What I am trying to accomplish is below: I want to show all categories that I have from a category table on my report. I also have transactions with different items. Depending on the total weight/product family of these items on the transactions...
  5. TryingToLearn101

    How to show Total only in Cross-Tab

    Hello all, I am using Crystal 2008. I am trying to create a report using Cross-Tab like below: TOTAL YTD QTY TOTAL MO QTY SHIP 1 MO SHIP 2 MO CUSTOMER The Cross-Tab will be grouped by the ship-tos. Each Ship-To column represents the monthly quantity. I am trying to...
  6. TryingToLearn101

    Parameter prompts do not start from the first prompt on the list

    Hi all, I am using Crystal 2008. I have about 25-30 parameter prompts on my report. Whenever I run the report and the prompt list shows up on the screen, it always scrolls down to prompt number 10. I have to scroll back up to start with the first prompt. How can I make the prompt list start from...
  7. TryingToLearn101

    Charting values based on group formula

    Hi all, I am working on Crystal 2008. My fields from the database are: Order No Order Date Order Line Count Invoice Line Count I grouped my report by order date as group 1 and set it to show by week. I also created a formula to show sum invoice line count by week / sum order line count by week...
  8. TryingToLearn101

    How to convert numbers to text

    Hi all, I am on Crystal 2008 and would like to convert my 4-digit decimal numbers to text. This is what I tried before and it didn't work. It always showed 2 digits. TOTEXT ({sales} / {quantity}, '#.####') Any advice is greatly appreciated. Thanks, TTL101
  9. TryingToLearn101

    How to get column headings of fields in SubReport to print on next pg?

    Thank you very much for the trick. It definitely works like a charm. What I forgot to tell you was that I actually have 3 different subreports in this report. I am not able to do the same to my second and third. Is there any way to do so on the remainder of my subreports?
  10. TryingToLearn101

    How to get column headings of fields in SubReport to print on next pg?

    Hi all, I am currently working on a report using Crystal 2008. I have a subreport that I need my fields column headings to print again when the subreport goes over to the following pages (kind of like on a page header). But the subreport only has report header. What can I do? Please advise...
  11. TryingToLearn101

    Exporting to HTML and found the font changed

    Hi all, I am currently using Crystal 2008. I have a working report that I would like to export to HTML. When I exported the report, I used HTML 4.0 option and unchecked the 2 options of page navigation and separate html pages. I used Calibri for my font. When I exported it to HTML, the first...
  12. TryingToLearn101

    Creating tab delimited values for blank fields

    Hi all, I am using Crystal 2008 and trying to create a report that I eventually will export to Excel and save it as a tab delimited file. I have 40 columns on my report. From those 40 columns, I only have information for the first 10 columns. However, when I export it to Excel and save it as...
  13. TryingToLearn101

    Creating blank spaces to export to .prn

    Hi all, I am creating a report using Crystal 2008 that I will export to .prn. I am creating a formula where I am combining multiple fields into this one giant formula field. For example: I have {customerID}+{customer_name}. The thing is I need to add 5 blank spaces at the end of the customer...
  14. TryingToLearn101

    Show data based on the number of quantities

    Thank you both. That certainly will work. The only thing I need to do is to convince my audience to not have the quantity ordered 1000 or 10000 or that table would need to be created as a large one. Thanks again. TTL101
  15. TryingToLearn101

    Show data based on the number of quantities

    The data appears: item_id qty_ordered item #1 2 item #2 1 item #3 3 etc.
  16. TryingToLearn101

    Show data based on the number of quantities

    Hi all, I am not sure I could come up with a better subject for this. It's a little bit confusing and I hope you all can help me. I am using Crystal 2008. I have an order with 2 line items. Item #1 was entered with qty ordered 2 and item #2 was entered with qty ordered of 1. What I need is...
  17. TryingToLearn101

    Crystal 2008 Repository

    Hi all, I am using Crystal 2008. I was not familiar with the repository functionality before version 2008 and I'm not familiar with whis version. Below are my questions: 1. Do I have to have Crystal 2008 server edition for this? 2. From what I heard, the repository allows you to save...
  18. TryingToLearn101

    Having the report to call the appropriate jpeg image

    Hi all, I am currently on Crystal 2008 and trying to create a report that is able to pull the corresponding jpg image file to an item. So if I have 5 items, I need the report to show the item ID and a picture of that item. I don't even know where to begin with this. I am afraid the solution...
  19. TryingToLearn101

    Crystal Report 2008 default values not uploading entire information

    I noticed the many pages. I went to the last page and that's where I found only item ID's up to H were uploaded. Total items uploaded was 1000. I did a google search and one posting said that he had to change the registry when he did it in crystal XI. But I don't even know how to do that in...

Part and Inventory Search

Back
Top