Hi, I have written a query which is you can see below. The query qpproximately takes 50- 60 SEC to run, which I believe is way too high. The total rows returned is 10,000 . Any idead/lead what to do to improve the query timings ? The number of rows in each table are as follows :
ACCOUNTS ...
Hi,
Can any one please tell me how to place two cross tabes side by side ( horizontallY) , so that they wont overlap each other , that means the gap betwenn the two cross tabls will be always maintained , wheter the frist cross tab shrinks or expands in size.
Thanks
-Feroz
Actually my PDF file is a A4 size So I put it as an OLE object in the detail section and then put the fields on proper positions on top of the PDF file. But when I embade the PDF file ( Insert OLE Object) , it shrinks the PDF file to 6.5 x 8.3 . I want it as a standard ful page. If I strech the...
Hi Julie,
Thanks for your reply. I tired to insert the PDF file into the report. I just put the fields into the proper places of the forms. When I print it , the printed PDF form is not that good. It is as if the whole document is blured. Is there any idea, if the graphics quality of the form...
Hi,
Does any one know how to superimpose the data from crystal report into a pdf form ? Let me clarify my requirements. There is a PDF file. Its basically a form .To fill out the form , you generally print the form and fill it out with pen or pencil. Instead of doing that , is there a way , I...
Hi,
I have a report . I have written this code in one of the field's display string code editor ( which is done by Format Field -> Common Tab - Display String )
ToText((CurrentFieldValue * 100),0,"###,###") + "%"
what it does basicall is multiplies 100 with the current field value and...
Hi,
Can any one tell me how to conditionally suppress cross tab rows ? here is what I want . Suppose in a cross tab, the data displayes is Income, Expense and Liabilities for 30 months. I dont want to diplay the Liabilites on the corss tab. But I want the amount to be summed up . How can I do ...
Hi LW,
Thanks for your quick reply. I tried that option before, but the data is not priting together . Here how the data is getting printed.
MASTER ID -1001
A- 300 - OF DETAIL 1
X- 900 - OF DETAIL 2
B- 200 - OF DETAIL 1
Y- 400 - OF DETAIL 2
C- 400 - OF DETAIL 1
Z- 230 - OF DETAIL 2
AND if there...
Hi, I want to create a report which will have two details section in a master section . And I dont want to use subreport. The out put should look like this
MASTER ID - 1001
DETAIL - 1
A - 300
B - 200
C - 400
DETAIL - 2
X- 900
Y- 400
Z- 230
. I want the all the records of "DETAIL 1" to...
Hi,
I am new to crystal reports. I am using verson 10 . My requirement is I have got three groups. 1. Continet, 2.Region, 3. Country. The Sorting should be the Continents, and then within the continents, the regions and within Regions the Countries. The regions are named as R01,R02,R03..., R45...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.