Crystal report table filter

Question

0.00/5 (No votes)

See more:

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

Posted 7-Jun-14 13:09pm

Member 10862570

Updated 7-Jun-14 13:30pm

v2

Add a Solution

Comments

[no name] 7-Jun-14 20:50pm

1. Not unless someone installs your program in exactly the same place as you (highly unlikely).
2. http://scn.sap.com/thread/1409139
3. You write a query
4. http://stackoverflow.com/questions/5174109/how-to-set-crystal-reports-textbox-value-at-run-time

DamithSL 7-Jun-14 22:24pm

hi Wes, Why don't you add this as answer? most of your comments answering to questions.OP can't mark this as answer even your answer is the correct solution.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Accepted Answer · 2014-06-07T16:21:00

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[^]