[Webinar] Streamline your web hosting managementRegister Today

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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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