Search results for query: *

Hi , How to do a date validation for DTPicker? I have a startdate and enddate? The startdate should not be greater than the end date How do i do this? Thanks for any help Devaki

Hi, How do i export the data to a specific sheet in Excel from VB.I can export it to an excel . How do i take it to a specific Sheet in the excel Thanks Devaki

Hi, Can anyone help me to find out the problem with this Query that has a date range. Select a.containername,a.containerid,a.thiscontainerlost,a.status from Container a, ContainerLevel b where a.levelid = b.containerlevelid And a.containername <> a.containerid And b.Containerlevelname =...

Hi, I have a report in crystal8.5 with start date and end date as input parameter.The datatype is date and it shows the calender whenever it prompts for input parameter. Now i want to show the date with month and year instead of a calender. Can it be done with the existing set up or i have to...

Hi , Can I draw a pareto chart using crystal 8.5? If so how do i do it? Thanks Devaki

Hi, How do i find out if my subreport returns no records . I want to create a formula in the main report that sets the value to 17 if my subreport returns no records. I am using Crystal 8.5 Thanks Devaki

Hi, I am using Crystal 8.5. I want each page to show only 25 records how do i do this. I tried to do the following In the Section Expert the selected new page after for the details and gave the condition as recordnumber=25 but this sets only if the recordnumber is equal to 25. Again my second...

Hi, I retrieve a set of records for example A B C D from the subreport by passing the parameter from the main report. If i try to retrieve it to the main report using a shared variable it returns only the last record i.e D How do i make it return all the records i.e A B C D ? I am using...

Hi, Is there a way to change the Color of a certain field based on the value of another field in crystal 8.5 Ex Field A Field B - Values 1,2,3,4,5 can i set the color of field A to be red if the corresponding records field B value is 1 Blue if value is 2 ... Thanks Devaki

Hi I am trying to export to Excel 8 format from crystal 8.5.The report consists of 4 subreports. Out of which i cannot get the value of one field that belongs to one of the subreport.Sametime the other fields of the subreport are exported. I don't understand the problem. I eliminated all the...

Hi , I want to sort a column in a flexgrid that has date values for example: 01/06/02 11:01:45 ...How to do the sorting on this column? Thanks Devaki

Hi , I have a number 1.250356. I want to take only 0356 out of it. If i use mid and convert it to text it brings out a blank result MOVEHISTORY.CYCLETIME=1.250356 For example mid(totext({MOVEHISTORY.CYCLETIME}),5) Is there a way to get this number 0356? Thanks Devaki

Hi, I am using Crystal 8.5 . I have a line chart . The legends which appear below the chart are not in order For example if i group by date the legends appear as 09/05/01 08/06/01 08/31/01 How do i make it 08/06/01 08/31/01 09/05/01 Thanks Devaki

Hi, How do i save the reports with data to a power point file. I am using crystal 8.5 Thanks Devaki

Hi , Is there a way to draw custom lines at 2 places For example. If y-axis ranges from +600 to -600 How to draw custom lines at +250 and -250? I am able to draw at only one point either at +250 or -250 . But i need lines at these two points Thanks Devaki

Hi, I have to set the minimum amd maximum values for the x-axis and the interval as 10. i tried in all ways but couldn't get a solution can somebody help me i am using crystal 8.5 . Chart is a line chart Thanks Devaki

Hi , Can anyone tell me how to set my own maximum and minimum values and the interval for the x-axis . I can set it for y-axis but i don't know how to set it for x-axis.(group axis) Please help. I am using crystal 8.5 It is a line chart Thanks Devaki

Hi, Can i draw a line graph based on the shared variable values. How to do this? Please help Thanks Devaki

Hi, I have a line chart inserted in a report. Y-axis ranges from +600 to -600. I want to draw lines at +250 and -250 and show that all points that exists between these two ranges are valid ones and those gone out are invalid ones. I don't want to give this in a formula but like to plot all...

Hi, I have a line chart inserted in a report. Y-axis ranges from +600 to -600. I want to draw lines at +250 and -250 and show that all points that exists between these two ranges are valid ones and those gone out are invalid ones. I don't want to give this in a formula but like to plot all...