Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by khoke

  1. khoke

    Cascading prompt not pulling all parameters

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

    Cascading prompt not pulling all parameters

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

    Parameters missing values

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

    Parameter triggers another parameter.

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

    Parameters missing values

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

    Export hyperlinks to PDF

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

    Parameters slow down report

    Sorry! Thank you for your help! HOV_StaffInformationHomeDeptAndHomeLocation.DefaultStaff} = False and {HOV_StaffInformationHomeDeptAndHomeLocation.InActive} = False and {HOV_StaffInformationHomeDeptAndHomeLocation.StaffHomeCostCenter} <> '' AND...
  8. khoke

    Parameters slow down report

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

    Parameters slow down report

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

    Parameters slow down report

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

    Change Page Layout for one section

    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!
  12. khoke

    Change Page Layout for one section

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

    Change Page Layout for one section

    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!
  14. khoke

    Calculating daily 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!
  15. khoke

    Calculating daily totals

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

Part and Inventory Search

Back
Top