Launch ODBC Report and Pass Parameters

Hello,

I’m familiar with using process.caller to call BAQ reports using the menu ID and passing parameters in there. And I’ve opened Bartender labels and passed parameters using their engine with a string. But What I need to do is open a ODBC Crystal report form the MES menu and pass some parameters to that and I don’t think I’ve seen any information on that. I’ve searched around and haven’t found anything specific to this. Could someone help me out, what is the syntax I need to to use to launch an ODBC crystal report and pass it some parameters? I’m doing this in a button click and I’m passing it some info i should be able to get from the screen, employee number and today’s date. Any help is appreciated!

I had a similar problem (passing parameters to an ODBC based CR report), and was told that the CR Runtime in Vantage won’t pass parameters. You need a third party CR viewer, but then launching that from Vantage might be just as hard.

Here’s a thought on kind of a hack. It requires an existing report that: a) can be launched from MES, and b) has the data your ODBC report would use as parameters.

  1. Make a new style for the report launched from MES.
  2. In CR designer, hollow out the report (obviously a copy of the report).
  3. Insert your ODBC CR report as a sub-report.
  4. Link the fields from the original report’s RDD, to the parameters of the CR report.

You might need to make a modified RDD (report data definition) to best match your parameters.

Thanks for the response. I was afraid of this and have looked around and I think I found a report I could use to hollow out. I am able to pass parameters to the RDD report I’m hollowing out using process.caller though correct (not sure with Vantage)? I think I can use Employee Badge, which is accessible from the Menu.