博客园-zsww-成功源于创新！-最新评论http://zsww.cnblogs.com/CommentsRSS.aspxzh-cnMon, 21 Mar 2005 02:58:00 GMTMon, 21 Mar 2005 02:58:00 GMTcnblogsRe:水晶报表使用经验谈3--在报表中显示多个表的字段（通过表关联）http://www.cnblogs.com/zsww/archive/2009/11/24/1075.html#1705520andre0115andre0115Tue, 24 Nov 2009 03:09:27 GMThttp://www.cnblogs.com/zsww/archive/2009/11/24/1075.html#1705520
andre0115 2009-11-24 11:09 发表评论
]]>re: 水晶报表使用经验谈1－－建立水晶报表第一步及编译最易出现错误的解决方法及报表转换成pdf文档进行打印方法http://www.cnblogs.com/zsww/archive/2008/09/02/781.html#1306075像蚊子的小猫像蚊子的小猫Tue, 02 Sep 2008 09:59:56 GMThttp://www.cnblogs.com/zsww/archive/2008/09/02/781.html#1306075怎么回事呀？

]]>re: 水晶报表使用经验谈1－－建立水晶报表第一步及编译最易出现错误的解决方法及报表转换成pdf文档进行打印方法http://www.cnblogs.com/zsww/archive/2008/06/17/781.html#122867379077907Tue, 17 Jun 2008 15:26:21 GMThttp://www.cnblogs.com/zsww/archive/2008/06/17/781.html#1228673http://www.51cto.com/art/200607/29265.htm

7907 2008-06-17 23:26 发表评论
]]>re: 水晶报表使用经验谈1－－建立水晶报表第一步及编译最易出现错误的解决方法及报表转换成pdf文档进行打印方法http://www.cnblogs.com/zsww/archive/2008/06/17/781.html#122866979077907Tue, 17 Jun 2008 15:23:32 GMThttp://www.cnblogs.com/zsww/archive/2008/06/17/781.html#1228669
SOAP的原理告诉我们一个WS交互的流程是客户端发送请求－>服务器接收请求－>服务器发送数据->客户

端接收数据，handler可以让我们在这四个操作中之前进行编码，所以，我们的验证进行在客户端发送请

求和服务器接收请求的时候，因此，我们要写两个handler，然后把它们装配上就可以了。

Handler验证方式如下：

主要参考的实例是XFIREdemo中的BOOK

服务器的代码如下

package com.nstar.xfire.auth;

import org.codehaus.xfire.MessageContext;
import org.codehaus.xfire.XFireRuntimeException;
import org.codehaus.xfire.handler.AbstractHandler;
import org.jdom.Element;
import org.jdom.Namespace;

public class XfireAuthenticationHandler extends AbstractHandler {
private static final String USERNAME = "biansutao";
private static final String PASSWORD = "12345678";
private static final String NS = "http://xfire.codehaus.org/biansutao";

public void invoke(MessageContext ctx) throws Exception {
// Check if header exists

Element header = ctx.getInMessage().getHeader();
if (header == null) {
throw new XFireRuntimeException("Missing SOAP Header");
}
// Does it have version tag
Element name = header.getChild("USERNAME",Namespace.getNamespace(NS));
Element pass = header.getChild("PASSWORD",Namespace.getNamespace(NS));
if(name.getValue().equals(USERNAME) && pass.getValue().equals(PASSWORD)){
System.out.println("验证通过");
}
else{
System.out.println("验证未通过");
throw new XFireRuntimeException("Authentication Failure");
}
ctx.setProperty("USERNAME", USERNAME);
ctx.setProperty("PASSWORD", PASSWORD);
}
}

然后需要在services.xml中配置如下：

xml 代码

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://xfire.codehaus.org/config/1.0">
<service>
<name>HelloWordService</name>
<serviceClass>com.nstar.xfire.IHelloWordService</serviceClass>
<implementationClass>
com.nstar.xfire.HelloWordServiceImpl
</implementationClass>
<style>wrapped</style>
<use>literal</use>
<scope>application</scope>
<inHandlers>
<handler handlerClass="com.nstar.xfire.auth.XfireAuthenticationHandler"></handler>
</inHandlers>
</service>
</beans>


