I am currently working on a payroll distribution report and I am have some trouble. I have pulled in the employees for the payroll along with the gross and net amounts of their paychecks. The only other peice that I need is the OT amount which comes from a different table. I have linked the two tables and when I try to pull in the OT amount with a (IF THEN, so I can try to only pull in the dollar amount for anyone who has an OT code) statement it gives me $0.00 listed for all of their pay codes. I need the OT dollar amount for just those that had OT and $0.00 for those that did not. Each person has several pay lines and I need everyone not just those with OT so filtering out the OT code will not work. Any suggestion would be deeply appreciated.
Example of what I am getting
Gross Net OT
398 John Doe 500.00 150.00 0.00 (This is a base pay)
398 John Doe 500.00 150.00 50.00 (I only need this line if an individual had OT)
What I need to see:
Gross Net OT
398 John Doe 500.00 150.00 50.00 (Had OT)
399 Sue Brown 600.00 250.00 0.00 (Did not have OT)If your OT table doesn't allow for nulls, you wouldn't need an IF statement. If so, you'd just check if it was null - if so put 0, if not put the value.
I.E.: if IsNull({Overtime.OT}) Then $0 Else ${Overtime.OT} //the $ sign is for converting to currency
Or am I not understanding your question?
Showing posts with label distribution. Show all posts
Showing posts with label distribution. Show all posts
Sunday, March 11, 2012
Thursday, March 8, 2012
Crystal Report Distribution - Newbie
I am a newbie at this and I have gotten myself very confused, someone please HELP!
I have V10 Pro installed and I have been teaching myself how to create report using it's features. I do not seem to have Crystal Enterprise so all of the repository features are not available.
I have been tasked to build reports that will be distributed to others within my company either as stand alone files or viewable with Internet Explorer. I need to have drill down and parameter capabilities at the users end but none of my users have any Crystal Products. How do I go about doing this?
Eventually, I will be building VFP applications that will run these reports and distribute them to my users.
The vast number of products offered by Business Objects for Crystal makes it a little confusing on a first time user. Will it be possible for me to make and distribute reports to my users without having them install any Crystal products or without me having Crystal Enterprise? I was thinking it would work something like creating a PDF and the end user viewing it with a free Adobe Reader...I actually located Crystal Enterprise 9 on my network, however, I am unable to connect to it, I get a CMS not on PORT 6400 error. Will this work with Crystal Reports 10 Pro? What do I need to do to connect to it?|||See if you find solution at support section of this site
www.BusinessObjects.com
I have V10 Pro installed and I have been teaching myself how to create report using it's features. I do not seem to have Crystal Enterprise so all of the repository features are not available.
I have been tasked to build reports that will be distributed to others within my company either as stand alone files or viewable with Internet Explorer. I need to have drill down and parameter capabilities at the users end but none of my users have any Crystal Products. How do I go about doing this?
Eventually, I will be building VFP applications that will run these reports and distribute them to my users.
The vast number of products offered by Business Objects for Crystal makes it a little confusing on a first time user. Will it be possible for me to make and distribute reports to my users without having them install any Crystal products or without me having Crystal Enterprise? I was thinking it would work something like creating a PDF and the end user viewing it with a free Adobe Reader...I actually located Crystal Enterprise 9 on my network, however, I am unable to connect to it, I get a CMS not on PORT 6400 error. Will this work with Crystal Reports 10 Pro? What do I need to do to connect to it?|||See if you find solution at support section of this site
www.BusinessObjects.com
Wednesday, March 7, 2012
Crystal Enterprise and massive report distribution to multiple destinations?
Hi,
Before we have used Oracle Reports for our application.
Now, customer wants to move to Crystal Reports.
The Oracle Report Server provided a great and rather simple interface for printing many reports in short time and sending them to multiple destination.
So, we had a function to run report and provided report definition file (.rpt for crystal reports), a destination (printer, mail(s), pdf, etc.) and some auth information as parameters and started distribution easily.
Does Crystal Reports or Crystal Enterprise provides such an interface?!
I've looked into the documentation yesterday and this morning but couldn't find anything simple and appropriate. I see there's Report Job Server and Page Job Server, which I assume provide some kind of queueing, but what is the interface to these servers? Is it simple and easy to use for massive report distribution to different locations?
I'm not interested in preview at all. Just need a lot of 'End of day' reports to printer and to files/emails. Also, I would like to have a central reporting service in my application which would forward print requests to report server and I don't need to use UI controls in my clients (Win and Web Forms). I would like that clients only send the report, auth and destination details and that the central reporting service forward the request to report job server.
How can Crystal Reports/Enterprise help me?Enterprise is a WEB based report server
You can schedule as many reports you want, with different scope fo each of them.
You can add all your user to the enterprise server and decide if they can only view, generate, schedule reports they can access.
You can use Windows authentication or Enterprise authentication, create group, assign privileges per group ( in fact by objects... user, report, group, viewver, scheduler...)
ask your nearest dealer to show you an installed application, I think that's the best...
Luc
Before we have used Oracle Reports for our application.
Now, customer wants to move to Crystal Reports.
The Oracle Report Server provided a great and rather simple interface for printing many reports in short time and sending them to multiple destination.
So, we had a function to run report and provided report definition file (.rpt for crystal reports), a destination (printer, mail(s), pdf, etc.) and some auth information as parameters and started distribution easily.
Does Crystal Reports or Crystal Enterprise provides such an interface?!
I've looked into the documentation yesterday and this morning but couldn't find anything simple and appropriate. I see there's Report Job Server and Page Job Server, which I assume provide some kind of queueing, but what is the interface to these servers? Is it simple and easy to use for massive report distribution to different locations?
I'm not interested in preview at all. Just need a lot of 'End of day' reports to printer and to files/emails. Also, I would like to have a central reporting service in my application which would forward print requests to report server and I don't need to use UI controls in my clients (Win and Web Forms). I would like that clients only send the report, auth and destination details and that the central reporting service forward the request to report job server.
How can Crystal Reports/Enterprise help me?Enterprise is a WEB based report server
You can schedule as many reports you want, with different scope fo each of them.
You can add all your user to the enterprise server and decide if they can only view, generate, schedule reports they can access.
You can use Windows authentication or Enterprise authentication, create group, assign privileges per group ( in fact by objects... user, report, group, viewver, scheduler...)
ask your nearest dealer to show you an installed application, I think that's the best...
Luc
Subscribe to:
Posts (Atom)