How to set paging in crystal Report?
I want to set paging in a very simple way (unlike Gridview). Might be from code behind or inside Crystal Report viewer tag in .aspx page but in a very simple way as I am very new to crystal Report.
.rdl file in asp.net crystal report.Data is displaying vertically in the report, when i filter on the date field.
1. I need paging in this.paging is not working.when i click on paging,a authentication window opens and after ths fill,all data comes on the report with out filter.
i have a load report on asp page
i have load report on button click
but when i click on next navigation button
then it gives me error with popup
"No valid report source is available."
my code is:
protected void Button1_Click(object sender, EventArgs e) { GetData();
}
private void GetData() {
SqlConnection connection = new SqlConnection(strcon); SqlCommand command = new SqlCommand("Select * from demoforreport WHERE role='" + TextBox1.Text + "'", connection); SqlDataAdapter adapter = new SqlDataAdapter(command); DataSet dataset = new DataSet(); adapter.Fill(dataset, "demoforreport"); ReportDocument CustomerReport = new ReportDocument(); CustomerReport.Load(Server.MapPath("CrystalReport.rpt")); CustomerReport.SetDataSource(dataset.Tables["demoforreport"]); CrystalReportViewer1.ReportSource = CustomerReport; CrystalReportViewer1.DataBind(); }
When i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.
View 2 RepliesI'm using Visual Web Developer 2010 Express, and I'm at the point in my web application where the data from my database (SQL Server 2008 express) needs to be put in a nice format. So I decided that I want to use Crystal Reports, and I see some online tutorials on how to implement them in ASP.NET/VWD, but I don't see any way to create a .rpt file or add any instance of Crystal Reports into my application. How does this work? What exactly do I need to configure/setup so that I can use Crystal Reports in my web application and just in general, Visual Web Developer?
View 4 RepliesI'm new to Visual Studio.NET . I need to integrate the crystal reports into an ASP.NET application. I generated Crystal report with the help of crystal report XI developer edition(Stand alone version and NOT from the one which comes from visual studio).
How to integrate this report with the web application.
We have quite a few reports which were developed earlier in Crystal Reports 8.5. We are now planning to use these reports in our web application developed in VS 2008 (C#).
What dlls are needed for calling 8.5 in the application and how should they be added to the application while shipping it to the client?
They are also struggling to get the code running. Would also need the code to call the report with parameters.
I have already generated crystal reports but i've made them static. but now i want to make the user to select the criteria for generating the reports. for eg., in one of them i want to show monthwise data so user should be able to select the month and year and that would be passed as parameter and compared to the existing data. provide me with proper exact code that can be used for giving parameters in such a report using C#.
View 3 RepliesIn my system Visual studio 2008 with sp1 and Crystal Reports XI Release 2.In Visaul studio 2008 ,while adding add reference it showing crystal reports version 10 instead of 11.How to solve the version problem.
View 1 RepliesI am considering using Crystal Report 2008 as my tool of creating reports on my webpage.The only problem which I'm facing is that I have no control of the remote server which hosts my site (besides uploading files). I can't run a MSI to deploy the CR runfiles.I can't find anywhere in the CR user manual of how to deploy the runtime files without running the msi, and I'm not even sure it's possible.Have anyone deployed CR 2008 without running the MSI and without having to register any files?
View 8 RepliesI have a field in my dataset with type nvarchar(1000). when I link it to crystal reports, it converts it to a field of type string with length set to 100. As a result of that, the string in that field is being truncated on the report. How can I increase the string length to 1000? (I already checked the "Can grow" option).
View 3 Repliesiam really new to Crystal Report XI Release 2..iam using multiple subreport in mainreport and onclick of particular subreport it would list out all items related to it..for example if u have customer chart(subreport) in mainreport and onclick of this it would list all customer on demand and subreport is binded and onclick of single customer it would list out single customer which sholud be passed as parameter it would get customer(full Contact details) in another subreport.if this can be done. how it can be done and explain in steps how it can be and if possible with screen shots
View 3 RepliesI have developed few crystal reports using VS.2005 and now i want to deploy the same on my web server which is running Windows 2003 server and got installed only .net frame work 2.0.... so now i want to know how can i run those reports successfully and i have downloaded CRRedist2005_X86.msi and even crXIsp3 and 4 _net_server from business objects page and i do have Crystal Reports XI original CD.... while by using them can i run crystal reports on my web pages.
View 1 RepliesI want report generted based on value from querystring.
View 3 RepliesCrystal
Reports Error when publishing a Website on to the Web Server---- The type initializer for 'CrystalDecisions.Shared.CrystalReportClientScriptManager' threw an exception
I'm working on a site that ws developed using VS 2005 and the server where the site is running has Crystal Reports for .net 2.0 (ver 10.2.36)I will be making changes. I just ported the website to my local computer, and build the site using VS 2008, that comes with Crystal R. Basic.I haven't tested all the functionality of the site, so I'm not sure since all the pages that use C. Reports work ok.My main concern is about publishing the site I compiled to the server. Will things work, if I have Crystal R. Basic and the server has Crystal R. for .net 2.0.
View 2 RepliesI'm getting the "Load Report Failed" Error.
I have a web application designed using VS2008 & Crystal Reports for VS2008 (Ver. 10.5.3700). I'm using Framework 2.0 for deployment.
My development system is WinXp and my deployment system is Win2003 Server.
Here is what i have done -
1) Added a Crystal Report to my project "rptReport.rpt"
2) Added a Crystal Report Source (crSource) to my .aspx page.
3) Added Crystal Report Viewer to my page, with crSource as its Report Source.
This works fine when i run it on my development machine. But Gives a "Load Report Failed" error on my deployment machine.
This is what i have already tried doing on deployment server:
1) Giving IIS_WPG full control to temp folder.
2) Publishing with "Allow this precompiled site to be updatable." checked/unchecked.
I'd like to implement a custom paging template for my formview that displays numeric paging as well as next/previous buttons. The pre-defined templates only appear to have numeric first last as an option. Can anyone recommend a good article that covers this?
View 2 RepliesCrystal reports are properly working on my local pc but not on server. I am using vs 2008 and install crystal report for Visual basic 2008 on server.but parameter count for CrystalReport is zero on server.
CrystalReportViewer.ReportSource = Session("Rpt" & Request.QueryString("ReportGroup") & Request.QueryString("ReportCode"))[code]....
I have a requirement to generate Dynamic Crystal Reports.I am a new bea of Microsoft .net.
View 2 RepliesWe have an old server (Win Server 2003/ IIS) that makes use of an old version of Crystal Reports for asp.net pages. I'm making a new server (Win Sever 2008 SP2/ IIS 7) that will be the replacement for the old server. I have asp.net apps working, but since I can't use the old Crystal reports install, the new one isn't doing anything for me.After installing CRRedist2008_x86, it shows some files in:
C:inetpubwwwrootaspnet_clientsystem_web2_0_50727CrystalReportWebFormViewer4
andC:Program FilesBusiness ObjectsCommon2.8inAre there any special configurations I have to do in IIS to get asp.net to recognize this stuff? Right now, I'm getting nothing.
why does my crystal reports not loading on the server
View 4 RepliesI'm new to Crystal Reports and am just trying to add some simple reports to my web application. In the non-report pages I've been using SqlDataSources to retrieve data from the database and would like to do the same for the report pages. I saw a tutorial that indicated I could do this by explicitly setting the data source for the report in the Page_Load callback of the ASPX page as shown below:
[code]...
Is there a way to create "bound" fields w/o a database, since I'll be specify the database at runtime? Or is there a way to create the ".rpt" file w/ unbound fields, that get "bound" at runtime?Or is there a better way to do this altogether?
I have requirement that have to add header and footer into 50 over reports. So I dont want to change one by one.
Is there a way to create master page header and footer and used it in multiple reports?
I have two reports but i want to use the same crystal report viewer to display both reports depending on an option selected. How can I achieve this?
CrystalReportViewer.setCrystalReportSource(CrystalReportSource3) or something like this i am just not sure about the code in c#