Getting second row in a data source

Hi,

I'm generating a report where 3 photos can be shown on a report if there are 3 photos in our data source.

they are layed out with the main photo on the left, and the other 2 photos on top of each other on the right.

The dataset that is returned from the query has a column called PhotoURL and each photo is a row of the returned dataset

I have inserted three images on the report

The first image I set the value to be =First(Fields!PhotoURL.Value, "Image")

How do you get the second image to have a value of the second row of the dataset, I mean there is no Second function, or movenext that I can see.

The same applies with the third image.

Thanks in advance

Auschucky

Hello Auschucky,

The First function is an aggregation function, which is not suitable for your images-issue.

When the dataset is returning a number of rows, you have to use a list or table on the report to get all rows (images) on the report. However, this doesn't match your report design.

If the dataset always contains one, two or three images, I suggest to change the select statement to return one row with three url fields. You can attach these fields to your images on the report.

getting Error: Subreport could not be shown in report viewer

Hi All,
I am getting this error - "Error: Subreport could not be shown" only in
the report viewer. Strangely, the first row in the parent report has
the subreport shown correctly and all the subsequent rows have this
error message.
The report runs fine when I use the preview in Business Intelligence
studio where I develop the report.
The log file has this error logged in it:
An error has occurred during report processing -->
System.ArgumentException: Item has already been added. Key in
dictionary: '84' key being added: '84'
Please help me solve this problem! It is taking all my time....
Thanks in advance
Bharathif you are talking about the report server, then make sure the subreport was
deployed into the same folder your main report was. If not, it will give an
error in the box where your subreport is supposed to be.
<bharath.mp@.gmail.com> wrote in message
news:1154370670.199335.21860@.i3g2000cwc.googlegroups.com...
> Hi All,
> I am getting this error - "Error: Subreport could not be shown" only in
> the report viewer. Strangely, the first row in the parent report has
> the subreport shown correctly and all the subsequent rows have this
> error message.
> The report runs fine when I use the preview in Business Intelligence
> studio where I develop the report.
> The log file has this error logged in it:
> An error has occurred during report processing -->
> System.ArgumentException: Item has already been added. Key in
> dictionary: '84' key being added: '84'
> Please help me solve this problem! It is taking all my time....
> Thanks in advance
> Bharath
>|||Hi Ben,
i was talking about the report server. yes, the sub report is deployed
in the same folder as the parent report. strangely, only the first row
in the parent report has the sub report displayed. the subsequent rows
have got the error message.
Thanks
Bharath
Ben Watts wrote:
> if you are talking about the report server, then make sure the subreport was
> deployed into the same folder your main report was. If not, it will give an
> error in the box where your subreport is supposed to be.
> <bharath.mp@.gmail.com> wrote in message
> news:1154370670.199335.21860@.i3g2000cwc.googlegroups.com...
> > Hi All,
> >
> > I am getting this error - "Error: Subreport could not be shown" only in
> > the report viewer. Strangely, the first row in the parent report has
> > the subreport shown correctly and all the subsequent rows have this
> > error message.
> >
> > The report runs fine when I use the preview in Business Intelligence
> > studio where I develop the report.
> >
> > The log file has this error logged in it:
> >
> > An error has occurred during report processing -->
> > System.ArgumentException: Item has already been added. Key in
> > dictionary: '84' key being added: '84'
> >
> > Please help me solve this problem! It is taking all my time....
> >
> > Thanks in advance
> > Bharath
> >|||Sorry to be a "me, too"-er, but yeah, me, too.
Main and Sub reports in the same folder, passing parameters correctly.
Getting the sub-report in the first record, but it errors out on all
subsequent passes. Also getting the "Item has already been added" message in
the logs.
Any ideas? I'm checking the Service Pack level with our Administrator group;
not sure where to go after that.
Mark.
<bharath.mp@.gmail.com> wrote in message
news:1154370670.199335.21860@.i3g2000cwc.googlegroups.com...
> Hi All,
> I am getting this error - "Error: Subreport could not be shown" only in
> the report viewer. Strangely, the first row in the parent report has
> the subreport shown correctly and all the subsequent rows have this
> error message.
> The report runs fine when I use the preview in Business Intelligence
> studio where I develop the report.
> The log file has this error logged in it:
> An error has occurred during report processing -->
> System.ArgumentException: Item has already been added. Key in
> dictionary: '84' key being added: '84'
> Please help me solve this problem! It is taking all my time....
> Thanks in advance
> Bharath
>