I am using CR XI and Access 20000
My report is in the form of a letter. I have grouped on Customer Id.
In GH1 I have Customer Name, Address, City, State, ZIP and Subject.
I have no trouble with this report when customer has only one Home address.
If the customer has multiple home address I...
I am using VB6.
I have a MDI parent )mdiMain) and two MDI Child forms. ( FOrm1 and Form2)
When the application opens the Form 1 (transacation entry) opens in the MDI parent screen.
I click on the menu to open Form 2 ( form 1 is still open). Form2 is History form displaying transactions...
I am using CR XI and access 2000.
I have an application developed in VB 6.0.
This is what I am trying to accomplish.
On double clicking on field in the report I want to open a VB form.
For example. if the user double clicks on Customer ID field, it will open the Customer specific Form.
if...
Hi I am using CR XI and access 2000.
I have report that displays the first page after it has read all the 255 pages of the report. The report will hour glass till all the pages are read.
Is there a way to display the first page with results so the user will be happy to see the records...
I am using CR Xi.
Is there a way to dynamically change the column width ? I read some where that you can use some API to accomplish this.
What specific APIs do I need to use ? Is this the only route to accomplish this functionality ? Is there no other approach ?
Hope somebody gives me a...
I am using CR XI.
I have two groups
GH1 is Client
GH2 is Staff
GF1 is Total
Details section is suppressed.
Current Period Previous Period Increase/Decrease
Hours Hours Hours
Client1 StaffA 10 150...
Hi ,
I am using CR XI.
My Client would like to print the parameter criteria after the report has printed.
My question:
I am thinking of passing a string parameter to CR. This string will be a long string and might contain "Carriage Returns", etc.
How many characters will Crystal allow me to...
I am using CR XI
This is what I really want to accomplish.
Sort first then group
If parameter is ascending, sort by compnay Ascending then group by Company Ascending
Company Employee
CompanyA XYZ
CompanyA PQR
CompanyA ABC
Company A 3
CompanyB LMN
CompanyB RST
Company B 2
If...
I am using CR XI.
I have grouped on a formula @grpbystr. This formula
is as below:
@grpbystr
Select {?grpParam1}
Case "ENGMNTDESC": {@engDesc}
Case "CONCMP": {@ccmp}
Case "ENGTYPE": {@engTp}
default: ""
I have another formula @grpbynbr. This formula is as below
@grpbynbr
Select {?grpParam1}...
I am using CR XI.
I need to accomodate 24 fields horizontally in my report. I changed the orientation to Landscape, Changed the font size to Times New Roman 8. and was able to accomodate 18 fields.
How do I accomodate the other 6 fields ? If this was a cross tab CR would have automatically...
I am using CR XI.
I have a report that has a layout like this.
****************************
Customer ID:
Customer Name:
Type Reference LogStatus
Bank Stmt 034-78433 Received
Pension Plan A12030505 Pending
Credit Card 10101023A Received...
I m using CR XI.
This is what I have to accomplish.
CP stands for Current Period
PP stands for Previous period.
CP(03/01/2005 to 03/31/2005) PP (03/01/2004 to 03/31/2004) Increase/Decrease
Hours % hours Hours % hours Hours %hours
Client1...
I am using CR XI.
I have inserted a crosstab in my report. I have a fake grp inside which I have inserted this crosstab.
The crosstab looks like this:
Jan Feb Mar
Amt Amt Amt
Staff A $5 $4...
I am using CR XI.
I have a crosstab in Section GH1a and 2nd Crosstab in GH1b. In the Page Header I have two text boxes (Client and Staff) which I am trying to use as row headers.
In the Page Header I have checked underlaying the sections.
Client Staff Jan Feb...
I am using CR XI, Access 2000.
I have inerted a crosstab in the report. The report is as below
Jan Feb Total
Hours Invoice Hours Invoice Hours Invoice
Staff P 5 $100 2 $50 7 $150
Staff Q 2 $50 3 $150 5 $200...
I am using CR XI..Access 2000
I have inserted a crosstab report.
Jan Feb Mar Total
Product A $100 $200 $10 xxxx
Product B $35 $303 $230 xxxx
Product C $200 $293 $222 xxxx
Client 1
Product A $101 $200 $12 xxxx
Product B...
I am using CR XI..Access 2000
I have inserted a crosstab report.
Jan Feb Mar
Product A $100 $200 $10
Product B $35 $303 $230
Product C $200 $293 $222
Client 1
Product A $101 $200 $12
Product B $35 $300 $211
Product...
I am using Crystal Report XI.
I have a employee Profile report.
There are no groups in the report.
Report Layout is as shown below
---------------------------
Da EmpID EmpFName EmpLName
SSN DOB
----------------------------
Db AddrType Addr
----------------------------...
I am using CR XI, Access 2000
I have created a report using UNION query. In my command object I have the written a SQL UNION query. I have created 5 parameters using the "Create" in the Add Command window.
My problem is the parameters do not prompt on refreshing the report ?
What am I...
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.