This time, enter the name Product for your formula name and Click OK when finished. Change the value in the formula to , Click the Accept button, and place the formula field box in the Details section of your report, just to the right of the Product field box.
Select Insert Formula Field a third time, enter the name Product for your formula name, paste the original formula in the Formula Text box, and change the value to Click the Accept button when finished, and place the formula field just to the right of the other two field boxes. The Report Editor should look like this: If you print your report to the print window, you'll see that the values you want are in their appropriate columns, but the data isn't lined up the way you want it in your final report.
In order to get the data lined up properly, we're going to subtotal the data in each of the columns so that a subtotal prints whenever the salesrep changes.
By setting up a subtotal on each change of salesrep, we will be duplicating the data that prints in the Details section. When we later hide the Details section, however, we will eliminate the duplication.
In order to see what we're doing, select Edit Show Field Names. This displays the field or formula name for each field in its field box. Select the Product field box, Click the right mouse button, and select Insert Subtotal from the pop-up menu. The Insert Subtotal dialog box appears with the value xtab. Leave the value in the second scroll box set at "in ascending order", and Click OK when finished.
The Insert Subtotal dialog box appears, and this time the value in the scroll box is Group 1: xtab2. Click OK to accept it. Repeat Step 17 with the Product field box. When finished, the Report Editor should look like this: To total the data in each column, we'll use the Insert Grand Total command. Select the Product field box again, Click the right mouse button, and this time, select Insert Grand Total from the pop-up menu.
The Insert Grand Total dialog box appears with the word sum in the scroll box. Since we want to create a grand total sum of all the data, Click OK to accept the dialog box as it is.
The program creates a Grand Total section and places the grand total field box in that section at the bottom of the Product column. Repeat Step 19 with the Product and Product field boxes as well. Now we need to hide the Group Header Section, because it is not needed, and to hide the Details section to get rid of the duplicate data remember, the subtotals duplicate the data in this section.
Crystal Reports hides that section of the report. Do the same thing with the Details section of the report. Since you have fields in that section, the section remains on screen but it becomes grayed-out to indicate that it is hidden. You are commenting using your Facebook account. Notify me of new comments via email.
Notify me of new posts via email. This site uses Akismet to reduce spam. Learn how your comment data is processed. Skip to content. Below is a sample of the report generated. Like this: Like Loading Previous TF The local version table for the local workspace could not be opened. Next in review.
Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:. Email required Address never made public. Name required. Follow Following. I have different date columns that cause the detail section for some columns to be blank as a given data can be under only one of these columns. If column A has data, for example, all other columns will be blank for that detail row. In the group footer of each column, I need to list the details in ascending order BUT eliminate all blanks for that column.
If this is not possible, can use a subreport to summarize and sort the data in the main report? What are you grouping on for your row level data? I am grouping by Shift first and by staff Level second.
I placed the nth smallest formula in the staff level group footer. But the formula is considering the blanks in the columns shown in the previous attachment which is actually part of the details section that is suppressed.
Sorry but I am having a hard time understanding your data set up. First I think I was trying toa ssist you with an actual crosstab, but now I am thinkning that you are trying to mimic a crosstab with an actual report so each row is showing a different group "minimim" correct? This would be very hard to get rid of your spaces becasue in escence you are trying to display different groups onto a single row.
0コメント