Each one of my files are grouped in my report. What if I create a formula that grabs the lowercase of each parameter file and then compares that with the database? Again my syntax is wrong but I'm thinking something like this:
Shared StringVar array convertedParam;
Local NumberVar i;
For i := 1 To Ubound({?Files}) Do
(
Redim convertedParam;
convertedParam := LowerCase({?Files});
convertedParam;
);
(my brackets aren't making it through this new post form, is there a code snippet I should be using to escape these characters?)
Currently I'm getting a "true" as a result of this so obviously I'm doing something wrong. But am I on the right track? Then I use the select expert to make sure any table files it pulls is compared with convertedParam instead of the actual ?files param. Obviously I could have to add a counter so i would increment at each new file group.