Database Administrators
Q&A for database professionals who wish to improve their database skills
Latest Questions
0
votes
1
answers
438
views
SSRS2016 external parameters for mobile report
How can external parameters be passed to a SSRS 2016 mobile report in order to pre-select values / settings for the report? The same scenario is possible for paginated reports as it always was. It's one of the key functionalities. In my scenario I need to integrate the reports into an existing appli...
How can external parameters be passed to a SSRS 2016 mobile report in order to pre-select values / settings for the report?
The same scenario is possible for paginated reports as it always was. It's one of the key functionalities.
In my scenario I need to integrate the reports into an existing application. So some settings like USERID or LANGUAGE must be passed to the integrated report to initialize it correctly. It's not tolerable to expect a user of the application to choose a language every time he/she runs a report inside of the application...
Besides setting parameters for the datasets within the mobile report I could not find any option to take values from external / url...?
Any solutions?
Magier
(4827 rep)
Jul 29, 2016, 07:55 AM
• Last activity: Apr 20, 2025, 09:01 AM
1
votes
1
answers
1962
views
Personal Finance App Monthly Reports Database Design ( SQLite )
I am building a personal finance mobile app that supposed to generate monthly reports, now I have a problem, confused about how to design the database to be monthly, I need the wallet to get archived after a month from the day it's created and transfer the remains/loss to the new wallet ( next month...
I am building a personal finance mobile app that supposed to generate monthly reports, now I have a problem, confused about how to design the database to be monthly, I need the wallet to get archived after a month from the day it's created and transfer the remains/loss to the new wallet ( next month ) if exist.
Now my idea is to generate one wallet with xx money and let the user change the start date and make the mobile app automatically generate a new wallet every month on that day with the necessary transactions like there a loss/remain from the old wallet, and archive or prevent the user to make any transaction to the old wallets.
**does my logic make sense or ...?** ( Note I'm still learning and this my first app using SQL/Database so please be patient with me )

hesham shawky
(111 rep)
Apr 2, 2021, 05:06 PM
• Last activity: Apr 6, 2021, 06:55 PM
3
votes
2
answers
813
views
SSRS 2016 Mobile Report Color Settings
In SSRS 2016 Mobile reports are a new option for Native mode report server. I have created several now and there appear to be consistencies between colors on different charts and graphs if the same columns are used in the setup of each element. However, I cannot find any way to consistently keep col...
In SSRS 2016 Mobile reports are a new option for Native mode report server. I have created several now and there appear to be consistencies between colors on different charts and graphs if the same columns are used in the setup of each element. However, I cannot find any way to consistently keep colors across slicer changes. Is there a work around, a setting a missed, a code behind, some way to ensure that when I change a parameter my chart legends do not suddenly swap colors?
This is with an "All" level setting on the parameters.
This is the new colors scheme after a parameter has been selected and the report updates with the new quantities. Totally unacceptable - this renders the report nearly worthless.
This behavior happens across reports and data sets for me. I would have tried to set an ordering as it appears to change based on quantity changes in each category, but there are no ordering settings for pie charts.


Dave
(2399 rep)
Jul 26, 2016, 05:17 PM
• Last activity: Aug 3, 2016, 11:28 PM
Showing page 1 of 3 total questions