| Author |
Data Missing Question
|
|
| mattism 2006-01-23, 7:07 pm |
| I am using CR for .Net 2003. I have two I have one dataset that has
two tables that I pass to the report. Currently only one of the tables
is receiving data. When I export the report to be displayed none of my
data is showing up. Is there a way to avoid this?
Thanks
Matt
| |
| Shariq 2006-01-23, 7:07 pm |
| Did you linked the tables?
"mattism" wrote:
> I am using CR for .Net 2003. I have two I have one dataset that has
> two tables that I pass to the report. Currently only one of the tables
> is receiving data. When I export the report to be displayed none of my
> data is showing up. Is there a way to avoid this?
>
> Thanks
> Matt
>
>
| |
| mattism 2006-01-23, 7:07 pm |
| No I did not link the tables
| |
|
| I have had the same problem with the second table in the dataset not showing
up in the report. I have tried linking the tables with the visual linking
expert and/or using a data relation in the dataset. Neither approach worked
for me. I finally had to output the two tables to an access db file and use
the odbc provider for access to add the tables on disk to the report. Then
I fill the tables, run the report and it works.
"mattism" <mattism@gmail.com> wrote in message
news:1138029666.105750.241600@g43g2000cwa.googlegroups.com...
I am using CR for .Net 2003. I have two I have one dataset that has
two tables that I pass to the report. Currently only one of the tables
is receiving data. When I export the report to be displayed none of my
data is showing up. Is there a way to avoid this?
Thanks
Matt
| |
| Shariq 2006-01-23, 7:07 pm |
| Go to Database Expert and click on Links and then create a link between to
two tables.
"mattism" wrote:
> No I did not link the tables
>
>
| |
| Shariq 2006-01-23, 7:07 pm |
| Linking two tables have always worked if linked properly.
"Rich" wrote:
> I have had the same problem with the second table in the dataset not showing
> up in the report. I have tried linking the tables with the visual linking
> expert and/or using a data relation in the dataset. Neither approach worked
> for me. I finally had to output the two tables to an access db file and use
> the odbc provider for access to add the tables on disk to the report. Then
> I fill the tables, run the report and it works.
>
> "mattism" <mattism@gmail.com> wrote in message
> news:1138029666.105750.241600@g43g2000cwa.googlegroups.com...
> I am using CR for .Net 2003. I have two I have one dataset that has
> two tables that I pass to the report. Currently only one of the tables
> is receiving data. When I export the report to be displayed none of my
> data is showing up. Is there a way to avoid this?
>
> Thanks
> Matt
>
>
>
| |
|
| Can you not join the two tables together in the sql generates the
dataset?
That's how I always work.
| |
|
| I would do it that way in most cases but in this one case the sql was too
complicated. I had to create temporary intermediate tables then query them
to create the final 2 tables. I could have gone one step further and do one
more query and create one final result table but I thought that should not
be necessary. After I got to the last two it should have worked. I am not
familiar enough with working with Crystal to know why it did not work so I
tried writing the tables to a temporary mdb and that fixed the problem.
Maybe though, your way would have been better.
Rich :)
"andy" <aon14@lycos.co.uk> wrote in message
news:1138107450.577820.148920@g44g2000cwa.googlegroups.com...
Can you not join the two tables together in the sql generates the
dataset?
That's how I always work.
|
|
|
|