Thursday 19 December 2013

Add SSRS Report in Dynamics SL 2011Menu

This post is an effort to the various operating steps which helps to adding the SSRS Report under SL menu

   Step 1: Create New SSRS Report or use existing Report (.rdl) 

   Step 2: Include the report in SL root folder under Usr_Rpts

   Step 3: Open SL 11 -> Administration->Maintenance -> Report Control Maintenance  (98.300.00)

       Enter the Report information Report number, Report format name, Report format into the Report 
       Control  maintenance .


   Step 4:  Open SL 11 -> Administration->Maintenance -> Screen Maintenance (98.330.00)

       Enter the Report number, Report name, Module and Type 


   Step 5: Open SL 11 -> Administration->Maintenance -> Menu Maintenance (98.350.00)
  1. Select the relevant Group in “Menu for Group”.
  2. Select the Screens tab in the Menu Maintenance (98.350.00). 
  3. Select ALL- Show All Screen from the Drop-down “Show Screen Access for Group”.  This will show up all the SL screens in the Screens tab.
  4. Select the exact Report  from the Screens tab. Drag and drop the Report into the “Navigation pane work area” under  Inventory -> Report .
  5. After add the report to menu exactly as a normal crystal report,but rename  the program ROISRS.EXE replacing from ROI. EXE.Report as shown in the below figure. 
  6. Save and close the screen.


  Step 6:  Close the Solomon and launch it.

Tuesday 10 December 2013

Dynamics SL Shortcut Keys

These shortcuts work in Dynamics SL:
  Are you using your F keys?  Some favorites:
F1 - Opens SL Help specific to the screen you are on
F2 - In a date field, brings up the relative period or relative date values; in a text field, allows enables cursor movement inside the field (including “Home” & “End”)
F3 - Opens PV list or the calendar on date fields.  If you prefer the mouse, double right click on the field.
F4 - Toggles between “Field View” and “Grid View” – i.e. change lines to grid and grids to line in your detail areas.  Double left click for the same results
F5 - Clears the value in a field
F6 - Insert Object wizard in Standard screen customization
F7 - Inserts today’s date in a date field
F9 - Opens “Yellow note” for editing 
F10 - focus on the Solomon Tool Bar
Alt + Ctrl + C - let's launches customize mode
ALT + F4 - Closes the active screen.
SHIFT+F3 - "Super" PV
SHIFT + F4 – Customized property browser for the selected control.
CTRL + S - Concluding error checks, save all changes in the current screen.
CTRL + E - Exports the grid detail to an Excel Workbook.
CTRL + HOME – Focus first segment of row in the Grid.
CTRL + END – Focus last segment of row in the Grid.