?
Solved

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

Posted on 2006-11-16
4
Medium Priority
?
700 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
  • 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month16 days, 17 hours left to enroll

862 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