Last post Jul 16, 2013 03:50 AM by Ajay2707
Jul 16, 2013 01:51 AM|Rajkumartag|LINK
I have created Crystal Report in vb.net 2010 and crystal report version is 13.0.2000.0.
I want bind 500 reports in my crystal report.But bind only 40 records in first page.I am not able to see second page.So I want bind and see 500 reports in Single Crystal Report. I have attached my code in this mail. Please check and tell me any one solution.
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" />
<CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
Dim con As New SqlConnection("Server=CMSCSGPC107;Database=CL_001382007;User Id=sa;Password=sql2005;")
Dim objDA As SqlDataAdapter = Nothing
Dim objcmd As New SqlCommand("SELECT I.STATUS,ITEM_CODE,I.DESCRIP as [Item_Descrip],G.CODE as [Group_Code],G.DESCRIP as [Group_Descrip] FROM TM_ITMPRD I,TM_GROUP G, TM_SUBGROUP SB WHERE I.MAST_TYPE = 'PRD' AND I.MAST_TYPE = G.MAST_TYPE AND I.GROUP_CODE = G.CODE
AND I.MAST_TYPE = SB.MAST_TYPE AND I.SUB_GROUP = SB.SUB_CODE", con)
objcmd.CommandTimeout = 0
Dim DS As New DataSet1()
objDA = New SqlDataAdapter(objcmd)
CrystalReportViewer1.Visible = True
CrystalReportSource1.Report.FileName = Server.MapPath("~/Crystal Reports/CrystalReport1.rpt")
CrystalReportViewer1.ReportSource = CrystalReportSource1
Jul 16, 2013 02:01 AM|Ajay2707|LINK
Are you want 500 reports or 500 records show from single crystal report? I think second you want.
So the issue is your page size. Also check your query , run in sqlserver side and check how much rows comes. Please check this link.
Jul 16, 2013 02:36 AM|Rajkumartag|LINK
Already i checked my datatable 500 Records is there. My problem is i am not able to see more than one page.
How to i will see second,third,...etc pages.Can i change any setting in crystal report.
Jul 16, 2013 03:50 AM|Ajay2707|LINK
please check this link, http://vbcity.com/forums/t/134575.aspx. For crystal report , you just give datatable and paging automatically done as per page size you define ( by default it is A4 , you can
change file-> print option -> page -size)
My suggestion is to create a report with stored procedure , because you know what you pass and also check which result will display.
It not takes too much time, so create new one as this link. or you can try new one.