I have some problems with parameters. I think I have mis-understood them.
We use a system that produces a accounting reports for limited companies. It also generates the business tax calculations and files them online.
I have a report that extracts data from the SQL DB and using a date picker, it populates 3 visuals.
Visual 1 is a matrix showing key values over 5 years and Visual 2 is a bar chart representation of Visual 1.
Visual 3 shows the business tax paid over 5 years.
I use @Melissa date query.
I have two parameters. One that prompts for the first month in the Financial Year and the other for the client code.
When I look at the tables, the M Query has worked as planned. I only have the data that I need.
Now for the Problems
- I assumed the report would display the data automatically in the report. But instead, I still have to go to the Page Filter and tick the Client to have the data display. The only client code available in the Filter List is client code in the parameter.
Is this by design or have I missed something? Should the filter have happed automatically?
- The client parameter is a list. I had assumed the user would only be able to choose something from that list, but they can enter anything.
Is this by design?
- Final question. Having created all of these parameters, I have just read that they cannot be used when the report is published. They can only be used on Desktop.
Is this still the case?