When I checked the SQL generated by the report against the actual database, all the data is correct. When I only use the first 2 parameters, the item that I would use as the 3rd parameter pulls back all the data I expect. However, when I try to add the 3rd paratameter, the selections that I...
Hello -
I am working in CR XI, and the data source is SQL. I am using a view as the data source behind my cascading parameter. The parameter has 3 levels.
I am allowing a multple selection on each level, when I select the parameters in the 1st and 2nd level parameters, the 3rd level of the...
With additional testing, I figured out that if I select multiple values from each level, the report will only print 335 records.
I am completely confused by this one.
Thanks
I am using CR XI, and a MS SQL database.
Is it possible to trigger a parameter from another parameter-
For example, I want only 1 parameter to prompt when I first run the report. Based on that choice, I want another parameter to appear.
For example - when I first run the report, I am...
Hi!
I am using CR XI, against a MS SQL database and am having trouble with my cascading parameter prompts.
I have a parameter with 5 levels, and after I enter the 3rd parameter, data starts 'disappearing.'
I am using one view as the data source, and the data pulled in by this view is correct...
I am trying to export hyperlinks to a pdf file. I am using CR11, and when I export to .pdf, the hyperlinks do not export. Per KB article c2014405 on Business Object's website, this is by design for CR10. I could not find anything on CR11, so am I to assume this is the same? Has anyone been...
Sorry! Thank you for your help!
HOV_StaffInformationHomeDeptAndHomeLocation.DefaultStaff} = False
and {HOV_StaffInformationHomeDeptAndHomeLocation.InActive} = False
and {HOV_StaffInformationHomeDeptAndHomeLocation.StaffHomeCostCenter} <> ''
AND...
Here is the SQL:
What does the N' stand for???
THANKS!
SELECT HomeDepartment, HomeUnit, Type, MiddleName, LastName, FirstName, StaffHomeCostCenter, InActive, DefaultStaff, ClassDate, ClockHours, HireDate, StartDate
FROM HOV_StaffInformationHomeDeptAndHomeLocation
LEFT OUTER JOIN...
I have a report in CR XI, which generates approximately 31,000 records. If I do not use parameters, the report runs within several seconds.
If I use parameters to narrow down the number of records I return, the report slows down, and takes approximately 15 minutes to generate.
Any idea why...
I have very short cross tabs in the main body of the report, and a very long one at the end of the report. It seems to be such a waste to print landscape when I only need to for the final totals.
But, if I did not hire any employees on 08/02, I still need to count the number of employees working on that day, so if I group by my hire date, 08/02 will not print on the report, and I need every date in my range to print, wether or not I hired anyone on that date.
Does that make sense?
THANKS!
I need to calculate daily totals of the number of employees for a beginning date to the current date.
So, if my start date is 08/01/05, and current date is 08/31/05, then I would need the counts for employees for 08/01, 08/02, .... .... 08/31. How to I get each date to print? The fields I am...
I apologize for not being as clear- posting with you is helping me understand this a little better... thanks!
This is what I want to do, overall-
Group 1- table.Dept
Group 2- table.Unit
Group 3- @Employee (this is where @TotalHours will print.)
Details (This is always supressed.)
if @Hours...
When I try to add this
@Hours > @TotalHours
to my group selection formala, I get an error message highlighting @TotalHours stating, "The formula cannot be used becuase it must be evaluated later.
I am using CR 10, and want to select records based on a sum.
For example, I want to select all groups who have a total number of hours less than my parameter.
Parameter (number)= @Hours
Group 1 = @EmployeeName
@TotalHours = Sum (ClockHours, @EmployeeName)
I want to display records when @Hours...
That works; however, I need to format (bold) the max value within the report. So, the formula will bold every value that is the max value at the time the record is read. I think the only way I can get this to work is through a subreport, and pass the value to the main report....
Thanks!
I am calculating average costs, and need to determine the maximum "average cost."
I have average costs calcuating per group, and want to determine which one is the greatest. Everytime I try to find the average on a calcualtion, I get an error message, "Field cannot be summarized." Is this even...
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.