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. musini

    Sum of a filed to be on each page footer with out grouping

    Thanks. That was exactly what I was looking for. Regards, M
  2. musini

    Sum of a filed to be on each page footer with out grouping

    Hi, I have to display the sum of a column on the fotter of each page and has to be reset for each page. There is no grouping in the report, the sum has to be caliculated for each record in the page be displayed at the end of the page. In the next page there should be a new sum for those records...
  3. musini

    Searching for a column in the script of all Crystal reports

    Sorry. It took so long to respond. We are searching for a column which is getting changed in the database and we have to see what is the impact of that on the reports. We would like to see even after that change all the reports are doing what they have to do. I am wondering if there is an easy...
  4. musini

    Searching for a column in the script of all Crystal reports

    Hi All, We have around 100 Crystal Reports which are in use. If I have to search for a table column and find out which reports are using that particular column what is the best way to do it insted of opening each report and looking for that column. Please advise. Thanks M
  5. musini

    To display a column header in a format when exported to excel

    I tried everything but nothing is working. If I do the enter after each word and export the reort with the above export options, I am getting a special charecter in between the words and all the word are in the same line, but not in the new line. Thanks, M
  6. musini

    To display a column header in a format when exported to excel

    Hi, I did that before, but it did not work. I am using the following export options. column width based on objects in details export object formatting maintain relative object position export pageheader and pagefooter Please suggest. Thanks, kranthi
  7. musini

    To display a column header in a format when exported to excel

    Is tehre a option where I could enable the wrap. Thanks, M
  8. musini

    To display a column header in a format when exported to excel

    Hi, I have a column with name as below. This is how it looks when it is exported to an excel file. (Customer Identification Number) 1 2 3 4 I would like it to be displayed as follows. Customer Identification Number 1...
  9. musini

    Displaying data in groups

    Thanks dgillz, I know that the grouping in crystl doesn't work that way but I was wondering if there is way to achieve this in crystal. Thanks, M
  10. musini

    Displaying data in groups

    I am soory, I am not supressing colb but checked the option hide drilldown ok. "If user clicks on Oct 2007, he should be able to see the accounts 100002,100001,100003." This meance all the data from the previous groups including the group the user clicked. I also included 100002 in there...
  11. musini

    Displaying data in groups

    Hi All, I have the data as below. col a col b sep 2007 100002 Oct 2007 100001 Oct 2007 100003 Aug 2008 100004 Aug 2008 100005 In the report I have grouped on cola and I am displaying the colb according to the group on cola. I have kept colb in details and...
  12. musini

    Sorting by sum of Arrears

    Thanks for the response LB. I have found the answe, I have used the repeat group header on each page option. Thanks, M
  13. musini

    Sorting by sum of Arrears

    Thanks LB. It worked perfect, first I was using running totals and so I could not do it but with summary column I could useit. I have one more question. Is there any way I could display tje group header on each page of the report. Thanks, M
  14. musini

    Sorting by sum of Arrears

    Hi All, In the report I have two groups group1 and group2 and I have the sum the arrears in the group2 footer. The details and group1 header are supressed, so the froup2 footer is shown as details. Now the report is sorted on the grouped fields, is there any way that I could sort it according...
  15. musini

    sorting

    Thanks, It worked perfect. Regards, M
  16. musini

    sorting

    from the database what I am getting is string field and I could not use month or year on that field.
  17. musini

    sorting

    Hi All, I have a field in the report where the data is as below. JAN 2007 FEB 2007.. .. May 2008 I am grouping on this field and after grouping I am getting it as below. APR 2007 APR 2008 AUG 2007 AUG 2008 DEC 2007.... It is sorting by alphabetical order but what I need is ascednig order...
  18. musini

    Displaying only parts of a column

    Hi All, I have a string column and the lenght of the colun is around 100 charecters and not fixed to each record. Below is an example of how the column looks like. 'abc'1234'/abc''def'lombard'/def''ghi'dr'/ghi' 'abc'235'/abc''def'illinio'/def''ghi'st'/ghi' This is just an example and all the...
  19. musini

    The string field shows only up to 10 charecters

    I looked in Toad and the problem is solved now. It was not with the crystal but some thinig else out of it. Thanks for the responses. M
  20. musini

    The string field shows only up to 10 charecters

    Even after widening it it shows only upto 10 for all the records by default, I don't understand is there any setting do I have to change. Thanks, M

Part and Inventory Search

Back
Top