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!

Register Log in
  • Congratulations derfloh 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: pkohli8
  • Content: Threads
  • Order by date
  1. pkohli8

    Reverse Table

    Hi, I have this table that contains Names and in other column, I have list of groups that person belongs to in CSV format. This might be possible that many person can belong to one group. so, what i am looking for is the reverse of the table. I want to list individual...
  2. pkohli8

    Reverse the CSV column(One to many relation)

    Hi, I have this table that contains Names and in other column, I have list of groups that person belongs to in CSV format. This might be possible that many person can belong to one group. so, what i am looking for is the reverse of the table. I want to list individual...
  3. pkohli8

    Query On One data point per records

    Hi, I have table in this form SAY TABLE upload_id col_name Value Row 13668 SS_ID 112 1 13668 AK DLP-2 1 13676 SS_ID 113 4 13676 AJ HP 4 13676 AK DSP-1 4 14576 SS_ID...
  4. pkohli8

    replace Regular Expression

    Hi, I have one table with two columns in one column Names of different Teams are stored and in other columns ....different departments are stored, basically these departments are divided into 3 categories say category 1, category 2, category 3 and are stored in second column in this format...
  5. pkohli8

    Schedule for Last Business day of month

    Hi, Is there any way to schedule Report for LAST BUSINESS day of month? Thanks
  6. pkohli8

    200 Field Report

    Hi, i have to generate report that includes almost 200 fields and for that i am using SQL query in the COMMAND. but as soon as after writing SQL query in Command, I hit OK, the crytal closes automatically. can anybdy tell , is there any limitation on the number of fields in CR or is...
  7. pkohli8

    add value to one record based on another record

    Hi, I have a table that has 3 fields Field A Field B Field C 101 Apple 3/2/06 3:00 AM 101 Orange 3/2/06 4:00 AM 101 Banana 3/2/06 9:00 AM 102 Orange 3/2/06 4:00 AM 102 Grapes 3/2/06 5:00 AM 102 Orange 3/2/06 10:00 AM 103...
  8. pkohli8

    Poblem with query

    Hi, i have table that following fields ID Name Value Record 11 Sname Peter 1 11 Age 38 1 11 Height 62 1 11 Weight 78 1 12 Sname Sam 2 12 Age 27 2 12 Height 59 2 12 Weight 89 2 13...
  9. pkohli8

    add value to one record based on another record

    Hi, I have a table that has following fields field A, Field B, Field C(Time) for example Field A Field B Field C 102 Apple 3:00 AM 102 Orange 3:15 AM 102 Banana 4:00 Am 300 Grapes 1:00...
  10. pkohli8

    Add Value to one record based on value of other record

    Hi, I have a table that has following fields field A, Field B, Field C(Time) for example Field A Field B Field C 102 Apple 3:00 AM 102 Orange 3:15 AM 102 Banana 4:00 Am 300 Grapes 1:00...
  11. pkohli8

    URL for Folders in CE10

    I want to create a URL(shortcut) to a folder that takes me directly to the list of all object/reports under that folder. right now CE 10 folder structure is like this Rootfolder/Sub 1/Sub 2/Sub 3 now i want to create a URL that directly takes me to the objects under "Sub 3" without drilling...
  12. pkohli8

    Shortcut(URL) to Folders in Crystal Enterprise 10

    Hi, This is the first time i am posting any query, so please bare with me if i m not quite clear. I want to create a URL(shortcut) to a folder that takes me directly to the list of all object/reports under that folder. right now CE 10 folder structure is like this Rootfolder/Sub 1/Sub...

Part and Inventory Search

Back
Top