Sitemap

Amicuk Programming Answers

Crystal Reports DataBase Fields

-0001-11-30   Views:1

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
The performance while you are using softwares like Illustrator, Photoshop and a 3D software like Maya together, Windows XP 64 "KILLS" the Windows 7 64, I've a computer i7 960 with 24GB ram, in my Windows XP 64 SP2, and yes, I'm using them all, f [More]
HI Friends After creating the invoice account posting has not been happened. Please specify what are the reason would be there. regards,Hi, Please go to VFX3 or VF02 there there u just try to releas the document manually and let us know what is the e [More]
This is the address to the website in question www.chartiermotorports.com. My dilema, when I navigate through the website, the slideshow in the header displays on all the pages except, now, when I get to the 'MULTIMEDIA' page then click on any of the [More]
My wifes iphone 5 and my 5s use different itunes and icloud logins...yet changes to her calendar for example reflect on my phone immediately.  Her icloud acct shows her contacts and calendar....mine shows neither.  Thoughts or suggestions...DanThis s [More]
Hi Gurus, I know the BAPI to change Article Master is BAPI_MATERIAL_MAINTAINDATA_RT.  Can you please let me know if there is any BAPI which i can use for MASS update of articles instead of calling the above BAPI in a Loop. My purpose is to mass udpat [More]
My dad, brother, and I share my apple ID and we all have the iCloud thing. And if there are photos and I delete all of them, will the photos delete on their devices too?Only the ones in photo stream, but not the photos that they have taken and which [More]
Hi there, I found that my Adobe flash player (version 10) is causing my computer to hang. I know this because when I disable it, it dosnt hang. I have tried to unistall and then installing version 9 Flash. With version 9 I am still having the same pr [More]
The Firefox bar has disapeared, is gone. What can I do to get it back?'''Menu Bar''' (File, Edit, View, History, Bookmarks, Tools, Help) Press ALT+ V T M (CTRL+V T M on Macs) on your keyboard. This should restore the menu bar (Firefox 3.6) '''Other t [More]
I download XSQL servle and set it up already. Now I try the "Adhoc Query Visualization" from my own database, but if I query from a view or from a object type is varchar2 then I will get the memory location. I tried the same example from OTN liv [More]
Download of new CS6 noted as "sucesssful"; but I found no instructions for installation after unzipping.  I don't want to download again (it took 3 hours).  Are there any alternatives? There apears to be some pieces of code missing.  Is there an [More]