Search results for query: *

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

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

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

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

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

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

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

Hi All, In crystalXI, the string field si showing only up to 10 charecters and is truncating the rest of the column. Pleaase suggest with this. Thanks, M

Hi All, Can any one explain me the difference between dynamic and static parameters in crystal. I always create parameter in crystal at command and they all, I believe are static. Any information on this would be great.

Hi All, My Data is some thing ike this. empno hrsowrked hrsonbreak 1 4 1 1 4 2 1 4 3 I want the output as 1 4 6 I do not want to sum the hrsworked but sum the hrsonbreak for a...

Hi All, Is there a way to have a number field in the report which will be increased by 1 evertime the report is saved. The problem we are facing is once the report is put to run on the server(infoview) and there is some problem with the report and we have to enhance it, we are unable to know...

Hi, I have a report with two parameters startdate and enddate. These parameters I have attached to the query in the command. Now it is fine that when ever there is a value given for the parameters, the report run fine but what I want is if there is no parameter specified, the report should run...

Hi I am Working on a cross tab report in crystal XI. My data is like this. col1 col2 count A B 4 B A 3 A c 7 C B 6 In the cross tab Col1 is in the ROWS of cross tab, col2 is in the COLUMNS of cross tab. and the count should be dispaled...

Hi, I am using crystal XI. I have a report with page heading and one group in the report. I have gorup heading and column names in the group header, then I have details and in the group fotter section i have the runnig total field. I am trying to export this report to excel but could not...

Hi All, I have a group in the repot, based on that group I am displaying the details now i have to make the sum on a particular column which is in the details and reset the sum on change of group column value. AAll this is fine but the sum i am making should be displayed on each row of the...

Hi All, I am stuck with a small problem. I am a grouping on a column which has null values in it. After I gorup on it the null value is first seen in the group header and then follows the other values in the column, but what I want is the column values first and at the last I need the null...

Hi, I have 4 fields int he report. accno, category,agency, date. I have groups on both category and agency. Now In the details I have accno and date. Is there a way that I could display only those records where date is maximum of all the dates in that particular group. Thanks, M

Hi, Whne ever I start a new report I mostly use command to put my query in. Once I put the query it takes lot of time to get into the report and start working on. Some times it do not respond at all for long time and then I have to end the task and restart again. Why this happens and is there...

Hi All, I am getting the data like this in to the report. accno statuscode arrears income agencycode 1 abc 30 y p 1 abc 30 a p 1 abc 30 b p 2 def...