Creating reports and dashboards | Stimulsoft community forum

I've created a variable which is connected to a data column. The key is a numeric field and the value is the description of that key. I then use that variable as a filter parameter on the report.

I want to include that variable's value in my page hdr. When I try to do that it includes the 'key' i.e. numeric instead of the 'value'. How do I include the 'value' element of the variable please?

Hello.

Unfortunately, it's impossible to include the value to the variable.
The variable have the type and could have one key value only.

Thank you.

Thanks for your response HighAley. OK, if I can't get to the Value of the variable. Let me explain what I'm trying to do and perhaps you can show me another way of achieving what I want.

I have a table of tours. Each tour has an id, date, description, cityid. I then have a table of cities which has id, citydesc, countryid. I also have a table of countries which has id, countrydesc.

I have set up a tours_city relationship and city_country relationship.

I have then created a Country variable connected via the relationships to the id of the Country table and the value is the countrydesc field.

I have then created a report which shows tours by Country using the variable as a filter to only show tours for a single country. The actual content of the report works fine.

However I want in my page header to say 'Tours Report for Country : countrydesc'. First I put in the countrydesc field into the page header. However regardless of which country I chose as a filter the system only showed me the 'countrydesc' of the first country it found in the country table.

So please can you tell me how I can set up the report so that it shows the correct 'countrydesc' based on the filter chosen.

Thanks for all your help.

Hello,

Please send us your report with test data for analysis.

Thank you.

Aleksey I've sent you a copy of the report via email. However my data is MySQL so difficult to send. Thanks for your help.

Aleksey I have now done a mysqldump of the development data and emailed that to you too.

Hello,

You sent those file to what email? Please send them to support@stimulsoft.com

Thank you.

Hi Andrew, yes I sent them to support@stimulsoft.com. The subject line is :

How to include Variable Value (not key) in Page Hdr

Hello,

Ok. We will check it and reply by email.

Thank you.

I want to achieve the same thing. kindly guide me, how can i do that?