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: paramsocool
  • Order by date
  1. paramsocool

    selectng multiple year values from record selection

    I have a @year formulae created in my report and it contains year values along with NULL values also . I am trying to select records using record selection criteria and my record selection has couple of selection parameters. I have to pick up those records that have an @year value between some...
  2. paramsocool

    pulling data from 10 tables but joining 20 tables

    If I am joining about 20 tables in Database expert and using fields from around 10 tables only in my report. Will it effect my report speed. I am considering that the other ten tables removal from my dataexpect does not effect my result Please advice
  3. paramsocool

    diff in openings excel output from CR

    what do you mean by cut-down version.....if I am exporting only a couple of pages it works fine....but for 700 pages it freezes in excel but pdf and rtf works fine
  4. paramsocool

    diff in openings excel output from CR

    I am exporting an a CR into excel and it has more than 110000 records and around 559 pages, IT gets exported fine but when I am trying to open the excel it goes into thinking mode and gets to not responding mode. Any advice
  5. paramsocool

    Is there any way of retrieval of data from a Flat File

    Is there any way of retrieval of data from a Flat File/Text file in crystal to be used a data fields in report
  6. paramsocool

    Setting a datasource as a favourite

    Did you try refreshing the Fav after adding to FAv?
  7. paramsocool

    Multiple occrance of same record even if it exists once in the table.

    I am pulling two tables from a same database source. The tables have exactly identical field names but the table names are different. I have to pick up some dates from the two tables. Same record may exist in both the tables...One of the table is a current table and the other one is History...
  8. paramsocool

    Please advice for RDCR201 crystal reports exam

    As the exam stucture for CRCP has changes after the BO merge and as we have two exams now for CRCP... RDCR201 and RDCR301...I have checked the forum and people have been talking about CRCP but I am not able to get any specific info for RDCR201 exam which I am planning to give. Can any one...
  9. paramsocool

    Info regarding RDCR201

    As the exam stucture for CRCP has changes after the BO merge and as we have two exams now for CRCP... RDCR201 and RDCR301...I have checked the forum and people have been talking about CRCP but I am not able to get any specific info for RDCR201 exam which I am planning to give. Can any one...
  10. paramsocool

    for CRCP exam

    can anyone please advice me the topics to cover for CRCP exam 1. I am using Crystal reports complete reference for XI and CRCP book .. Please advice which chapters to cover from complete reference XI
  11. paramsocool

    using if condition with blank spaces

    Hi I am trying to use an if condition with a table column that has Null or blank spaces. I am able to handle Null with if else but I am not able to figure out how to handle blank space condition as if (value)=' ' becuase the blank space can be variable and I want to satisfy both the null...
  12. paramsocool

    Combining 3 tables using DataBase command

    Hi I have tables in SQL SERVER and the fields are TABLE A ---POLICY_ID ( Primay Key) POLICY_NUM TABLE B- POLICY_ID ( F Key) ISSUE_DATE DELETE_DATE TABLE C- POLICY_ID ( F KEY) CANCEL DATE Only those records are to be picked from TABLE A for which...
  13. paramsocool

    Concatination of String and Number in CR XI formulae

    Hi I am trying to combine a string and a number field together by using following syntax table1.stringfield &"." & table2.number field I have to put a "." between the combined fields. The problem i m getting into is that my original number field is some whole number like 13 etc. When I...

Part and Inventory Search

Back
Top