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

SSIS How to stop testing connectivity while opening project



I feel so bore while I opening project and I have to wait for long time because SSIS requested testing connectivity and I have to clicked at "OK" several times if my some of my package lost connection from database.

I tired several times how to stop to do this process but seem like there is tiny person feel same me and today I have to say Congratulation with me ^_^ I have found a solution, OKEY! let's go.

STEP-1
You have to open your project and click on your project name on the right page as image as below


STEP-2
Go to on SSIS menu then click at "Work Offline" then save your project

STEP-3
Close your project and reopen the project again, this time you will not see any alert to interrupt you anymore.

NOTE
but please you want to run some package of your project, you have to remove a click on "Work Offline" again, otherwise you will can not to run any package.
Read More

AngularJs, ExtJs, Jquery EasyUi Which one is the best for developer?

,
Sometime we have to learn too many ways to find the best one for us, sometime need to take long time and sometime we could not find but if you have someone can guide line for you, you maybe easy find the best way for you shortly.

Okey! I would like to talk about Web Application programming, Which one is the best tool to create the wonderful website, more faster, look nice and modern. The important thing is easy to use and easy to learn. So let's see between AngularJs, ExtJs, Jquery EasyUi which one is suitable for you.





AngularJs 
At the first time when I heard this name, I really could not imagine how is it? until I have learnt a bit of Angular and see many features, I can say that WOW! ^_^  This is perfect template that can solve my problem.
Why is that? because it faster then other template that I ever had, more interactive, you do not need to refresh the page if you just want to active some part of the page (Just only data have changing), I can say that it is Jquery in advance or above advance and also you do not need to code all platform to support for all device, just one code, it can give you all device such as mobile, all browser, ipad.

Good website to study

ExtJs
That my nightmare T_T, sorry to say that but because it made me have to rebuild my project again after I used ExtJs.

The concept of ExtJs is the same like Angular but the weak point of ExtJs are, Can not reload multiple of module or job in one page and too slow for me T_T, Yes I'm agree that it look pretty cool in outside, Look clean, blue color at default (I love them color) and also work with Jquery, Jason, It quite difficult and did't convenient for codding and it not for free, for free version it not full of feature.
http://www.sencha.com/products/extjs/



Jquery EasyUi
I LOVE THIS TEMPLATE ^_^ Yes very easy to understanding and coding, It's so simple but no have many interactive feature yet, you still have to refresh to page when you have to get some data to preview, I mean refresh all the page, It's not like Angular that have only refresh just controller module. However I still love Jquery EasyUi, ^_^ and it's free.
http://www.jeasyui.com/
Read More