Search results for query: *

Hello, I am using Crystal 7.0 . Can anyone tell me how do i write th report selection criteria so it gets data only for the current full week (starting from sunday until now) Thanks, Ash

I am using crystal 7. I have created a report to print labels (3 columns). When i try to export labels to a text file it becomes 1 part label ??? can the undesired effects be avoided? I want to export it to a text file for printing it onto an IBM mainframe impact printer. Cannot use laser for a...

hello, I have a string parameter which has an edit mask to accept date as dd-mon-yy . This is an optional parameter. I have the following formula which formats the parameter NumberVar dd; NumberVar mm; NumberVar yyyy; StringVar text_mmm; dd := ToNumber(Left ({?Docket End Date},2))...

I have a report with 2 sub reports in it. The sub reports are independent of the main report data. The report has 2 parameters and the same parameters are being used for the sub reports. The first sub report is in report footer A and the second sub report is in report footer B. Based on the...

Hello, I have written a DLL which I want to use in forms 4.5 . I am basically a visual basic programmer but I have this requirement of using the DLL in oracle forms . I have minimal knowledge of Oracle forms . Based on this does anyone have sample code of how to invoke DLL's from oracle forms...

there are several ways to do it. Simple method is using a crystal ocx in visual basic.

Hello, From the parameter list window drag and drop the parameter you want to display on the title. When you right click on the parameter you can select format and use the exact type you want.

Hello, I am kinda new to this. Can someone provide a tutorial to call a crystal report from Oracle Forms 4.5 . All i got to do is on click of a button on forms 4.5 I want the crystal report to be printed. Any helps tips / tutorials is appreciated. Thanks, Ash

Weird problem.. I have a report which displays few columns from different tables. I am using PDSORA driver to connect to oracle . The problem i am having is a column by name xyz does not print on the screen even though it has some data in it. However if i run the report again it prints the...

I have a report with 2 parameters from date and to date. I am using an oralce table with couple of millions of records. I want the user to enter the from and to dates in the parameter and if the difference between the 2 dates is greater than 10 then the report should not access the database and...

thanks for the answers but my work place is using crystal 7. Is there a possibility to solve this issue in crstal 7 ? thanks

Right click on the details tab and select insert detail line. Is this what you were looking for ?

I am trying to write a crystal report which lists missing records.... The following eg would be useful I have a Ora Table which has 3 records . Assuming the column name is serial number it has the following records SNo ---- 1 5 10 From the above data the min is 1 and max is 10. My report...

Hello, Thanks for the response. I cant use the " " because I would not know the lenthg of each record at design time. For eg the data could be like be as below. "AAAAAAAAAAAAA" "DDDD" "WWWWWWWWWWWWWWWWWWWWW" so I cant really use as you suggested...

Exporting data to a text file truncates the trailing spaces. How do i deal with this ? I also tried the following "ABCD" + SPACE(75) + CHR(13) The purpose is to feed the output file to the mainframe in a fixed length format. When used the above in the formula and export it to a...