Results 1 to 3 of 3

Thread: Cristal reporting with proper way

  1. Oct 8th, 2006, 11:00 AM #1
    rumy
    rumy is offline

    Thread Starter
    Lively Member
    Join Date
    Sep 2002
    Location
    Bangladesh
    Posts
    106

    Cristal reporting with proper way

    I have 2 tables named Purchase and Sales and the tables field name is

    ProductID ProductName Quantity

    when i am opening this table from cristal report it's creating a link wiht the ProductID field. I have only 5 rows in both tables but in the report it's showing a lot of rows.

    What can i do will you please tell me wha's the proper way to make a report and make a quary? Is there any tutorial for learning cristal report?

    Will you please help me?

    Thanking you
    Rummy
    Reply With Quote Reply With Quote
  2. Oct 9th, 2006, 07:32 AM #2
    Besoup
    Besoup is offline
    Frenzied Member
    Join Date
    Nov 2001
    Location
    Mass USA
    Posts
    1,674

    Re: Cristal reporting with proper way

    What do you have the productID linked to? Are there more than 5 matches?
    Reply With Quote Reply With Quote
  3. Oct 15th, 2006, 02:59 PM #3
    Mark Gambo
    Mark Gambo is offline
    Giants World Champs!!!! Mark Gambo's Avatar
    Join Date
    Sep 2003
    Location
    Colorado
    Posts
    2,965

    Re: Cristal reporting with proper way

    Do both tables have the same exact field names? CR will try to make "Intelligent" joins on tables. This means that if two tables are added to the report and if they both have a numeric field with the same name, CR will "Assume" that they should be joined together.

    Could you post a of each table's schema as well as sample data from each table?
    Regards,

    Mark

    Please remember to rate posts! Rate any post you find helpful. Use the link to the left - "Rate this Post". Please use [highlight='vb'] your code goes in here [/highlight] tags when posting code. When a question you asked has been resolved, please go to the top of the original post and click "Thread Tools" then select "Mark Thread Resolved."

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width