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 gkittelson 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
  • Order by date
  1. OT2

    compare pct columns and suppress where necessary

    Hi DJ, I cant summarize @Diff formula, i guess its cause theres a calculation involved. Thanks for your help.
  2. 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...
  3. OT2

    Export Cross-Tab to Excel

    Hi Madwac, thank you for your response. How would I insert the formulas into the cross-tab? Here is what is going on: On screen I see this: Account Code Ticker1 Ticker2 Ticker3 XXXXXX XXXX shares shares shares XXXXXX XXXX shares shares shares...
  4. 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...
  5. OT2

    Design view is blank

    Hi Turkbear, new reports work fine. I tried something else, opened up a report on a working PC and saved using a new name. Opened up the new report on my pc and it works. Strange, not sure whats going on.
  6. OT2

    Design view is blank

    Yes we both have access to the datasources.
  7. 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...
  8. 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...
  9. OT2

    Convert multiple datasource onto one view

    Hi, once I make all the data source changes, the report runs forever and freezes up. I think my best bet is to start from scratch with my new view.
  10. OT2

    Convert multiple datasource onto one view

    Hi RobbieB, I tried that but the report breaks on me.
  11. 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...
  12. OT2

    Cumulative Returns in CR11

    Using and ODBC into CR11 and trying to figure out a way to do a cumulative sum of a return field for a given perdio, ie: day return% 1 .0.00% 2 -0.74% 3 -0.03% 4 -0.22% -------------- CumRtn -0.99% the Cumulative return formula in excel would be...
  13. OT2

    Cumulative Returns in CR11

    Hello, wondering if CR11 had a function to help me sum cumulative returns for a given period. Thanks.
  14. 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.
  15. OT2

    Can I underlay a group total?

    Robbie, I got this to work, please disregard my previous post. Thank you! Looks awsome.
  16. OT2

    Can I underlay a group total?

    Hi Robbie, formulas work, but the total appears at the top of the account group, to the right of Amount1 in my example above, any way I can get it to jump to the bottom?
  17. 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...
  18. 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...
  19. OT2

    Subtract 5 days from maturity date but exclude weekends

    Never mind, found solution at http://www.kenhamady.com/form17.html

Part and Inventory Search

Back
Top