|
If the report having a sub report, how can I do? How to push the dataset into the sub-report. Thanks.
|
|
|
|
|
This is a great article for anyone who wants to learn how to create reports with Crystal Reports, as I did with this simple and great article.
Since then however, I have developed a deep hate towards Crystal Reports.
Even thou I have never made such statement in public before, I can just say how glad I am to get this off my chest. Because the only thing this product have given me the last month or so is sorrow and nervous breakdowns. If I was living in the US, I would sue the muther f***er who is responsible for this software.
My advice to any of you who even consider doing any report that requires more then five bindings to a single datatable, for your own sanity sake do not use Crystal Reports. For small applications like the one used in this tutorial you may even like it.
I stand by my statement, feel free to flame me but I doubt anyone will because I beleive that there are alot of peoples out there that need counceling after they have used this frustrating tool.
--------------------------------------------------------------
This is where you send your flames: Fredrik Andersson
|
|
|
|
|
Hello ,
I make SeparatePages property of crystal viewer false. So that all crystal report pages appear in one asp.net page. But what happens is, my page design shows only for one page hight and the content goes beyond page design. So basically content does not fit into the asp.net page at run time.
What can be the solution of this problem.
Please let me know if you want more information.
Best Regards
|
|
|
|
|
Hi,
Can anyone provide the solution for following error.
CrystalDecisions.CrystalReports.Engine.DataSourceException: Query Engine Error:
Some of the reports are displayed properly. For some it's giving this error.
Order and type of parameters passed are just perfect and so is the location of report.
I dont know where's the problem..
Plz reply asap.
Thanks in anticipation
|
|
|
|
|
Using pull method i can display the image in the crystal report. this can be done by using the subreport.
But when we are using the push method, how is it possible to use sub report ...?
or is there any other method by which i can display the image on the report.
Regards,
Sandeep Patel
|
|
|
|
|
When i am using one datasource, the reports are working fine ... but i want to use 2 datatables.... is it possible..
sqlConn = New SqlConnection(ConnString)
Dim strSql As String
sqlcommd = New SqlCommand
' sqlcommd.Parameters.Add("@quantity", TextBox2.Text)
sqlcommd.Parameters.Add("@EmployeeID", TextBox1.Text)
sqlcommd.CommandText = "USP_Report"
sqlcommd.CommandType = CommandType.StoredProcedure
sqlcommd.Connection = sqlConn
daObj = New SqlDataAdapter
daObj.SelectCommand = sqlcommd
dsObj = New DataSet
daObj.Fill(dsObj, "Emp")
crpt.Visible = True
cr.Load(Server.MapPath("crpt.rpt"))
cr.SetDataSource(dsObj.Tables("Emp"))
cr.SetDataSource(dsObj.Tables("orders"))----- can this be added
crpt.ReportSource = cr
Regards,
Sandeep Patel
|
|
|
|
|
I was bulid a project buy following this mothed. however, I get a error..
please help me out.
----------------------------------------------------
Error in File C:\DOCUME~1\TEPC402\ASPNET\LOCALS~1\Temp\temp_198f502c-275c-44a1-88a4-89a648a75696.rpt: Unable to connect: incorrect log on parameters.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnException: Error in File C:\DOCUME~1\TEPC402\ASPNET\LOCALS~1\Temp\temp_198f502c-275c-44a1-88a4-89a648a75696.rpt: Unable to connect: incorrect log on parameters.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[LogOnException: Error in File C:\DOCUME~1\TEPC402\ASPNET\LOCALS~1\Temp\temp_198f502c-275c-44a1-88a4-89a648a75696.rpt:
Unable to connect: incorrect log on parameters.]
.L(String , EngineExceptionErrorID )
.G(Int16
, Int32 )
.F(Int16 )
CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestContext reqContext)
CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestContext pageReqContext)
CrystalDecisions.Web.ReportAgent.{(Boolean C)
CrystalDecisions.Web.CrystalReportViewer.OnPreRender(EventArgs e)
System.Web.UI.Control.PreRenderRecursiveInternal()
System.Web.UI.Control.PreRenderRecursiveInternal()
System.Web.UI.Control.PreRenderRecursiveInternal()
System.Web.UI.Page.ProcessRequestMain()
nan
|
|
|
|
|
This is another Crystal Reports Bug... install last service pack... from this location
http://support.businessobjects.com/fix/downloads_updates.asp
|
|
|
|
|
How can I read ahead in the database... I need to get integer values from the database several rows below the current row that crystal reports is on
|
|
|
|
|
may want to mention that I am using Crystal Reports .NET (~CR9) in VS.NET 2003. THe database is stored inside a dataset. The database itself is a MS Sql db
|
|
|
|
|
How to print Crystal Reports in Web-Based application??
I was born intelligent Education ruined me!.
|
|
|
|
|
This code can help u print the report
Private Sub lnkPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lnkPrint.Click
Dim crExportOptions As ExportOptions
Dim crDiskFileDestinationOptions As DiskFileDestinationOptions
Dim strFileName As String
Try
' Create temporary file to send it to the client
strFileName = Request.PhysicalApplicationPath + "Exported\"
If Directory.Exists(strFileName) = False Then
Directory.CreateDirectory(strFileName)
End If
strFileName = strFileName + Session.SessionID.ToString & ".pdf"
crDiskFileDestinationOptions = New DiskFileDestinationOptions
crDiskFileDestinationOptions.DiskFileName = strFileName
crExportOptions = RptDoc.ExportOptions
With crExportOptions
.DestinationOptions = crDiskFileDestinationOptions
.ExportDestinationType = ExportDestinationType.DiskFile
.ExportFormatType = ExportFormatType.PortableDocFormat
End With
RptDoc.PrintOptions.PaperOrientation = PaperOrientation.Landscape
RptDoc.Export()
' The following code writes the pdf file to the Clients browser.
Response.Clear()
Response.ClearContent()
'Response.ClearHeaders()
Response.ContentType = "application/pdf"
Response.WriteFile(strFileName)
Response.Flush()
Response.Close()
' delete the exported file from disk
System.IO.File.Delete(strFileName)
Catch ex As Exception
HandleException(ex, Err.RptPrintFailed)
End Try
End Sub
Regards,
Sandeep Patel
|
|
|
|
|
Dear Sandhep patel,
Where the reference "ExportOptions" come from ?
thx
|
|
|
|
|
Add this to ur code
Imports CrystalDecisions.ReportSource
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Imports CrystalDecisions.Web
Problem will be solved...
Regards,
SAndeep
|
|
|
|
|
Directory not declared
what is rptdoc????
Actually i am exporting crystal report to pdf but it is show an following error during export
Error in File C:\WINDOWS\TEMP\temp_d0912936-dbb3-4b2f-a54c-b63bf29cccd9.rpt: Operation not yet implemented.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NotSupportedException: Error in File C:\WINDOWS\TEMP\temp_d0912936-dbb3-4b2f-a54c-b63bf29cccd9.rpt: Operation not yet implemented.
Source Error:
Line 197: DiskOpts.DiskFileName = strFilePath
Line 198: rpt.ExportOptions.DestinationOptions = DiskOpts
Line 199: rpt.Export()
Line 200: obj1JavaScriptClass.OpenPDFFile(Me, "Output.pdf")
Line 201:
|
|
|
|
|
When I saw the header of this article I thought it may help me with the functionality i'm looking for.
I'm going to create a report at runtime, let the user select a bunch of fields, create the dataset on the fly and pass it to the report and show it. Sounds simple doesn't it?
/Håkan N.
------------------------------------------------
- Bachelor in systems analysis 1991
- Systems developer, C#, Java, C, VB3-6
- DBA, database design, SQL, admin
------------------------------------------------
|
|
|
|
|
Hi. I'm using VS.NET 2002 and RAS to make some reports. I want to use the push method to implement these reports.
But when I am trying to push a dataset that has a image column into crystal report, an error always displays:
"System.ArgumentException: Type System.Byte[] can not be marshaled as an
unmanaged structure; no meaningful size or offset can be computed"
It almost makes me mad,I don't know how to resolve this problem!
Pls help me! Thanks!
|
|
|
|
|
hi,
i am doing a project wherein i need to connect mysql database with asp.net & then generate crystalreports.
i have already made the connection & it works fine with my first page set up.i need to take an item from the drop down list which i populated from myfirst webpage & then generate a crystal report for the same.the drop down list is being populated from the database which is myfrist page.later i need to bind this to a crystal report.
i am doing it with the push model.intially i select a dataset item & then try to drop table from mysql database.it gives me an error stating that the wizard detected the following problem when configuring the data adapter for "table name"
error in select clause :expression near""
error in from clause :near""
unable to parse query text.
when i do the same that is drag & drop with a diferent database that is sqlserver 2000 i don't face any such problem.
would like to know that the push model that u have dissuced is not applicable for generating a dataset for mysql database.
when i found that your method of generating a dataset did not work i draged and droped a dataadapter from the tool box and then generated a dataset .but i feel that i am conflicting the push method mentioned by u.because i am again writing the code for it in the form .when i do this i get an error stating that the "pop up window is blocked".
let me know what is the right way of generating a crystal report from mysql databse using a dataset.
thanks,
saira
|
|
|
|
|
I use VB.NET...
When I drag/drop a crystalreportviewer,.... it doesnt create this...
protected CrystalDecisions.Web.CrystalReportViewer CrystalReportViewer1;
What should be there??!!??
Finally.. how to go with the report source etc... please tell me..
I was born intelligent Education ruined me!.
|
|
|
|
|
I got to see that in the 'designer generated code'...
Now... how to go with this and the following in 'VB.NET' then...
CrystalReport1 report=new CrystalReport1();
I was born intelligent Education ruined me!.
|
|
|
|
|
finally, I thought I figured out something and then... resulted in this error... please help...
CrystalDecisions.CrystalReports.Engine.DataSourceException: Query Engine Error: 'C:\DOCUME~1\KUMAR\ASPNET\LOCALS~1\Temp\temp_48601739-54fc-48c6-9fce-e9df2d49c2d3.rpt'
I was born intelligent Education ruined me!.
|
|
|
|
|
Hi do you how can i disapear the crystal report logo. I need to eliminate this logo in my asp.net web reports, hope you can help
Thanks
|
|
|
|
|
I am just starting Crystal Reports... so, lemme give u the idea I use....
Go to this folder of the PC / server from where ur ASP.NET app runs...
C:\Program Files\Microsoft Visual Studio .NET 2003\Crystal Reports\Viewers\images\ToolBar
Here is where the pictures for the toolbar is set... you can edit / change the pictures. Just put a black transparent picture there to solve the problem!!
Will post info, if I found the actual method to replace the logo... lemme know if you found another method for the same!!
I was born intelligent Education ruined me!.
|
|
|
|
|
You can set the HasCrystalLogo property of the Crystal Viewer to false.
You either do it in the properties window for the viewer (in Design view) or programmatically in the code behind.
|
|
|
|
|
In Crystal Reports for Visual Studio .NET (2002 and 2003) HasCrystalLogo property don't exists... you can buy Crystal or modify logo image or hide all toolbar...
|
|
|
|