Hi azar80,
first of all , always maintain one query per thread.
excel/crystal/pdf reports can be tested in various ways, one of the ways could be direct comparison and more better a file comparison after retreiving the data from your report and compare it with your expected data.
for your second query, i would like to suggest you to first research on how to parse and work with strings, like in your case you can use 'Replace' function.
I would also like to suggest you to first try with yourself and let us know if you have any issues mentioning what ever you have tried, in that way we will be more than happy to help you rather providing a generic code
some of the things has been discussed earlier. search this forum, I am sure you will definetly get some lead from there.
first of all , always maintain one query per thread.
excel/crystal/pdf reports can be tested in various ways, one of the ways could be direct comparison and more better a file comparison after retreiving the data from your report and compare it with your expected data.
for your second query, i would like to suggest you to first research on how to parse and work with strings, like in your case you can use 'Replace' function.
I would also like to suggest you to first try with yourself and let us know if you have any issues mentioning what ever you have tried, in that way we will be more than happy to help you rather providing a generic code
some of the things has been discussed earlier. search this forum, I am sure you will definetly get some lead from there.