?
Solved

Set location for a crystal report using vb

Posted on 2005-04-14
10
Medium Priority
?
232 Views
Last Modified: 2013-12-25
Hello,
   i am using vb6 crystal reports 8.5 and sql 2000.
i am using crytsal report control to call the report from vb.
i want to know how can we change the database set location using vb .i am using odbc to connect to the database.i want to change runtime to the main report and subreport.can u please help me in this regard.it is very urgent for me .can u please tell me what r the references and components required for it.
thanks
suman
0
Comment
Question by:muddasani
  • 4
  • 4
9 Comments
 
LVL 8

Expert Comment

by:MYLim
ID: 13787327
try
 .connect
0
 
LVL 8

Expert Comment

by:MYLim
ID: 13787333
u can either set DSN or using conenction string.

with crystalReport
   .connect = "DSN=MyDSN"
end with
0
 

Author Comment

by:muddasani
ID: 13790681
Hello,
i have done the same thing but its not working.
i have used 2 types
1.
CrystalReport1.LogonInfo(0) = "DSN=ABS;UID=;PWD=;DBQ=<Crwdc>database=ABS"

2.  CrystalReport1.Connect = "DSN=abs"

Still i dont get to work.do u have any suggestions.
Thanks
muddasani
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:muddasani
ID: 13791367
Hello,
    When ever i tried with a invalid dsn name the report does not come up.The property is working but it is not refreshing the data with the new dsn.
thanks
muddasani
0
 
LVL 8

Expert Comment

by:MYLim
ID: 13795824
is ur report oredi uncheck 'Save data with report' ?
0
 
LVL 8

Expert Comment

by:MYLim
ID: 13795835
and please make sure 2 database got same structure.
beside that ,pls post error message,10Q
0
 

Author Comment

by:muddasani
ID: 13798894
Hello,
     i am using the same database ,i dont get any error message.
I unchecked save data with report.
Evreytime i am creating a new report and checking but still i dont understand the problem
Thanks
muddasani
0
 

Author Comment

by:muddasani
ID: 13810653
Hello,
  i got the solution.I have change the databse setlocation in the report.for ex: abs.dbo.earning to earning.Thats work fine.
Thanks for ur suggestion
muddasani
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 14108464
Submitted to PAQ with points refunded (180)

DarthMod
Community Support Moderator
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses
Course of the Month15 days, 12 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question