Clarity 13 Offline Time sheet Will not be avilable

Clarity 13 Offline Time sheet

Offline time sheet will not available any more in clarity 13 release.

Configuring Actuate Spread Sheet Report.

Step 1:

Install actuate spread sheet report from Actuate website. 

Step 1:

Mentioned below file require to do the modification.

Example: R175_Phi_Month_v0.1_qa.VTX design file you will get 

Step 2: 

Convert to the above file to zip file like this R175_Phi_Month_v0.1_qa.ZIP

Step 3: 

After converting extract the zip file and you will fine three files. 

- R175_Phi_Month_v0.1_qa.guid  (Guid File)

- R175_Phi_Month_v0.1_qa (Actuate parameter Template)

- R175_Phi_Month_v0.1_qa (Formula one file)

Click on the Actuate parameter template file, it will open in the spread sheet environment. 

some time if does not open, please reopen through actuate spread sheet. 

Step 4:

After opening go to Data file and then click "Data manager", you can find the connection and query, 

if you have any connection issue in the odbc. create connection through ODBC driver.

Happy coding 

Bala

Create ODBC connection using Windows 7

Step 1:

open this path in windows C:\Windows\SysWOW64

Step 2:

Please click on this file :odbcad32

Step 3:

After clicking the above mentioned file, it will open popup window with contains multiple tabs.

Step 4:
please open "System DSN" tab to select and add the ODBC connection to respective database servers

Happy coding
Bala

Clarity 13 Performance

Clarity 13 Partial load

When you make changes in the page only part of the page needs to be refreshed. instead of whole page like previous version of clarity.

You will notice that there is now a # sign in the URL. This is what allows clarity reload/redraw part of the page instead of whole page.

Actuate Chart Report

Dynamically changing the chart value by using the CustomizeCategoriesAndSeries event

Sub CustomizeCategoriesAndSeries( baseLayer As AcChartLayer, overlayLayer As AcChartLayer, studyLayers() As AcChartLayer )

Super::CustomizeCategoriesAndSeries( baseLayer, overlayLayer, studyLayers )

Dim checkMonth as integer

checkMonth=month(now)

if(checkMonth<>1) then

Dim numberOfSeries As Integer

numberOfSeries = baseLayer.GetNumberOfSeries( )

Dim seriesIndex As Integer

For seriesIndex =checkMonth To numberOfSeries

Dim series As AcChartSeries

Set series = baseLayer.GetSeries( seriesIndex )

Dim point As AcChartPoint

Dim pointIndex As Integer

Set point = series.GetPoint( 1 )

point.SetYValue(0)

Next seriesIndex

end if

End Sub

Full Text Search in SQL Server 2012

The Full Text Search in SQL Server 2012 has been enhanced by allowing you to search and index data stored in extended properties or metadata. Consider a PDF document that has "properties" filled in like Name, Type, Folder path, Size, Date Created, etc. In the newest release of SQL Server, this data could be indexes and searched along with the data in the document itself. The data does have to be exposed to work, but it's possible now

Ad-Hoc Query Paging in Sqlserver 2012

Ad-Hoc Query Paging:

Paging results in SQL Server has been discussed for years. The Order By option in the SQL SELECT statement has been enhanced in SQL Server 2012. Using a combination of OFFSET and FETCH along with ORDER BY gives you control of paging through a result set. Using this technique can really help performance by bring back only the results you want to show to your users when they are needed. The following TSQL code runs against the Person table in the AdventureWorks sample database (available from Microsoft). In the sample query below, SQL Server would return 10 records beginning with record 11. The OFFSET command provides a starting point for the SELECT statement in terms of paging, and the FETCH command provides how many records to return at a time.

SELECT BusinessEntityID, FirstName, LastName FROM Person.Person ORDER BY BusinessEntityID OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;

Drag & Drop Feture using HTML 5

I like personally this new interesting feature, two years back i was done  manually through javascript by using list in html and took time. Now in HTML 5 made very simple.

New Features in HTML 5

- New feaures should be based on HTML, DOM, CSS3 and Javascript
- Reduce the need of external plugins (like flash)
- Better error handling
- More markup to replace scripting
- HTML 5 should be device independent.

T-SQL Rediscovered with SQL Server 2012

SQL Server 2012 introduces a plethora of the new enhancements in T-SQL. With newly introduced syntax the code of the 100s lines can be reduced to merely few lines. By converting the old T-SQL syntax to new T-SQL syntax one can immediately get enormous performance improvement. This session will cover T-SQL tips and tricks which will make writing the code more fun!

Sync Fushion Grid Control

i have come across situation like to increase the performance Sync fusion
Grid control. for that have tried all our asp.net datasource. but we couln't able to
increase. finally found Sync fusion control itself having data source object (Grouppassdatasource).

Grouppassdatasource:

which will connect from datacontext.

Datacontext.

you have to create using link to sql data file (deml extension).

Sync fusion datasource name is GroupPassdatasource

Note: GroupPassdatasource should be with update panel