There is a report that I'd like to modify that is part of some software that we use to report Non-Conformances (NC's) called uniPoint. It is a Crystal Report. I would need to add 2 tables to the report to pull the information I am looking for. I have a basic understanding of CR but this one uses datasets and I am at a total loss of where to start. What I need sounds relatively simple but I'm not sure where to go for help.
The report will have an NC Type that was the result of either 'Vendor', 'Customer' or 'In Process'. The program has a form that will list either the Customer or Vendor ID. Since this is a number it is meaningless to the users and they'd like to see the Customer or Vendor NAME. Since the NAME is not in the existing table I will need to add them.
At one time, I had been able to link a Customer and Vendor (Supplier) table to the report and get it to run. It worked fine when the NC Type of Vendor, but if it was Customer, then many of the fields were blank.
There are other issues I'm trying to figure out as well. In order to get everything to fit on this form, neatly, I was going to put in a condition that if the NC Type equaled "Vendor" to suppress the Customer and visa-versa, that way I could squeeze those two fields together to make room for the NAME. That would normally be an easy task for me but when I look at the form in Crystal it shows asterisks inside the TEXTBOX.
Can anyone point me in the right direction? Or do I need to start with a brand new report? --sql-unipoint-Client-Reporting-U.vbproj --sql-unipoint-Client-Reporting-User.rpt
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.