VB Crystal Report, linked subreport

microsoft.public.vb.crystal - Microsoft Visual Basic


VB Crystal Report >> linked subreport

by Shailesh Patel » Tue, 26 Apr 2005 00:08:49 GMT

Hello,
---Version 7----
I have crystal report designer in VB6 that has subreport linked in it.
Now, when I install this project on client machine and run report, main
report looks into the database located/installed into C:\Program
Files\<project folder> directory (i.e. C:\Program Files\mydatabase.mdb)
while linked subreport looks into the folder I created project at design
time (i.e. c:\<project folder>mydatabase.mdb)
How can I make sure that make sure that linked subreport looks at C:\Program
Files\<project folder>\mydatabase.mdb and not C:\<project
folder>mydatabase.mdb at RUNTIME.

Thank you for your reply.

Shailesh



Top
Similar Threads

1. Cannot link subreport by parameters 

Argh.  I have a report and a subreport, both of which have the
parameters StartDate and EndDate.  I am trying to link the main report
to the subreport using the parameters.  It is not working at all.  What
am I doing wrong?????

2. Linked Subreports - VB Crystal Report

3. Linking subreports 

I'm using Crystal Reports 8.0 and i've been using text fields in my
report(i.e. abc_ttx.field1), i created a subreport in the existing
report and linked it with this field(i.e. abc_ttx.field1) that should
be displayed in the subreport. But i'm unable to link subreport to
parent report. The field gets displayed in the parent report but not in
subreport.
Here abc_ttx is a text file i've been using to print field "field1" in
the crystal reports.
Can anybody suggest as why the field doesn't get displayed in
subreport.......Thnx in advance

4. Linking Subreports based on Stored Procs - VB Crystal Report

5. Linking subreports without parameters 

Hi,

Because of export problems to pdf in my webform CR's, I now use Record 
Selection Queries, instead of parameters.
How can I now link the subreports?
I use 5 subreports in one totals report, linked by the parameter ?Periode.
In every subreport, Periode is used for the record selection.
How do I solve this problem?

Kind regards,
Alison

6. Subreport Linking with VBA

7. Outer Link on subreport 

"Bob Holmes" < XXXX@XXXXX.COM > wrote in message
news:#Q91# XXXX@XXXXX.COM ...
> Hi Ken,
>     I don't think I would classify it as an "inner join."  Your main
report
> record would be displayed, whether or not there was a subreport record to
go
> along with it.  For example:  If you had an inventory report of all items
> that a store carries and you wanted to put all of the sales in a subreport
> linked by the item number, your main report would still display every
item,
> but the subreports would not return data for an item if there were none
> sold.  In this way, it works more like a "Left Outer Join."
>
> Bob Holmes
>


OK Bob, good enough, but let's reverse the situation. And I have an example
this time! I posted here yesterday about supressing a section in the main
report if all the values returned by the 3 subreports in said section were
0. Would there be a way to make the subreport link an inner join then? That
way, it would NOT return the records where the subreport values were null?
(In my situation yesterday, NULL and 0 were the same). This way, I wouldn't
have to worry about supressing any sections where the subreports returned 0
or NULL, they just wouldn't be returned by the report. Is this possible?
Thanks.

KB

8. Subreport Date Range Links - VB Crystal Report