Solved

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

Posted on 2006-11-16
4
683 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 100

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 100

Accepted Solution

by:
mlmcc earned 500 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 100

Expert Comment

by:mlmcc
ID: 18190834
Glad i could help

mlmcc
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 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