Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ind123p
  • Content: Threads
  • Order by date
  1. ind123p

    Suppress extra detail rows

    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...
  2. ind123p

    Same form loading twice.

    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...
  3. ind123p

    Double Clicking on the report fields

    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...
  4. ind123p

    Can report display first page with records ?

    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...
  5. ind123p

    Dynamically Changing column width

    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...
  6. ind123p

    Sorting issue

    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...
  7. ind123p

    Parameter string length

    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...
  8. ind123p

    Sort first then group

    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...
  9. ind123p

    Dynamically "CHANGE GROUP"

    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}...
  10. ind123p

    Report with many fields

    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...
  11. ind123p

    String sorting within detail dection

    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...
  12. ind123p

    Difference of summarized fields in crosstab

    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...
  13. ind123p

    Crosstab --2 date ranges

    CP(03/01/05 to 03/31/2005) YTD (01/01/05 to 05/31/2005) Hours Amount Hours Amount Client1 StaffA 10 $50 150 $750 StaffB 5 $60 50 $1300 Total 15 $110 200 $2050...
  14. ind123p

    Row indent issue in Crosstab

    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...
  15. ind123p

    Suppress text - Underlay sectcion issue

    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...
  16. ind123p

    Crosstab TopN sorting -- Better Approach??

    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...
  17. ind123p

    crosstab total

    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...
  18. ind123p

    Sorting Summarized fields

    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...
  19. ind123p

    "Suppress if duplicated" not working

    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 ----------------------------...
  20. ind123p

    Parameter defined in Command not prompting

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

Part and Inventory Search

Back
Top