Search results for query: *

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

Also, the report is grouped by user's zip code- would that affect the formula and deter it from working properly? I've tried lots of times, but still not able to get it to worked... kg.

The letters no longer move to the right. Do you know why it could be? Even the other formula you provided, the letters do not move to the right anymore. I've triple checked the formula, and they are correct. I've also made sure the reset formula is in the page header and not the report...

I did delete previous formulas. I created the fields again. How do I verify the point at which the formula tries to wrap in the page footer? I tried changing the 31 to the smallest number possible and up to 3000, and no luck. When I click the next page arrow, the letter changes to reflect the...

Hi LB. Just to confirm and to make sure i did it correctly. I created a formula field named "reset" and put the formula below that you provided in the field's Formula Editor. Then I dropped that "reset" field any where in the Page header. whileprintingrecords; stringvar p; numbervar i; if...

Hi LB. So I changed the formula to the following... I need one more help, please if you could. How can I force the letter to start at the very beginning of the line once the space allotted for the field has been used? The letter goes to the next line. I had formatted the field to have Exact...