Some problems

[Tommaso]

Hi, I've got some problems with designer and preview:

- ProcessingDuplicates doesn't work with my own reports, while works with samples (but I can't figure out any difference);
- Formatting a TextBox with DateTime or Money and setting nothing for null values doesn't work; it still shows "€ 0.00" for Money null values and "01/01/0001" for DateTime null values;

I'm using StimulReport 1.60, trial version, with Oledb connections and data sources, and Italian language (on italian Win XP SP2)

[Edward]

Hi, I've got some problems with designer and preview:

- ProcessingDuplicates doesn't work with my own reports, while works with samples (but I can't figure out any difference);

For the version 1.60 ProcessingDuplicates property works when the StiText components are on one line and have summary height the same as height of the band. If the height of StiText differs from the height of Databand use GrowToHeight property of StiText;
Also please see flashtutorial http://www.stimulsoft.com/livedemos/Rep ... cates.html
Latest build of StimulReport.Net has extended functionality of ProcessingDuplicates property.
Please contact us at for the patch for your version of StimulReport.Net (please specify .Net version).

- Formatting a TextBox with DateTime or Money and setting nothing for null values doesn't work; it still shows "€ 0.00" for Money null values and "01/01/0001" for DateTime null values;

I'm using StimulReport 1.60, trial version, with Oledb connections and data sources, and Italian language (on italian Win XP SP2)

In PropertyEditor of Designer please select Report component. Set ConvertNulls property to false.
Thank you.

[Tommaso]

Thank you.

I've got another question. I need to build two calculated columns (like Crystal Report formulas) in this way:

columns from data source:
pay_date = date field
end_date = date field
pay_value = decimal field

calculated columns:
state = string field
value_to_sum = decimal field

To calculate "value_to_sum":

Code: Select all

if (pay_date is dbnull.value) then
  value_to_sum = pay_value
else
  value_to_sum = dbnull.value
end if

To calculate "state":

Code: Select all

if end_date < datetime.today andalso pay_date is dbnull.value then state = "SCADUTA"
if not pay_date is dbnull.value then state = "INTERESSI"

I've tried some ways to do this, but I can't understand if I'm wrong or there's a bug; I tried to write code directly in the "Value" box of calculated column; I tried to write a function in report code to do the work and then call it with parameters in "Value" property; but nothing works. Besides I noticed that, even if the formula is quite simple, such as "RPT_PAGAMENTI.DATA_PAG < DateTime.Today", report doesn't show values for each row, even if RPT_PAGAMENTI.DATA_PAG has always a value
I'm using VB.NET language. regards

[Edward]

Thank you.

I've got another question. I need to build two calculated columns (like Crystal Report formulas) in this way:

columns from data source:
pay_date = date field
end_date = date field
pay_value = decimal field

calculated columns:
state = string field
value_to_sum = decimal field

To calculate "value_to_sum":

Code: Select all

if (pay_date is dbnull.value) then
  value_to_sum = pay_value
else
  value_to_sum = dbnull.value
end if

Please use ternary operation for calculated column.
In VB.NET you should use the IIF function.
Unfortunately this function is not a part of the VB.NET language so you need to add the Microsoft.VisualBasic.dll to your list of referenced assemblies and add Microsoft.VisualBasic to your list of NameSpaces.
Please write the following code in

Code: Select all

IIf(pay_date is DBNull.Value(), DataSourceName.pay_value, DBNull.Value())

DataSourceName - datsource, containing your field

To calculate "state":

Code: Select all

if end_date < datetime.today andalso pay_date is dbnull.value then state = "SCADUTA"
if not pay_date is dbnull.value then state = "INTERESSI"

I've tried some ways to do this, but I can't understand if I'm wrong or there's a bug; I tried to write code directly in the "Value" box of calculated column; I tried to write a function in report code to do the work and then call it with parameters in "Value" property; but nothing works. Besides I noticed that, even if the formula is quite simple, such as "RPT_PAGAMENTI.DATA_PAG < DateTime.Today", report doesn't show values for each row, even if RPT_PAGAMENTI.DATA_PAG has always a value
I'm using VB.NET language. regards

Also you may define your own function in report code and use result of it for the calculated column.
Please see the flash Tutorials
1. Calculated columns http://www.stimulsoft.com/livedemos/Rep ... ields.html
2. Custom function in report
http://www.stimulsoft.com/livedemos/Rep ... ction.html

You also may send your report to for analysis.
Thank you.