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 bkrike 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: OT2
  • Content: Threads
  • Order by date
  1. OT2

    compare pct columns and suppress where necessary

    Hello, im using CR11 and an ODBC connection into our OMS to put togther the following report: ORDER1 Account TgtQty @TgtQty% ExecQty @ExecQty% @Diff acctA 40 40% 40 40% False acctB 40 40% 40...
  2. OT2

    Export Cross-Tab to Excel

    Hello, I am using Crystal 11 to create a Cross-Tab report. The cross-tab has two rows and one column. I have created custom row headers and placed them in the page header, also underlayed all sections so that the headers match up with the cross-tab rows. On screen everything looks good but when...
  3. OT2

    Design view is blank

    Hello, at work we are using CR11, a co-worker and I are experiencing the same issue; when we open up reports the desing view is blank, all the data fields are missing. We are unable to refresh and view data. This only happens on our machines, the same report opens up and runs normally on other...
  4. OT2

    Crystal11 sum formula different groups

    Using Crystal 11, have a report that looks like this: group1:FundName group2:ClassName Details: date1 - shares outstanding - total assets date2 - shares outstanding - total assets date3 - shares outstanding - total assets I need to create a formula that will sum shares...
  5. OT2

    Convert multiple datasource onto one view

    I cam using CR11 and an ODBC connection and would like to change the datasource on an old report, that was built by linking 9 tables, onto a single view. I have tried the "Set Datasource Location" tool but it does not produce the results I would like and the report breaks on me once the...
  6. OT2

    Cumulative Returns in CR11

    Hello, wondering if CR11 had a function to help me sum cumulative returns for a given period. Thanks.
  7. OT2

    Exporting to Excel using CR11

    Any way to automatically export freezed panes to excel? Using CR11, client would like header information to freeze at top of screen when scrolling through data in Excel. Thank you for you help.
  8. OT2

    Can I underlay a group total?

    Hi, I am using CR11 to create a report, client has asked for three groups: vendor, docnumber and account. All my data is at the account level, and I have a sum of amounts by account that I would like to underlay so that it appears in line with the last item in the account group, ie: Vendor...
  9. OT2

    fit cross tab to one page using CR11

    Hello, I have a cross tab in CR11 that I would like print automatically to one page. Right now it will expand to two pages depending on the field headings. I really dont care for the field headings, only care about the data in the columns. Any way to have the report print on one page without any...
  10. OT2

    Subtract 5 days from maturity date but exclude weekends

    Hello, Using CR11 to put together a report that shows fixing dates for notes, for example, a gold note that expires on 07/15/05 would have a fixing date of 07/08/05, ie: 5 business days prior to the maturity. Simple subtraction in CR11 would provide me with a fixing date of 07/10/05, which...
  11. OT2

    week of the year

    Hello, I am using CR9 and was wondering if there was a function I can use to convert a WeekofYear value into a date range, for example if my WeekofYear value is 23 I would like to see: Week of 06/05/2005 - 06/11/2005 Thank you for you help
  12. OT2

    record selection formula, please help

    Hello, I am using CR9 and I am having problems selecting multiple values with the following selection formula: If {?Portfolio} = "a" then...
  13. OT2

    Breakdown Column

    Wondering if you can help with the following: I am using CR9 and have been asked to put together a stale prices report. I have accessed the price table in our port admin database called mhfspric, the fields I will need to use from this table are mhfspric.secid mhfspric.pricedate mhfspric.price...
  14. OT2

    PARAMETER GROUPS

    Hello, I am using CR9 to modify a report using a single parameter. Currently our users open the report and select every single portfolio they would like to see on their report. I would like to group this paramater so that our users can select a goup of portfolios. For example instead of having...
  15. OT2

    "Not Active" items dropping from report

    Hello, I am using CR9 and have a transaction by sercurity report that has three parameters: security ID, Starting Trade Date, Ending Trade Date. The report works perfectly except for one thing, it drops securities that I entered in my parameter that have not been traded in the specified date...
  16. OT2

    summary formula

    Hello, I am using Crytal Reports 9 to create a report. The report is currently grouped by portfolio, equity group and country. I have a column called PCT of Assest wich I would like to summarize at the bottom of the report for every country. The formula for pct of assets is: {@Mkt_Acc} /...
  17. OT2

    Parameter List

    Hello, hopefully you will be able to help me with the following. I have report with three parameters: Start Date, End Date and Identifier. The identifier parameter allows multiple values so what I would like to do is include a list at the end of my report that shows all the indentifier I used...
  18. OT2

    UPPERCASE in Crystal 9.0

    Hello, I am using Crystal 9.0 and wanted to know if there is a way for me to capitalize fields without having to write a formul, ie: uppercase(table.field). Is there a formatting shortcut for this? Thank you for your help. OT2
  19. OT2

    Remove Website Viewer

    Hello can someone please take a look at my HijackThis log and tell me exactly what items I need to select and fix? Thank you. Logfile of HijackThis v1.99.0 Scan saved at 9:28:10 AM, on 1/25/2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)...
  20. OT2

    Running Report for Current Day

    Hello, I am new Crystal user so please pardon if this question seems trivial. I have a batch job that runs a crystal report and exports it to a pdf file. The report has a date parameter that I need to set to current day everytime I run the job. Is there a way I can set the parameter in the...

Part and Inventory Search

Back
Top