Crystal Reports Spring V9 "Make filter on map from the spring form"

Question

[Crystal Reporter] []1

I have this screen, I need to build a map that shows me the Monthly and Annual Analysis at the same time, but, from a query and not specific tables only that in this query I need a filter that is the year (2019) of the above Image.

How do I get the form 2019 insert into the map without using parameters? follows the query( the year (2019) needs to come from the form):

select *
from (

select a.rubrica, 
Jan=isnull((select sum(jan.acum) from AcRubricas jan where jan.rubrica=a.rubrica and month(dataac)=1 and year(dataac)=2019 ),0) ,
Fev=isnull((select sum(jan.acum) from AcRubricas jan where jan.rubrica=a.rubrica and month(dataac)=2 and year(dataac)=2019 ),0),
Marc=isnull((select sum(jan.acum) from AcRubricas jan where jan.rubrica=a.rubrica and month(dataac)=3 and year(dataac)=2019 ),0),
Abr=isnull((select sum(jan.acum) from AcRubricas jan where jan.rubrica=a.rubrica and month(dataac)=4 and year(dataac)=2019 ),0),
Mai=isnull((select sum(jan.acum) from AcRubricas jan where jan.rubrica=a.rubrica and month(dataac)=5 and year(dataac)=2019 ),0),
Jun=isnull((select sum(jan.acum) from AcRubricas jan where jan.rubrica=a.rubrica and month(dataac)=6 and year(dataac)=2019 ),0),
Jul=isnull((select sum(jan.acum) from AcRubricas jan where jan.rubrica=a.rubrica and month(dataac)=7 and year(dataac)=2019 ),0),
Ago=isnull((select sum(jan.acum) from AcRubricas jan where jan.rubrica=a.rubrica and month(dataac)=8 and year(dataac)=2019 ),0),
Sept=isnull((select sum(jan.acum) from AcRubricas jan where jan.rubrica=a.rubrica and month(dataac)=9 and year(dataac)=2019 ),0),
Outb=isnull((select sum(jan.acum) from AcRubricas jan where jan.rubrica=a.rubrica and month(dataac)=10 and year(dataac)=2019 ),0),
Nov=isnull((select sum(jan.acum) from AcRubricas jan where jan.rubrica=a.rubrica and month(dataac)=11 and year(dataac)=2019 ),0),
Dez=isnull((select sum(jan.acum) from AcRubricas jan where jan.rubrica=a.rubrica and month(dataac)=12 and year(dataac)=2019 ),0) 
from AcRubricas a where year(a.DataAc)=2019  group by a.Rubrica) mensal
inner join
(select rubrica,sum(Acum) as Acumulado,sum(orca) as Orcamento,( sum(orca) - sum(Acum)) as desvio from AcRubricas where  year(DataAc)=2019 group by rubrica) anual on anual.rubrica = mensal.Rubrica

Answer 1

I would say that the simplest is to create a view based on this query, removing the filter by Year and grouping the data by Year. Then create a new map based on the existing one. You add your View to the map, you can link to the existing table, for example by Rubric, thus having the filter of selected rubrics in the window. Inside this map you have a field "Year" ("formula field"), which is passed by Spring. Use this field to filter the data to be presented.