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 Chriss Miller 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
  • Content: Threads
  • Order by date
  1. 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???
  2. 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...
  3. 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...
  4. 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...
  5. 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???
  6. 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...
  7. 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.
  8. 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...
  9. 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...
  10. lisa626

    Enterprise Folder Lists BOE XI R2

    Is there an easy way to print lists of folders/objects out of enterprise????
  11. 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...
  12. 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 |.
  13. lisa626

    DTS

    We have a DTS process that runs, I have it scheduled to run every morning, I am trying to set up the notification so that it will send me an email upon either/and/or successful completion or errors. Help please.
  14. lisa626

    Unmanaged Disk - BOE XI/Crystal XI

    I have several reports I need to schedule with a destination of unmanaged disk, The destination is a Network Share with a Main Folder and several sub folders, all folders have specific access abilities. I am having trouble setting this up in the destinationjobserver, reportjobserver...
  15. lisa626

    Emailing from BOEXIR2

    I have several reports scheduled that run and send an email. Does BOEXIR2 retain that email anywhere???
  16. lisa626

    Sheet Protection

    I have a spreadsheet I want to password protect but I also want to allow changes to be made to it without having to resave/rename it each time.
  17. lisa626

    Grouping Sums

    OK, New But VERY similar. I know need to show how many changes occurred on Non Refundable tickets and Refundable tickets, following is how data is seen. Group 1 ABC Group 2 BAAAME NON REFUNDABLE Detail 132456 640.20 NR 1 0 BAAADG NON REFUNDABLE...
  18. lisa626

    Summing the MAXIMUM function

    Is there a way in Crystal XI to sum the MAXIMUM function, I have a report with several groups and I need to use maximum to get the correct number at group 2 then need to sum that to get a total in group 1. EX. Group 1 3 REDGO@ + HEUDYE + EKRKEK Group 2 REDGO@...
  19. lisa626

    Count Formula

    I am using Crystal XI and have the following... Group 1 BAAAME NON REFUNDABLE Detail 132456 640.20 1 0 BAAADG NON REFUNDABLE 123654 246.04 1 0 BAABFP REFUNDABLE 458975 326.60 0 1...
  20. lisa626

    Future Month

    I have a report that I need to schedule to run based on what is GOING to happen per specific dates in report. How can I tell it to pull data for next full week or next full month???

Part and Inventory Search

Back
Top