I have an inventory report that looks at every inventory transaction and sums the transaction quantities in a complex formula. The details section shows every inventory transaction, and it's suppressed. Group 3 is the item number, and the sum of the transaction quantities is displayed in that...
I'm using Crystal Reports v8.0, Crystal Enterprise v8.0, and the interface to Baan ERP on Oracle. I need some help figuring out the best way to massage my data into the proper report format.
Here's a simplified version of my table:
ProblemID Person1 Person2 Person3 Action1 Action2 Action3...
Has anyone created any worksheets or design tools/aids to help with development of Crystal reports? I'm halfway through writing an Excel spreadsheet that documents columns, fields, formulas, ...; but I'd rather not recreate the wheel.
I'm looking for something that I can use to simplify the...
The database table looks like this:
Shipping
{Item#} {Date}
How do I show every item whose latest shipping date is more than 90 days ago? Our DB guy said he'd do it in SQL with a HAVING clause.
We're using Crystal Reports v8.0, and the report will be published in Crystal Enterprise. The...
I have a report that I'd like to schedule in ePortfolio to run on the 1st of each month with a date range of the previous month. I'd also like to run it on demand with a parameter prompting for a date range. Is this possible? Steve Bell
There's nothing better than a friend, unless it's a friend...
I've got XP up and running fine. I created accounts for my wife and me. I left the guest account for my brother-in-law when he visits.
Now I'd like to get my webcam working again. How do I make the webcam software run at reboot, even when no one's logged in? (Especially when no one's logged in...
I have a new CE user who gets this error message when trying to view any report:
Internet Explorer cannot open the Internet site
http://dntapp03/crystal/enterprise/ePortfolio/en/viewrpt.cwr?id=661&init=actx:connect
The connection with the server was reset
He can log in and change his display...
I'm using CR v8.0 connecting to Baan ERP via the DLL interface.
I've developed a report that:Retrievesrelevant inventory transactions for each part from the transaction history (to establish a usage level for the last 12 months)
part-specific info (standard price, safety stock level) from the...
We're a Baan ERP shop, and we're interested in
Crystal Enterprise for Baan
I have a video-conference scheduled with Seagate later this week to get a demo and go over pricing and technical issues. What questions should I ask? Steve Bell
We're a Baan ERP shop, and we're interested in
Crystal Enterprise for Baan
I have a video-conference scheduled with Seagate later this week to get a demo and go over pricing and technical issues. What questions should I ask? Steve Bell
I'm writing a report to calculate margin on our parts. The costs for each part (materials, labor, overhead, subcontracting) are rolled up periodically and stored in a different table.
My problem is how to retrieve only the data I want. I have a set of tables that look like this:
Invoice Table...
My report uses a combination of sums, running totals, and formulas in a group footer. When I suppress or hide the details section, the values from the bottom line of each page are duplicated in the first line of the next page (replacing the correct values). When I unhide or unsuppress the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.