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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: lisa626
  • Order by date
  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????
  16. lisa626

    Exception Reporting Crystal XI

    Sorry, not trying to be dense here but... 1. So join the tables 2. Do I put TABLE1.Field 1 Table2.Field2 or should I set up individual formulas for each field?? If you know where I could find any good examples of this that would be a huge help.
  17. lisa626

    Exception Reporting Crystal XI

    Sorry, thought I gave version in Subject Line, it's Crystal XI. So, for the 1st report I need to join to tables with a left outer on all fields or just one??? What do you mean by "Note that Left Outer fails when you also do a selection for the second table" Thanks.
  18. lisa626

    Exception Reporting Crystal XI

    I have the following situation: Table A Table B Table B includes ALL fields in Table A PLUS there are approx 20 custom fields added based on a DTS process that runs. What I am wanting to do is create some validation/exception reports to show... 1. SHOW Ticket # where...
  19. lisa626

    Error Message

    I am trying to import a txt file and append into a table and I keep getting the following error, any help would be appreciated. Access 2003 You entered an expression that has an invalid reference to the property |.
  20. lisa626

    Unmanaged Disk - BOE XI/Crystal XI

    Do I have to change the Report Servers also or just all the Job Servers???

Part and Inventory Search

Back
Top