1 Crystal report for Multible departments

[rickm4]

Hi all,
I am very new to Crystal Reports (8.5) so please be patient I have created a cross tab report in crystal that is based on tables in out time and attendance system (Kronos CENTRA). The good new is, The department heads love the report!!! the bad news(for me) is, this report has to be run every two weeks and must go to about 9 different departments which mean the data is different for each department. What i am doing now (Still in testing phase)is changing the department number through the "Select" option in Crystal and then doing a refresh data and exporting the data to an Excel spreadsheet for that department, and then going back changing the department number again for the next department...so on and so on. PLEASE tell me there is a way to automate or at least make this easier through the use of variables or something. Please let me know if this does not make sense, i will try and clarify. Thanks in advance. Rick

 

[synapsevampire]

You can create a parameter field (use the field explorer) which is pre-populated with each department (or you can enter the numbers), now you can just select from the list to do this on an individual basis.

You would then reference the parameter in the record selection criteria (Report->Edit Selection Formula->Record):

{MyTable.MyDepartment} = {?MyDeptParm}

As for automation, you can either code for this using VB or some such, or use Crystal Enterprise to publish and/or distribute this data.

Another less expensive and solid product is from Ido Millet, one of the experts here:

http://www.milletsoftware.com/CUT.htm

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[IdoMillet]

SynapseVampire, thanks for the plug... )

Rick, have a look at my Visual CUT utility:

http://www.milletsoftware.com/Visual_CUT.htm

It allows you to schedule and automatically export, burst, and e-mail a report.

In your case, your report would need to be grouped by Department and you would need either a table with the email address of each department manager or a formula that returns the email address given the department code.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[rickm4]

Thanks Guys, Do you offer a Demo of your product? I would like to try it. Also, Sorry for the second question but, This report is a "CrossTab" report, When i set up a parameter Field to enter the department number and press refresh data, The report will rerun but, the data on the report will not change(??) Pleasae tell me what i am doing wrong. Thanks

 

[synapsevampire]

Add to the record selection criteria (Report->Edit Selection Formula->Record) something like:

{MyTable.MyDept} = {?MtDeptParm}

Substituting your table deptfield/deptparm.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[adiazy]

I am trying to do a report like the one rick did and I am having trouble with it, I can get who is late or early but not who is absent on the specific date.

Anyone knwos how I can acomplish this?