Creating reports and dashboards | Stimulsoft community forum

I have the following data schema: I have created a data source for each of these tables. I have then created a relationship for Tour_City and another City_Country.

Based on the above relationships I can extract the following information in a single data band as follows:

{Tours.id} {Tours.tourdesc} {Tours.Tour_City.citydesc} {Tours.Tour_City.City_Country.countrydesc}

I now need to provide a parameter where the user selects from the list of countries from the Countries.countrydesc and that brings up only those Tours which are in that country.

I created a variable called Country and linked it to the Data Column key = countries.id and value = countries.countrydesc. I now need to tell sql query to use this variable.....and that's the bit I can't do.

Please will you tell me how to do that.

Currently my query strings are :

select id,tourdesc, tourcityid, from tours.
select id, citydesc, countryid from cities.
select id, countrydesc from countries

All help gratefully received with thanks.

It's OK I've found out that the way to do this is to create a Filter on the Data band and then use the country.id through the relationships and make it equal to the variable. That then works fine.

However I would like to ONLY present a final pdf file to the client rather than via the viewer. I can arrange to request their choice of country.id via other programming ways. If I do that then how do I present to the report progammatically the filter parameter?

Thanks for your help.

Hello,

You can use an additional variable which uses in the filter and set before rendering, exporting report.
You can find samples at the following link:
https://www.stimulsoft.com/en/samples/js

Thank you.

Hi Aleksey

I looked through all of the JS samples and I couldn't find any that dealt with parameters. There are a couple of videos which show how to work with parameters but not through code.

Please could you tell me which particular samples I should look at. Thanks.

Hello,

You can use the following code to set the value for variable from code: Thank you.

Thanks very much for that info Aleksey. I'll have a try.

I'm beginning to realise that there is a LOT MORE functionality within the software than is described in the documentation, samples or videos. Is there anywhere I can get at the 'Object' models for the JS version please? That would allow me to understand what other functionality I could use.

Hello,

You can find documentations:
https://www.stimulsoft.com/en/documenta ... er-manual/
https://www.stimulsoft.com/en/documenta ... ng-manual/

Samples:
https://www.stimulsoft.com/en/samples

Thank you.