Allowing the use of % - wildcard character in PS Query prompt ::
Make sure for the prompt definition the edit type is 'No Table edit' and Also while using this prompt in the Criteria definition, make sure the operator is 'Like' and not 'Equal to'
For Group by functionality in PS Query, whenever an expression is defined to have aggregate function in it, check the box which syas 'aggregate function'
No comments:
Post a Comment