![]() This section repeats once for each record in the table or query that the report is based on. The one section that is present in every report is the Detail section. Decide which data to put in each report sectionĮach report has one or more report sections. The query can be embedded in the RecordSource property of the report, or you can create a separate, saved query and base the report on that. More often, the data that you want is stored in several tables that you must pull together in a query, before you can display it on the report. If all the data is contained in a single table, you can base your report directly on that table. In this case, the other person can draw the sketch before you begin work.Īfter you create your sketch, determine which table or tables contain the data that you want to display on the report. Note: This technique is also very useful if you are designing a report for someone else. Or, perhaps your report is a simple listing of the data in the table, in which case your sketch can contain just a series of rows and columns. Then, the sequence repeats for the next product and so on until the end of the report. Whichever method that you use, be sure to include enough rows to indicate how the data repeats.įor example, you can use a row for product information, then several repeating rows for that product's sales, and finally a row of sales totals for the product. Alternatively, you can use programs such as Word or Visio to create a mockup of the report. However, if you decide to design your report without using these tools, you might find it helpful to make a rough sketch of your report on a piece of paper by drawing a box where each field goes and writing the field name in each box. This step is not required - you might find that the Access Report Wizard or the Report tool (both of which are available on the Create tab, in the Reports group) provide a sufficient starting design for your report. This can be an indication that the tables are not normalized - this means that the data is not stored in the most efficient manner. During the design process, you might even discover that the arrangement of data in the tables will not allow you to create the report that you want. When you design a report, you must first consider how you want the data arranged on the page and how the data is stored in the database. In this articleĪdd or remove report or page header and footer sections This article discusses the general process of designing a report and then shows you how to add specific design elements to your report. Whichever method that you choose, you will probably make at least a few changes to the design of the report to make it display the data the way that you want. You can use the Report Wizard to create a more complicated report, or you can create a report by adding all the data and formatting elements yourself. ![]() You can use the commands on the Create tab to create a simple report with a single click. If I select PatientTB or ListTB from dataset crystal report will work fine.īut selection of both tables can not display anything because of relationship of primary-foreign key in both the tables.Ĭmd = new SqlCommand("SELECT Date,Doctor,Patient.Patient_Id,Patient_Name,Contact_No,Payment_Type,Item_Count,Grand_Total,List.Batch_No,List.Item_Code,List.Item_Name,List.Exp_Date,List.Qwantity,List.MRP,List.Amount FROM Patient INNER JOIN List ON Patient.Patient_Id = List.Patient_Id WHERE Patient.Patient_Id = '" + Main.txt_crs_pid.Text + "'", con) ĬrystalReportViewer1.Access provides you with a number of tools that help you to quickly build attractive, easy-to-read reports that present the data in a way that best suits the needs of its users. When I create a crystal report with anyone of above table it works fine.īut when I select both the tables no data will display. Now the column Patient_Id is an primary key in PatientTB and same column is an foreign key to ListTB table. PatientTB contains all patient details, and ListTB consist of item that patient's purchase. The project contains two tables 1) PatientTB & 2) ListTB,
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |