i have one problem in crystal reports.i made one group with accounthead.i want to print each account head in new page.please give me the best solution for this task.
Thanks in advance,
View Complete Post
i have one problem in crystal reports
i want print group details ,for each group it should print in new page.
some thing like this
Transaction Number Date Amount Remarks
I have developed a set of ssrs .rdl reports and am trying to display them from the reportviewer control embeded in my asp web page. The problem is that when I select the print icon on the reportviewer control I am prompted to install ms sql server. I need help here. What is the best way to print .rdl reports from the web page's embeded reportviewer control to the client's local network printer.
I need some help.
If I create a Report with a Matrix Tablix (with row Groups and column groups) in landscape layout and preview it in print layout, the report generates me some extra empty page every 2nd page.
I don't understand the rule, why it's doing that.
My Report settings are:
According my Report settings this shouldn't happen, should it. The width of my Tablix is max 22cm.
What I noticed is, that when I shrink the width of my Report Body to 21 cm (to the width of the portrait layout) or less, the emtpy pages disappear.
Or when I delete the column group, it also renders the report without some empty pages.
I think this problem has something to do with column groups.
Is this a bug or am I missing a setting?
hi, i'm a new user of mvc 2, so, i need to use crystal reports on mvc 2, actually, i'm developing on visual studio 2008, but i canÃÂ´t run my reports. it's posible run my reports???
thank you very much.
Having a very wierd problem. I have an application that uses Crystal Reports and it uses what I have found to be a common scenario (I am not a CR expert in any way). I have an ASPX page that gathers options for the report, and then it goes and gets the data and if there is some, a button appears for them to launch the report. On clicking that button, the code sets some values in the HttpResponse.Context area, then performs a Server.Transfer to another ASPX page that is our Report Template. This page contains the CR stuff and it generates a PDF version of the report. It then does the following code:
With HttpContext.Current.Response .ClearContent() .ClearHeaders() .ContentType = "application/pdf" .AddHeader("Content-Disposition", "inline; filename=Report.pdf") .BinaryWrite(s.ToArray) .End() E
I am trying to print crystal repot directly from a C# application, which is calling webservice. I am able to display report in
crystalreportviewer by passing the webservice call to datasource. However, is
there anyway, I can print directly without showing the report?
Alternatively, I was trying return ReportDocument object from
webservice, which would solve my problem, but I was unable to return the ReportDocument
because of serialization issue. Is it even possible? Thank you
Whenever I open my Crystal Report page, I am taken to the Database Authentication page where I am asked for
User name Data Name Password
Is there a way to avoid this and I save these authentication in my page once.
I am using VS2005, C#.
Any Help will be appriciated.
I need to develop 3 pages.
On the first page user defines atmost 7 column names to be displayed on the report. I'm saving these names in a Sql DB table 'Columns' with Column_Nm and Column_ID as Table columns.
On the second page I'm retrieving column_Nm from the table and displaying them on the page so that the user enters the data. This data is saved in another table 'Summary' with the Columns column1 through column7.
on the 3rd page I need to show a report of 'Summary' table.
How do I dynamically replace column1 through column7 names with that of 'Column_Nm' on the report?
Any help/suggestions would be appreciated.
Hi , i am creating crystal report with asp.net it is working showing data but data is of two page its is take round trip action but report is not show until again i click on show button in this it is not propersly showing that data is how. <br /> <asp:Button ID="btnShow" runat="server" OnClick="btnShow_Click" Text="Show Report" /> <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true"
DisplayGroupTree="False" EnableDatabaseLogonPrompt="False" />
CrystalReportViewer1.ReportSource = null;
SqlCommand cmd = new SqlCommand(strcmd, c.con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ReportDocument doc = new ReportDocument();
doc.Load(AppDomain.CurrentDomain.BaseDirectory + "\\rptQuotation.rpt");
// login info
SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString);
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new Tabl
I am new to .Net and And I have absoutely no idea about crystal reports. Can anyone please let me know a step by step process of how to design and generate a crystal report in vs2005
I need to ask for start date and endate.. when selected .. i should genarte a report using the existing stiored procedure and the connection string in my web config file..
Your help willbe very much appreciated..
Crystal Reports for Visual Studio .NET provides a comprehensive reporting solution for .NET developers that is thoroughly integrated with both the Visual Studio .NET IDE and the .NET Framework. Crystal Reports supports ADO.NET, XML Web Services, and ASP.NET server controls and caching. It also integrates seamlessly with the Visual Studio .NET Server Explorer, toolbox, and design environment. It has a rich programming model and flexible options for customizing and deploying reports. These major features and others covered here take the drudge work out of data representation in your own applications.
MSDN Magazine May 2002
MSDN Magazine January 2001
A can grow field in the details section of a crystal report may have so much text that the section will be larger than the remaining space available on the page (the space below the previous record). The section has vertical lines on it with Extend to bottom of section when printing set to true. The section starts on a new page (and may continue on the following one). I want it to start on the page where the last record was laid out, and continue to the new page without leaving a gap with vertical lines on it. I'm using Crystal Reports 9 and I can't work out how to do it. Has anyone got a solution?
I am working on updating a reporting system that uses Crystal Reports. All of the 250+ reports were created in CR 8 and I have been opening up the old files in Visual Studio 2005 and updating the database location. All I have had to do with all connections to views and even a couple of stored procedures is create a new connection to the database and then update the old report's datasource location. The reason I need to update the location is so that the .NET application will use the correct driver. Everything has worked fine up until I got to one stored procedure. The old version of the report works perfectly with the stored procedure, but when I try to run the report using VS 2005 I keep getting errors.
First I connected to the database using the Oracle OLE DB provider, then updated the location of the stored procedure in the report. It then prompts me for the two parameter values for the stored procedure, both of which I keep as NULL so that the report parameters will be passed to the procedure. Then I get the following error:
Query Engine Error: 'ADO Error Code: 0x
Description: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'STORED_PROCEDURE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored'
I have been trying from the past two weeks to integrate crystal reports into my web application. The problem is "We created some reports using Crystal Reports 2008(Sp2) and we are trying to integrate those reports into webpage. Everything works fine on my local machine but when it is deployed to the production server i ran into a lot of problems..
Problem-1 : First time I load the report it comes to the screen where it prompts for DB credentials and stucks up there..I mean those are non editable and doesn't go to next screen. On my local machine the report even didn't prompt for DB credentials. Why it prompts when moved to prod'n Box? How to avoid that?
Problem-2: How about the images on parameters screen?
Can somebody please help me out with this issue..Can some body have the code for doing all these stuff
I need to generate almost 73 reports using Crystal reports using SQL SERVER. I might get more data from XML so opted ASP.NET MVC2.
I have 2 questions:
1) I have a lot of tables to generate Data Context around 35 ( I was thinking to write more stored procedures). Any help with that?
2) Is it possible to create one Report viewer/Crystal report to display these reports ( I just need to Read data by querying on input No CRUD operations)
If somebody can explain me the best process to use. Thanks in Advance.