Solved

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

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Not Exists 3 69
cross tab report accumulative amount 9 51
Ignore parameter if no value entered 22 61
Crystal Reports 13 5 58
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. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 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