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

Thanks ken i removed all the subreports and got the all the data in a view. Then designed the report .Now it gets exported without problems. Devaki

{EPI0280.DEFECTS} is a subreport field

ken, when i am in the design mode the subreport with one field is displayed without any problem.I can even get the data in the run mode.Problem appears only when exporting to excel. Is this your question ken? Thanks Devaki

ken, All the fields from the main report and the subreports are fine when i run from crystal. But when exported to excel i have the data missing from one subreport. The problem is only when exporting. In crystal everything is fine both in design mode and run mode. If you need more details...

Ken, When exported to excel actually {EPI0280.DEFECTS} has to appear in column M of excel sheet.This happens when i don't add the subreport EPI0280AND80 . If i include the subreport EPI0280AND80 with the above formula then the value of the formula...