客户端代码

package com.nstar.xfire.client.auth;

import org.codehaus.xfire.MessageContext;
import org.codehaus.xfire.handler.AbstractHandler;
import org.jdom.Element;

public class ClientHeaderHandler extends AbstractHandler {
//用户验证
private static final String USERNAME = "biansutao";
private static final String PASSWORD = "12345678";
private static final String NS = "http://xfire.codehaus.org/biansutao";
public void invoke(MessageContext ctx) throws Exception {
Element header = ctx.getOutMessage().getOrCreateHeader();
header.addContent(new Element("USERNAME",NS).addContent(USERNAME));
header.addContent(new Element("PASSWORD",NS).addContent(PASSWORD));
}

}



package com.nstar.xfire.client;

import java.util.List;
import java.lang.reflect.Proxy;
import java.net.MalformedURLException;
import java.util.ArrayList;

import org.codehaus.xfire.*;
import org.codehaus.xfire.client.Client;
import org.codehaus.xfire.client.XFireProxy;
import org.codehaus.xfire.client.XFireProxyFactory;
import org.codehaus.xfire.service.Service;
import org.codehaus.xfire.service.binding.ObjectServiceFactory;
import com.nstar.xfire.IHelloWordService;
import com.nstar.xfire.Student;
import com.nstar.xfire.client.auth.ClientHeaderHandler;

public class HelloWorldClient {

/**
* @param args
*/
public static void main(String[] args) {
Service serviceModel = new ObjectServiceFactory().create(IHelloWordService.class);
XFireProxyFactory factory = new XFireProxyFactory(XFireFactory.newInstance().getXFire());
String url = "http://10.232.75.61:8090/Xfire/services/HelloWordService";
try {
IHelloWordService service = (IHelloWordService) factory.create(serviceModel, url);

XFireProxy proxy = (XFireProxy)Proxy.getInvocationHandler(service);
Client client = proxy.getClient();
client.addOutHandler(new ClientHeaderHandler());

List list = new ArrayList();
List list1 = new ArrayList();
list.add(new String("测试"));
int age = service.getAge("边苏涛");
String name = service.getName(1);
Student s = service.getOneStudent(27);
list1 = service.getStudent(list);
System.out.println("边苏涛's age =="+age);
System.out.println("学号为1的学生姓名 "+name);
System.out.println("age == "+s.getAge()+" name == "+s.getName()+" list content

"+s.getList().get(0).toString());
System.out.println(list1.size());
for(int i=0;i<list1.size();i++){
System.out.println(list1.get(i).toString());
}
} catch (MalformedURLException e) {
e.printStackTrace();
}
}
}


。





7907 2008-06-17 23:23 发表评论
]]>re: 水晶报表使用经验谈1－－建立水晶报表第一步及编译最易出现错误的解决方法及报表转换成pdf文档进行打印方法http://www.cnblogs.com/zsww/archive/2008/05/27/781.html#1211051ddfddfTue, 27 May 2008 14:42:21 GMThttp://www.cnblogs.com/zsww/archive/2008/05/27/781.html#1211051



设计好报表之后编译成jasper文件,在servlet中调用,我们需要实现自己的hibernate datasource:

public class HibernateQueryResultDataSource implements JRDataSource {

private String[] fields;

private Iterator iterator;

private Object currentValue;

public HibernateQueryResultDataSource(List list, String[] fields) {
this.fields = fields;
this.iterator = list.iterator();
}

public Object getFieldValue(JRField field) throws JRException {
Object value = null;
int index = getFieldIndex(field.getName());
if (index > -1) {
Object[] values = (Object[]) currentValue;
value = values[index];
}
return value;
}

public boolean next() throws JRException {
currentValue = iterator.hasNext() ? iterator.next() : null;
return (currentValue != null);
}

private int getFieldIndex(String field) {
int index = -1;
for (int i = 0; i < fields.length; i++) {
if (fields[i].equals(field)) {
index = i;
break;
}
}
return index;
}

}

