Using Save As to create subreport: Selection causes Data to Disappear

[roody91]

Hi,

I've built a rather large report for an entire distrcit that I must also show broken down by Manager level. The data/formulas at the manager level is almost identical to the district level.

My plan is to save a copy of the original report with the Save As command. In the new copy of the report I will add a selection to select records only pertaining to the particular manager then insert the new report as a subreport on the original district wide report. Seems to make sense to me and should be easy.

However, when I tried this and added the selection on the Manager field All my data vanishes. Is there something that I'm missing? If I clear all of the selection formula data reappears. What gives? I am using the selection expert to add the selection criteria.

Thanks,

Frank Buckley

 

[Roadkill150]

Hello,
Can you provide a bit more information? is this occuring in the saved report before it has been placed as a subreport? ie: standalone? Also, did you rename the 2nd report? I would suggest that you try adding in the your selection criteria one part at a time using the selection formula editor instead of the expert, and then running the report each time to find which part of your selection criteria is causing the report to not return data. Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[roody91]

Hi,

I found the problem to be the selection criteria. For some reason the report now does not work when I use the "is equal to" option in the selection criteria. Instead I must use the "is not one of" option to get my data to display. As you can imagine this can be time consuming and in the future produce incorrect results should more choinces ba added to a field at a later time. All of the fields I work on are strings. Has anyone had this experienced this trouble? I swaer it worked before when I had the professional version 8.5 . I recently upgraded to the developer edition of 8.5. I think this may be the cause but cannot be sure.

Frank B.