Creating reports and dashboards | Stimulsoft community forum

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.

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.

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 ?

Hello,

Please see the sample report in attachment.

Thank you.