Run a field in body of report only once?

nverma

I created a report for our client a while ago and they wanted a few modifications. So basically, the user will go to Customer Ledger Entries and select the ones he wants. Based on the selection, I have to transfer the Description and the Amount field from the selection to the report I have created. In the report, we have the following fields in the header:- Year, Description, and Amount.

1) In the body section, I was able to get the Description, and Amount field user selected. However, the client want the year to be printed once. Currently, since its in the body section, it repeats it for every single record. Is there any property that I can set, so the year field runs only once in the report. I tried moving the Year field from the body section to the Header section (which fixed the issue, but now its not at the same level as the description field). The client needs the year to be at the same level as the first description field).

2) When the report is run, I want it to be able to Automatically Incremment the Receipt No. based on the number it was last time. For Instance, I ran the Report Once (Thus, Receipt No. field should show 1. The next time I run the report, it should automatically Incremement the Receipt No. and show the receipt No. field as 2). Any Idea how I can implement this functionality?

mohana_cse06

1) you have to create 2 body sections..one with year,description and another with only description
Show first section only one time..

2)You can create a table and Insert the record each time in it when you run the report..

nverma

I created a body section like you suggested. How can I show it only once? What property would it be? SHOWOUTPUT??

mohana_cse06

yes..

nverma

UMMM.....What would the if condition be????

if ??????? then
Begin
CurrReport.SHOWOUTPUT(TRUE);
end

mohana_cse06

1.You have to take an Integer variable or boolean
2. initialize them to 0 and false in the begining of report
3. Print the first section if integer =0 or boolean = false
4. make the integer to 1 or boolean to true in same section once after printing
5. print the second section if integer = 1 or boolean = true.