Display Picture in a Crystal Report from a FileName in a database table

07-Jun-1313 Leave a comment

http://www.c-sharpcorner.com/forums/thread/116813/how-to-display-images-using-crystal-reports-with-file-names.aspx

http://visualbasic.ittoolbox.com/groups/technical-functional/visualbasic-l/how-to-display-jpg-file-in-crystal-report-using-file-path-from-sql-table-1640366

1)Save a default “Not Available” image in your images folder (you
can download one from google small images).
2)open crystal reports
3)Go to the Insert menu.
4)Click on Picture. – Also works if you use an OLE Object
5)A window will open for you to choose a picture, choose the
default one from step 1.
6)click ok and place it on the report.
7)Right click the image & click Format Graphic.
8)In the form that will open, click on the “Picture” tab.
9)Click on the formula button next to “Graphic Location”.
10)In the formula editor that will open, just select the path
field from your table and save the formula.

Filed under Crystal Reports

Crystal Reports Error: The request could not be submitted for background processing

06-Mar-1313 Leave a comment

If there is a database picture this may need to be re-imported

Filed under Crystal Reports, Errors, Troubleshooting

Crystal Reports – Invalid Argument provided. Failed to open a rowset. Error in File Invalid argument for database

17-Jan-1313 Leave a comment

At first thought it ran OK in Crystal not when called from program.

Then checked that it ran from the program on the Crystal developer machine OK.

So runs OK on developer’s machine not on particular user’s machines.

Hence error with ODBC. Changed developer machine ODBC to use from SQLNCLI to SQL Server Native Client 10.0 i.e. SQLNCLI10 and then went to report and “Set Location” for the newest table, the report then worked on all machines

Filed under Crystal Reports, Errors Tagged with

Visual Studio 2010 with Crystal Reports error ‘ The type initializer for ‘CrystalDecisions.Shared.SharedUtils’ threw an exception’

19-Oct-1212 Leave a comment

On a x64 PC

‘ The type initializer for ‘CrystalDecisions.Shared.SharedUtils’ threw an exception’

Project properties > Compile > Advanced Compile Options > Target CPU change to X86

Or on install of SAP Crystal Reports Version for Visual Studio 2010 tick box for running x64

With thanks to

http://www.logicaltrinkets.com/wordpress/?p=213

and for runtime

http://www.businessobjects.com/jump/xi/crvs2010/us2_default.asp

 

Filed under Crystal Reports, Errors, Visual Studio

Crystal Reports run-time error – “Failed to open a rowset”

09-Dec-1111 Leave a comment

Details: HY000:[Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another comand

SOLVED
Report ran in Crystal Reports designer. Problem turned out to be that there was an unlinked table in Visual designer. Replaced the fields from this table with fields in a view, then removed this table from the report and report then ran

USED this entry:
SRS 18th Dec 2012

THIS ERROR Can also be if there are truly multiple start points for your Crystal Report

In this case use two connections.  This could be the same ODBC connection added to the report again. This works as proved 11-Jan-13
See Purchasing\Requirements.rpt

Filed under Crystal Reports, Errors Tagged with

ODBC Crystal Reports ODBC hanging due to Tracing Log file

07-Dec-1111 Leave a comment

Problem on a colleagues machine where ODBC was very slow on Crystal Reports.

We thought problem was due to 32-bit and 64-bit ODBC. Possibly see http://support.microsoft.com/kb/942976

SOLVED
However problem was that ODBC > Tracing > Tracing was on. Stopped it and crystal reports immediately went quicker. The log file was also very big 200,000 Kb.

Filed under Crystal Reports, Troubleshooting Tagged with

Crystal Reports specified DSN contains an architecture mismatch between the Driver and Application

09-Aug-1111 Leave a comment

Database error: MicrosoftODBC Driver Manager The specified DSN contains an architecture mismatch between the Driver and Application. (IES 10901) (WIS 10901)

On Windows 7 there are two ODBC. Probably want the first of these:
C:\Windows\SysWOW64 use against 32 bit data
C:\Windows\System32

However this could be mis-leading, as was the case this morning. It could be that a DSN is missing. Or perhaps missing from the correct ODBC.

Filed under Crystal Reports, Errors

Search Crystal Reports in Visual Studio for table/procedures

03-Aug-0909 Leave a comment

 
 
This is a part of the VB proc I built to generates the list of all tables used by my reports. Reports are listed in a ‘reports Table’, and I use a memo field to store the name of all used tables. It is then quite easy to update all requested reports once tables have been modified.
Publicfunction tablesUsedByAReport(myReportName asstring)asstringDim m_report As CRAXDRT.Report, _      m_crystal As CRAXDRT.Application, _      m_tablesUsedByAReport AsStringDim m_table As CRAXDRT.DatabaseTable, _      m_section As CRAXDRT.section, _      m_objet AsObject, _      m_subReport As CRAXDRT.SubreportObjectSet m_crystal =New CRAXDRT.ApplicationSet m_rapport = m_crystal.OpenReport(m_nomRapport,1)'table names in the report'ForEach m_table In m_rapport.Database.tables    m_tablesUsedByAReport = m_tablesUsedByAReport & m_table.location &";"Next m_table 'table names in each of the subreports'ForEach m_section In m_rapport.Sections    ForEach m_objet In m_section.ReportObjects        If m_objet.Kind= crSubreportObject Then            Set m_subReport = m_objet            Set m_report = m_subReport.OpenSubreport            ForEach m_table In m_rapport.Database.tables                m_tablesUsedByAReport = m_tablesUsedByAReport & m_table.location &";"           Next m_table        EndIf    Next m_objetNext m_section 'my tables list'tablesUsedByAReport = m_tablesUsedByAReport Endfunction

 

Filed under Crystal Reports, Visual Studio