I have serveral databases with same tables. I created a crystal report to show the report for respective logins from the database. I have a problem in it. In crystal report when i changing the database it should not change the respective table. It loads only the table what we give in the connection string first time.
View 1 Replies
<connectionStrings>
<add name="SchoolEntities" connectionString="metadata=res://*/SchoolModel.csdl|res://*/SchoolModel.ssdl|res://*/SchoolModel.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.;Initial Catalog=school;User
ID=sa;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient"/>
</connectionStrings>
how report read this connection string
Is there anyway to use a connection string from web.config for Crystal Report? The problem I'm having is that I develop on two different computers and on each I use a different IP to connect to the SQL Server. And when I deploy to a web server I use "localhost". So each time I get prompted for changes from the Crystal Report...
View 8 Repliesemp database(connection string vsspl-005sqlexpress)employee database(connection string vsspl-002sqlexpress)
runtime employee database when i give print button emp database
the above 4 fig display the problem.. since i'm trying from last 4 days
i've one crystal report which is connected to the database using database expert and connection string is
vsspl-005sqlexpress and i want to override the connection string to vsspl-002sqlexpress..
i've writen the connection string in webconfig file it is working well..
for example. the report is connected to the emp database using database experts..
and the overriding string is connected to the employee database in webconfig file..
when i run it is displaying correct employee database..
but when i give print it is diaplaying the logon prompt with server name same vsspl-005 emp database.
and in the pdf it is printing the eml database. i want the employee database in the pdf and print..
i want to override the connection string both the time while its running and when i give print command in pdf also..
I 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 want report generted based on value from querystring.
View 3 Replies I am using crystal report Xi release 2.
How can I change my reports English to Arabic language?
i hv a unbounded string in crystal report .hw can bind the string runtime say equal to "hello world"
View 1 RepliesWhen 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 RepliesI built a crystal report using crystal report 2008, and have it working fine aganist my test db. in my c# code that loads the report I put this in:
[Code]....
but problem is when i pushed this change to production, the report was stilling pulling test data, even though the web.config entry (LocalSqlServer) was updated in production to use production db. Could I have setup the crystal file incorrectly? When I'm creating the crystal file and connecting it to the db, is there something that I need to check or uncheck to tell it I'm going to dynamically supply the db connection rather than having it use the one I used to setup the report?
I have a report in which one of the fields prints name. Datebase is returning name field as "myname". In Code behind I have to change the value from "myname" to "MyNaMe". Suppose database just returning names like
jojo
kojo
mojo
In crystal Report I have to display these names as (just example)
JoJo
koJo
Mojo
There 5 crystal reports which have the same fields. Each of them is using different store procedure as datasource as sp1, sp2...sp5 I have done first report rp1. I copied rp1 as rp2. How to change rp2 datasource from sp1 to sp2?
View 1 Repliesif ({lms.seq} = 1) then {lms.des}
else if Not ISNULL({lms.des}) then {lms.itmchk};
When I run the above statement i get a error "A String is required here" near the second If statement.
What I want is decribed below.I have a three fields i.e seq,des,itmchk
if "seq = 1" display "des"
if "des" is not empty display "itmchk". "itmchk" will display either "True" or "False"
if "itmchk" is not empty replace "True" with Star.
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 have negative numbers in my report and I wish to display them with a "<" sign.
View 5 RepliesI developed crystal report using the tool available with VS2005.
I need help for extracting a string in a formula field.
Example :
String= CFG:1,132578992,1958| result should be 132578992
String= CFG:2,158974,1953| result should be 158974
in the string always starting part is "CFG" and ending part is "|" how can i trim the string after the first comma .
I inherited some project which uses crystal reports. The datasource for startdate is in string format but I would like to make it up so that the time does not get added. Should I change the sql query somehow or can I make from the object in crystal reports (IFieldObject) to something more manageable.
View 2 RepliesI just want to place static text on my report. From the toolbox I placed an unbound field type string on my report but I can not set the text or value somewhere?
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.
How to change float number such as 0.12 to 12% in CR? I knew how to % but only display 0.12%
View 2 RepliesI have web application using asp.net and from that i generate crystal report after generation of report when i'll export it to pdf from crystalreportviewer inbuild function. So report is saved by name crystalreportviewer.pdf but I want to change name of report at the time of generation.
View 1 Repliesusing vb.net 2005 and crystal reports I added a server and db to my crystal report and I can see the table and fields in the server explorer. Also in "database expert" I added the table that I want to display data from. The question I have now is how to I display fields from this table on my report? I thought I remembered simply dragging and dropping a field onto the report from the table but not able to do that now
View 1 RepliesI have some informations to put in my report and i want to display them in a table format
for example:
Number
[Number Information extracted from the database]
Description
[Description Information extracted from the database]
I am retrieving connection string based on value stored in cookie.NowI am making crystal report. I cannot hard code server credential. I have to get these credential from connection string from web.config. so that i can pass these credentials to my crystal report .
ConnectionInfo reportConnectionInfo = new ConnectionInfo();
reportConnectionInfo.ServerName = connection string server name from web.config
reportConnectionInfo.DatabaseName = connection string database name from web.config
reportConnectionInfo.UserID = ...;
reportConnectionInfo.Password = ...;
