Results 1 to 3 of 3

Thread: Create Report using SQL Qurey

  1. Oct 5th, 2006, 04:36 PM #1
    hafizfarooq
    hafizfarooq is offline

    Thread Starter
    Fanatic Member
    Join Date
    May 2004
    Location
    Quetta-Pakistan
    Posts
    852

    Create Report using SQL Qurey

    Hello,
    How to count the number of records showing in a Subreport. I want to stop the report on 12th record.(mean when show 12 records. no more records appear)

    How to create report using SQL Query in CRYSTAL REPORT
    Please help me
    Reply With Quote Reply With Quote
  2. Oct 9th, 2006, 09:10 AM #2
    shakti5385
    shakti5385 is offline
    Just Married shakti5385's Avatar
    Join Date
    Mar 2006
    Location
    Udaipur,Rajasthan(INDIA)
    Posts
    3,747

    Thumbs up Re: Create Report using SQL Qurey

    Quote Originally Posted by hafizfarooq
    Hello,
    How to create report using SQL Query in CRYSTAL REPORT
    Please help me
    Check out the crystal report tutorial at my signature see the post 3.
    My Blog : My Article of the day
    Reply With Quote Reply With Quote
  3. Oct 15th, 2006, 03:01 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: Create Report using SQL Qurey

    You can try this:

    VB Code:
    1. SELECT TOP 12 * FROM YourTableName
    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