Crystal Reports :: CR Grouping And Columns?
Apr 22, 2010I'm using CR that included in VS 2005. I have a Dataset of Phone Extenions that I pass to Crystal Reports then exports it to a PDF for printing.
View 9 RepliesI'm using CR that included in VS 2005. I have a Dataset of Phone Extenions that I pass to Crystal Reports then exports it to a PDF for printing.
View 9 RepliesI have a Cystal Report with Group field "category". I want to enable/disable grouping in crystal report from code behind.I want to do something like this
[Code]....
Acually user will decide if grouping is required or not by clicking on checkbox
How to display more than 20 columns in a crystal report.
In .Net Crystal report how can I display over 20 columns? I can use not more than 10 columns.
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 have a crystal report which accepts a parameter and gets displayed on a webpage abc.aspx
On another webpage i have a grid displaying columns from a table loan_request.
When I click a row in gridview I want to get the report of that corresponding row.
I used rowcommand on gridview to get the value that uniquely identifies the row in a gridview, now I need to pass this value as parameter to the crystal report.
for this i think two possibilities
1. pass the value as querystring.
2. store it session and use it on the page that display the report.
I don't want to use query string.
for better understanding. once look at the code.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Request_Log_Search_Sort.aspx.cs" Inherits="WebApplication1.Request_Log_Search_Sort" %>
<%--<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>--%>
<%@ Register Assembly="CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
[Code].....
I'm trying to create dynamic columns in the Crystal Report. The parameter fields are named column1,column2,column3.....
I tried below code and it gives me an error "The parameter is incorrect".
[Code]....
Is there any way to solve (by coding) if there comes extra columns in excel sheet at the time of downloading.
if (repDS.Tables[0].Rows.Count > 0)
{
Rpt.Load(Server.MapPath(ReportPath));
Rpt.SetDataSource(repDS);
pnlReport.Height = 500;
CrystalReportViewer1.ReportSource = Rpt;
CrystalReportViewer1.DataBind();
}
I'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 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.
Crystal 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 want to develop some crosstab also know as pivot reports in Asp.net with x-axis and y-axis being dynamics, allowing grouping by row and column, for example: have products in y-axis and date in x-axis having in body number of sells of a given product in a given date, if date in x-axis are years, i want subtotals for each month for a product (row) and subtotals of sells of all products in date (column)
I know there are products available to build reports, but i am using Mysql, so Reporting Service is not an option. It's not necessary for the client build additional reports, i think the simplest solution is having a control to display such information and not using crystal report (which is not free) or something more complex, i want to know if is there an available free control to reach my goal.
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?