Showing posts with label subreport. Show all posts
Showing posts with label subreport. Show all posts

Monday, March 12, 2012

Getting problem when using Dundas chart in subreport

Hi,
I am using Visual Studio 2005 and SQL Server 2005 Reporting Services with
Dundas charts for Reporting. I have creatied one subreport and put this
subreport in List control in main report. I have placed Dundas chart in
subreport. In this way I want to display many dundas charts dynamically.
When I preview the main report it only displays last chart and red X image
is displayed instead of other charts.
I also tried to install SQL Server 2005 SP2 and then I also installed
"cumulative hotfix package for SQL Server 2005 (build 9.0.2153)". But still
same problem.
Do u have any idea about this problem?
Thanks,
....HineshDid you find a solution for that. I have the same problem with dundas chart in a subreport
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Friday, February 24, 2012

Getting field info from subreport

Quick question...
I have a report with a subreport. Can I reference a field/textbox in the
subreport from the main report? For example, if I have a sum calculated by
the subreport, can I display that in the report?
Thanks!hi!
you can't reference a value from SubReport in Report directly, but you can
sent this value as a parameter to a Report
1. In Subreport Set a link to main Report
1.1 Inb the Subreport select textBox or field in the table
1.2 select navigation tab of property
1.3 select "jump to Report" and chose your Main Report
1.3 as Parameter set needed calculated value from SubReport
2. Set parmater in the main Report
( with the same name as calculated value in SubReport )
3. Now you can access calculated value from SubReport in Main Report
I hope it will be usefull. i thing it is the best way to send a value
between reports in one project.
"Teros" wrote:
> Quick question...
> I have a report with a subreport. Can I reference a field/textbox in the
> subreport from the main report? For example, if I have a sum calculated by
> the subreport, can I display that in the report?
> Thanks!

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
>