水晶报表过滤器 [英] Crystal report table filter
问题描述
您好b $ b
我使用的是强类型访问数据库vb.net。
我想打印数据库，所以我添加了一个水晶报告。
我有一个问题，水晶报告要求登录用户ID，通过，...虽然我没有通行证，但它让我登录失败...！
所以我在水晶报告向导中选择了一个新的连接并选择了访问数据库DOA。
但是我有一些问题...
1- DOA被定位到我项目中的数据库位置（c：\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ >
2-任何人都可以告诉我如何绕过水晶报告的愚蠢登录弹出窗口，以便我可以使用我在prog中使用的数据库吗？
3-我在数据库的任何情况下，如何过滤表格，（例如：我只想显示同名的商品）
4-我需要放一些textbo x在水晶报告中我用代码填写它我该怎么做？
请尽快帮助
请用VB编写代码。强类型数据库的网络。
谢谢
Hi
I am using vb.net , strongly typed access database.
I want to print the database so I added a crystal report.
I had an issue that the crystal report asks for login user id, pass,... although i don't have a pass , it gives me login failed...!
so I choosed a new connection in the crystal report wizard and choosed access database DOA.
BUT i have some questions...
1- the DOA is targted to my database location on the project (c:\m\projects\....) so is it going to work when the prog is installed and the database location change?
2- can any one tell me how to bypass the stupid login popup of the crystal report so that I can use the database I am already using in the prog?
3- I any of the cases of the database, how can I filter the table , (ex: I want to show only items with the same name)
4- i need to put some textbox in the crystal report i fill them by code how can I do that?
PLEASE HELP ASAP
please write the code in VB.net for strongly typed database.
thanks
推荐答案
1。不，您需要通过代码设置数据库位置。否则它会尝试从原始位置加载。请查看以下答案以获取更多详细信息
使用VB.net在Database Expert中设置Crystal报表数据库路径 [ ^ ]
2. 具有ms访问连接问题的水晶报告 [< a href =http://www.codeproject.com/Questions/194531/crystal-report-with-ms-access-connection-issuetarget =_ blanktitle =New Window> ^ ]
3.您可以更改select语句来过滤数据，例如：select my，name from myTable where id = 2
4. Google [ ^ ]
1. No. you need to set the database location by the code. otherwise it will try to load from original location. check below answer for more details
Crystal report Database path setting in Database Expert using VB.net[^]
2. crystal report with ms-access connection issue[^]
3. you can change the select statement to filter data, for e.g:select id, name from myTable where id =2
4. Google[^]
这篇关于水晶报表过滤器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
