|
i added a crystal report to my asp.net.. but when i try create an object i cant access it
i want to say: CrystalReport objRpt = new CrystalReport ();
But i cant do this..
ended up using this code:
ReportDocument rpt = new ReportDocument();
string reportPath = Server.MapPath("CrystalReport .rpt");
rpt.Load(reportPath);
rpt.SetDataSource(ds);
CrystalReportViewer.ReportSource = rpt;
CrystalReportViewer.DataBind();
CrystalReportViewer.Visible = true;
CrystalReportViewer.HasExportButton=true;
please help me.
|
|
|
|
|
Hi All
I developed one desktop application,
Will u help me to make crystal reports with sql server 2000
I use Crystal report version 8.5
So Help me to make report
Mrugesh
|
|
|
|
|
Can anyone tell me how to upload ASP.NET application with Crystal report on WEB
|
|
|
|
|
can any one help me to create crystal report in asp.net 2005 using codeing i am creating dataset manually and then want to so report
GIRISH KUMAR
|
|
|
|
|
High All, This is my first post...
Is there any way to fix height of Detail section of Crystal Report, Asp.Net 1.0. I have selected Paper size as Recipt 10 * 6 from Designer > Printer Setup...In fact of all these formatting the detail section shows a lot of blank spaces...I have added a dummy blank section and set it New Page After property to true...but then that does not work when project is deployed on web....Please Help me out from this problem....Hoping for some immediate Help...
|
|
|
|
|
Hello everybody,
how to pullish DHTML Button in asp.net.
Its need urgently to my project.
If anybody have the knowledge about this,please help me
|
|
|
|
|
Hi everyone. I am an ASP programmer, but i have never played with crystal reports never realy needed to until now. I am wandering how to post the values from ASP to crystal report already set up. I have set up a report using my database on SQL Server, and now i would like to open this report from within my project, and filter it by values of Identifier sent from the same project.
Is this posible, and can someone give me a pointer or two.
Thanks Folks.
|
|
|
|
|
Dear Sir
I have deveoped report and .aspx page according to the this article direction
more than 5 times but all the time when going to running .aspx page raised an error "PAGE LOAD FAILED" and stack trace as follows. Please help me solve this an error .My e-mail is derrickl@unitedmotors.lk
Load report failed.
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.LoadSaveReportException: Load report failed.
Source Error:
Line 50: ds.Tables.Add(table);
Line 51: // set report's dataset
Line 52: report.SetDataSource(ds);
Line 53: // set report source
Line 54: CrystalReportViewer2.ReportSource =report;
Source File: d:\dotnetproject\odpnetws\src\report\webform1.aspx.cs Line: 52
Stack Trace:
[LoadSaveReportException: Load report failed.]
. F(String , EngineExceptionErrorID
) +273
. B(String , Int32 ) +64
CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String reportName, OpenReportMethod openMethod, Int16 parentJob) +1158
CrystalDecisions.CrystalReports.Engine.ReportClass.Load(String reportName, OpenReportMethod openMethod, Int16 parentJob) +515
CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSource(Object value) +283
report.WebForm1.Page_Load(Object sender, EventArgs e) in d:\dotnetproject\odpnetws\src\report\webform1.aspx.cs:52
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
thanks
Derrick Lasantha
-- modified at 6:13 Monday 12th March, 2007
|
|
|
|
|
Is there a method to use a DataSet with variable structure(variable number of columns) as source for a Crystal Report?
|
|
|
|
|
In crystal reports 9.0 it was not possible i guess. but i think in latest version it might be.
Omkar Bhave
ygg
|
|
|
|
|
This is a great sample.
However I do have some problems. I created this sample using VS 2005 via a new ASP.NET web application. However when I run the application, the icons do not appear.
However, if a virtual directory is created on IIS and run on http://localhost, the icons appears.
Also, when I create a web site (not a web application), icons do appear on the report.
Another bug I found is when going to the next page, it only goes up to page 2. But when the page number is typed, it goes to the correct page.
Has anyone encountered these problems. Hope you can help me. Thanks.
|
|
|
|
|
Create a virtual directory "CrystalReportWebFormViewer2" under your web site and point it out to "C:\Program Files\Microsoft Visual Studio .NET 2003\Crystal Reports\Viewers\" or corresponding path of VS 2005
Regards,
Sylvester G
|
|
|
|
|
sir,
My id is prabodh_bansal1@yahoo.com.
I do get the same problem ie when crystal report 11 is run i do not get icons.
Can you please help me in this regard.
I need to get icons on iis, web site or project in both cases.
Thanks and Regards
Prabodh Bansal
prabodh
|
|
|
|
|
-Regarding above i got no problem and success to created a crystal report, it only row of data to display.
- now i using query to store data into variable and using while root to dipslay by using above feature , is it possible ? can give me some source ?
or other opinion for me , please very urgent
- e.g.
strSQL = "SELECT a.r_materials_num,a.r_batch_num, a.r_des,a.r_UOM,a.r_exp_date ,(select sum(r_QTY) FROM tblreport_1 where r_situation = '" + "In" + "' and r_materials_num = a.r_materials_num and r_batch_num = a.r_batch_num ) as totalIn , (select sum(r_QTY) FROM tblreport_1 where r_situation = '" + "Out" + "' and r_materials_num = a.r_materials_num and r_batch_num = a.r_batch_num ) as totalOut FROM tblreport_1 a where a.r_situation = '" + "In" + "' GROUP BY a.r_materials_num,a.r_batch_num,a.r_des,a.r_UOM,a.r_exp_date "
PublicFunc.DR = DataHandler.GetDataReader(PublicFunc.strSQL, PublicFunc.strConn)
While DR.Read()
viewstate("r_materials_num") = Trim(PublicFunc.DR("r_materials_num").ToString)
viewstate("r_batch_num") = Trim(PublicFunc.DR("r_batch_num").ToString)
viewstate("r_UOM") = Trim(PublicFunc.DR("r_uom").ToString)
viewstate("r_des") = Trim(PublicFunc.DR("r_des").ToString)
viewstate("r_exp_date") = Trim(PublicFunc.DR("r_exp_date").ToString)
viewstate("totalIn") = Trim(PublicFunc.DR("totalIn").ToString)
If PublicFunc.DR("totalOut").ToString = "" Then
viewstate("totalOut") = 0
Else
viewstate("totalOut") = Trim(PublicFunc.DR("totalOut").ToString)
End If
keepOUT = viewstate("totalOut")
keepIn = viewstate("totalIn")
KeepQTY = keepIn - keepOUT
If KeepQTY <> 0 Then
Response.Write(" ")
Response.Write("")
Response.Write(viewstate("r_materials_num"))
Response.Write(" ")
Response.Write("")
Response.Write(viewstate("r_des"))
Response.Write(" ")
Response.Write("")
Response.Write(viewstate("r_batch_num"))
Response.Write(" ")
Response.Write("")
Response.Write(KeepQTY)
Response.Write(" ")
Response.Write("")
Response.Write(viewstate("r_UOM"))
Response.Write(" ")
Response.Write("")
Response.Write(viewstate("r_exp_date"))
Response.Write(" ")
Response.Write("")
Else
End If
End While
- i want use those display result to display on crystal report it is possible ?
email beginhs@gmail.com
regds
begin
|
|
|
|
|
Hi
I went through your code but was unable to get this line of code in your code.
CrystalReport1 report=new CrystalReport1();
I performed a different steps in my project for the dataset which gets generated on runtime.
Now i take a blank report .rpt file as u specified in your explanation.
but when i trying to write the CrystalReport1 report=new CrystalReport1(); code
my intellisense doesnt shows me the reference of CrystalReport1
My .rpt file name is CrystalReport1.rpt.
can u give me explanation for the above scenario.
Waiting for reply
Thanks in advance
-- modified at 2:35 Tuesday 18th July, 2006
|
|
|
|
|
How can i pass datas from textboxes to crystal report
|
|
|
|
|
I did exactly the same thing which you mentioned in the above article in VB.NET.
All the initializations which you did in the PageLoad() function were done in the Initialization() function of the Form.
But now when I bind the Dataset into a DataGrid, it shows the data but when I bind it with the Crystal Report a logon window pops up asking me the data source and server name with login and password for the source of this report (even when I have clearly mentioned the source and login information using the SetDataSource and SetDatabaseLogin functions)
Any Ideas why?
crap learner !
|
|
|
|
|
Dear sir
i want to use keyup in datagrid
how to do that
Plz.. urgently req..
thanks..
|
|
|
|
|
Dear sir,
I want to use crystal report in asp.net..
with Chart..
Urgently req..
Thanks..
|
|
|
|
|
Hi All,
I'm trying to call a Crystal report 11 (Sample.rpt) generated from Stored procedure from my aspx page (Sample.aspx). When I scroll to next page using the next button in the Crystal report viewer, it is taking more time. Then I found that it is executing the stored procedure and displaying the next page. Why is it. But if we run the report preview from Crystal reports there is no such an issue for scrolling. Please help.
My aspx code is given below. I'm missing something. Your help is greatly appreciated.
<%@ Page language="VB" %>
<%@ Register TagPrefix="cr" Namespace="CrystalDecisions.Web" Assembly="CrystalDecisions.Web" %>
Sub Page_Load(s as Object,e As EventArgs)
If not isPostBack then
Dim sRptName as string
sRptName="Sample.rpt"
CrystalReportViewer1.ReportSource=Server.MapPath(sRptName)
CrystalReportViewer1.DisplayGroupTree = False
CrystalReportViewer1.HasRefreshButton = True
End If
End Sub
<cr:crystalreportviewer id="CrystalReportViewer1" style="Z-INDEX: 102; LEFT: 222px; POSITION: absolute; TOP: 80px"
="" runat="server" autodatabind="true" width="445px" height="947px">
|
|
|
|
|
How i can use 'push method' without 'add DataSet from solution explorer'?
In case when DataSet already created and initialized from code.
Thanks in advance.
|
|
|
|
|
I had a hairy SQL statement which I would never be able to build with CR, the last resort was to code the report by hand until I sussed the SetDataSource method, the glue missing was the XML schema which I needed to create, once that was done, it worked like a charm. Thanks for the aricle.
My Blog ^
|
|
|
|
|
CrystalReport1 report=new CrystalReport1();
CrystalReportViewer1.Visible=true;
report.SetDataSource(Ds.Tables[0]);
CrystalReportViewer1.ReportSource = report;
I have above code to fill report, when i run first time it did not fill the report. I went to solution and create a CR report. Connect the database from server explorer and get the table and drag the col that i want on the report. and worked fine.
If i do this whats do use of the DS. How DS releated to the report. Is this the way doing this. My DS already have the data. How come its not showing with out plugging the data from server solution.
Am i doing this wrong. seems like there is two connection and tow data.
DS and report
is this the way to do push?
|
|
|
|
|
How to connect crystal report file in ASP.Net using C# language during runtime to generate the report
|
|
|
|
|
This would seem to be straightforward but is not (for me at least!) I'm creating a report in a separate *aspx page, and the display is always centered (or more toward the far right of the page. I want to have the display left justified .... have tried on the page holding the crystal report viewer, putting review control in table, going through the .Net crystal report form, all to no avail.
|
|
|
|