I have to produce a report based on a range of data from a formula field, [which is in a format - "If NumericText {field} then ToNumber({field}) Else 0;"]... no problem.
To do so, I have created parameter fields to select the start/end range based on this numeric formula field... no problem.
I now have to list "dummy" record numbers to fill in gaps between the actual numbers contained in the formula field, (with a text comment ala... "Debit Advice No. not yet presented"
... that is the problem for me !!
Note that I have used the sample sub-report from Crystal Decisions, ("Creating Fake Records that are Missing from a Field", as my guide. HOWEVER, I AM NOT GETTING ANY FAKE RECORDS TO APPEAR IN THE SUB-REPORT.
I have proven, (by another report I've created), that the reason for this may be due to the sample report using a database field and NOT a formula field, (like me, as above), to calculate another formula field, "Next(<database field>)", which is then used for subsequent sub-report calcs… (ie, I would need to use "Next(<formula field>)".
The other issue I noted in the sample Crystal Report is that the report started at Database Record No. 3, (which is obviously the first valid record in the sample d'base), and then listed the subsequent real/fake records, (via the main & sub-reports). I would need to display fake records before the first valid database value, dependent on the starting parameter field number. (eg fake nos. 1 & 2, if my 'Start' Parameter field is set to "1", and "3" is the first valid number).
(I'm hoping the solution is a simple "evaluateafter" or "whileprintingrecords" or something like that, and the second issue is an easy one also).
Sorry for the above saga, but I hope someone has previously investigated the sample report, and/or gets where I'm coming from !
To do so, I have created parameter fields to select the start/end range based on this numeric formula field... no problem.
I now have to list "dummy" record numbers to fill in gaps between the actual numbers contained in the formula field, (with a text comment ala... "Debit Advice No. not yet presented"
... that is the problem for me !!Note that I have used the sample sub-report from Crystal Decisions, ("Creating Fake Records that are Missing from a Field"
, as my guide. HOWEVER, I AM NOT GETTING ANY FAKE RECORDS TO APPEAR IN THE SUB-REPORT.I have proven, (by another report I've created), that the reason for this may be due to the sample report using a database field and NOT a formula field, (like me, as above), to calculate another formula field, "Next(<database field>)", which is then used for subsequent sub-report calcs… (ie, I would need to use "Next(<formula field>)"
.The other issue I noted in the sample Crystal Report is that the report started at Database Record No. 3, (which is obviously the first valid record in the sample d'base), and then listed the subsequent real/fake records, (via the main & sub-reports). I would need to display fake records before the first valid database value, dependent on the starting parameter field number. (eg fake nos. 1 & 2, if my 'Start' Parameter field is set to "1", and "3" is the first valid number).
(I'm hoping the solution is a simple "evaluateafter" or "whileprintingrecords" or something like that, and the second issue is an easy one also).
Sorry for the above saga, but I hope someone has previously investigated the sample report, and/or gets where I'm coming from !