Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. Crystal report

Crystal report

Scheduled Pinned Locked Moved ASP.NET
csharphelptutorial
6 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • K Offline
    K Offline
    kumarjammula
    wrote on last edited by
    #1

    Hi I hava problem regarding crystalreports My problem is how to genarate crystal report form two tables which has regid as comman coloums I am using .net2.0 ,sqlsever2005

    came out of hardwork

    S 1 Reply Last reply
    0
    • K kumarjammula

      Hi I hava problem regarding crystalreports My problem is how to genarate crystal report form two tables which has regid as comman coloums I am using .net2.0 ,sqlsever2005

      came out of hardwork

      S Offline
      S Offline
      Sherin Iranimose
      wrote on last edited by
      #2

      Hi, You can create a "view" in sql server 2005 from 2 tables. And use that view to create the report.The view here will act as a single table.


      To succeed, we must first believe that we can. Sherin Iranimose


      K 1 Reply Last reply
      0
      • S Sherin Iranimose

        Hi, You can create a "view" in sql server 2005 from 2 tables. And use that view to create the report.The view here will act as a single table.


        To succeed, we must first believe that we can. Sherin Iranimose


        K Offline
        K Offline
        kumarjammula
        wrote on last edited by
        #3

        I am new to .net could plse suggest me any example so that ia can manage my self

        came out of hardwork

        S 1 Reply Last reply
        0
        • K kumarjammula

          I am new to .net could plse suggest me any example so that ia can manage my self

          came out of hardwork

          S Offline
          S Offline
          Sherin Iranimose
          wrote on last edited by
          #4

          Hi, I dont know websites explaining SQL server views. I think you know how to create crystal reports from tables. So... 1.Open MS Sql Server Management Studio 2.Navigate to your database 3.There will be a treenode "Views" right click on it. 4.Select New View 3.Select the tables that you want to include.press Add Give your condition for the view. dont think it is difficult.try yourself it is very very easy...


          To succeed, we must first believe that we can. Sherin Iranimose


          K 1 Reply Last reply
          0
          • S Sherin Iranimose

            Hi, I dont know websites explaining SQL server views. I think you know how to create crystal reports from tables. So... 1.Open MS Sql Server Management Studio 2.Navigate to your database 3.There will be a treenode "Views" right click on it. 4.Select New View 3.Select the tables that you want to include.press Add Give your condition for the view. dont think it is difficult.try yourself it is very very easy...


            To succeed, we must first believe that we can. Sherin Iranimose


            K Offline
            K Offline
            kumarjammula
            wrote on last edited by
            #5

            HI Thanku I created a view how to use it form userside or the query which is generated is to be used

            came out of hardwork

            S 1 Reply Last reply
            0
            • K kumarjammula

              HI Thanku I created a view how to use it form userside or the query which is generated is to be used

              came out of hardwork

              S Offline
              S Offline
              Sherin Iranimose
              wrote on last edited by
              #6

              Hi Oh... good You are Fast... The view you created will act like a table. No need to use the query generated. Save the view with a name. then eg: SELECT * FROM MyView will return all the data from the view. I think now you are femiliar withit...


              To succeed, we must first believe that we can. Sherin Iranimose


              1 Reply Last reply
              0
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • World
              • Users
              • Groups