Crystal Reports & PB : database Connection Handle
Hello all of you,
I'm using the function <Application>.LogOnServerWithPrivateInfo( ..., ...)
to connect our Crystal Reports interface to the database, specifying a valid
ODBC connection handle.
1) I have succesfully used this function for any ODBC connection. However,
when I make a NATIVE connection within PowerBuilder to an Oracle 8i instance
this doesn't work.
In this case, I get a messagebox from CR saying that an invalid connection
handle has been passed. I understand the problem because no ODBC connection
is used. However, I do not know how to correct this probl...Crystal Reports switch database OR set parameter, but does not allow both
I have a collection of Crystal Reports that are based on stored procedures in our test database. When the user selects a report, I need to load up that report, point it to the production database, and set the paramaters for the stored procedure. If I leave it pointing to the original test database, then I can set the parameters and it works. OR, I can change it to point to the production database, and it works then too, except then all the parameters are set to NULL. I have tried setting the parameters both before and after I change the database location, and when I step through in the ...does anyone use Web Services to set the database connection for Crystal?
just exploring the possibilites of using a web service in conjunction with Crystal reports.
Has anyone tried this out?
psinycThanks, Peter Iuvara, MCP...Using Stored Procedure Parameter and changing Database Location at run-time in Crystal Report
New Page 1
I use Crystal Report for .Net
2005(Crystal Ver.10.2.3600.0), MSSQL 2000 where I have created an Stored
Procedure having two paramenters. I am using this Stored procedure to print a
Report in Crystal Report. I pass parameter to this Stored procedure through
ASP.Net Page. This works fine but if I use this Report for diffrent DB Server or
diffrent Database and use DBLogonInfo to set new location for stored procedure
in Report, Report is Displayed but parameter critaria is on accepted and report
is not displayed within the range.
My Code is as Following
Imp...Help! Prompt window shows "Logon Failed..." in Database Expert when trying to use Dataset for crystal report!!
Here's what I'm doing,
1) I created a Dataset (named dataset1) in my project by "Add New Item"/Dataset
2) Added some tables into the Dataset(dataset1.xsd file) by dragging tables from the Server Exployer
3) Created a crystal report and trying to linking the Dataset created in step 1. In Database Expert/Data tab, I selected Project Data/ADO.NET Datasets and click the plus beside dataset1, after another window for selecting Data Class Name, a prompt window comes out say "Logon failed. Details: Object reference not set to an instance of an object."
Anybody...The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.
I'm not sure what this error is referring to.
I've built a report and it runs in the IDE in preview mode, however when I try to deploy it, I get this error message.
...how to build Invoice & Accounts format reports using crystal web reports
i am doing payroll system which is related to accounts i need to generate beautiful invoices using crystal reports , how can i can u help me ...data truncation problem while Exporting report to PDF using Crystal Reports 11.0
I need a solution for data truncation problem while Exporting report to PDF using Crystal Reports 11.0 version.
...Can some one show me a example that search a SQL database and use a table to show all results?
Can some one show me a example that search a SQL database and use a table to show all results?
Thank you very much~
Well can you be more specific?
Do you know what fields (information) and what tables that database
contains? Do you know what you're searching for?? (specific information
for each field)
or do you want to simply "scan" the database for tables and do a generic search?
I don't suffer from madness, I enjoy it every minute of my life
ok, I'm doing a website using Asp.net 2.0 + C#
I have a SQL database which contains a Table called "CodeTable"
Fields: ...How to create Charts using Crystal Report 2008 which uses stored procedure that takes parameters
Question#1: Can someone explain how to create charts using Crystal Report 2008 which uses stored procedure? My stored procedure will take parameter from textboxes.
Question #2: After creating, how I can deploy them into web (Visual Studio 2008 using C#) applicationAnil Singhal
Hi read these articles http://aspalliance.com/215_Creating_Professional_Reports_using_Crystal_Report_for_Visual_StudioNET_Part_1.allhttp://aspalliance.com/265_Crystal_Report_for_Visual_Studio_NET.allhttp://aspalliance.com/crystal/ Don't say thanks rather mark my reply as "Answe...Crystal Report && sqlserver Reporting Service
I am new to the reporting service.Can anyone tell me which one is Best Crystal Report && sqlserver Reporting Service.sqlserver Reporting Service is it required liesence?i am working in a web application which need 200 -300 reports regular basic.Please give me a solutions urgently
To Compare Reporting Services. vs. Crystal Reports / Crystal Enterprise
http://images.globalknowledge.com/wwwimages/whitepaperpdf/SQLvsCrystal_WP.pdf?bcsi_scan_2229F3D84EB...Report that is using ObjectDataSource that uses a proc is showing report with no data?
I was in a hurry so I used the wizards to do this even though I have a strong dislike for them.
I have verified that the parameters return data when using the proc.
The data source is set in the ReportViewer controls properties in design mode.
What might I have missed?
Here is my code that get's called when a button is clicked.paramList = New List(Of ReportParameter)
paramList.Add(New ReportParameter("StartDate", startDate.Date, False))paramList.Add(New ReportParameter("EndDate", endDate.Date, False))
Re...How do I deploy an application using crystal reports/install crystal reports?
First of all: C# .NET framework 1.1, IIS 6.0, XP SP1, Windows forms - not ASP.NET but I don't see how it would make a differenceMy Situation: I am tasked with adding to an application the ability to generate a crystal report. It currently has nothing to do with them.The application runs on an XP system with .NET 1.1 installed but lord only knows how it was installed on there (the guy that set it up is long gone and from past experience with his work I think he was just guessing anyways) In an attempt to see if crystal reports was installed, I wrote a quick test forms appl...how show image from database in crystal Report
hi all ,
i have to show user image in his status report but i not avial to get the user image in Crystal Report
how i can get the user in image in crystal report i m using 2003.net /sql2000
User image saved in DB(datatype Image)
New In .NET World
You can add image just like any other db field, drag and drop the image field on ur report.
if u have saved the image in db field User_image
add that field in query and drop that field on ur report....