Solved

Infoview Scheduling ONLY when there is data there

Posted on 2010-11-18
4
443 Views
Last Modified: 2012-05-10
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?
0
Comment
Question by:CAHFS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 34173475
Scheduling only when there's data there implies that the report will occasionally return 0 records, but your question makes it seem like it's just some owners within the report (grouped by owner, for example ) that will have 0 tickets.  If that's the case, why not eliminate owners with 0 records from the report?

Can you please provide a little more information?

~Kurt
0
 

Author Comment

by:CAHFS
ID: 34174628
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.
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 34176405
I am not sure Infoview can do what you want.

It sounds like you have persons A, B, C, D.

If A and B have open tickets then you want them to receive the report but no report to C and D.

You might want to look at a  third-party tool like Visual Cut

http://www.kenhamady.com/bookmarks.html

mlmcc
0
 

Author Closing Comment

by:CAHFS
ID: 34189117
I thought as much...  Thank you for the help! Visual cut certainly "looks" like it would do what I need.  
0

Featured Post

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question