Creating a Report Using Microsoft Business Intelligence Development Studio (BIDS)

about using microsoft business intelligence development studio docid\ oei ts0kclk97 wq9sxvgetting started with bids docid\ oei ts0kclk97 wq9sxvcreating a new report with bids docid\ oei ts0kclk97 wq9sxvediting an existing report with bids docid\ oei ts0kclk97 wq9sxvabout the ssrsreportextension dll file docid\ oei ts0kclk97 wq9sxv in addition to using microsoft business intelligence development studio (bids) to create reports, you can also use the microsoft sql server reporting service (ssrs) report builder the microsoft ssrs report builder is integrated with to facilitate building report templates see creating reports and report templates docid\ nbwtfjmfn9gmaqcwuo6sm for more information about using the microsoft ssrs report builder about using microsoft business intelligence development studio this information explains how to create reports with cloud platform and how to use microsoft business intelligence development studio (bids) to create reports directly from your desktop you can access the bids documentation at https //msdn microsoft com/en us/library/ms173767(v=sql 105) aspx https //msdn microsoft com/en us/library/ms173767(v=sql 105) aspx bids is the former integrated development environment (ide) from microsoft, which was used to develop data analysis and business intelligence solutions utilizing the microsoft sql server analysis services, reporting services, and integration services bids is based on the microsoft visual studio development environment, but customized with microsoft sql server services specific extensions and project types, including tools, controls and projects for reports, data flows, and data mining structure report managers and administrators can create their own customized report templates and then create reports from these custom report templates provides default reports as a reporting solution that you can customize if you have already customized some of your reports, you can download those reports from your own instance and update them in the solution getting started with bids if you have trouble downloading bids, see allowing internet explorer 9 to automatically prompt for downloads docid\ uqbm 2gifxoxdj r3aevh in the troubleshooting reports docid\ uqbm 2gifxoxdj r3aevh topic start bids by doing the following a download and install bids from the microsoft download center at http //www microsoft com/en us/download/details aspx?id=30438 http //www microsoft com/en us/download/details aspx?id=30438 b install the file called sqlexpradv x64 enu exe c depending on the type of system that you are using, download and install the correct file selecting the download package go to ivanti community path https //forums ivanti com/s/article/how to use business intelligence design studio bids with ivanti service manager where the heat reporting bids zip file is located download the heat reporting bids zip file and copy the ssrsreportextension dll file into program files\microsoft visual studio 9 0\common7\ide\privateassemblies if you have two different program files for a 32 bit and a 64 bit system, copy the ssrsreportextension dll file into both of the folders you must place the ssrsreportextension dll file in the private assembly folder of the bids installation to open bids, do the following a go to heat reporting bids and access the heatreports folder b open heatreports sln in the solution explorer pane, double click heatreports > shared data sources > saasappmodel rds saasappmodel rds in the shared data source properties dialog box, click edit located near the connection string button and enter the credentials that your administrator provided click test connection to verify your connection check save my password click ok in the next two screens creating a new report with bids follow these steps to create a new report using the bids new report rdl \[design] template double click new report rdl in the solution explorer the system displays the newreport rdl \[design] template newreport rdl \[design] template expand data source on the left side (if you do not see the report data panel on the left side of the screen, select view > report data to display the panel ) right click saasappmodel select add dataset the system displays the dataset properties dialog box click query designer the system displays the query designer dialog box query designer use the query designer dialog box to create the microsoft sql query for this dataset a click edit as text to create the microsoft sql query b enter a query c click ! to verify the data d click ok to run the query e enter a meaningful name for the dataset and click ok to save the dataset verify data the system displays the dataset under datasets in the report data left pane dataset create a report using your new dataset and save the report using a new name upload the bids report template to by following the procedure described in downloading and uploading a report template docid\ nbwtfjmfn9gmaqcwuo6sm the system uploads the report created in bids as a report template to bids refers to a report while refers to a report as a report template editing an existing report with bids if you make any changes to the report template parameters, you must recreate the corresponding reports to edit an existing report follow these steps double click the report name from the solution explorer edit the report by following the steps in creating a new report with bids docid\ oei ts0kclk97 wq9sxv if you upload a report template with the same name, the system asks if you want to update the existing report if you select yes , the system updates the existing report template in to edit a customized or new report, access and click download the system displays the report templates workspace report templates workspace from the solution explorer, right click reports > add > existing item edit the report according to your business requirements existing report upload the report as a report template in if you upload the report using the same name, the system overwrites the existing report template about the ssrsreportextension dll file as part of the reports module, provides a custom microsoft net dll file called ssrsreportextension dll this file calculates the duration for the reports in reports with datetime values, you can filter the data based on a specified number of days, weeks, months, quarters, or years example report with datetime value the ssrsreportextension dll file uses three methods called getstartdatetime , getenddatetime , and getvalidationlistsql these methods run inside the microsoft ssrs server and calculate the datetime logic for the reports the system passes the report parameters to those methods and the methods calculate the dates required for the reports in the dataset properties dialog box, under the parameters heading, you can define parameters and their values you can use expressions for the parameter values for example, you could create a parameter called @en datein and set its value to =code getstartdatetime(parameters!daterangeoptions value, parameters!timezoneoffset value, parameters!last value) use the query designer to declare and then call the parameter inside the query using the ssrsreportextension dll file