Search results for query: *

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

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

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

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

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

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

Hi all, I'm using crystal report 2008 and trying to upload default values on my parameter field. I have item ID's populated from A - Z in my item_id field in the database. However, when I upload my item ID's to the parameter field, I only got A - H. It doesn't matter if I was using static or...

Hi all, I created a very simple report in crystal version 8.5. I only have 2 columns (item ID and item description). When I exported my data to comma separated values (csv) using the export feature, my header prints on each line. In Crystal: Item ID Description ABC Glue XYZ...

Hi all, I am currently using Crystal XI professional. I have this report that uses a subreport. The subreport contains note information. That said, this subreport can grow quite large. Here's an illustration of how the report looks like: Item ABC Subreport Note Item XYZ Subreport Note Let...

Hi all, I am using crystal XI professional edition. I have my information in the detail section. Everything works well in crystal. Nevertheless, when I exported it to Microsoft Excel (97-2000), the excel file results in skipping the even numbers and show the information in the odd number...

Hi all, I am currently using crystal 2008 and was wondering if I can do described below: I am building a sales report. This report shows the transactions per salesman. I have a prompt to show details vs. summary. If the user chooses details then I need the detail section to show and the...