INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Crystal Reports 10

Crystal Reports 10

(OP)
Hello All, TGIF!

I have a report that shows me a case manager’s caseload, which is the total number of clients a case manager is assisting.
For example, John is assisting 82 clients.
These clients are divided into families (households)...
So he may be assisting 82 individual clients, which comes to a total of 28 Families.

Currently, Crystal Reports 10 makes me enter a parameter value.
So when I refresh my report, it makes me enter a parameter value, which is a case manager’s initials.
In doing so, I can only view each case manager and their totals, individually.

I would like to create a report that shows me a list of all my case managers and their total number of families each one is assisting.

I’d like the report to look something like this:
John Doe 22 Families
Jane Jacobs 21 Families
Joe Jones 23 Families
Joan Jet 20 Families

Any idea on how I can create this?

I feel like I am missing something....

Thanks in Advance, Mojz

RE: Crystal Reports 10

You just need to remove the reference to the case manager's initials and the parameter from the Record Selection.

You may need to add something so as to limit the records returned to "open" cases - without knowing your case management data it is difficult to be specific.

Hope this helps.

Cheers
Pete.

RE: Crystal Reports 10

(OP)
Thanks for replying pmax9999!
How would I remove the case mgr's initials and the parameter?

RE: Crystal Reports 10

From the Menu, select Report => Selection Formulas => Record.

You will then need to look for a piece of code that says something like {Table_name.Field_name} = {?Your Parameter Name}.

If you aren't able to identify the correct piece of code, post the entire Record Selection Formula here and we should be able to help you identify the correct pice of code to remove.

Cheers
Pete

RE: Crystal Reports 10

(OP)
I went to Report => Selection Formulas => Record
But can't find the piece of the code that says that...
So how do I get the entire Record Selection Formula?

Thanks in Advance, Mojz

RE: Crystal Reports 10

Can you send us a screen shot of what you are seeing?

RE: Crystal Reports 10

(OP)
Hello All!

I uploaded an attachment. Hopefully, you are able to view it.

So as you can see, I have a Family ID for every household.

And every person in the household has a Client ID.

Due to the parameters feature, I can only view my case manager one by one.

I would like the report to show me a list of all my case managers (their initials) and their total number of families each one is assisting.

I’d like the report to look something like this:

22 Families ZM
21 Families MO
23 Families JJ
20 Families PR

I am having trouble removing the case manager initials parameter....so I can create a report like this (above)



RE: Crystal Reports 10

What I really wanted to see was the 'Report => Selection Formulas => Record', so we could figure out how to remove the filter on the report. It is possible that the report is filtered at the command level.

RE: Crystal Reports 10

It appears on the surface the the filtering is being done in a command or a stored procedure. A command could be fairly simple to look at (Database menu item, Database expert, right click on the item in the right pane, you should get a pop up menu that gives the option to edit command). If it is not a command (i.e., Stored Procedure). Then you will need other tools and possibility permissions to edit the data source.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close