What are the ways we can use built in BO funtionality to determine if rows are retrieved or not in Webi reports?
I have a business need to schdule Webi reports to .pdf where they are distributed by a sperate workflow application. One of the requirements is that these reports should not be sent out if they do not include data (makes sense!). The current way we are managing this is using multiple reports with vba which exports only when rows are retrieved. Ideally I would like to utilize some other built in way and slim down to one report possibly using profiles.
I’ve not seen the previous thread myself… but also have the same request.
We have reports sent out weekly to vendors to alert them when there are changes to merchandise, however many vendors have no changes during a week and we don’t want to send them a report if there was no data returned. (It seems a bit unprofessional to send that blank looking PDF file).
If anyone has found a solution, or know if it’s even possible I’d love to hear about it.
I’ve got a requirement to do this now.
Crystal Reports Server XI on a Sybase IQ datasource.
Its an Exception type report that needs to run hourly and notify user by email of records above a certain threshold.
I looked into trying to get the Crystal Report to flag an error somehow to the scheduler to fail the report, but no joy.
Next stage is a Batch or Perl script that interrogates the datasource and will trigger an event for the report to run…unless someone got a better idea that does not involve spending more pennies???