Page 1 of 1
Some problems
Posted: Wed Sep 13, 2006 10:25 am
by 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)
Some problems
Posted: Wed Sep 13, 2006 11:07 am
by Edward
Tommaso wrote: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).
Tommaso wrote:
- 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.
Some problems
Posted: Thu Sep 14, 2006 5:26 am
by 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
Some problems
Posted: Thu Sep 14, 2006 11:13 am
by Edward
Tommaso wrote: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
Tommaso wrote:
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.