此类构造函数需要两个参数,查询结果的list以及查询的所有属性名(这些属性名必须和报表界面的field名一致)

,使用方式如下:

1.导出pdf:

File reportFile = new File(getServletContext().getRealPath(
"/reports/" + queryResult.getReportFileName() + ".jasper"));

HibernateQueryResultDataSource dataSource = new HibernateQueryResultDataSource(
queryResult.getList(parameters), queryResult.getFields());
if (reportType.equals("pdf") || reportType.equals("")) {
try {
byte[] bytes = JasperRunManager.runReportToPdf(reportFile
.getPath(), null, dataSource);
response.setContentType("application/pdf");
response.setContentLength(bytes.length);
ServletOutputStream ouputStream = response.getOutputStream();
ouputStream.write(bytes, 0, bytes.length);
ouputStream.flush();
ouputStream.close();

} catch (Exception e) {
e.printStackTrace();
}
}

2.导出excel,需要把poi-2.0-final-20040126.jar放进web的lib里:

try {

JasperPrint print = JasperFillManager.fillReport(
new FileInputStream(reportFile), null, dataSource);
// JRXlsExporter t=null;
JRXlsExporter jRXlsExporter = new JRXlsExporter();
ByteArrayOutputStream xlsReport = new ByteArrayOutputStream();
jRXlsExporter.setParameter(JRExporterParameter.JASPER_PRINT,
print);
jRXlsExporter.setParameter(JRExporterParameter.OUTPUT_STREAM,
xlsReport);
jRXlsExporter
.setParameter(
JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,
Boolean.TRUE);
jRXlsExporter.setParameter(
JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,
Boolean.TRUE);
// jRXlsExporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,ReportsConstants.bankDetailsHtml);

// jRXlsExporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,
// Boolean.TRUE);

jRXlsExporter.exportReport();
byte[] bytes = xlsReport.toByteArray();


response.setContentType("application/vnd.ms-excel");
response.setContentLength(bytes.length);
xlsReport.close();
OutputStream ouputStream = response.getOutputStream();
ouputStream.write(bytes, 0, bytes.length);
ouputStream.flush();
ouputStream.close();

} catch (Exception e) {
e.printStackTrace();
}



ddf 2008-05-27 22:42 发表评论
]]>re: SQL Reporting Services 困惑的解决 直接传递参数并用ReportViewer来呈现报表http://www.cnblogs.com/zsww/archive/2008/03/05/12894.html#1091869mogemogeWed, 05 Mar 2008 06:41:00 GMThttp://www.cnblogs.com/zsww/archive/2008/03/05/12894.html#1091869为什么我的控件上没有Format这个属性

moge 2008-03-05 14:41 发表评论
]]>re: 很高兴来到这里 感觉这里还不错！http://www.cnblogs.com/zsww/archive/2007/12/28/256.html#1017917谢谢谢谢Fri, 28 Dec 2007 01:30:00 GMThttp://www.cnblogs.com/zsww/archive/2007/12/28/256.html#1017917
谢谢 2007-12-28 09:30 发表评论
]]>re: SQL Reporting Services 困惑的解决 直接传递参数并用ReportViewer来呈现报表http://www.cnblogs.com/zsww/archive/2007/07/09/12894.html#810857小小小程序员小小小程序员Mon, 09 Jul 2007 02:51:00 GMThttp://www.cnblogs.com/zsww/archive/2007/07/09/12894.html#810857如果不可以，当条件为1个以上怎样组合条件，难道只能用存储器来拼条件吗

]]>re: SQL Reporting Services 困惑的解决 直接传递参数并用ReportViewer来呈现报表http://www.cnblogs.com/zsww/archive/2007/06/01/12894.html#768075zangjnzangjnFri, 01 Jun 2007 10:25:00 GMThttp://www.cnblogs.com/zsww/archive/2007/06/01/12894.html#768075我发现如果报表取中文名字，打印js出错。还有一个问题请大家帮忙。
我做的是可以折叠的报表，直接在ie中输网址可以。但是用这个控件放到程序中
点击展开无效。

