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
a blog to share Microsoft technologies Azure, DotNet, SharePoint, SQL Server,JavaScript Framework: Node.JS, Angular, React
Wednesday, January 28, 2015
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"
Subscribe to:
Posts (Atom)