Recent content by kg2report

I have the counter formula you provided in the details section and the following formula in the report footer. When I changed the formula in the counter formula to yours, the numbers from page to page did not reset to "1." What do I need to do to make it reset to "1" and for the records to...

Hi LB. I discovered that it's suppressing the records that are duplicates. I had the following in the details section "Suppress" no drill down: previous ({table1.field1})=({table1.field1}) Question: how can I make the record counter NOT skip and still not list the duplicates? Thanks. kg

I have a crystal report and would like for it to do the following: 1. For each record, it counts incrementally (ex: first record displays "1", second record displays "2" and this will go up to record 17. 2. The counter resets after 17 so each page should have 1 thru 17 and starts over again...

I have the following excel formula that I would like to run in Crystal- can someone help, please? Thanks in advance. =IF(COUNTIF(range,criteria),"YES","NO") kg

Hi. I have the following field, which counts the number of records (staff) displayed on each page. However, on some pages it skips a record, and I'm wondering what is wrong with the formula I have and how I can fix it. Please help. Thanks. WhilePrintingRecords; Global NumberVar x; x:=x+1; x...

Even though it seems fixed in Crystal, when it's exported to excel, the seconds data remains.

I tried that already before and that didn't work.

Hi. I have field that is formatted as mm/dd/yyyy HH:MM:SS pm/am. I need to delete the seconds but still be able to show the "am/pm". Please help. Thanks. kg

Hi, I have a label and want a field that would turn (in increment of 1) as I print how ever many labels I want. NOTE: No records attached to the label or the label doesn't link up to any db. Can someone help me with this please? Thanks. kg

Yes- users will fill in manually. I've created lines to create for the columns in each row. Thanks. kg

Hi. If anyone can help me with this... Scenario. I have a Crystal Report page that needs to have a fixed number of 10 rows per page (the rows are not tied to any records). The pages; however, are tied to records based on zip codes. I also need to have a fixed number of 10 pages per zip code...

Thank you- you've been a great help.

Hi LB. I was wondering if you would kindly explain what each line does in the formula you provided below? I'm trying to learn more and would like to visualize what each line does in the process. Thanks. kg. whileprintingrecords; stringvar p; numbervar i; if remainder(i,40)=0 then( i := 0; p...

Hi LB. Just want to give you an update. It finally worked! I had to fudge with the size of the field and font formats, but it works. Thanks so much for your help on this!!! Very much appreciated for your help and patience. kg.

Below is the formula I used. The letters do not move at all to the right even if the page number changes... so the field doesn't even wrap. I did try changing the 31 from 1 to 300, and it still didn't do anything. Formula entered in field "reset" (placed in page header): whileprintingrecords...