Search results for query: *

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...

Yes, the dynamic parameters are showing within the where clause. Thanks!

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 the report set up to print landscape, it just seems like a waste, since most of the cross tabs repotrs are very narrow. Thanks!

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.

I want to print my report in Portrait layout until the Report footer, I want to print landscape. Is this possible? I am using CR 10, with SQL. Thanks!

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...