pmacduff Posted June 24, 2008 Share Posted June 24, 2008 Ok Tom I need your assistance... I have a client that is a PEO and has 80+ divisions (employers). There is a crystal report I modified that gives me the list of divisions, however it will only list the divisions for which there are employees in the database. When I add new divisions (prior to adding any of the corresponding employees) I like to review a listing of the divisions to be sure I have them all and entered all the new ones. Can you think of a way I can get the report to print all of the divisions and not just those with associated employees or is that not an option? Thanks in advance Link to comment Share on other sites More sharing options...
Tom Poje Posted June 24, 2008 Share Posted June 24, 2008 Its a lot easier for me to write pension songs. perhaps if you go to plan specs / miscellaneous/excluded divisions that should give a list of the all the divisions, and you can probably actually print that sub folder. that would be my initial guess, for by now you know how lazy I am and will try to find any work around. Link to comment Share on other sites More sharing options...
pmacduff Posted June 24, 2008 Author Share Posted June 24, 2008 ok - I'll give that a try and let you know..... keep singin' Link to comment Share on other sites More sharing options...
pmacduff Posted June 24, 2008 Author Share Posted June 24, 2008 couldn't get that to work. no option to print. I'll keep trying other things. Link to comment Share on other sites More sharing options...
Fredman Posted June 25, 2008 Share Posted June 25, 2008 What tables are you using in your CR and how are they linked? You may be able to change the type of link to include all of the divisions from your employer table to include all of those records. If you want to post the CR report, I'd be happy to take a whack at it. Link to comment Share on other sites More sharing options...
pmacduff Posted June 25, 2008 Author Share Posted June 25, 2008 Thanks Fredman. I'm using all the "div" tables. I think my Crystal report may be pulling only those with balances because I had modified another old report. I may play around with it when I get some free time . I'll keep you posted. I'm running on an "old" version (9.1) but I did contact Relius support and they were very helpful. They had me do a script in SQL and I could then copy and paste the complete division listing to Excel. Relius support told me that once I upgrade/update, they think I can print one off DB viewer that will have all divisions. Link to comment Share on other sites More sharing options...
Fredman Posted June 25, 2008 Share Posted June 25, 2008 Glad you found a solution. DB viewer is pretty cool once you learn the lingo. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now