Title:
show me the blank report
Name:
Deep
Date:
2006-02-15 4:52:08 AM
Comment:
hi,
it's nice matirial but it ca't be display the field of database in crystal report . so tell me the process how i see database content on crystall report at run time.
tank you
|
Title:
Always getting Logon failed error
Name:
Shikhar
Date:
2006-02-08 3:54:04 AM
Comment:
This is my 6th day working with Cryatal Report but still iam getting LogOnfailed error.Plz any body can help me.its urgent
|
Title:
CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
Name:
Gaya
Date:
2006-02-08 12:19:39 AM
Comment:
Why am I getting this logon failed exception when I export the report generated by PUSH?
Logon 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.LogOnException: Logon failed.
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: Logon failed.]
.F(String , EngineExceptionErrorID
)
.A(Int16 , Int32 )
.@(Int16 )
CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestContext reqContext)
CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestContext pageReqContext)
CrystalDecisions.Web.ReportAgent.u(Boolean N)
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()
|
Title:
Populate dataset
Name:
Sona
Date:
2006-02-06 6:20:10 AM
Comment:
Using push model, how can I populate the dataset and feed it to the Crystal Report? Pls give the code for it.
|
Title:
help me please
Name:
joy
Date:
2006-02-01 10:20:56 AM
Comment:
first of all i want to thank you for this article it is very helpfull and has a very good information.
i have this problem with Crystal when i'm trying to export it to PDf and it gives me this error "The file is damaged and could not be repaired" do you know how to solve this problem it is urgent and i will be very appreciated.
regards
|
Title:
<@ Register tagprefix ="cr" getting crystaldecision.web as invalid
Name:
Benjamin
Date:
2006-01-25 2:42:29 AM
Comment:
When I am running a crystal report in visual studio.net 2005 I am getting an error in the <@Register > statement where it says crystaldecision.web as invalid
|
Title:
Error on logon failed
Name:
venkatesh
Date:
2006-01-20 7:11:51 AM
Comment:
I have got one problem when i am using crystal report.that is logon failed .
i don't know why it appears
i have used asp.net/sqlserver
my mail id = mcanetvenkat@hotmail.com
|
Title:
Export Crystal reports into rpt file
Name:
Dima
Date:
2006-01-19 9:30:34 AM
Comment:
Hi,
Yeas, you can save report with data. You can select file and then “save data with report” after that save the report and then can you export report s into rpt with data .
Good Luck!
|
Title:
Crystal Report
Name:
Dima
Date:
2006-01-19 7:35:48 AM
Comment:
I have a graph in crystal. The search criteria is year and week. I want to result 20 weeks back in year 2005 also. If I write week 2 so i am take a results only week 1 and 2. Can you help me pleas how can i do.
I have search criteria now:
{@week}>=({?week}-19)and
{@year}= {?year}
|
Title:
Export Crystal reports into rpt file
Name:
Shan
Date:
2006-01-18 5:13:06 AM
Comment:
Can we export Crystal reports into rpt with data?
Thanks
|
Title:
LogOn error Solution
Name:
alz
Date:
2006-01-17 5:49:39 PM
Comment:
Try this:
1. Go to SQL Server Enterprise Manager / Security / logins / new login.../General / Name /
2. Add account - ASPNET(account for running the ASP.NET), you can change login properties according your needs
3. Add DataBind(); in page_load
Good Luck!
|
Title:
sql join
Name:
minto
Date:
2006-01-17 11:33:19 AM
Comment:
not working if the query is a join
|
Title:
loadsavereportexception
Name:
thangaraj selvam
Date:
2006-01-12 5:35:24 AM
Comment:
CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: It failed in the load of the report.
in pull method it specifies the given line
crreport.SetDatabaseLogon("sa", "")
in push method it specifies the given line
oRpt.SetDataSource(myDS)
|
Title:
Error
Name:
Richard
Date:
2006-01-06 12:59:53 PM
Comment:
When I try to add the control to the web form I get a gray box with red letters saying "Error Creating Control CrystalReportViewer1". I have VS .NET 2003 with Crystal Reports XI. Any ideas?
|
Title:
push model export to pdf
Name:
vipin
Date:
2006-01-02 2:56:44 AM
Comment:
hi all,
how we export the crystal report usinh push model?
send me code in devs_vipin@yahoo.co.in
thanks in advance
|
Title:
login failed error at myReport.Export()
Name:
vipin
Date:
2006-01-02 2:41:44 AM
Comment:
hi,
happy new yaer to all
very good article,but in exporting to pdf make some problem.
login failed error at myReport.Export()
the error is
CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
what i do?plz send an immediate solution to devs_vipin@yahoo.co.in
with regards
vipin
|
Title:
LogOn Error
Name:
Steve O
Date:
2005-12-31 11:26:49 AM
Comment:
I have tried every method to correct the log on error that everyone is getting including those posted here and on MSDN. I still get the error.
I have concluded as I had in the past when using Crystal Reports that the reason for this problem is that Crystal Reports sucks. It has always sucked, and will probably suck into the future.
Hope this helps.
|
Title:
An excellent article
Name:
Avi
Date:
2005-12-30 6:17:59 AM
Comment:
When I started to work with crystal report I read
this article and for my first step working with crystal report it was graet.
|
Title:
setting background image
Name:
roy
Date:
2005-12-27 3:39:51 AM
Comment:
Hi can anyone help me?
Can anyone tell me how to set a background image on a crystal report?
if you can, mail me the answer: roy_devos@hotmail.com
thx in advance
|
Title:
Crystal Report for Visual Studio .NET
Name:
D.P
Date:
2005-12-14 2:11:26 AM
Comment:
The step by step explanation is v good. With the push method, in the 7th step Im not getting the table name under ADO.NET.dataset1. How to get it. Why am i not getting the table name.Do let me know. Thanks in advance.
DP
|
Title:
missing chart
Name:
ainul
Date:
2005-11-29 8:24:22 PM
Comment:
this article is great. it helped me understand crystal report for .NET. but i'm having a slight trouble with the chart, it refused to show itself. everytime i add a chart to my report, it's there during design time but during runtime, there's only a blank white box with the little red x at the top. am i missing a component?
|
Title:
Solution for: CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed
Name:
Imran Shaikh
Date:
2005-11-29 4:07:28 AM
Comment:
Here is the solution for CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
http://www.dotnetjunkies.com/Article/790775A0-C493-46D8-ABE0-40CA588D33D3.dcik
|
Title:
Mrs
Name:
Sudha
Date:
2005-11-24 1:16:02 AM
Comment:
Good Article. Helped me through my first crystal report
|
Title:
Crystal Report for Visual Studio.Net
Name:
Ronan
Date:
2005-11-16 7:33:17 AM
Comment:
Best guide I've found for someone new to Crystal reports in asp.net. Thanks for the help.
|
Title:
help
Name:
aresun
Date:
2005-11-15 2:12:53 AM
Comment:
CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
Getting this error while calling the particular web form.
Also it could be fine if i could get some sample reports (setting the database connection during the run time and passing parameters to the report)
Thanks in advance
Mail id :- sundarg23@yahoo.com
|
Title:
blank report
Name:
Vladimir
Date:
2005-11-14 12:27:18 PM
Comment:
Hi,
I followed the Push Method walk through, and i did everything as said. When i run my app. all i get is a blank report. I don't get any errors!
This is the code that i use:
string sql = "select * from psi_players";
SqlConnection conn = new SqlConnection(connS);
SqlCommand com = new SqlCommand(sql,conn);
com.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet1 ds = new DataSet1();
da.Fill(ds,"psi_players");
int tes = ds.Tables[0].Rows.Count;
CrystalReport1 report = new CrystalReport1();
report.SetDataSource(ds);
CrystalReportViewer1.ReportSource = report;
CrystalReportViewer1.DataBind();
help anyone?
|
Title:
Too Gud
Name:
Prashanth
Date:
2005-11-02 7:03:07 AM
Comment:
Hi guys....
This article is really very helpful for a beginnner to get to know about Crystal Reports in .NET.
Good Work....
|
Title:
Good peice of Work
Name:
Amit Jain
Date:
2005-10-26 5:39:13 AM
Comment:
Its really vry nice article for begineers like me.I have tried through Pull method but there is some problem atlast I have got through Push methiod.
Good peice of article.
|
Title:
LogOn error Solution
Name:
Kshitiz
Date:
2005-10-25 5:02:44 AM
Comment:
Solve that problem by using below code
write on Page loadthe following code either or make a function aaaaand call on page load
CrystalDecisions.Shared.TableLogOnInfo myLogin;
foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in crpt.Database.Tables)
{
myLogin = myTable.LogOnInfo ;
myLogin.ConnectionInfo.Password = "sa" ;
myLogin.ConnectionInfo.UserID = "sa" ;
myTable.ApplyLogOnInfo(myLogin) ;
}
CrystalReportViewer1.ReportSource=crpt;
}
u will definetly come out of prob
|
Title:
Crystal Report
Name:
Priya
Date:
2005-10-20 5:04:53 AM
Comment:
This material is good for beginners.
|
Title:
Crystal Report
Name:
Selmiya
Date:
2005-10-16 5:28:32 AM
Comment:
Nice article! Great help for beginners
|
Title:
about crystal report
Name:
vikas vyas
Date:
2005-10-15 2:10:20 AM
Comment:
that's nice work . it help me a lot in crystal report . thax for it.
vikas vyas
|
Title:
Crystal Report for Visual Studio .NET
Name:
aplee
Date:
2005-09-23 5:21:34 PM
Comment:
I am attempting to use a single CrystalReportViewer and allow the user to select from a list of report to display on a ASP.NET Web Form? I can switch to different reports The only problem I encountered is once I loaded the first report, as long as sub-sequent reports have the same Record Selection Formula, it works fine, otherwise, error occurs because of field unknown or whatever. My question is, when the browser post back with a new report selection, why does the CRystalReportViewer retain the old SelectionFormula?
|
Title:
no output...
Name:
Bhakti
Date:
2005-09-22 1:41:20 PM
Comment:
hi , using similar code when i try to run the application in the main window it just displays the toolbar(crystal report) without any data. I also cross checked whether the dataset works fine od not with datagrid
but there it works fine but not with the crystal report.
Please help me for this....
Its urgent....
Thanks in advance....
|
Title:
Re: Comma Expected
Name:
Patrick
Date:
2005-09-16 4:17:53 PM
Comment:
Nice tutorial.
For the comma expected error...
BC30196: Comma expected
Look at the HTML code and make sure the ReportSource property is being assigned correctly .NET 2003 assigns this
ReportSource= "<%# PATH %>"
when it should be
ReportSource= '<%# "PATH" %>'
|
Title:
problem
Name:
Crystal report at time of execution
Date:
2005-09-10 5:50:28 AM
Comment:
hi
i put the chart in a report which is in crystal report 9 ,and when i executed on net the chart was not display
and ya my application is in ASP.Net
|
Title:
Not working with Crystal 9
Name:
Lyners
Date:
2005-09-08 9:01:40 AM
Comment:
\
\
\
\
\
\
\
\
|
Title:
Logon failure and incorrect logon parameter errors
Name:
Priya
Date:
2005-09-07 1:30:11 PM
Comment:
Hey guys, those who are using Oracle and connecting the ReportDocument object to Oracle database, and perplexed with that stupid logon error? here is the solution.
1. load the report using ReportDocument.Load() method
2. Use setdatabaselogon on the report doc object and just specify the user name, and password. DOnt use the overload that specifies all four, i.e. user, pasword, database and server. Those who get this error, would be using this overload.
3. dont set any table level logon properties after this.
4. Specify parameter values using the report object report.setparametervalue('parm', val, 'subreportname'); if you are specifying a parameter for your main report, use main report object setparametervalue overload that takes only the parm and the value and not the sub report name
5. Export your report to disk/wherever you want using the export methods. (actually this is where you will get your logon failure errors)
with the above steps, you should be able to get rid of the logon failure error!
Hope this helps (but it still seems wierd to me.. this means that its not possible to runa report using server, database names at runtime.. are crystal reports so difficult to bind to databases at run time?? still digging into this)
-Priya
|
Title:
Crystal Report for Visual Studio .NET
Name:
Ali Gelenler
Date:
2005-09-02 8:13:57 AM
Comment:
You get the error Logon Failed,since your password to access the database doesn't recorded by the Visual Studio for security reasons,so you have to add your password at run time.Just add this code to your Page_Load function, this is in c#;
//first define variables
YourCrystalReport crpt;
CrystalDecisions.Web.CrystalReportViewer CrystalReportViewer;
CrystalDecisions.Shared.TableLogOnInfo myLogin;
//in the page_load
crpt =new YourCrystalReport();
foreach(CrystalDecisions.CrystalReports.Engine.Table myTable in crpt.Database.Tables)
{
myLogin = myTable.LogOnInfo;
myLogin.ConnectionInfo.Password = "yourpassword";
myLogin.ConnectionInfo.UserID = "youruserid";
myTable.ApplyLogOnInfo(myLogin);
}
//now you can assign your report CrystalReportViewer1.ReportSource = crpt;
Hope this will help!
Bye...
|
Title:
Crystal Report
Name:
nell
Date:
2005-08-29 10:41:29 AM
Comment:
this is ok and can help alot, please give or share more examples regarding this topic.
thanks! and godbless.
|
Title:
Crystal Report for Visual Studio .NET
Name:
Juan Carlos Mendoza
Date:
2005-08-24 2:45:57 PM
Comment:
Very good, congratulations.
regards.
|
Title:
CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed
Name:
Nirenjan
Date:
2005-08-19 9:42:46 AM
Comment:
I got the same problem but i resolved by removing my previous crystal version dll in the references (Visual studio .Net 2003) and adding new reference with the latest version (i.e removing 9.10 and adding 11.0). This will solve Logon failed issues and invalid report source.
|
Title:
Re: Logon Failure Solution posted by Bob T.
Name:
Arun
Date:
2005-08-09 6:46:42 PM
Comment:
Bob,
SetDatabaseLogon() does not seem to be a supported method for a Crystal Report object in C#. I am using VS .NET 2002 and Crystal Reports for VS .NET. Suggestions?
Thanks, Arun
|
Title:
Error on my program
Name:
Kanagavel
Date:
2005-08-09 1:05:04 AM
Comment:
I am getting the following error. Help me in woring out this proplem. The error comes is like this "CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
|
Title:
Load report failed
Name:
Jorge Alvarado
Date:
2005-08-03 6:26:23 PM
Comment:
Exception Details: CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: Load report failed.
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:
[LoadSaveReportException: Load report failed.]
CrystalDecisions.Web.ReportAgentBase.m()
CrystalDecisions.Web.ReportAgent.get_RequestContext()
CrystalDecisions.Web.ReportAgent.get_()
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()
|
Title:
Crystal Report
Name:
Prakash
Date:
2005-07-25 3:15:18 AM
Comment:
This article really helped me to work with crystal reports in web application but i dont know how to export the data in to excel.
|
Title:
Cannot find "Data Binding"
Name:
Samuel Tzeng
Date:
2005-07-24 2:38:03 PM
Comment:
Hi Sir,
I cannot find the Data Binding from the Crystal Report Viewer properties. But I am sure my installation was ok without failure. Should I enable what or do anything?
Thanks for everyone's suggestion. jiunshen@gmail.com
Samuel
|
Title:
Good Code
Name:
Krishna
Date:
2005-07-15 1:40:34 AM
Comment:
Sir i am searching for this topic and i got many answers but they didnt solve my problem i like ur way of answering
thankx a lot
|
Title:
An Error occurred during the installation of assembly
Name:
Ethan Yang
Date:
2005-07-12 12:34:54 PM
Comment:
Hi,
I was wondering if anyone could explain the following:
'CrystalDecisions.ReportAppServer.CommonControls.Version = "9.2.3300.0",Culture... HRESULT: 0x80070020.
I get this error message when installing an aplication with the Crystal reports server imbedded on a Citrix environment. The server had crystal 8.5 on their previously and we uninstalled it but we still get this error message.
Any insights would be greatly appreciated! Thanks
|
Title:
Crystal report error logon failed
Name:
Amit Gupta
Date:
2005-07-12 4:15:46 AM
Comment:
Hi There,
I have got one problem when i am using crystal report.that is logon failed .
i don't know why it appears
i have used asp.net/sqlserver
if u have any solution pls mail me at my mail id.
agupta@hanusoftware.com
|
Title:
run project on other server
Name:
narong
Date:
2005-07-07 4:00:51 AM
Comment:
this is ok. but when I copy project to other server. It not install crystal Report and crystal report enterprise. It's cannot run . please advise
|
Title:
i have a question
Name:
caut
Date:
2005-06-28 3:34:51 AM
Comment:
Is it possible to display a vertical object over several sections in Crystal Reports 9?
The object must appear on the right of each page and must have the same orientation regardless of the content of the page.
|
Title:
Crystal Reports 10.0 for .NET
Name:
Basil
Date:
2005-06-22 3:20:45 AM
Comment:
Hello!
Could you help me?
I have a problem with changing push model to pull model.
Sample report have table which is described in field definition file. I want to change connection from TTX file to SQL Server table.
I try to change like this:
rpt.DataSourceConnections[1].SetConnection("MYCOMP","TestDb","sa","");
CrystalDecisions.Shared.TableLogOnInfo tbllogInfo = new CrystalDecisions.Shared.TableLogOnInfo();
CrystalDecisions.Shared.ConnectionInfo cnInfo = new CrystalDecisions.Shared.ConnectionInfo();
tbllogInfo = tbl.LogOnInfo;
cnInfo = tbl.LogOnInfo.ConnectionInfo;
cnInfo.ServerName = "MYCOMP";
cnInfo.DatabaseName = "TestDb";
cnInfo.UserID = "sa";
cnInfo.Password = "";
tbl.LogOnInfo.ConnectionInfo = cnInfo;
tbl.Location = "TestDb.dbo.Table1";
tbl.ApplyLogOnInfo(tbllogInfo);
Then I get LogOnException.
Thank to All.
|
Title:
fail to view report
Name:
shahrizan
Date:
2005-06-20 2:38:04 AM
Comment:
i've followed step by step instruction to view CR report from this site..i've got an error 'Load Report Failed' when i try to run my report.but it's managed to be loaded when i try to bind it during the desing time..
Any advice..
|
Title:
Crystal Report Viewer for VS.Net
Name:
Bhaskar mallela
Date:
2005-06-10 12:54:45 PM
Comment:
Excellent article which give overview of everything about crystal reports on .Net
|
Title:
export html file to doc file
Name:
GiaCatTa
Date:
2005-06-09 5:49:09 AM
Comment:
I want export html file into doc file, but i don't know to how to do it .
you can help me
thanks
|
Title:
Web developer
Name:
Noorah
Date:
2005-06-06 10:22:05 AM
Comment:
Hello
This example worked just fine, But when i use my report insted og the one in the example i reaseve the follwing error:
Logon Failed
Please help to fix this problem.
Regards;
|
Title:
Error Logon failed
Name:
Sudhanshu Lal
Date:
2005-06-04 2:59:52 AM
Comment:
I am getting an error on when i try to preview the report thru the browser i get an error logon failed please someone help as its urgent !!!1
Thnx in advance
Regards
Sudhanshu Lal
|
Title:
Mr robin
Name:
Robin
Date:
2005-05-27 3:48:58 AM
Comment:
this is not working
pull model not working
login failure for the sql server database
pubs db , for integrity secruity or user id
not working...
giving login failure, what is the reason
|
Title:
MR
Name:
robin
Date:
2005-05-27 3:47:58 AM
Comment:
This Pull method is not working
login failure
what is the reason but push method workes
|
Title:
RE: HTML Text Interpretation
Name:
Eric Landes
Date:
2005-05-18 9:43:01 PM
Comment:
I'm not sure what the answer is here. But I would suggest checking out http://www.aspalliance.com/crystal or http://support.businessobjects.com where you might be able to find the answer. HTH
|
Title:
Plug the Crystal report viewer to Enterprise Library Data Access block
Name:
Etienne
Date:
2005-05-18 11:54:29 AM
Comment:
Hi all,
I was stuck cause I wanted to use the mighty Microsoft Enterprise Library to autopopulate a strongly typed dataset that would be the source of my CrystalViewer report...
Thanks to Jason Robinson, I managed to work it out by using:
myDB.LoadDataSet(myCommandWrapper, CType(myTypedDS, DataSet), "DataTableName")
You can also find this info and more at:
Jason's blog:
http://weblogs.asp.net/josh.robinson/archive/2005/03/30/396311.aspx
My blog:
http://etiennel.blogspot.com
Cheers!
Etienne
|
Title:
HTML Text Interpretation
Name:
Arun
Date:
2005-05-18 11:29:32 AM
Comment:
This question was already posted but no responses yet. I would be really thankful if someone can address this
I'm creating crystal reports for a web application, through ASP.NET v1.1. What I noticed was
1) If Crystal Reports 9 is installed HTML Text interpretation option appears in "Format Editor", but
the reports don't show the text in the respective field at all. It shows blank fields.
2) I heard that typing "crHTMLText" in the "Formula Editor window" and clicking on "Save and Close"
does the desired task. So I tried doing that, still it did not work.
Does anyone have any idea of whether this option works in ASP.NET cryastal reports or not? If it doe
sn't work what do I need to do for achieving the effect?
Looking forward to your help....It is urgent!!
Thx in advance.
|
Title:
Solution of CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed
Name:
Shedrek
Date:
2005-05-14 6:18:36 AM
Comment:
This exception occurs when u r not logon to the database...
in vb.net we use setDatabaseLogon(uid,pwd) method.....
e.g
crReportDocument.SetDatabaseLogon("sa", "sa")
|
Title:
Solution to dataset problem
Name:
Eric Landes
Date:
2005-05-11 11:54:10 PM
Comment:
Thanks for sharing your solution on this Ken.
|
Title:
One solution to the "The 'multiple tables in dataset' camp "
Name:
Ken
Date:
2005-05-11 4:26:59 PM
Comment:
On a hunch, I created a view with selects an a few joined tables. I then call the view in a stored procedure.
Next, I open up Visual Studio .NET (2003) and create a new dataset. The Server Explorer contains the newly created view. I drag and drop the view into the design area and save.
Next, I create the report. In the details section I Database/Add/Remove Database... and include the dataset I created. The names of the fields are there as would any table. Drag and drop the fields according to this articles directions.
Later, in the .aspx report viewer code, I create the mechanism for calling the stored procedure. When I fill my custom dataset via the data adapter, I refer to it as 'myAdpt.Fill(myDataSet, "myView");', just as one would fill the custom dataset given in this article's example. It works.
Have fun.
|
Title:
The 'multiple tables in dataset' camp
Name:
Ken
Date:
2005-05-11 3:20:02 PM
Comment:
There were a few inquiries about using multiple tables within the dataset. I would like to know how that is done as well. I was able to use the 'push' model example effectively, filling the dataset with a stored procedure, etc. However, I cannot achieve output using a dataset with multiple tables. Tracing through the code, I can set that the dataset has the proper results from the stored procedure I'm using, but the data never reaches the report fields.
|
Title:
Logon Failure Solution
Name:
Bob T
Date:
2005-05-06 1:41:10 PM
Comment:
Below is a working solution to the logon failure first posted by Srinivas Bandi:
add the following code in page load event instead of databind logon failed error should go away.
Dim crreport As New pulltest 'replace pulltest by your reportname
crreport.SetDatabaseLogon("username", "password") 'replace username and password
CrystalReportViewer1.ReportSource = crreport
It really can't be put much cleaer for those of you using VB.
In C# use the following:
protected INSERTREPORTNAMEHERE rep = new INSERTREPORTNAMEHERE(); //(My report is named INSERTREPORTNAMEHERE.rpt)
private void Page_Load(object sender, System.EventArgs e)
{
mf.SetDatabaseLogon("username","password");
CrystalReportViewer1.ReportSource = rep;
CrystalReportViewer1.DataBind();
}
|
Title:
Could not create instance of the report
Name:
sups
Date:
2005-05-03 7:33:12 AM
Comment:
I made a simple report CrystalReport1.rpt which was added to my project (Add New Item => Crystal Rep
ort).
I want to use the report in my project:
CrystalReport1 = new CrystalReport1();
But I get this compile-error:
The type or namespace name 'CrystalReport1' could not be found (are you missing a using directive or
an assembly reference?)
The report is in another folder called Reports in the root folder. I am not getting this report, where as if i create a report in the root directory i get it.
What is wrong?
|
Title:
crystal report convert in pdf in asp.net
Name:
amit
Date:
2005-05-03 2:26:53 AM
Comment:
hi tech
how i design a crystal report in asp.net ,now my problem is how to crystal report convert in pdf in asp.net on button click
help us
send sample code
thankx
|
Title:
RE: runtime error
Name:
Eric Landes
Date:
2005-04-27 10:31:32 PM
Comment:
Since I don't see any code or an error message, it's pretty hard to help out. I would suggest going to http://support.businessobjects.com for help, or http://aspalliance.com/crystal and look on the community page for some of the different mailing lists that can help.
|
Title:
runtime error
Name:
jason
Date:
2005-04-27 4:23:45 PM
Comment:
i used the above example in one of my applications, i used the pull method with the world sales report.rpt file, the report is rendered in the design view but when i build and try opening the page in a browser, it gives me a runtime error...can someone help me here?
|
Title:
RE Change VB to C#
Name:
Eric Landes
Date:
2005-04-20 10:04:56 PM
Comment:
To change that code, I think you'll just need to add a ; to the end of each line. Here's a link to a project that converts VB.net to C# http://www.codeproject.com/csharp/GBVB.asp HTH
|
Title:
change vb code to c#
Name:
ttu
Date:
2005-04-20 8:54:53 AM
Comment:
i want to convert this code to c# but i don't know how can i
?
please help me.
CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.UserID = user
CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.Password = pass
CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.ServerName = server
CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.DatabaseName =dbname
CrystalReportViewer1.DataBind()
|
Title:
Logon Error
Name:
Mark Lewis
Date:
2005-04-19 7:10:11 AM
Comment:
I was having loads of problems with the logon error. The code i used to get round it was:
Dim rpt As New CrystalReport
rpt.SetDatabaseLogon("user", "password")
CrystalReportViewer.ReportSource = rpt
CrystalReportViewer.DataBind()
Note I am only using the username and password and NOT the database and server options as well.
|
Title:
Logon failed error
Name:
Upendra Chaudhari
Date:
2005-04-19 6:56:02 AM
Comment:
Hi
I'm trying a simple example but using an ODBC connection to a Sybase database. Th
e connection is working fine when building the report, but when I call the DataBind() method I'm get
ting a Login Failed message. What am I missing?
Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
Stack Trace:
[LogOnException: Logon failed.]
.F(String , EngineExceptionErrorID
)
.A(Int16 , Int32 )
.@(Int16 )
CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestContext reqContext)
CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestContext pageReqContext)
CrystalDecisions.Web.ReportAgent.u(Boolean N)
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()
|
Title:
logon failed error sloved by
Name:
Srinivas Bandi
Date:
2005-04-13 3:59:50 PM
Comment:
add the following code in page load event instead of databind logon failed error should go away.
Dim crreport As New pulltest 'replace pulltest by your reportname
crreport.SetDatabaseLogon("username", "password") 'replace username and password
CrystalReportViewer1.ReportSource = crreport
|
Title:
crystal report in asp.net
Name:
subhashchandra
Date:
2005-04-12 6:45:05 AM
Comment:
hy,
i am a student of b.e.computer engg. i am working on asp.net.
1) i want to know how to make crystal report in asp.net
2) how to convert rpt file to pdf file format.
3) how pdf file send to selected email-id.
please send me reply early.
my email id- sardhara_subhash@yahoo.com
|
Title:
Login error
Name:
D
Date:
2005-03-30 2:10:48 PM
Comment:
Mansur,Prasad,Joe,Mihir,Michael,Rob,...
This error can be anything from a Bad Parameter Data Type to typo in the source path or even report name or maybe something else I am not aware of. I will watch first for a typo. Happen to me this morning :-O
|
Title:
Crystal Reports with selected data records
Name:
Sachin
Date:
2005-03-30 5:39:06 AM
Comment:
Thank You very much for your detailed explanation,but if we want to retrive particular records of a database table then what sould we do?Please answer as early as possible.
With Regards,
Sachin
|
Title:
Crystal Report
Name:
Sachin
Date:
2005-03-30 5:34:06 AM
Comment:
Really helpful.Thanks for your detailed explanation.
With Regards,
Sachin B.
|
Title:
LogOnException: Logon failed
Name:
Prasad
Date:
2005-03-30 1:37:09 AM
Comment:
I'm not able to get the solution for this. If anybody can plz.
[LogOnException: Logon failed.]
.F(String , EngineExceptionErrorID
)
.A(Int16 , Int32 )
.@(Int16 )
CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestContext reqContext)
CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestContext pageReqContext)
CrystalDecisions.Web.ReportAgent.u(Boolean N)
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()
|
Title:
Crystal Reports
Name:
Sreedhar
Date:
2005-03-29 10:29:35 AM
Comment:
How to create crystal report dynamically in asp.net
|
Title:
Good article but still lacks one thing.
Name:
Preeti Sharma
Date:
2005-03-22 1:31:45 PM
Comment:
Hi,
No doubt this article is more than enough. Its very good.
One which has written it is making concept very clear.
But still one thing is left. As i am looking for a code to create report using dataset. In this example dataset is crated using wizard. I m making query at rum time and generating dataset at run time. But in that case i m unable to generate report. Is it possible for author of this article to hepl me in this matter.
Thanks a lot.
Preeti Sharma
|
Title:
Logon failed. SQL Server Solution
Name:
Alex K.S.Lim
Date:
2005-03-22 2:45:06 AM
Comment:
http://support.microsoft.com/default.aspx?scid=kb;en;319264&sd=msdn
This Articles explained why, and Solution in C# Code.
I changed the code to VB.Net code and it worked.
|
Title:
Push model displays an empty report
Name:
Janki
Date:
2005-03-21 6:19:54 PM
Comment:
I used the same source code as given above, to connect to a database using SQL Server authentication. Though it no longer throws logon failed exception, it displays an empty report.
Please HELP !
|
Title:
re: logon failed solution
Name:
gurvin
Date:
2005-03-21 2:17:34 PM
Comment:
i got the same error "CrystalDecisions.CrystalReports.Engine.LogOnException: Logon Failed"
and I removed the password for my SQL Server, uid=sa pwd=
this is a temporary solution, I will dig in more to find out why this exception occuring.
|
Title:
Field Explorer
Name:
Mahe
Date:
2005-03-13 8:32:52 PM
Comment:
go to View/Other Windows/Document Outline. This should bring your field explorere.
|
Title:
Comma expected
Name:
Joe
Date:
2005-03-13 4:24:20 AM
Comment:
BC30196: Comma expected
I have even put the crystal report to the same directory. this error still comes up. Can anyone help? Thanks in advance!
|
Title:
can't find Field Explorer
Name:
mahe
Date:
2005-03-12 6:53:32 AM
Comment:
After the table being selected on step 10)(Expand the "Pubs" database, expand the "Tables", select t
he "Stores" table and click on ">" to include it into the "Selected Tables" section), the Field Expl
orer didn't show up on my screen. Does any one has any idea what is going on on my set up? Many than
k!
|
Title:
thanks
Name:
srinivas
Date:
2005-03-11 10:09:16 AM
Comment:
hi
the code is working all for pop method but geting an error when using push and tring to export it to doc file as
logon failed
pls help me
thanks
srinivas
mail id srinivaspeesapati@yahoo.co.in
|
Title:
Crystal Report for Visual Studio .NET
Name:
Ngoc suong
Date:
2005-02-26 10:51:11 PM
Comment:
thanks for explanation, but when you want to use more tables how does it work ?
bye
|
Title:
Field Explorer didn't show up
Name:
Kening Wang
Date:
2005-02-23 12:16:19 PM
Comment:
After the table being selected on step 10)(Expand the "Pubs" database, expand the "Tables", select the "Stores" table and click on ">" to include it into the "Selected Tables" section), the Field Explorer didn't show up on my screen. Does any one has any idea what is going on on my set up? Many thank!
|
Title:
CrystalReport1 = new CrystalReport1();
Name:
Marinus
Date:
2005-02-23 9:22:49 AM
Comment:
I made a simple report CrystalReport1.rpt which was added to my project (Add New Item => Crystal Report).
Now I want to use this report in my project:
CrystalReport1 = new CrystalReport1();
But I get this compile-error:
The type or namespace name 'CrystalReport1' could not be found (are you missing a using directive or an assembly reference?)
What is wrong?
|
Title:
Connection string
Name:
chow
Date:
2005-02-22 2:13:02 AM
Comment:
The connection string in Bindreport() is giving me error. I am not able to connect to the SQL2K. FYI, I did not set any password for 'sa'. Do I need to change the connectcion string ? Any idea ?
|
Title:
Logon failed with ODBC connection
Name:
Germano
Date:
2005-02-19 3:06:17 PM
Comment:
I'm trying a simple example like the one above but using an ODBC connection to a Sybase database. The connection is working fine when building the report, but when I call the DataBind() method I'm getting a Login Failed message. What am I missing?
|
Title:
Alignment of Data
Name:
Liying
Date:
2005-02-19 11:50:45 AM
Comment:
Can someone help me?
I am trying to create a table of content that is horizontal. How can i go about doing it? Each time the report get generated it will tabulate different number of columns. I have been trying for 1 week but failed to make the report auto create columns of data.
Is it possible to add HTML code to Formula Editor??
if it is possible. how can i go about doin it?
Thank you in advance.
|
Title:
Learn Crystal Reports in 21 Minutes
Name:
Malik Asif joyia
Date:
2005-02-16 1:32:42 AM
Comment:
Hello
Very good Effort by Ajay and Shanker. i am realy very thankfull to them for this kind of good guideness to the people who are learning Cyrstal Reports.
Thanks Again
|
Title:
Logon failed
Name:
Confused
Date:
2005-02-14 4:48:00 PM
Comment:
Did anyone figure out how to get passed that LogOnException:Logon Failed Error? I tried changing permissions in the folder to store file but still get the error.
|
Title:
Crystal Report for Asp.net
Name:
Laxmi
Date:
2005-02-11 5:04:45 AM
Comment:
I got to view the report at design time but in run time i could see only the control...can someone h
elp me with that?
thanks
|
Title:
Crystal Reports for ASP.NET
Name:
Dhana
Date:
2005-02-07 10:07:24 PM
Comment:
I am using the same steps as described above.
But in the runtime it always shows -
Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
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: Logon failed.]
.F(String , EngineExceptionErrorID
)
.A(Int16 , Int32 )
.@(Int16 )
CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestContext reqContext)
CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestContext pageReqContext)
CrystalDecisions.Web.ReportAgent.u(Boolean N)
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()
|
Title:
Export in 2 lines!
Name:
Andrew Denman
Date:
2005-02-04 10:47:09 PM
Comment:
\
\
|
Title:
crystal report
Name:
haytham
Date:
2005-01-26 9:59:33 AM
Comment:
very good article but it is not as we required in our project.:(
|
Title:
Crystal Reports Walkthrough - Using the Pull Model
Name:
senthilkumar
Date:
2005-01-21 5:46:39 AM
Comment:
Code Behind Page Modifications
18) Call the Databind method on the Page Load Event of the Code Behind file (.aspx.vb).
in the databind method what we have to do,please show me the code in databind
|
Title:
Problem while using the PULL model
Name:
Aresung
Date:
2005-01-18 10:48:49 PM
Comment:
Followed the steps to create a new report using the Pull Model. And able to view the preview of the report with dummy data.
But while running the application, getting an error.
CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
|
Title:
One solution to the Logon Fail problem
Name:
Angel Huerta
Date:
2005-01-12 5:47:25 PM
Comment:
Check out this KB:
http://support.microsoft.com/default.aspx?scid=kb;en;319264&sd=msdn
|
Title:
Crystal Report for Visual Studio .NET
Name:
Rob Morgan
Date:
2005-01-05 2:20:14 PM
Comment:
\
\
\
|
Title:
Mr.
Name:
Bill Anklemoore
Date:
2005-01-04 2:36:20 AM
Comment:
How about the "passing user input parameters" model. This is far more useful than the "push" or "pull" model. Simply put, Crystal Reports can't do this online!
|
Title:
Thanks a lot !
Name:
Vijay
Date:
2004-12-29 1:34:28 AM
Comment:
I got exactly what I was looking for. Very useful article on Crystal Reports in .NET. Thanks.
|
Title:
Crystal Report for Visual Studio .NET
Name:
Richard Dudley
Date:
2004-12-24 1:20:55 AM
Comment:
>DiskOpts.DiskFileName = "c:\Output.pdf"
|
Title:
logon failed
Name:
Michael Zhao
Date:
2004-12-20 11:30:17 PM
Comment:
I got a logon failed error as well
-----------------
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: Logon failed.
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: Logon failed.]
.F(String , EngineExceptionErrorID
)
.A(Int16 , Int32 )
.@(Int16 )
CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestContext reqContext)
CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestContext pageReqContext)
CrystalDecisions.Web.ReportAgent.u(Boolean N)
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()
|
Title:
Crystal report connection with oracle
Name:
marcelo
Date:
2004-12-20 11:54:01 AM
Comment:
i have this error when i connect with oracle 8i or 9i at then runing time. Anybody have then solution.
Thank
Error is "CrystalDecisions.CrystalReports.Engine.LogOnException: Logon Failed"
|
Title:
Not working in runttime
Name:
Visu
Date:
2004-12-09 2:44:33 AM
Comment:
In design time CrystalReport viewer able to display information But in runtime i am not able to get.
I am getting login failed ..
|
Title:
Crystal Report for Visual Studio .NET
Name:
Richard Dudley
Date:
2004-11-18 8:45:54 PM
Comment:
\
|
Title:
Background image
Name:
Butch Pornebo
Date:
2004-10-22 9:56:32 PM
Comment:
How do you set the background image of the page in Crystal Report?
|
Title:
Crystal Report for Visual Studio .NET
Name:
dhanya
Date:
2004-10-13 5:37:13 AM
Comment:
i got to view the report at design time but in run time i could see only the control...can someone help me with that?
thanks
|
Title:
Logon error
Name:
Mike
Date:
2004-10-11 1:23:00 PM
Comment:
I got that logon error on an export, it was because of rights on the folder. Took me hours to find that.
|
Title:
HTML Text Interpretation
Name:
Himani
Date:
2004-10-06 8:40:26 AM
Comment:
I'm creating crystal reports for a web application, through ASP.NET v1.1. What I noticed was
1) If Crystal Reports 9 is not installed on machine, the option of HTML text interpretation does not appear in "Format Editor" of the reports that are being created through .NET.
2) If Crystal Reports 9 is installed HTML Text interpretation option appears in "Format Editor", but the reports don't show the text in the respective field at all. It shows blank fields.
3) I heard that typing "crHTMLText" in the "Formula Editor window" and clicking on "Save and Close" does the desired task. So I tried doing that, still it did not work.
Does anyone have any idea of whether this option works in ASP.NET cryastal reports or not? If it doesn't work what do I need to do for achieving the effect?
Looking forward to your help....It is urgent!!
Thx in advance.
|
Title:
LogOnException: Logon failed
Name:
Mihir Aich
Date:
2004-10-06 8:31:12 AM
Comment:
I am using the same steps as described above.
But in the runtime it always shows -
Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
Stack Trace:
[LogOnException: Logon failed.]
.F(String , EngineExceptionErrorID
)
.A(Int16 , Int32 )
.@(Int16 )
CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestContext reqContext)
CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestContext pageReqContext)
CrystalDecisions.Web.ReportAgent.u(Boolean N)
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()
|
Title:
Crystal Reports with Oracle
Name:
SEE#YEM
Date:
2004-09-22 10:43:54 AM
Comment:
Guys,
I googled and banged with supports but could not solve the issue with Crystal Reports not able to connect to Oracle and i get a same default error message which is not allowing me to pass the gate at all..Any help would be apperciated...
Error is "CrystalDecisions.CrystalReports.Engine.LogOnException: Logon Failed"
|
Title:
Challenging doubt
Name:
Naushad
Date:
2004-09-09 7:43:30 AM
Comment:
HI,
can i use some other datasource other than datasets in push model?..my requirement is to display data in a crystal report as when they are read from a file.Note the data is not stored in a database.
|
Title:
CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
Name:
Vinodh
Date:
2004-09-06 5:42:57 AM
Comment:
Thanx,like the above examples, i have done using oracle but i got error saying that CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
any suggestion on that.
|
Title:
Exception of type System.Exception was thrown.
Name:
Mansur A
Date:
2004-08-18 10:03:37 AM
Comment:
I tried the code.On compiling it the following error occurs.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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:
[Exception: Exception of type System.Exception was thrown.]
CrystalDecisions.Web.ReportAgent.u(Boolean N)
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()
Im have tried many tricks but to no avail !!
Hope you can answer back !
Mansur
|
Title:
CS1009: Unrecognized escape sequence
Name:
sam
Date:
2004-07-31 2:10:28 PM
Comment:
hi
I can see the report in the design mode.
but when i run it i get the following error.
CS1009: Unrecognized escape sequence
Do we have to escape the reportpath while binding it to the reportsource
pl help
thanks.
|
Title:
crystal reports
Name:
alen
Date:
2004-07-27 7:19:26 AM
Comment:
this is ok, but when we r runing the same in oracle with ado.net .
the report is not generating the required rows as executed by the query given in the connection string,
instead it is showing all rows in report
what is the solution for this
|
Title:
use more tables
Name:
eli
Date:
2004-06-23 2:24:56 AM
Comment:
thanks for explanation, but when you want to use more tables how does it work ?
bye
|
Title:
Crystal Report for Visual Studio .NET
Name:
Richard Dudley
Date:
2004-06-19 11:23:40 PM
Comment:
\
|
