Solved

Crystal Report - Parameter/ Ideas

Posted on 2013-05-20
4
403 Views
Last Modified: 2013-05-20
Good morning. I am  trying to think of different ways to handle a report I created for commercial invoices. We have a field (COO - Country of Origin) that has to be typed in and for the most part works fine because it pulls the data for the COO from the DB. However, when there is a TBD or N/A in the field, it causes us an issue because obviously it will have to be hand written in which will cause it to be rejected at customs. I am thinking of the best way to handle this and the only thing I have come up with so far is to have users run the report as usual and in the event that the report returns data in the COO field that has TBD or NA, they then export the report to excel and then change the field by typing in the appropriate information.

Is there a way to create a formula that would allow the report to generate a parameter based off of the field data? Then from there they could actually select the COO from the list.

Any other ideas would be appreciated.
0
Comment
Question by:Llacy80
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39181124
Reports are not interactive.

You could provide a value that is substituted for all TBD/NA values.

Is there any way to determine what the value should be like a city or country field?

mlmcc
0
 
LVL 4

Author Comment

by:Llacy80
ID: 39181145
There would really be no logical way to determine with out human interaction to select from a list. That is why I was hoping I could somehow create a formula that would prompt if the COO field was TBD or NA so that the salesperson could just select from the list.
0
 
LVL 18

Expert Comment

by:vasto
ID: 39181147
How do you run the report?
0
 
LVL 18

Accepted Solution

by:
vasto earned 500 total points
ID: 39181224
You can check this sample video for cascading parameters:
http://www.r-tag.com/Pages/Preview_CascadingParameters.aspx

I guess your first parameter will be InvoiceID, when you select it the viewer will get the COO and will show it in a second combo (which will contain also a list of other possible values) . the user might change the COO or run the report as is. You can create a stored procedure or a  command , which will handle the COO value and will process it automatically.

You can also create an event , which will check the value of the CCO and if it is not correct will not allow the user to run the report . A sample vide , which demonstrates this feature is available from this link: http://www.r-tag.com/Pages/Preview_Demo.aspx
Jump to minute 8:30 or select "Events" from the menu in left (you might need to wait until this part of the video is downloaded)
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Backup Exec 15 not showing job history in report if failed/cancelled. 9 147
Crystal Reports 2008 6 42
Crystal Reports 13 5 86
Crystal Reports total formula with groups? 4 64
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question