You could suppress the Blank sections. Place this in the formula field for the formatting of this group and check the suppress box.
if {follow_up_intv_dt}=0 then true else false;
At least then you can get rid of the blank lines.
-TO
The problem is the tables are created daily. What I need to be able to do is reference a table that has not yet been created when the original report was written. I need to be able to write the report using standard data, however, at run time have it get records from a table that I can not add...
What I've got is a database that has hundreds of tables. These tables are created and named automatically inside the original database. I need to be able to link to them based on either a formula or a parameter field. Here is an example of what I need. I have a database called Jobrpt.mdb, inside...
I was able to get the distinct count of Number B's that I needed by using the following variation of the formula above in the details section:
whileprintingrecords;
stringvar MyNums;
if instr(MyNums,totext({PRODUCTINFO.SequenceNo},0,"")) = 0 then
MyNums :=...
I have a report that contains records with a "Number A" and a "Number B". The Number A is what is used for Grouping. What I need to be able to do is list all the Number B's that are contained in the records of that group. Here is an example of what the records look like...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.