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!

  • Congratulations dencom 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 lisa626

  1. lisa626

    TOP N Parameters

    ALSO, my fault, forgot to add that I have 2 subreports on this report that also need to show top n, would I do the same thing for the sub reports as I did for the main. SORRY, I thought I was adding to the original.
  2. lisa626

    TOP N Parameters

    It won't let me leave it blank, it wants a number greater than 1.
  3. lisa626

    TOP N Parameters

    Ok, have the parameter created... Under report->group sort->topN->where N = 10000, where do I put the formula if {?topN} <> 0 then {?topN} else 10000 does that go at the group I want to sort on or where????
  4. lisa626

    TOP N Parameters

    Crystal XI - Business Objects XI R 2 I have a report that has multiple parameters, I want to add a parameter so that a person can tell it to pull the top # or all of a certain group, what would be the easiest way to do this???
  5. lisa626

    Change Tracking Excel 2003

    I have and excel document that has 2 worksheets, I want to be able to Protect the document so it's read only AND be able to track any changes to the history sheet which users can always see. Is this possible, I'm wanting to use this so that if changes are made by allowed users, all users can...
  6. lisa626

    Passing Parameters from Scheduled Rpt to Stored Proc

    Crystal XI I have the following stored procedure which I am using as a datasource, this works great for someone if they want to manually run this. I want to be able to schedule this thru the BOE system and have it automatically emailed out to certain recipients, I want the report to pull based...
  7. lisa626

    Difference

    OOPS, SORRY 25-22 = 3/25 = 12%
  8. lisa626

    Difference

    Crystal XI Have a report as follows: Grp 1, DatabaseName Grp 2, Table Name ACount ACost Details are suppressed, what I need to be able to do is the following: CASTLE TICKET 25 3200.00 CAR 16 3185.00 HOTEL 13 3030.00...
  9. lisa626

    Folder List - Windows XP

    I have done a search on a drive and it returns several hundred files with the specified details File Name Director Size Mod Date Acc Date I need to be able to print the results of this, any ideas???
  10. lisa626

    Linking Tables w/same fields

    I'm sorry, need a bit further clarification, when I join the two tables, on what field do I link and what type of link do I use, THEN, where does the function above go, in a formula??
  11. lisa626

    Linking Tables w/same fields

    I have to link together two tables, one is a tickets table with a ticket number, date, total cost etc..., the other is an airseg table with a ticket number, depart date, depart time etc... I need to link the two together via the ticket number, however, there may be multiple of the same ticket...
  12. lisa626

    Cross Tab Suppression XI

    I have a crosstab as follows in the report footer: mickey mouse 0 0 0 1 2 3 6 donald duck 1 2 1 0 0 0 4 goofy 0 0 0 0 2 0 2 I want to be able to suppress anything less than 3.
  13. lisa626

    Stored Procedure Questions

    I am VERY new to this. I have SQL 2000, there is a stored procedure that was previously created that I need to be able to run, I made some minor changes to it such as I want it to SPECIFY a date to look out but am not sure I have done that right either. Below is the code, like I said I really...
  14. lisa626

    Exporting ??

    Currently using Crystal XI, I have a data file that I need to export with some specific settings, not sure if Crystal can do this. I need to export in a pipe delimited format, also need to specify field lengths, specific formatting. Example Field 3 represents a rate ($), $13.00 needs to...
  15. lisa626

    Enterprise Folder Lists BOE XI R2

    Is there an easy way to print lists of folders/objects out of enterprise????

Part and Inventory Search

Back
Top