Microvellum Knowledge Network

Trouble with Filter on a Report

Hi,

I'm having an issue with a filter I cant seem to solve.  What is happening is I have it looping per specification group to fix the header information.  However its giving all subassemblies from products in both spec groups.  I want a filter to get rid of the ones that don't match.



I set up 2 Variables to equal the Run Thru spec Group and the subassembly.product.specificationgroups.name


      (Here you can see strSpecificationGroup = Framed
                                    strTempSpecificationGroup = Framed


However when I filter so expression strSpecificationGroup = strTempSpecificationGroup nothing appears.  I've ignored Drawer Fronts so something renders and I can see the splits.







Lastly, without the filter (and showing exact values)



you can see Cabinet 1 is Framed, Cabinet 4 is Framed
Cabinet 2 is Framed (2) (strTempSpecificationGroup)


Any help on this would be great, the events to get the two variables are:
      Before Print: strSpecificationGroup=SpecificationGroups.Name (From a SpecificationGroup Databand)
      Before Print: strTempSpecificationGroup=Subassemblies.Products.SpecificationGroups.Name (From a Subassembly Databand)

Thanks,

-James

    MVU eLearning



    Grow Your Knowledge
    Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


      Follow us on:

               

        Google Review