zangjn 2007-06-01 18:25 发表评论
]]>re: SQL Reporting Services 困惑的解决 直接传递参数并用ReportViewer来呈现报表http://www.cnblogs.com/zsww/archive/2007/01/10/12894.html#617215dennyhongdennyhongWed, 10 Jan 2007 14:40:00 GMThttp://www.cnblogs.com/zsww/archive/2007/01/10/12894.html#617215msn:dennyhong1108@hotmail.com

dennyhong 2007-01-10 22:40 发表评论
]]>re: 微软发布SQL Server 2000 Reporting Services Service Pack 1http://www.cnblogs.com/zsww/archive/2006/11/30/17960.html#577997111111111111Thu, 30 Nov 2006 09:07:00 GMThttp://www.cnblogs.com/zsww/archive/2006/11/30/17960.html#577997

111111 2006-11-30 17:07 发表评论
]]>re: SQL Reporting Services 困惑的解决 直接传递参数并用ReportViewer来呈现报表http://www.cnblogs.com/zsww/archive/2006/11/09/12894.html#555188Ivan[匿名]Ivan[匿名]Thu, 09 Nov 2006 04:35:00 GMThttp://www.cnblogs.com/zsww/archive/2006/11/09/12894.html#555188谢谢你！
请好心大侠回信：zsy_1205@hotmail.com

Ivan[匿名] 2006-11-09 12:35 发表评论
]]>re: SQL Reporting Services 困惑的解决 直接传递参数并用ReportViewer来呈现报表http://www.cnblogs.com/zsww/archive/2006/09/01/12894.html#491953上上签上上签Fri, 01 Sep 2006 01:43:00 GMThttp://www.cnblogs.com/zsww/archive/2006/09/01/12894.html#491953
上上签 2006-09-01 09:43 发表评论
]]>re: SQL Reporting Services 使用感受http://www.cnblogs.com/zsww/archive/2006/08/24/6007.html#485457找奔找奔Thu, 24 Aug 2006 09:04:00 GMThttp://www.cnblogs.com/zsww/archive/2006/08/24/6007.html#485457我进报表数据库的时候是用window集成,

找奔 2006-08-24 17:04 发表评论
]]>re: SQL Reporting Services 困惑的解决 直接传递参数并用ReportViewer来呈现报表http://www.cnblogs.com/zsww/archive/2006/08/24/12894.html#485432徐风碧树徐风碧树Thu, 24 Aug 2006 08:40:00 GMThttp://www.cnblogs.com/zsww/archive/2006/08/24/12894.html#485432
徐风碧树 2006-08-24 16:40 发表评论
]]>re: 水晶报表使用经验谈5--使用格式化编辑器http://www.cnblogs.com/zsww/archive/2006/07/31/121111.html#463949CureCureMon, 31 Jul 2006 05:13:00 GMThttp://www.cnblogs.com/zsww/archive/2006/07/31/121111.html#463949
Cure 2006-07-31 13:13 发表评论
]]>re: SQL Reporting Services 使用感受http://www.cnblogs.com/zsww/archive/2006/07/18/6007.html#453836dianefangdianefangTue, 18 Jul 2006 06:33:00 GMThttp://www.cnblogs.com/zsww/archive/2006/07/18/6007.html#453836
dianefang 2006-07-18 14:33 发表评论
]]>re: 水晶报表使用经验谈1－－建立水晶报表第一步及编译最易出现错误的解决方法及报表转换成pdf文档进行打印方法http://www.cnblogs.com/zsww/archive/2006/06/21/781.html#431433hellphellpWed, 21 Jun 2006 04:43:00 GMThttp://www.cnblogs.com/zsww/archive/2006/06/21/781.html#431433Server Error in '/Eform' Application.
--------------------------------------------------------------------------------

