Here at my company, we have to report product data for many different products: ProdA, ProdB, ProdC.
Is it possible to have ONE .rep file with a script that will handle each product?
***For example, I want one file to do this***
-Refresh report (Select * From Table Where ProdId="ProdA"
-Save as PDF (ProdA.pdf)
-Refresh report (Select * From Table Where ProdId="ProdB"
-Save as PDF (ProdB.pdf)
-Refresh report (Select * From Table Where ProdId="ProdC"
-Save as PDF (ProdB.pdf)
Is this possible to do using VB scripting? How do I change the SQL each time using the script?
Any help is greatly appreciated, thank you.
Is it possible to have ONE .rep file with a script that will handle each product?
***For example, I want one file to do this***
-Refresh report (Select * From Table Where ProdId="ProdA"
-Save as PDF (ProdA.pdf)
-Refresh report (Select * From Table Where ProdId="ProdB"
-Save as PDF (ProdB.pdf)
-Refresh report (Select * From Table Where ProdId="ProdC"
-Save as PDF (ProdB.pdf)
Is this possible to do using VB scripting? How do I change the SQL each time using the script?
Any help is greatly appreciated, thank you.