If you look at the filter1 contents, it's essentially an XML document.
In order to get down to the filter list I've found that you need to start using the split() functionality in crystal in order to gradually get down to the "list" part of the filter. I've seen that multiple filters all go into the "Filter1" field, so you need to look at this part carefully.
In order to create the correct formula I create a new crystal report, link in the BAQ and display the Filter1 column and then the formula.
I then start splitting until I am displaying just the "list" portion I'm interested in.
At that point it's usually another split or two and you have your array of values from your filter.
________________________________
From: vantage@yahoogroups.com on behalf of Hernandez, Dolores
Sent: Tue 9/7/2010 2:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ - Crystal Report
Hello All,
I have a BAQ report that uses the Warehouse Code field to filter by and in the Crystal Report I am trying to grab the warehouse(s) from the {BAQReportParameter.Filter1} field. I am having some difficulty in doing this and wondered if anyone could give me some direction. Below is the data received from the {BAQReportParameter.Filter1} field and I need to extract just the warehouse codes.
[cid:image001.jpg@01CB4E94.75EFFEA0 <mailto:image001.jpg%4001CB4E94.75EFFEA0> ]
Thank you,
Dolores
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
In order to get down to the filter list I've found that you need to start using the split() functionality in crystal in order to gradually get down to the "list" part of the filter. I've seen that multiple filters all go into the "Filter1" field, so you need to look at this part carefully.
In order to create the correct formula I create a new crystal report, link in the BAQ and display the Filter1 column and then the formula.
I then start splitting until I am displaying just the "list" portion I'm interested in.
At that point it's usually another split or two and you have your array of values from your filter.
________________________________
From: vantage@yahoogroups.com on behalf of Hernandez, Dolores
Sent: Tue 9/7/2010 2:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ - Crystal Report
Hello All,
I have a BAQ report that uses the Warehouse Code field to filter by and in the Crystal Report I am trying to grab the warehouse(s) from the {BAQReportParameter.Filter1} field. I am having some difficulty in doing this and wondered if anyone could give me some direction. Below is the data received from the {BAQReportParameter.Filter1} field and I need to extract just the warehouse codes.
[cid:image001.jpg@01CB4E94.75EFFEA0 <mailto:image001.jpg%4001CB4E94.75EFFEA0> ]
Thank you,
Dolores
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]