By lots of record I mean to say that I have a database which has lakhs of records. Now, when I try to display some of these records, Word just stops responding (I waited for nearly half hour for it to respond). I created the following template:
|
Session ID
|
Log Date
|
|
<wr:forEach select="select * from wsc_transaction_log" var="var1"><wr:out value="${var1.sessionid}"/>
|
<wr:out value="${var1.logdate}"/>
|
</wr:forEach>
Above fields were taken from MySQL database, which I created with the help of DataSource, & created the above table by dragging the whole table from the DataBin. It worked fine when my one of the table was having 25 records, but my this table (wsc_transaction_log) has nearly 150,000 records. Again I say that I am not getting any error, but the Word just stops responding, which also affects other programs on computer (if running).
Also one more thing I wanted to ask you that when I create matrix of this type:
|
<wr:matrix/>
<wr:column select="select distinct channel from Transaction_log" var="col"/>
<wr:if test="${col.channel} = 1">
<wr:out value="GPRS”/>
<wr:else/>
<wr:out value="SMS”/>
</wr:if>
|
|
|
<wr:row select="select distinct date1 from Transaction_log order by date1" var="main"/>
|
<wr:out var =”ggg” value="${main.date1}" type="DATE" pattern="MMMM/yy"/>
|
|
<wr:row select="select distinct grpid from Transaction_log" var="mr"/>
|
<wr:out value="${mr.grpid}"/>
|
|
<wr:row select="select distinct service_type from Transaction_log where grpid=’${mr.grpid}’ " var="row"/>
<wr:function select="select status from Transaction_log where date1=’${main.date1}’ and service_type =’${row.service_type}’ and channel =’${col.channel}’ and grpid=’${mr.grpid}’" function="COUNT"/>
|
<wr:out value="${row.service_type}"/>
|
I get the name of the rows on the right hand side. Like this:
I just wanted to left align the names of the row. Could you give me the idea to do it. Thanks in advance!!!
