• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 706
  • Last Modified:

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

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
marnien
Asked:
marnien
  • 3
1 Solution
 
mlmccCommented:
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
 
marnienAuthor Commented:
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
 
mlmccCommented:
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
 
mlmccCommented:
Glad i could help

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now