CAHFS
asked on
Infoview Scheduling ONLY when there is data there
Hi!
i have a Crystal IX report that needs to be run daily via Infoview scheduler for people who have help tickets open. However, not everyone has an open ticket every day. How do i set Infoview to only e-mail out the report to those "owners" who have open tickets?
i have a Crystal IX report that needs to be run daily via Infoview scheduler for people who have help tickets open. However, not everyone has an open ticket every day. How do i set Infoview to only e-mail out the report to those "owners" who have open tickets?
ASKER
i can get the report to work fine. Like you said: grouped by owner new page for each one, when the owner doesn't have an open ticket, nothing shows.
What i'm having trouble getting my brain around is the actual scheduling of the report in Infoview. My thought is that I would have to make an "owner" parameter, then upload the report to Infoview and then make a separate schedule for each person? But then, the report would run Monday through Friday and go out to all of those people. Considering that each employee can have an open ticket, this would be a monumental task and seems really counterproductive. What if only a small percentage of people actually have an open ticket that day? Everyone else will get a blank report. I found something online that says to set "new page after" at the report header then check the suppress printing if no records exist on the rest. Apparently this would crash the report as Infoview is trying to send it out. I spend all kinds of time trying to get reports not to crash, seems a little sad to crash them on purpose and that would still mean creating a schedule for each active employee. I was hoping for a better suggestion. It would be nice if we could somehow link our outlook address book to Infoview. Sorry rambling now.
What i'm having trouble getting my brain around is the actual scheduling of the report in Infoview. My thought is that I would have to make an "owner" parameter, then upload the report to Infoview and then make a separate schedule for each person? But then, the report would run Monday through Friday and go out to all of those people. Considering that each employee can have an open ticket, this would be a monumental task and seems really counterproductive. What if only a small percentage of people actually have an open ticket that day? Everyone else will get a blank report. I found something online that says to set "new page after" at the report header then check the suppress printing if no records exist on the rest. Apparently this would crash the report as Infoview is trying to send it out. I spend all kinds of time trying to get reports not to crash, seems a little sad to crash them on purpose and that would still mean creating a schedule for each active employee. I was hoping for a better suggestion. It would be nice if we could somehow link our outlook address book to Infoview. Sorry rambling now.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I thought as much... Thank you for the help! Visual cut certainly "looks" like it would do what I need.
Can you please provide a little more information?
~Kurt