I have created a Cross-Tab that has three rows and one column. I would like to have the ability to conditionally hide Row3 three and roll up the summary at the deparment and job title level. ...
Hello Experts
i want to put condition in my report that if formula (@To) is equel to (field) "To_Date" than (field) "Chq_DD_No" else 0
i dont know how to do that, I tried , Please check at...
So... somehow i got chosen to learn some c11 design stuff not my forte by any means but gotta do what i gotta do.
Scenario as follows: Reports are hosted on a remote server and to edit/cha...
Hello,
I'm having some difficulties trying to create a simple Pie chart in my report.
I have two total values, I'll create a simple example:
Vehicles : 2
Vehicles delivered : 5
I get ...
Hi,
I have a crosstab and a chart and i need them to be the same height.
Can i create a chart there can grow in height and how?
Hello,
How can I suppress the following two summary fields if they are equal ?
Sum ({@Travel Bill Rate}, {PAM_InvoicedTSs.JOBNUMBR})
Sum({@Travel Cost}, {PAM_InvoicedTSs.JOBNUMBR})
I...
I am trying to link parameters in my main report to the parameters I need for my sub reports.
This is easier said than done!
In the subreport drop down, I dont get the parameters that w...
Hello Experts,
I created a report with numeric field . In preview, it shows correct value without clubbing in a report.
My poblem is that,
When I convert into text file, Its clubbing in tex...
For some reason my report has a page with just the header information at the end of my report. I take it that the new page after in my group is causing it. How would I make it so the new page ...
Hi all
I have a strange problem i have a few check boxes that i select to print a report using the code below. The problem i have is the first time i check a box it prints everything fine b...
Hello Experts,
I am trying to print registration sheets using the CR design. I am also displaying the page number on each page. Because each registration has got 4 pages in it. I want to re...
Helo all,
I'm need help with client side configuration for Crystal Report, if it exist. I have a client-server application using Oracle ODBC and VB6, on two workstation when I ran the rep...
Hi,
i have a crystal report done but i am having problems with page break. There is 1 group in my crystal report, i would like crystal report to page break when It has reached a new group o...
Could someone help me to solve a problem in Crystal Report? I don't know what wrong with it. Every time I create a new blank report and start to increase section space such as Report Header, P...
I hope this makes sense. I want to make field sizes display based on the largest size of the text. For example if I have model number as afield and 1 result is ABC111 (6 characters) and anot...
My client just replaced a PC running Win-XP with a new PC running Win-XP as the hard-drive was bad. I have installed Crystal-9, the report's database (Timeslips) and the "linking" DLLs that we...
I have one field that I want to split into to separate fields based on what it find for my "delimiter" in my main field.
Example: MainField contains Name 1-Name 2 (delimiter here is -)
I...
I am new to Crystal Reports (12 Hours) and I need to add X's to fill a field. The file is banking report and I have an 11 character field for SWIFT codes though many of the codes are only 8 c...
I summarize (count), based on Select Expert, a certain set of records from an Access database per month. Most months return a value (such as "2" or "4"), but some months, there are no records ...
This is approach I'm taking now, my "Line" column is a string type right now, but always stores decimal values:
1
1.1
1.1.1
1.10
1.2
2
2.1
etc
I use this code to get the rows sort...
Hello Experts
I am trying to make the CR design to produce the PDF with the following dimensions.
Height : 24 cm , Width : 32.7 cm
But I am not getting the desired size, the page typ...
Hello Experts,
Hopefully I can explain this so that it makes sense. I need to create a report that will query an Oracle database. The top section of the report should include a case number da...
Hi ,
I hope you can help.
We have multipal MS Windows in terminal server mode. Using crystalviewer. When we go to print on one server, the print job prints starts about an inch down the...
Hi Experts,
I am trying to round of the integer fields.
e.g,
If I have value 21552 or 21559 it should get rouded off to next 10 digit i.e, 21560
Hello Experts. I could sure use your help.
I've used the OLE Object feature in Crystal with images and it works great but I'm trying to link PDFs and I'm getting no where.
This is what...