Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Which one is better (DSR files inside VB) or Seperate report files

Status
Not open for further replies.

nomi2000

ISP
Feb 15, 2001
676
CA
Dear Fellow programmers
please let me know which one is better to use
DSR files inside VB) or Seperate report files & call in VB..
is there any cons and pros of the two methods
i have to make a decision about it please help me...
Regards
Nouman
 
Personal view is to use external rpt files.

Advantages
1)You can provide custom alternate rpts for your clients
2) A small change to rpt doesn't require a recompile and redistribute of your exe

Disadvanatges
1) lots of extra rpt files to distrubute
2) Your report design is wide open for anyone to borrow of change

Using the DSR: advantages
1) Fewer files to distribute
2) Rpts are securely locked inside the EXE

Disadvantages:
1) Change your report spec, send out a new EXE
2) Everone gets the same reports. Difficult to customsie reports. Editor and Publisher of Crystal Clear
 
thanx very much chesetech
i also think to distribute by report files but there is one serious problem which is how to secure the report files ..if someone deleted that report file then the application mught crush...does crytal report provide some thing to secure the reports files? i m wondering if there is some crystal report server which can provide the security for the files
Regards
Nouman
 
If you want secure reports, then you need to use the DSR file.

But your reason for wanting "secure" reports needs more thought. It is easy enough to check for the existence of a rpt file before you assign it to the RDC objects. And you might have a reason you want your user to create a variation of one of your standard reports.

Another way to secure your reports is to make them all ADO, so they can only be used via your app passing it the data it needs via an ADO recordset. Editor and Publisher of Crystal Clear
 
You don't have to put all of the .DSR files into the .EXE. You could put them into 1 or more DLLs. If you can group the reports by subject or department and make each set into a DLL, future changes might only involve an updated DLL.
 
We chose to use all .rpt files.

Two reasons drove this decision. The first was a VB limitation (solved, I believe, by the latest VB Service Pack and MDAC 2.5). The other is a desire to be able to update/change a report without having to reinstall the application.

We have 5-600 users and a system locked down so only adminstrators can install software. A nightmare when only changing a report.

To help secure the report files, we loaded them on a network drive as read-only and the directory is network-secured as read-only for all but the development team.

good luck
mlmcc
 
thanx all ur advices are of great help for me to deciede which on is better for me i will go for dsr files b/c i dunno have so many users to deal with
but thanx all of u for ur help,,i really appreciate u...
thanx again
Regards
Nouman
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top