Reports with dynamic columns

[midhun.os]

Hi ,
We are looking for implementing stimulsoft designer and reports for our web application. I would like to know whether the following items can be met by the reports

1. Can we have render dynamic colums using stimulsoft reports engine?

eg

while designing , the user might be designing the report like

Origin Destination [weightbreakRates] EffectiveDate Expiry Date


But when we render the report, the data set will contain columns like 1 ,100, 500, 1000 . we need to replace the [weightbreakRates] palce holder with these dynamic columns
So the rendered output should be something like follwoing.

Origin Destination 1 100 500 1000 EffectiveDate Expiry Date

LHR JFL 10 15 20 25 10-10-2010 UFN
JFK EWR 30 50 70 100 08-05-2010 12-12-2012

The number of dynamic columns can vary from 0-50. We should be able to render the report by dynamically adjusting the column width.
2. Can we add images to a reprot , when the user imports images in the reports designer, where it will be get saved?

4 Can we design report in such a way, if there in no values available for rendering the column, we have to hide that column.

[Alex K.]

Hello,
[quote="midhun".os]1. Can we have render dynamic colums using stimulsoft reports engine?
eg
Origin Destination [weightbreakRates] EffectiveDate Expiry Date[/quote]
In this question everything depends on the form in which data are represented. If [weightbreakRates], each value is represented by a separate entry, then you can use a cross databand.

[quote="midhun".os]2. Can we add images to a reprot , when the user imports images in the reports designer, where it will be get saved?[/quote]
An image added in the report (.mrt file) is stored in it.

[quote="midhun".os]4 Can we design report in such a way, if there in no values available for rendering the column, we have to hide that column.[/quote]
It depends on the data representation, but in any case, it can be done.

Thank you.

[midhun.os]

Thank you for the quick reply.
We use data sets. Our data model looks as follows



38423

2001-01-01T00:00:00+05:30
9999-12-31T00:00:00+05:30
false



false
true
Special promotions avaiilable from August
false
false
false

GBP
4671
UK
Special Rate
BA
1
1
General
1
PAX
LD
NO
80
2001-01-01T00:00:00+05:30
9999-12-31T23:59:59+05:30
38423
4.3000
4.2000
4.5000
4.4500
Y
Y
Special Rate
AAA
BBB
Tito Airport 1 test sample234 (TC)
Tito Airport 2 [TCI] (TC)


WeightBreak
100


WeightBreak
250


WeightBreak
1


WeightBreak
45


OptionalColum
CarrierProduct


OptionalColum
Prepaid


We need to generate report based on the "WBTariffRates" table . "ColumMetaData" Table will give info regaring the [weightbreakRates] columns. We have to dynamically define the columns based on the data in "ColumMetaData" Table.
Could you please help me with a sample report ?

[Alex K.]

Hello,

Please see the sample report in attachment.

Thank you.