Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1342
  • Last Modified:

Printing Parameters in Crystal Report, source Vantage

Good Afternoon Experts!

I am having a problem with the reports I create through Vantage. If anyone is familiar with this program, basically you create first a BAQ, then you design a BAQ report, then you create a Crystal Report based on the XML generated in Vantage. Two of the tables that appear on Crystal are: BAQReportResult and BAQReportParameter.

I'm creating a report, and I'm using the Crystal "Select Expert" to filter my data. When my logic doesn't find any records, the fields from the BADReportParameter are not being printed on my report. This parameters include the report Title and the User's Input parameters

I'd really appreciate if you can help to overcome this issue.

0
capertuz
Asked:
capertuz
  • 4
  • 3
1 Solution
 
mlmccCommented:
What is the BadReportParameter?

Returning no records is a valid result.  I suspect BadReportParameter means you entered an invalid value

mlmcc
0
 
capertuzAuthor Commented:
Thanks for your answer mimcc. I had a Typo on my question instead of BADReportParameter is BAQReportParameter, and this refer to one of the tables that Vantage generates in the XML.
0
 
mlmccCommented:
How are the tables linked?

mlmcc
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
capertuzAuthor Commented:
I'm linking BAQReportParameter --> BAQReportResult with a Left Outer Join
0
 
mlmccCommented:
What filters are you using?

mlmcc
0
 
capertuzAuthor Commented:
I'm filtering records from the BAQReportResult table, but still, if the selection doesn't return any records, the information from BAQReportParameter should be displayed because is a left Outer Join.
0
 
mlmccCommented:
As soon as you filter based on the jopined table, Crystal changes the join to an INNER JOIN so it doesn't have to deal with the NULLs.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now