Is there a way for Crystal to call a function or run some VBA code in Access?
I have a dynamic query that i need to make each and every time a report is ran, i could probably make a function to make the query in Access, but how to call it?
You will have to connect via OBDC to see the parameter queries. Using this sample if you set Parameter=1 Field1 will be equal to FieldA; if other than 1 than Field1 will be equal FieldB.
The fields that you are selecting for a column should be the same size and type. You can also use the Access built in function Choose to allow to select more than two fields. I have try in the past to use VBA function I built to do a more complex selection but Crystal had problems. The query worked okay in Access but Crystal get complaining about the query not having any fields.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.