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

Problem with naming a pdf file and setting criteria

I am having trouble generating pdf file based on a criteria set in a query.  Currently the file name is as listed below;

Plan 92 Provider #1 07.08.2011

Plan 92 = is part of the that on the report (this is what I need to add based on that field in the table)
Provider #1 = Reference
07.08.2011 = DraftDate

I need to add the PlanType at the end of the file name based on the criteria set in the query.  This is where I am having trouble, the PlanType is in the “tluFundsImport” table.  I tried setting the criteria in the “qryRPT1” query to generated just those PlanType 92, but it is creating pdf for all files, and disregarding the query.  

I need to create a separate report for each Reference Number, and having a pdf file for each Reference, but only if there is a record:  an example of what I need is as follows:

Reference, PlanType, DraftDate, it should look like this: Provider #1 Plan 92 07.16.2011

I will be creating a different report for each Plan Type, and will need to generate just the records with these Plan Type for each Reference.

I file is attached.  Thanks in advance!

Test-EFT-08-24-11--5-New-2.accdb
0
Delores_C
Asked:
Delores_C
  • 4
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
is the recordsource of your report the query "qryRPT1" ?

0
 
Jeffrey CoachmanCommented:
Why is qryRPT1 a "Group By"  query...

In a general sense the recordset and the Report recordsource should be basically the same.

Also note that the pound symbol ("#") is a *restricted* character in Windows file names...
http://support.microsoft.com/kb/177506
0
 
Jeffrey CoachmanCommented:
..and so is the period (".")
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
Jeffrey CoachmanCommented:
This "Kinda" works OK for me.
(it runs without errors, and produces 3 PDF files, all with *valid* file names)

If it is not what you wanted, then pleas state what is wrong with it.

Jeff
Test-EFT-08-24-11--5-New-2.accdb
0
 
Delores_CAuthor Commented:
Answer for Capricorn1:  Yes the qryRPT! isw the record source

Answer for boarg2000:  Problems:

1.  The file is still using the title, which is part of the script in the SQL, not the actual PlanType in the filename
There are 3 differenct PlanType in the table. I  should have deleted the Plan 92 from the script

0
 
Jeffrey CoachmanCommented:
So what are the *Exact* results you are looking for, based on the DB you posted?

In other words don't describe what is, or is not happening like you are doing above...

Literally list the *EXACT* results you are expecting.
Ex:
I need ____ files created
The first file should be named _____ and should have ____ records, ...etc
The second file should be named _____ and should have ____ records, ...etc
...etc
0
 
Delores_CAuthor Commented:
The answer was part of the answer
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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