Error in File D:\Eform\PurchaseCry\PurCryKin.rpt: Access to report file denied. Another program may be using it.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: Error in File D:\Eform\PurchaseCry\PurCryKin.rpt: Access to report file denied. Another program may be using it.

Source Error:


Line 54: crExportOptions.ExportFormatType =ExportFormatType.PortableDocFormat ;
Line 55:
Line 56: oRpt.Export();
Line 57: oRpt.Close();



hellp 2006-06-21 12:43 发表评论
]]>re: SQL Reporting Services 困惑的解决 直接传递参数并用ReportViewer来呈现报表http://www.cnblogs.com/zsww/archive/2006/04/26/12894.html#385788钢笔水钢笔水Wed, 26 Apr 2006 09:21:00 GMThttp://www.cnblogs.com/zsww/archive/2006/04/26/12894.html#385788(我想不用报表的参数,而是自己来写参数,让报表接收我传入的参数,来查询数据.只能用存储过程吗?)


钢笔水 2006-04-26 17:21 发表评论
]]>re: SQL Reporting Services 困惑的解决 直接传递参数并用ReportViewer来呈现报表http://www.cnblogs.com/zsww/archive/2006/04/12/12894.html#372962??????Wed, 12 Apr 2006 02:09:00 GMThttp://www.cnblogs.com/zsww/archive/2006/04/12/12894.html#372962
??? 2006-04-12 10:09 发表评论
]]>我这里是水晶报表华南的核心,有这方面疑问的可以给我有件!http://www.cnblogs.com/zsww/archive/2006/03/20/890.html#354038liuzhengliuzhengMon, 20 Mar 2006 06:56:00 GMThttp://www.cnblogs.com/zsww/archive/2006/03/20/890.html#354038
liuzheng 2006-03-20 14:56 发表评论
]]>re: SQL Reporting Services 困惑的解决 直接传递参数并用ReportViewer来呈现报表http://www.cnblogs.com/zsww/archive/2006/03/07/12894.html#344576冰點火燄冰點火燄Tue, 07 Mar 2006 04:15:00 GMThttp://www.cnblogs.com/zsww/archive/2006/03/07/12894.html#344576我也遇到相同的問題，就是SQL設計器中的SQL語句不可以使用表達式，
一種解決方式是使用存儲過程，將參數傳入，存儲過程生成動態SQL語句，
我用的是Oracle，可以使用Excute Immediate "SQL" 語句
但是由於我這裡使用存儲過程很不方便，希望能採用其它方式解決，現在還沒有好的辦法。

冰點火燄 2006-03-07 12:15 发表评论
]]>re: SQL Reporting Services 使用感受http://www.cnblogs.com/zsww/archive/2006/02/09/6007.html#327811xxAxxAThu, 09 Feb 2006 08:52:00 GMThttp://www.cnblogs.com/zsww/archive/2006/02/09/6007.html#327811http://localhost/reports里
查看报表时报：
登录失败。
登录失败: 未知的用户名或错误密码。 (异常来自 HRESULT:0x8007052E)
的错误．这是怎么回事．

xxA 2006-02-09 16:52 发表评论
]]>re: 水晶报表使用经验谈1－－建立水晶报表第一步及编译最易出现错误的解决方法及报表转换成pdf文档进行打印方法http://www.cnblogs.com/zsww/archive/2005/12/06/781.html#291427AndilyAndilyTue, 06 Dec 2005 00:21:00 GMThttp://www.cnblogs.com/zsww/archive/2005/12/06/781.html#291427
Andily 2005-12-06 08:21 发表评论
]]>re: SQL Reporting Services 使用感受http://www.cnblogs.com/zsww/archive/2005/12/02/6007.html#289052xiaobaixiaobaiFri, 02 Dec 2005 02:38:00 GMThttp://www.cnblogs.com/zsww/archive/2005/12/02/6007.html#289052
xiaobai 2005-12-02 10:38 发表评论
]]>