How to include Variable Value (not key) in Page Hdr
How to include Variable Value (not key) in Page Hdr
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?
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?
Re: How to include Variable Value (not key) in Page Hdr
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.
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.
Re: How to include Variable Value (not key) in Page Hdr
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.
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.
Re: How to include Variable Value (not key) in Page Hdr
Hello,
Please send us your report with test data for analysis.
Thank you.
Please send us your report with test data for analysis.
Thank you.
Re: How to include Variable Value (not key) in Page Hdr
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.
Re: How to include Variable Value (not key) in Page Hdr
Aleksey I have now done a mysqldump of the development data and emailed that to you too.
Re: How to include Variable Value (not key) in Page Hdr
Hi Andrew, yes I sent them to support@stimulsoft.com. The subject line is :
How to include Variable Value (not key) in Page Hdr
How to include Variable Value (not key) in Page Hdr
Re: How to include Variable Value (not key) in Page Hdr
Hello,
Ok. We will check it and reply by email.
Thank you.
Ok. We will check it and reply by email.
Thank you.
Re: How to include Variable Value (not key) in Page Hdr
I want to achieve the same thing. kindly guide me, how can i do that?