Thank you for your response!
Yes the user/pass combinations are identical.
I did try what you suggest, and for most it returns the expected value, however, for resources with no hours data it pulls a blank. This is what I figured as well... it is trying to split a blank value and gives an...
Hi all,
I have a solution that is working in Crystal, but when I upload it to BOE schedule it I get an Array error, that the subcript has to be between 1 and the size of the array.
What I have is a report pulling a name from one source and comparing it to the name of another source to get...
Thanks for your responses! For the future reference of others, this is a solution I found that returns what I was looking for. I will try your solution as well lbass, as the performance on my solution is fairly poor.
I put this query as the data source(oracle db):
Select x.*
from [table] X...
No, I want all hours for all resources who have any support hours. That inclues admin and support hours.
So something like
If resouces has any support hours
then
select proj,admin, and support hours
else
ignore
Does that make more sense?
This is more about the data selection than the graph
thanks for replying!
maybe i didn't explain this well.
we have these fields
resc_nm (resource name)
to_dt_hrs (hours to date)
proj_nm (project name)
so in the database we could have
ted 10 support
ted 15 admin
ted 5 project
rita 4 admin
rita 10 project
bob 30 support...
All,
I am having a problem creating the follow selection criteria... any help greatly appreciated. CR XI R2, oracle database, data is time tracking.
What I'm looking for is a graph that is filtered down only to resources that have >50 hours to date in support.
It's a stacked percentage graph...
To elaborate, first off im using Version XI
I have created a group "Selected" above district and made a formula to separate them...
If {?District}={HPD.District} Then "RegionSelected"
else "OtherRegions"
I then tried to insert a chart that shows teh value instances per month on change of...
I am trying to create a report that will show average tickets per user by region against the over-all average tickets per user.
What I have is this
Group #1 Region
Group #2 Date
Group #3 Product
Group #4 User
In Group #2 I have a line chart that shows average resolution by...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.