Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Connect to database Post Reply Post New Topic
Author Message
ganesh
Newbie
Newbie
Avatar

Joined: 11 Jan 2007
Location: India
Online Status: Offline
Posts: 8
Quote ganesh Replybullet Topic: Connect to database
    Posted: 11 Jan 2007 at 8:18pm
hi
 i m facing a problem in crystal report. actually i have a user list and each user has their own database. database schema is same, but data will be different.now i want to display report on user's database. means user 1 is logged on same report will connect to 1 's database and generate report.if user2 logged on than same report display record from 2' database. this user list can be increased. its not prefixed. so i want to make crystal report's connection dynamic. so on the basis user's login it will connect to their database.
gsg
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 12 Jan 2007 at 12:31am
Are you familiar with programming .NET? You are going to have to change the connection properties of the ReportDocument object using the DatabaseName property.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
ganesh
Newbie
Newbie
Avatar

Joined: 11 Jan 2007
Location: India
Online Status: Offline
Posts: 8
Quote ganesh Replybullet Posted: 19 Jan 2007 at 8:52pm

i m again repeating that  i want all these functionality  in crystal only. i m not using these report with any application. these report will run independently.

pls if u have any idea abt this thing send me. thank u

gsg
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 19 Jan 2007 at 10:36pm
Unfortunately, it can't be done using Crystal Reports only.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
ChrisM
Newbie
Newbie


Joined: 10 Dec 2007
Location: United Kingdom
Online Status: Offline
Posts: 4
Quote ChrisM Replybullet Posted: 10 Dec 2007 at 5:52am
Originally posted by ganesh

hi
actually i have a user list and each user has their own database. database schema is same, but data will be different.
 
I'm sure there's a perfectly sane reason for doing this...but wouldn't it be easier (and somewhat more conventional) to have one db, with column 'IDuser' in each table? Yes of course it would, you've just established that.
It can only get worse: the company does rather well - 5 users becomes 50 - then you have to make some schema changes...
Beer will get you through times of no money better than money will get you through times of no beer.
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 14 Dec 2007 at 6:27am
Originally posted by ChrisM

I'm sure there's a perfectly sane reason for doing this...but wouldn't it be easier (and somewhat more conventional) to have one db, with column 'IDuser' in each table? Yes of course it would, you've just established that.
It can only get worse: the company does rather well - 5 users becomes 50 - then you have to make some schema changes...


In all fairness, he may not strictly be talking about entire separate databases for each user.  He may be talking about user-owned tables in a single database.  This is a methodology that does have some distinct advantages.  But, again, Crystal does not deal well with changing anything about the connection on the fly.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.