Reporting Service Configuration to Sending Mail

The photo is not match about the story I will talking about today, I knew that but I just want all of you to be happy and smile ^_^ and I likes her hips even I am a girl and straight.

OKEY! today I would like present how to configuration mail on SQL Reporting Service to sending mail to any concerns.

STEP-1
Go to "SQL Server Reporting Service Configuration Manager"

STEP-2
You will the popup as image below, This details in window it for configuration of SQL Reporting Service Only

STEP-3Then you have to fill mail server detail as image below

Read More

Create Parameters On SSRS for Query Data (Advance) #3

http://www.mymemoboxs.com/2015/01/create-report-on-ssrs-for-share-point.html
http://www.mymemoboxs.com/2015/01/create-report-on-ssrs-publish-on-share.html

We are moving to SSRS in advance, Now it's time to create some parameters to selection from database as we wanted. Let's go to step by step

For this concept, we will select Year and Property from database as we have on hand to be a selection when we wanted to run report.

STEP-1
Query data for value to create drop down on parameters, Click right on "Datasets" on Report Data area, if your could not see this area, go to "View" menu on top then select "Report Data" as below

STEP-2
Select Data Set from data source in same report

STEP-3Query data form table to get year value

Example Query for Year Parameter
SELECT distinct (year) FROM customer ORDER BY year DESC

STEP-4 

Now you will see Data Year as image below. Next step is create parameters by click right on "Parameters" menu

STEP-5 parameter name and label, select data type as "Allow multiple values" and "Allow blank value ("")"

Set



STEP-6 
Set value for Year parameter by click on "Available Values" then
Select from one of the following options : Get values from a query
Dataset: "dataset name" select dataset as we created
Value field: "Field year name"
Label field: "Field year name"

STEP-7
After finished create parameter "Year" you have to set parameter on your query as
"SELECT * FROM TABLE WHERE (pl_year in (@Year))"

STEP-8
Every thing have done now, you have to preview and select parameter as image

Read More

Publish and Configuration SSRS to Share Point Portal

SSRS Create Report and Publish

http://www.mymemoboxs.com/2015/01/create-report-on-ssrs-for-share-point.html

http://www.mymemoboxs.com/2015/01/create-report-on-ssrs-publish-on-share.html

Now you can create report on SSRS in basic level then you have to configuration server on Share Point Portal Let's Go!.

You have to configuration Share Point Portal Site

STEP-1
Go to report folder on Share Point Portal Site, You will see projects appear on the page, Click on report project

STEP-2
Click on "Manage"

STEP-3
- Click on "Data Source", set username and password of report data source server on
"Credentials stored securely in the report server"
- Click on "Use as Windows Credentials..."
- Click on "Test Connection"
- Click on "Ok"

STEP-4
Click on drop down on Report Project then select  "Subscribe" for publish report on the site

STEP-5
After you clicked on "Subscribe" then click on "My Subscribe" on the right menu
You will see all reports have subscribed appear on the list, For set schedule to publish report, you have to click on "Edit"

STEP-6
For setting schedule generate report and send email to concerns people, you have to select "Delivery by: E-Mail"

For setting schedule generate to concern people, you have to select "Delivery by: Windows File Share"

STEP-7
Set up schedule time click on "Select Schedule" then set the date and time as you want to generate or publish this report

Read More

Create Report on SSRS Publish on Share Point Server - Episode #2

Yo! Now you know how to create report by using SSRS, that quite pretty cool right? And  it will look too perfect if you can publish reports to any user as permission setting by use Share Point Sever.
http://www.mymemoboxs.com/2015/01/create-report-on-ssrs-for-share-point.html

OKEY! Let’s go for next step

STEP-1
Click on "Data Source" (on the left menu)  then click right and select "Convert to share data source" why you need to do this? because that mean any report can use data source as your have to created.

STEP-2

After you finished on STEP-1 you will see "Share data sources" appear on the right menu then click on right and select "Deploy", Why you have to deploy? it for publish on Share Point Server otherwise if you publish report, the data may disappear.

STEP-3

If you could not preview report and be sure you do all right way but the report still struck, you have to build on project by click on right on the project then select "Build" as image below

STEP-4
Click right on the report to publish on Share Point Web Portal then select "Deploy"

STEP-5
And now you will see the report appear on Share Point Web Portal as detail below

I hope this subject will help you and can guide line for you, Have a best working day ^_^ Enjoin!

Read More

Create Report on SSRS for Share Point Server - Episode #1

SSRS (SQL Server Reporting Service)
Is the best solution to create report and deploy to Share Point Server for any user and access as permission.

I do like the concept of Microsoft how to create report because it very simple and useful for BI data, You can connect data by use Relational or Cube, that depend on your organise concept.

OKEY! let's go to step by step how to create report on SSRS

STEP-1
Open SQL Server Data Tools for Visual Studio (You have to install this package while you were installed SQL Server and after installed, you have to configuration Server for SSRS (Will tell you later, but now let's skip ^_^))

STEP-2
Create project by go to File -> New -> Project…

STEP-3
Set project name by select Business Intelligent -> Report Server Project, Then click “OK”

STEP-4
Project have created then set your property project by go to Project -> Properties
Why must configuration property project because if you have to deploy reports to another server, This section have to requested.

STEP-5
Change the server point to deploy reports as detail “TargetServerURL” such as http://11.11.11.11/reportserver/

STEP-6
Create report by click on “Reports” on the right menu then select “Add New Report”

STEP-7
You will see Wizard Report as image then click on “Next”

 
STEP-8
Select Data Source window will appear, You have to set up database as your server by click on “Edit” (If your database is not SQL Server you have to select another type by  click on “Type”)

STEP-9
Then you have to fill configuration server,
Server Name : IPDatabaseServer
Log on to the server : You have two option for security, by Window and by SQL account
Connect to Database : You have to select database name you want to connect
After fill all configuration you have to click on “OK”

STEP-10
Set “Credential” I set to “Window Authentication” why you have to configuration this point? Because the default of system will clicked on “Prompt for credential” I do not want always fill my username and password while my project connect to database server all the time, but if you like that depend on you.
Then click “OK” and click “Next”

STEP-11
You have to build query data from table by click on “Query Builder”

STEP-12
Add data on table you would like to query as the icon on right page “Add Table”

STEP-13
After you finished to query data on table click on “OK” and click on “Next”

STEP-14
For this section you have to select the type of report you want to show, I recommend you normal type by click on “Tabular” then click “Next”

STEP-15
And now you have to select data in each section to show
If you do not understand and not sure which data have to set in each area, just notice on the preview page in yellow area
Page :  This data will appear on the top of report page
Column : This data will appear on column on the page
Rows : The name of row
Details : The details of data will appear here
If you want to remove the field of data just click on the field in each area then click on “Remove” but if you have completed then click on “Next”

 
STEP-16
This section to have to selection the report style as you like then click on “Next”

STEP-17
And now almost be done but you have to set the name of report. It should concert of report details then click on “Finish”

STEP-18
Now your report look cool!, you have to click on “Preview” it will popup black window to running , DO NOT CLOSE IT just minimize OKEY!

Please minimize this page only

Report Completed

Create Report on SSRS for Share Point Server - Episode #2

Read More