Hi All

I am trying to retrieve all the records from a table (select * from Northwind..Employees). Here is what i did:
1. Open Word.
2. Paste Windward syntax in Word as an rtf file.
3. Set my datasource using AutoTag
4. Save the rtf file
5. Run report and a blank report comes out.

I have read the Windward guides and i came up with below 3 possible syntaxs to achieve this, however the report comes blank. Can someone please help me with the right syntax?

--1.
<wr:forEach select="select * from Northwind..Employees" datasource="WWdt2">
<wr:out select ="select * from Northwind..Employees" datasource="WWdt2"/>
</wr:forEach>

--2.
<wr:forEach select="select * from Northwind..Employees" var="temp_OctMN" >
<wr:out value="${ temp_OctMN.EmployeeID} " />
</wr:forEach>

--3.
<wr:forEach select="select * from Northwind..Employees" var=" temp_OctMN" >
<wr:out select="select * from Northwind..Employees where value="${ temp_OctMN.EmployeeID} " />
</wr:forEach>

I am using the Northwind database or use can any table to retrieve all the records. Thank you in advance.

I have looked at your code in our test environment and it turns out that it works with the two periods in the table/row declaration, IE Northwind..Employees.

Example 2 is the correct way to do what you want. I noticed you have named your datasource. You should only name your datasource if you have 2 or more. Otherwise Windward Reports will select the first datasource by default.

If you are running this from the Java Engine by way of command line, then you may not be declaring your datasource name.

Here is an example of how you should run an rtf template with a named data source on the command line.

From Sample16 in the samples directory for the Java Engine

----------Sample 16 run_java.bat-----------
echo off

if "%2" == "" goto skipSql
echo Running Sql Server examples. Make sure SqlServer jdbc driver jar files are in your classpath.

java net.windward.xmlreport.RunReport "Two Data Sources.rtf" "Report - Two Data Sources.rtf" -xml: xml "Invoice Complex Data.xml" username=%1 password=%2 -sql:northwind "//localhost:1433;DatabaseName=Northwind"
goto end

:skipSql
echo Sql Server examples not being run (call "run username password" to run Sql Server examples).

:end
echo all reports generated.
-----------End Sample 16 run_java.bat---------------

This .bat file takes 2 arguments on the command line

PROMPT> run_java.bat SQLDB_USERNAME SQLDB_PASSWORD


--Ryan