Including a “Company” name column can help with grouping on your report. Here is a simple example, but you can make this as complex as is needed. Simply using a union statement in any query with the database ID attached to the second (or third …) will allow you to pull the data from multiple companies as long as the data source is pointing to one of them. SSRS has a handful of built in multi-company reports, but it is fairly easy to make your own. Create multi-company reports by using unions in your data set =MYCOMPANYID&ProductID=0&ActionType=OPEN&FunctionName=OpenVendorID&VENDORIDĩ. ="dgpp://DynamicsGPDrillBack/DatabaseInstance=&ServerName=MYSERVERNAME&CompanyID Below that is where to put it in your report. Here is an example of one to open up a vendor window using a report parameter to drive which vendor is used, but it will also give you a guideline as to what they should look like.
#WHAT IS SSRS REPORT BUILDER WINDOWS#
If you are on the more technical side, you can look at the SQL views in your database and the columns to the far right will give you some options/paths of windows you can use. There are a handful of windows that you can drill back into, including cards and transactional windows. It was an even better bonus to learn that I could create these custom drill backs in the reports that I wrote myself. I was very excited to hear that we could now drill back directly into Dynamics GP from SSRS. Lastly, you finalize your formatting and titles and you have a new graph for your Dynamics GP homepage! Once you identify your data and which type of report you want to use, you just choose how you want your data to display. One of my favorite features of Report Builder is how easily you can create new KPIs for your company with the drag and drop chart wizard.
The new interface in Report Builder 3.0 is now much more flexible in allowing end users to create the reports they need with less technical knowledge. Use the Report Builder wizard to create easy graphs and charts by dragging and dropping data For those of you who missed the first two sections, you can find them here - Part 1: Viewing & Using, Part 2: Managingħ.
#WHAT IS SSRS REPORT BUILDER SERIES#
This is the last in our series of three SSRS Tips & Tricks blogs. Architecture, Engineering and Construction (AEC).International Microsoft Dynamics Partners.National Microsoft Dynamics ERP Partners.Regional Microsoft Dynamics ERP Partners.
0 kommentar(er)
