Recent content by Devaki

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, I am using a simple code as below Open "c:\Epi.Xls" For Output As #1 Then everytime i use a print #1 and get the data to the excel from my grid that has the value. Now i think i need to use it as an excel object. Could you please provide me a sample code to do this. Thanks for...

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 , Both ways does not work. Any other ways to do this? 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 , Do i need to create 2 Default value list . one for the month another for the Year. Thanks for the help Devaki

Hi, I want the parameter field to show only the month example Jan 01,Feb 01... I don't want to show the complete calender and then format the parameter field after that. Is there a way to do this? Thanks Devaki

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 created something like this in the detail section and got the count but how do i reset the value at the page footer could you please explain in detail WhilePrintingRecords; numberVar Test1; Test1:=Test1+1 thanks for your help 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...

Thanks Bruce. It works fine

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