Solved

Crystal report command parameter via table

Posted on 2011-03-21
1
606 Views
Last Modified: 2012-05-11
Is there a possibiliy of passing values from a regular table as a parameter value in crystal report command?

For example: table Ordertrack (with fields: originatorid, requestdate)

Sql Command:

Select * from EmployeeeLoan where EmployerID={?@originatorid} and LoanDate >={?@requestdate}.

We cant join these 2 tables together but using a sql command would be most efficient if the command can accept values from the Ordertrack table for its parameters.
0
Comment
Question by:ITDeptAtPCS
[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
1 Comment
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 250 total points
ID: 35182111
In other words, you want to use one table as the source for the List of Values with a dynamic parameter.  The short answer is no.  Dynamic parameters aren't compatible with SQL Commands. That being said, if you capture the dynamic parameters in a container report, you can pass them to a subreport that uses the command.   So, build a blank report against one table and create dynamic parameters against that table.  Then, create a subreport based on the command and link the main report to the subreport based on the parameter values in the main to the parameter values that exist inside the command.

~Kurt
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
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…

732 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