Sitemap

Amicuk Programming Answers

Crystal Reports DataBase Fields

-0001-11-30   Views:0

Advertisement

Hi, I'd like to know if is possible to set the query string and the DataBase when you want to open a Crystal Report from SBO. Thanks.You cannot set the database connection string from the SBO connection information because the password is encrypted.

Hi,
I'd like to know if is possible to set the query string and the DataBase when you want to open a Crystal Report from SBO.
Thanks.

The replay answer
Advertisement
You cannot set the database connection string from the SBO connection information because the password is encrypted.
But if can grab the password from somewhere else you can do it like this:
    private void SetConnectionInfo(CrystalDecisions.Shared.ConnectionInfo crConnectionInfo, ReportClass report)
      TableLogOnInfo crTableLogOnInfo;
      report.SetDatabaseLogon(conn.UserId, conn.Password, conn.Server, conn.Database);
      crConnectionInfo.ServerName = conn.Server;
      crConnectionInfo.DatabaseName = conn.Database;
      crConnectionInfo.UserID = conn.UserId;
      crConnectionInfo.Password = conn.Password;
      foreach(Table table in report.Database.Tables)
        crTableLogOnInfo = table.LogOnInfo;
        crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
        table.ApplyLogOnInfo(crTableLogOnInfo);
        string s = table.Location;
        s = crConnectionInfo.DatabaseName + "." /*dbo." */ + table.Location.Substring(table.Location.LastIndexOf(".") + 1) ;
        table.Location = crConnectionInfo.DatabaseName + "." /*dbo."*/ + table.Location.Substring(table.Location.LastIndexOf(".") + 1) ;
Hope this helps,
Jurgen

Go to See the other 4 answers

Crystal Reports DataBase Fields

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'd like to know if is possible to set the query string and the DataBase when you want to open a Crystal Report from SBO. Thanks.You cannot set the database connection string from the SBO connection information because the password is encrypted.[More]

Seagate Crystal Reports: Database Error

Category:DefaultRelease time:-0001-11-30Views:130

I am using Crystal reports Version 8 and frequently get the error 'Seagate Crystal Reports: Database Error' when I try to open a previously working crystal report file. The error occurs when I click on the Database menu. Every time I get this error I[More]

Crystal Report Formula field function  on OLAP SAP BI/BW Cube

Category:DefaultRelease time:-0001-11-30Views:130

Dear All We create OLAP Cube Report in  Crystal Report 2008 (BO)  base  SAP ( DB2)  BI/BW  Cube, Grid report coming correctly.  Crystal Report Formula Field  functionalities are not avilabel or suporting.  If any one explain or some kind of documenta[More]

Crystal reports "Database login failed" when using push method

Category:DefaultRelease time:2015-10-11Views:130

I have a web application (ASP.NET, .NET v3.5), that pushes data to a CR 2008 report. On two servers one of the three reports returns a "Database login failed" error. I am stumped since there is no login, it's push not pull; in addition the probl[More]

Crystal Report Database Query

Category:DefaultRelease time:-0001-11-30Views:130

Hi I would like to ask regarding queries from the database. I have 2 main tables that gets their images from 1 master table. First is TASK table and Second is ASSET table. Both tables are relational. Each Task has Asset connected by Task_Asset_ID. Bu[More]

How to change crystal report data field at runtime ?

Category:DefaultRelease time:2015-10-11Views:130

Hello everyone, I have a Crystal Report file ,which i am using to generate report for my windows form project . In that report i have a filed called as Quantity which data type is set as decimal, the requirement is like that the number of value those[More]

Crystal report database logon failed through ODBC in report

Category:DefaultRelease time:2015-10-11Views:130

Please see viewpage.cs in type = "FPR"  in my web application https://sourceforge.net/projects/aspchequesprint/ is it my program code problem ? i edited as following also not work, when i update with crystal report 2008 sp1 it said version is to[More]

How to Change Crystal Report database name from visual basic code?

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I have created a Crystal Report (CR)  with .NET VB. I also have developd some UDTs for that pusrpose and everything is OK. However I cannot use the same CR in another Company which has the same UDTs. I have not found how Connect to Company (i[More]

Crystal Report Database connection problem in CMC

Category:DefaultRelease time:-0001-11-30Views:130

Dear All, We are using Business Objects XI 3.1, Crystal Report 2008 SP1 for report development. Crystal reports are generated using SAP BW Query. Where in, once you have published Crystal report to Enterprise server and open the same using Infoview i[More]

JSP & Crystal Reports Database Problem

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I hava problem with refreshing the crystal report web viewer if the report retrieves data from DB. If I don't refresh the report, it shows the report with default parameters. But when I refresh the report (I mean viewer.refresh()) it gives an[More]

Random Characters insterted into Crystal Reports string fields

Category:DefaultRelease time:-0001-11-30Views:130

I'm having a problem where random characters are being inserted into string fields in my crystal reports, I talked to a representative and they are unable to fix the problem, so I'm asking here if someone has a workaround.  The characters are always[More]

Hot
Hi all, I recently installed iTunes 11.0 onto my MacBook Pro, and I yearn for the days of far simpler content management.  All I want to do is add certain songs and playlists from my computer onto my iPhone without re-syncing the entire thing (every [More]
Hi, I use a 30 days trial of Crystal Reports 2008. When i try to connect with the database i always get the next error: [http://www.visiscan.nl/error.jpg] The database is 4.1GB large and there is 10GB free space on the database. Anybody can tell me w [More]
I am trying to copy and paste an image or picture from the internet and insert it into a word document. I select and copy the image from the internet page. I then go to the word document and select past special. When I select 'paste special' it only [More]
I'd like to connect these devices together.As Kevin J. Doyle points out, the displays from NEC are better than what Apple has to offer for graphics. For video, you'll need a broadcast capable monitor for accurate color correction. Not a computer moni [More]
I purchased iLife '08 (and iWork '08) two days after they were released. And really, I have to say, I think that they are both well worth $80. There's been so much talk about the shortcomings of iMovie '08, and maybe it's just me, but it seems like A [More]
Hello to all I am getting a problem. In 190(Development).. In PA30 and infotype 8 some wage types are included for employees. But these wagetypes are not refelecting in PA0008 table. When i went into change mode of PA30 and then save ... then these v [More]
Good Morning, I have a 10g 2 database using flash recovery. I checked the flash recovery area and in there is listed arc log files from February. I had clicked the delete expired several times but it does not take affect. Is this a known bug or am I [More]
Hi I have an application with multiples datagrid populate with an XMLList (internal). I've made the datagrid editable for quick change and at the end of the page there's an update button. I was wondering how I could make it work. The update button is [More]
So.. I have a Dual Core i7 MBP.... (also a quad core i7 iMac) is there a way to graphically see how different processes are being run on the different cores? In other words... can I see how efficent my computer is? when running different programs (Fi [More]
When I moved I wanted to update my profile, could not remember my password so I had to create a second account, now skype reverted to the first account, what do I do now? can't get to the second account.It could be a 'caching' issue with the browser. [More]