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 Mike Lewis 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: *

  1. CRoompa

    BOE 4.0 how you schedule a report to run?

    I guess that is the problem... in Crystal Reports 2011 I enter the database information, and it works fine. On the server, verified ODBC driver for connecting to the Oracle database, enter the same login information, but it won't run.
  2. CRoompa

    BOE 4.0 how you schedule a report to run?

    Trying to upgrade to new server version. Was very familiar with BOE XI server, uploading reports designed in CR2011, scheduling them to run and mail the pdf to users e-mail. I am lost on this new server. I can upload reports to it. But try to schedule a report to run, fails: Object Package...
  3. CRoompa

    Saving Report Database Password on BOE Server

    Once you upload the report to the server, click on the Process tab, and then the click on database, you can enter the password there, and then at the bottom select the radial button use same database logon as when report is run, and then update.
  4. CRoompa

    Business Objects - digital signature?

    Our company uses BOE/crystal reports to send reports out to various distribution lists. However, they are wanting us to start only sending out e-mail with attachments if they have a digital signature. Anybody configured Business Objects XI to use a digital signature before? or suggestions...
  5. CRoompa

    grouping by instr text?

    I was trying to use mid and instr and over complicating it. the if statements work. Thanks.
  6. CRoompa

    grouping by instr text?

    Using Crystal 11, original data is just a text file, but I imported it into a spreadsheet; then I am trying to look at a column and group similar webaddresses, count the number of hits. Data looks like this mess: 56 /cmdoc.html 10 /cmdocs/cr0764/cr0764.html 10...
  7. CRoompa

    Suppress Duplicate Contacts

    I think I see what you are suggesting.. loading the contacts into an array and then suppress the contacts found in the array. However, not sure I am doing it right, since this removes all of them, since they would all appear in the array. How to suppress on duplicates in the array?
  8. CRoompa

    Suppress Duplicate Contacts

    CR 11, Oracle 10g I have a report that pulls data for every 5th support ticket from the database. The report is used for followup customer survey. There can be many contacts for the same ticket, and also more than one phone number for each contact. I have this working by using a subreport...
  9. CRoompa

    IP Address Grouping

    Actually, I just figured out what I wanted using this: Left({Table.IPAddress}, InStrRev({Table.IPAddress},".")) +"X" Thanks raja2008, you got me started down the right path.
  10. CRoompa

    IP Address Grouping

    No, I am just saying there would be a variety in the number of digits between the periods, depending on the IP Address. If the IP address looks like these: 101.110.5.123, 101.110.5.21, 101.110.5.35 should be grouped as 101.110.5 If the IP address looks like these: 10.120.110.123 10.120.110.1...
  11. CRoompa

    IP Address Grouping

    Sometimes the IP address may be: 101.110.5.123 another time it may be 10.120.110.4 Either way, I want to basically group everything together if the first 3 numbers are the same, and ignore the number after the three decimal...
  12. CRoompa

    IP Address Grouping

    CRXI with Oracle Database I would like to create a report grouping on the IP address. If have this data: 10.10.10.1, 10.10.10.2, 10.10.10.3, how can I just have it group them all as 10.10.10? This will need to work whether there is 1-3 numbers between the periods. Appreciate any help.
  13. CRoompa

    Parse a worklog entry?

    I was so close... but didn't have my syntax quite right. Your formula worked great! Thanks.
  14. CRoompa

    Parse a worklog entry?

    I am using CRXI and trying to figure out how skip over the first part of a worklog entry and extract out the next 40-50 characters at the beginning of each work log entry. The worklog is formatted like this: Wednesday, 8/20/2008 17:17:52 USERNAME (EMPLOYEE##) START OF THE ACTUAL WORK LOG...

Part and Inventory Search

Back
Top