[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Linking a "File System Data" datasource with a (pervasive.sql) database table

Posted on 2006-11-16
4
Medium Priority
?
696 Views
Last Modified: 2012-08-13
Hi, I am trying to create a report for Physician dictation/transcription info. My report is based on a few tables from a pervasive.sql database. (I am connecting through the native connection but can do an ODBC if necessary) I have added a network folder as a File System datasource but I don't know how I can connect the file system datasource with my tables (I need to know if a file has been uploaded for a particular appointment record in my Schedule table). It is the filename that could provide the linkage BUT only through a combination of field values from my Schedule table.   The file name is always in the same format: physician-initials.document-type.encounter-date.patient-name.medrec#.dss. An example file name: JBP.OPC.20061115.MARYANN-SMITH.665322.DSS. If there isn't a way to link these in the Links window, there must still be a way to do it on the report - perhaps through grouping? I'm sure it's my limited experience...but I need to figure this out ASAP..500 points...anyone??

0
Comment
Question by:marnien
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 17962490
I doubt you can link them.  Also Crystal doesn't like 2 data sources particularly if they are different database types.

Build a report on the file system that retrieves the file names
  Add a formula that counts the records
  assign the count to a shared variable
Add it as a subreport
Link it using the file name
Using the shared variable test if it is 0 or 1

mlmcc
0
 

Author Comment

by:marnien
ID: 18058476
Hi, sorry for the delay in responding, thanks mlmcc for the tip regarding subform...I do use different database types all the time in Crystal- MS Access, PervasiveSQL, text files, Excel, etc...I guess my question should have simply been, "how do I go about buildng a  'relationship table' (of sorts) to connect the 2 tables"? Is that what I should do? Is a subreport better? Does anyone have any other thoughts? If not, the points go to mlmcc..
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 18058550
A subreport is probably the easiest way.  You can link a subreport to the main report.
http://support.businessobjects.com/communityCS/TechnicalPapers/scr_subreports.pdf.asp

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 18190834
Glad i could help

mlmcc
0

Featured Post

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

650 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