Wednesday, January 28, 2015

Quick Tips on SSRS Report Development on Visual Stuido 2013

I just complete couples of SSRS recently. I summarize some of the tips here, please feel free to take them if you think they are helpful.


1. How to show the Report Data Windows on Visual Studio 2013

use  Ctrl + Alt + D from Keyboard or click on the View on the toolbar menu, then select Report Data option.




2. How to add a group total in the report with row group being added.

select the column that you want to add the total based on the same group, then right on the selected column

select Add Total option from the popup menu





 3. Add Group Name or Description on the top of each group
 select the group column, then right click on it, then click on Insert Row, then select Inside Group Above,
then yon add your group name or description on newly added row.




4. Add a line break to the group

select the group column, then right click on it, then click on Insert Row, then select Inside Group Below, then yon can see a new line on each group in the report.


5. Show column header on each report page.

 first we need to enable the advance mode from the column group



second go to the Row Group tab, then select the static



 Set RepeatOnNewPage property to true in the Properties Window







Wednesday, January 14, 2015

How to fix SQL query exceeds specified time limit or storage limit against AS400 Data Source


 I implmented an data loading with VB script that executing in the Look Server, I have the following connection string to access the data source.

VarConString = "DRIVER=Client Access ODBC Driver (32-bit); UID=as400User;PWD=mypassword;SYSTEM=MyDataBaseName"

But I got a very weird error on the execution. the error message is shown below



Microsoft OLE DB Provider for ODBC Drivers
[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0666 - SQL query exceeds specified time limit or storage limit.



the google search suggest the fix is to modify the ODBC configuraton to increase the execution time limit and storage limit.

However it is a better approach to use a different data driver. such as the IBM iSeries driver to solve those issue.

i simply replace the connection string with the following connection string, the the error is gone and data return from the execution.

VarConString = "Provider=IBMDA400; User Id=as400User;Password=mypassword;Data source=MyDataBaseName"