hi Is there any way to send null to an optional stored procedure parameter via crystal reports8.5 and vb6? I use CRXParamDef.AddCurrentValue method to send stored procedure parameter values. ...
hi I've created a new report using crystal reports 8.5. In it, I've used 3 sub reports and they are positioned in main report vertically. My question is, How can I stop overlapping them with each other and also with the down border of the main report? thank you ...
I'm using Crystal Reports 2008. I need a report that shows monthly performance. It doesn't make sense for the user to select a date. What I need is for the user to select the month and year from a drop-down box. Any ideas? ...
I have been asked to convert a legacy app containing some crystal reports from vb6 standalone to .net c# web based application This is my first .net c# web app so I am learning as I go My attempts to get crystal reports .net (included version not licensed) have failed. I was pleasantly surprised to find that I could simply copy the ....
SUBSTRING(SLAC_CNTRL_ACNO, 3, 4) how can i use this query in crystal report ...
I have a problem with creating an report in my Webservice with ASP. Lokally everything works fine, connecting to SqlServers or MySQL Servers is no problem at all. But now !'m trying to connect to a SqlServer 2005 and i get an error, somthing about a database vendor code 17 (it's a german version, so i won't directly post the whole error...
I have a Crystal Report in Visual Studio 2008 (C#). Its datasource is set programmatically at run-time to a .NET list, defined as follows: List<visit_volume> Visits a visit_volume looks like this: public class visit_template { private int _numberOfVisits; public int numberOfVisits { get { return this._numberOfVis...
SUBSTRING(GLBT_OUR_DOC_NO, 3, 2) = ISNULL('{?Branch Code}', SUBSTRING(GLBT_OUR_DOC_NO, 3, 2)) how can i check the above condition oin crystal report formula editor ...
I using a three columns in my crystal report credit, debit ,netamount.Here net amount is the running total fields.i have done like this using a formula like{credit}+{debit}.and this formula i have invoked in the running total the net amount is calculating fine but a small issue in this i have to show net amount with cr and dr how to do t...
I need to get data from reports fields to open others windows forms or other reports, How I can get the values of reports fields to pass to local C# o VB.net variables ? ...
Hai Friends I am developing similarly 50 reports each reports i am having one aspx file.i want to club these reports to a single aspx file.user will run only yhat single aspx file all the reports should run.how its possible pls expalin me briefly. ...
I have a Visual Studio 2008 solution which is multi-layered. In one of those projects (which is not the main project and is actually a Class library) i have a Crystal Report file which i want to be included in the deployment of the application. I tried several settings with no success. How can i achieve deploying this report file with...
I have been asked to find out if it is possible to connect Cyrstal Reports to a MYSQL database within a php website. Is this possible? Are their any alternatives Thanks Edit I suppose in the perfect world I am wanting to show crystal reports within a PHP website ...
Here is a strange problem I have run into. My record select formula is as follows, I have dumbed it down for purposes of this error: reportDocument.RecordSelectionFormula = " {@ClientName} = 'Smith' " If I copy this exact selection statement into Crystal it previews fine, but when run from .NET I get 'This field name is not known'. The...
I have the following code: select order_number,received_date from order_head where order_head.order_number not in (select order_number from csa_log group by order_number) and ordernature in ('02','03') and received_date > '01.01.2010' and buyer_code = 'GAP' group by order_number,received_date order by received_date desc When run in cr...
I have 2 reports needing to list the same amount as they group differently and both require the amount to be rounded to the tenth place. Example: October data County Tons Date AB 2.48 10/01/09 AB 2.25 10/15/09 AB 2.34 10/15/09 BC 2.76 10/02/09 BC 2.85 10/03/09 BC 4.74 10/03/09 a. Monthly report - Example (October) ...
Would someone please explain the difference? Are these the same product, and if not what are they each used for? ...
How do I find statitics on how often certain reports are run from our Crystal XI R2 Server? How can I determine which reports are not being used? A Google search was fruitless. ...
We need to make a Crystal Report pop up a custom error message and then stop running. Numerous Google searches have not even found anyone else asking how to do this before. (The error is triggered to prevent the user from accidentally making a long running query that pegs the CPU on the database server. The report has no parameters, the...
Dear all, I want to display dynamic column at run time in crystal report. Example : If January then 31 column will displayed. If February then 28 column will displayed. If March then 31 column will displayed. If April then 30 column will displayed. How to make dynamic column in crystal report? ...