Search results for query: *

Hi All, I have parent id which is linked to three child records. When i try to display the child id , in the group by parent section , i get only one child id displayed. I moved the child id to the detail section , it displays all child id three times. I tried to supress them by using supress...

Hi All, I am trying to open an excel sheet by using the following command, the last variable -sheet is for the sheet number 1 -------------------------------------------------- C:\>cqperl ExcelperlImportCIT.pl -act Add -excels C:\CQTMTestScriptSample.xlsx - rows 6 -sheet 1...

Hi All, I have the following text stored in a database in a multiline field. I have written a perl script to get the following contents and print it in a html page. I found the newline characters and replaced it with a <br> using the following perl statement $executivesummary =~...

Hi All, How can i change my width of the chart based on the data in the table ? Thanks Saran

Hi All, I have a chart with date's on the x-axis and count on the Y-Axis. Based on the values in the table, the y-axis will grow weekly. How do I change the chart properties, so that it changes its size based on the number of data in the table. Please let me know. Thanks Saran

Hi all, I added a cross tab in my report and placed it on the report header section. I added few additional text as labels and drawn few line around the cross tab. When I run the report the line and additional labels are not appearing in all the pages. I formated the line and the additional...

Hi All, I have a crystal report with few charts embedded in. While exporting that report into an html, it created .png files for chart present in the report. The name of those .png files are random with some ascii values. Is it possible to generate them with user provided information ? For...

Hi All, I have a Defect table with milestones and issues as reference lists. The sample values are for Defect ID 001, Milestones 01 02 03 04 Issues 0001 0002 How to display both referece lists with out...

This question is regarding the crystal reports - chart types, Is there a chart type which is equivalent to a filling cylinder model, for example If I have 20 Testcases and five of them executed.. can i show it in a single bar, with maximum of 20 and 5 is embededed in the same bar (not like...

Hi All, I have field called date in my table, and an another field called verdict. I have to supress the date (nothing should be displayed) , if the verdict is null or empty. How to do that . Please help me out. Crystal report version is 11.0 Fields ClearQuest.rundate...

I have a test verdict field in my table called testverdict. The possible options are pass fail or null I want to have a counter , that counts the total number of pass and fail skipping all the nulls pass -5 fail -2 null - 5 it should display 7, and i should be able to include it in a chart...

Hi All, I have a field called debugtime in my table. I am displaying that in chart after converting that into a number using a formula @debugtime tonumber({ClearQuest.debugtimes}) in the chart , i am displaying Max(@debugtime), if the value is null , I need to display that as Zero in the...

Hi All, I have date field in my table called , ClearQuest.testcaseexecuteddate, I included it as a group field in my crosstab report. I have to display the summary fields only when the above field is not null. I tried this in the supress - as a formula {ClearQuest.testcaseexecuteddate} <> ""...

Hi All, I have a field in table called testcaseverdict with values as pass , fail or nothing. I want to display "NotExecuted" if there is no verdict and i used the following formula in the display string of the group field. if (IsNull({ClearQuest.testcaseverdict}) or...

Hi All, I have an image file stored in a location. In my report i have to display this image for a specific condition based on the value of a field in my table. The field name - "Name" I have to display that image only if the field value is equal to "CMCore" . Is it possible ? Please let me...

Hi All, I have an attachement field in my table. where i attached a .bmp file. I want to display that image in the crystal report. How can I do that. The field name is "AttchmentID" and the value it contains is "37284374 New Chart 6.bmp 1308150 n" how to dis play this on a crystal report...

Hi All, I have a crystal report chart which displays the field name in the Legend. Is it possible to change the change the legend so that it displays other than the field name. Example Legend has Max of @DownTime I need to change that to DownTime Please let me know. Thanks Saran

Hi All, While exporting my report with multiple pages into an HTML with format 4.0, the font size of the multiline fields increases and the output looks very bad. How to avoid it ? I am using crystal reports X1. Please let me know. Thanks Saran

Hi All, I have a crystal report chart, where I have a group by "DateTime" Field , name of the the field "StartTime" In the chart it is displayed like "5/17/2009", I want to format so that it displays "May 17". I can do this very easily if the group by field was in a crosstab or in my report...

Hi All, I have a short string field in my table and i converted the values in number using the to number function and then try to get the value as int. int(tonumber({ClearQuest.fldcolumn_2})) I am always getting the value with two decimal points. example I am getting "1.00' instead "1"...