Search results for query: *

...below: IF SUM ({sales}, {invoice_date}, "daily") <> 0 THEN SUM ({profit$}, {invoice_date}, "daily") / SUM ({sales}, {invoice_date}, "daily") * 100 ELSE 0 I then placed the formula at the group footer 1. Everything works well. However, I can't seem to figure out how to chart that...

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

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

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

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

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

...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 * 100 to get the percentage. I then placed the @percentage field to group 1 header. Everything looks great until I get to the chart. How can I...

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

Thanks LBass - I'll try again.

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?

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

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

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

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

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

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

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

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

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

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