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

Stimulsoft Reports.JS discussion
nexar
Posts: 31
Joined: Tue May 02, 2017 5:55 pm

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

Post by nexar »

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?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

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

Post by HighAley »

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.
nexar
Posts: 31
Joined: Tue May 02, 2017 5:55 pm

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

Post by nexar »

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.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

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

Post by Alex K. »

Hello,

Please send us your report with test data for analysis.

Thank you.
nexar
Posts: 31
Joined: Tue May 02, 2017 5:55 pm

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

Post by nexar »

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.
nexar
Posts: 31
Joined: Tue May 02, 2017 5:55 pm

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

Post by nexar »

Aleksey I have now done a mysqldump of the development data and emailed that to you too.
Andrew
Posts: 4104
Joined: Fri Jun 09, 2006 3:58 am

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

Post by Andrew »

Hello,

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

Thank you.
nexar
Posts: 31
Joined: Tue May 02, 2017 5:55 pm

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

Post by nexar »

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

How to include Variable Value (not key) in Page Hdr
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

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

Post by Alex K. »

Hello,

Ok. We will check it and reply by email.

Thank you.
Qurat
Posts: 1
Joined: Thu Mar 29, 2018 7:20 am

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

Post by Qurat »

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