My report is using two (2) different databases, how can I programmatically logon to each database? I am using Visual Studio 2010, in preview mode the report populates with no problems. I am using the standard code to login to a single database, but unsure on how to pass values for the second.
View 1 Replies
I am creating the crystal report without database data, just i am read the data from text file and fill into dataset then genrate the crystal report but problem is here if i am export the crystal report into different format so he wants the database logon parameter.so in this case i have no database crendential because i am creating the report without database.
View 1 RepliesI have a Web Forms app that uses forms authentication. I have a Crystal Reports Server 2008 V1 server with InfoView .NET installed and working. I have some Enterprise accounts setup. EDIT: I should mention that my Web Forms app is on a different server from Crystal Reports Server.
I need to know how to log on to InfoView .NET programmatically on my custom ASP .NET page (C#) and then transfer the user to InfoView without them having to type in the logon information.
Something like this would be nice (C#):
string username = "blah";
string password = "asdf";
// create logon token for crystal reports server
// .. // this is the code I need
Response.Redirect(url);
I did find this question, which gets me partway there, but it doesn't tell me how to pass the token to InfoView .NET. Some older docs also mention needing a cookie. I've also found other sites that show how to pass it to Java InfoView, but I need the .NET version.
I wanted to post my problem and solution since I've gotten some good information on this board. When deploying my Visual Studio 2008 C# .NET 2.0 web application Production, I encountered some problems, which is not unusual. What was unusual is that my Crystal Reports .NET reports that use the Report Viewer control would not work; they errored out with:
note: Crystal Report works fine in dev environment....
Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed. Unable to connect: incorrect log on parameters.We are using Oracle 11g 64 bit as database. We establish crystal report database connection by two ways,
1. Microsoft OLE DB Provider for Oracle
2. Microsoft OLE DB Provider for ODBC
but we got the same error in report module when we using two methods.
Our Coding : //CrystalDecisions.CrystalReports.Engine.ReportDocument crpt = new ReportDocument();
private ReportDocument crpt = null;
private void Page_Init(object sender, EventArgs e) [code]....
I want to use a single Crystal report (.rpt) file for two actual reports, changing only the title and the data. I've got the data working, but I can't seem to get the title part right. I tried to follow this
tutorial, but when I do my report just disappears (whether I set the parameter or not). I created a "Report Title" special field and dragged it to my page header. Then I brought up the formula editor on the report title display string and clicked on my title parameter. So the formula ends up being
{?Title}
I'm sure I'm probably just making a rookie mistake here.
I'm sorting the Crystal Report (2008) programmatically:
FieldDefinition fdSortField = rpt.Database.Tables[0].Fields[ddlSort.SelectedItem.Value];
rpt.DataDefinition.SortFields[0].Field = fdSortField;
if (rbSort.SelectedIndex==0)
{
rpt.DataDefinition.SortFields[0].SortDirection = CrystalDecisions.Shared.SortDirection.AscendingOrder;
}
else
{
rpt.DataDefinition.SortFields[0].SortDirection = CrystalDecisions.Shared.SortDirection.DescendingOrder;
}
(the user selects the sort field from the Dropdown list ddlSort and the sort direction from the Radiobutton list rbSort).
This works fine, the only problem is that this doesn't work for the formula fields, because they are not part of the database. However, since it is possible to set the sort order by the formula field in design time, it should be possible to do this programmatically.
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 RepliesMy report does not use data from a database. It uses a code generated dataset. How do I give crystal reports the necessary logon data to avoid database logon failures.
View 1 RepliesI'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 have done a crystal report in asp.net. i have a table called c_order it contains cust_id field, so while generating report itself i specified cust_id value but i have put a textbox and a button in the form which contains crystalreportviewer. so i need to enter a value in textbox and press the button then it should get value which match with the value in textbox with database and generate report.
View 1 RepliesI am having database file employee.mdf
and i have sql server express only.
What are the credentials i have to use for ConnectionInfo class and i do not have user id and password
my code:
connectionInfo.ServerName = @".SQLEXPRESS";
connectionInfo.DatabaseName = @"E:employee_Data.mdf";
here how to use integrated security and i given
connectionInfo.IntegratedSecurity = true;
But it is asking the user id and password while i am using the report there is no user name and password
I want to know that is it possible to create crystal report without database as datasource?
because i am having database but the data that i want to show in report is not a direct values from database...
Actually i am having one attendance table now i want to show the total no of rows(attendance table has 50 rows then report should display just "50" instead of displaying each rows) in the report...how can i show that?
attendance table(sub_code,status,roll_no,date)
subjects(sub_code_sub_name)
my report format is like :(sub_name,total lectures,present lectures)
for example:-report should look like....
(sub_name,total lectures,present lectures)-This total lectures can be counted using attendance table but how can i diplay in report thats what i want to know?
Sub-1 | 20 | 15
Sub-2 | 45 | 4
Sub-2 | 33 | 3
I want to display images in crystal reports from database. what i do?
View 1 RepliesI am developing a web application and I am using a crystal report for my project, how can I pass the query string to the crystal report using the database.
View 1 RepliesI'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 RepliesWhile calling a crystal report from ASPX i get the following error message:
Error in File C:WINDOWSTEMPReport1 {CB17A4FE-ECB0-4461-AB9C-0E07F8CDDB1F}.rpt: Failed to retrieve data from the database. Details: [Database Vendor Code: 102 ]
I have tried to verify the database and then call it again but in vain.
i have created several crystal report for my web application, i need to use my application to connect different database on the server which has no problem in the application but when i open the reports created using crystal report, it still connected to the database configured. how can i fix this, is there other way than to use another copy of the application and configure it manually at the each of the reports. i do have pass the logon information to the report using vb.net in which i get the info from the web.config
Dim A As ConnStr = New ConnStr
With ConnInfo
.ServerName = A.getServerName()
.DatabaseName = A.getDBName()
.UserID = A.getUser()
.Password = A.getPwd()
End With
my problem is how to make crystal report to uses all the logon info passed and not use the infor set in the report file
