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 TouchToneTommy 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: samson123
  • Content: Threads
  • Order by date
  1. samson123

    Report takes a long time to retrieve records

    I am using CR XI, Access 2000 I have a main report and three subreports in the detail sections (Db, Dc, Dd). Contact Name, Company are stored in CONTACT table Address info stored in ADDR table Phone info stored in PHONE table Email info stored in EML table It is basically a Contact Address...
  2. samson123

    Trial version

    I have developed reports using trial version of CR XI. Will the report functionality stop working at my client's place where I have deployed after 30 days ?
  3. samson123

    Records not retrieved

    I am using CR XI I am having a strange problem. I have created a report using a test dB "Cust_test.mdb" This how I connect to the database thru VB 6.0 ******************************* Set m_objconnectioninfo = m_objcrxReport.Database.Tables(1).ConnectionProperties...
  4. samson123

    Changing print orientation at run time

    I am using Crystal XI I need to change the print orientation at run time. The report is already created, but I want to be able to change fields depending on options that the user selects. Certain of these options will cause the report to require more fields than the other options, so I will...
  5. samson123

    Clicking on a field higlishts the column

    Hi I am using CRXI, Access 2000 When I click on a field in the report, it highlights the entire column. Is this a bug or is there a property which can disable this feature ?
  6. samson123

    Group Footer appearing above Group Header

    I am using CR XI, Access 2000 The Report has following layout GH1 D GF1 I have formula to stop the column headers from printing after change of every group. In the PF, I have a @reset formula @reset ------- whileprintingrecords; numbervar linecnt := 0; In the GH1 I have a @incrementcount...
  7. samson123

    Logon failed error

    Hi, I am using CR XI, Access 2000. We have created a deployment package using merge modules. We installed in successfully on 2 PCs. Both the PCs never had CRystal Reports or Visual Basic installed. I am getting a Logon failed error message on one of them. The other machine does not give any...
  8. samson123

    Logon Failed Error

    Hi, I am using CR XI, Access 2000. We have created a deployment package using merge modules. We installed in successfully on 2 PCs. Both the PCs never had CRystal Reports or Visual Basic installed. I am getting a Logon failed error message on one of them. The other machine does not give any...
  9. samson123

    Dynamically changing column width

    Hi all, I am using CR XI, Access 2000. Is there a way to dynamically change the column width ? I do not want to add multiple sections with different column widths. I am using Visual Basic 6.0 to call the reports.
  10. samson123

    Column Headers not appearing

    I am using CR XI, Access.. I have grouped by Type FirstName LastName Type Sam Peters Contractor John Smith Contractor Count of Contractors: 2 John Doe Employee Paul Smith Employee Count of Employees : 2 and so on...
  11. samson123

    Dynamically change the font of the entire report

    I have CR XI, Access 2000. We want to pass the Font Name to Crystal Report as a parameter. That font should be applied to all the fields. Is there a way in Crystal reports to dynamically change the font for the entire report ? I do not want to write code for EACH individual fields on the...
  12. samson123

    Equivalent of "NOT EXISTS" in Recordselection formula

    I am using CR XI, Access 2000 What is the equivalent of "NOT EXISTS" in the record selection formula ? I have a queryas follows: SELECT * FROM TableA where TableA.custid = 100002 and not exists (Select * from TableB, TableA where TableB.custid =TableA.custid) I would like to do this...
  13. samson123

    Portrait Landscape mode issue

    I am using CR XI, Access 2000. In the report footer I have PrintDateTime field on the bottom right corner. By default the report is in Portrait mode. PrintDateTime field is visible in the bottom right corner But if the user selects to print in Landscape mode, the PrintDate Time field is no...
  14. samson123

    Sections not getting suppressed

    I am using CRXI, Access... am using CR XI, Access 2000. I am dynamically displaying values based on the user selection. Following is the layout of the report ?Disp1 ?Disp2 ?Disp3 ?Disp4 ?Disp5 ?Disp66 @Col1 @Col2 @Col3 @Col4 @Col5 @Col6 I am using the...
  15. samson123

    Sections not suppressing

    Suppression I am using CR XI, Access 2000. I am dynamically displaying values based on the user selection. Following is the layout of the report ?Param1 ?Param2 ?Param3 ?Param4 ?Param5 ?Param6 @Col1 @Col2 @Col3 @Col4 @Col5 @Col6 ?Param# are parameter accepting...
  16. samson123

    Report not displaying actual values

    Help needed.. Using CR XI, Access 2000 I have two tables... 1) MRCOL --Mater table holding Table name, DBfield name, Display Name 2) TCON----Contact Info The MRCOL table Table_name DBfield_name Display_Name TCON CONFNM First Name TCON CONLNM Last Name TCON CONCNM...
  17. samson123

    Field names instead of field positions

    I am using crystal Reports XI. Access database 2000 I have in my VB code If text = "Customer Name" report.RecordSortFields.Add report.Database.Tables(1).Fields(2), crAscendingOrder endif The above code works fine. But I would like to use the following so that I do not have to remember the...
  18. samson123

    Business Objects Logo

    I am using CR XI. Is there a way to hide the "Business Objects" logo that appears on the toolbar on the upper right corner of a crystal report ? I do not want to hide the toolbar using the enabletoolbar = false Thnx in advance
  19. samson123

    craxdrt.dll registration failed

    I am using CR XI . Access 2000, Windows XP. I have built a Setup using Package & deployment wizard. When I run the setup craxdrt.dll fails to register. It gives me this error message "An error occcured while registering the file "C:\program files\common Finles\business...
  20. samson123

    Report Selection formula Query

    I am using CR XI , Access 2000 I have a master table which stores all the codes and their descriptions. MCodes (ID is the PK) -------- ID Code_type Desc 1 Status Active 2 Status Inactive 3 ContactType Employee 4 ContactType Vendor 5 ContactType Temp I need...

Part and Inventory Search

Back
Top