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 SkipVought 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: aka45
  • Order by date
  1. aka45

    CMS not starting

    Thanks for your reply. By objects I meant the text, custom functions etc.. Please let me know if you any idea. Thanks, Ak
  2. aka45

    CMS not starting

    I have to one development installation of CR Enterprise 10 and another test one. While doing some maintenance some dll file was deleted and since then the CMS in development is not starting. we have some objects left in the repository. how could I retrieve that from that CMS? Please suggest me a...
  3. aka45

    cross-tab calculation help

    The results would like this Q1-2005/Q1-2004 Q2-2005/Q2-2004 Q3-2005/Q3-2004 Q4-2005/Q4-2004 Q1-2006/Q1-2005 Q2-2006/Q2-2005 Q3-2006/Q3-2005 Q4-2006/Q4-2005 There is a date field from which I am getting the quarter. Year and Month are the two parameters that I have based on which I have the...
  4. aka45

    cross-tab calculation help

    My problems is year parameter. It could be 2005 to 2006 or 2004 to 2006. How can I handle this situation? Please shed some light. Thanks LB -AK
  5. aka45

    cross-tab calculation help

    I am using Crystal Reports Version 10. is possible in this version. Thank you, AK
  6. aka45

    cross-tab calculation help

    I have two cross-tab as following for Quarter to Date and Month to date. The columns grow according to parameter input.This one is for Q2 of 2005 to Q4 of 2006. Q205 Q305 Q405 Q106 Q206 Q306 Q406 North 226,624 185,821 271,763 489,886 404,895 293,116 282,458 Total 226,624 185,821 271,763...
  7. aka45

    Cross-tab percent - 1st row/Sum of the following rows

    Thank you for your reply LB. It worked. Just added a condition statement to check on Zero's before the % calculation. AK
  8. aka45

    Cross-tab percent - 1st row/Sum of the following rows

    Hi lbass, I have GL Account Numbers, Netactivity, Accounting period in the database. Account numbers are grouped togather to form the rows of the crosstab below like Standar labor, Actual Direct labor etc. Accounting Period like Jan, feb etc represent the Columns of the cross tab. sum of...
  9. aka45

    Cross-tab percent - 1st row/Sum of the following rows

    How can I insert a percent in a cross-tab with sum of standard labor by period divided by sum of other fields by the same period as below? Do I need to do a Manual Cross tab? Jan Feb Standard Labor 105,044 105,044 Actual Direct...
  10. aka45

    record lock

    I am not inserting the records.Reports are running against a production database and when the table is very large its locking the table.
  11. aka45

    record lock

    how to avoid record locking in SQL server while querying through crystal reports? is there a way to insert with NOLOCK when we send a query? Thanks in advance.

Part and Inventory Search

Back
Top