hyper threading: call

I am trying to call a subreport in master report, if i try to run the sub report individually by passing hardcoded nonqueried values in the parameters it runs fine, but when i use it as subreport in a master report, it shows the error: subreport could not be shown,

In my subreport i am using the table control to populate all fields is there something to do with table control or i am calling the subreport control in the detail pane of main report, and all main reports fields are in the group header.

Please help.

error info: from error list:

Warning 1 [rsErrorExecutingSubreport] An error occurred while executing the subreport ‘subreport1’: One or more parameters required to run the report have not been specified. c:\aspnet\ccsreports2005\ccsreports2005\rptNewIssueHRT.rdl 0 0

Thank you all very much for the info.

Have you mapped the parameters in the master report to the parameters in the subreport? You do that through the properties screen of the subreport object.|||

Hi Adam,

I did mapped the parameters via parameter tab from subreport control.

My subreport is using a table control to populate all columns and there result.

If i run the sub report by itself individually, it runs fine with hardcoded values in it, but when i reference the same thru a subreport control via master report i am getting the error subreport could not be shown.

Please help is there something i am doing a mistake. and also do i need to have the subreports parameters also in master report.

Since under my master report i only have 1 parameter, thats all defined to pull it data, once that data gets in want to use those master datas value to pull the subreports data.

Master report uses stored proc which expects only one parameter, that is what i defined under parameter collection on layout of report.

Thank you very much.

|||So if your master report only has 1 parameter than how did you perform the mapping from the master report to the subreport parameters?|||

I got that error when the subreport was bigger than the textbox in which I placed it. I've also gotten the error when the datasource wasn't quite right, but it looks like you've covered that.

Hope this helps,

Don

|||

Yes, i found the problem yesterday. i am getting the parameter related columns in the dataset but did'nt place it on the report as a column since it is holding ID's in it.

after placing teh column and made it hidden true, then it is able to pull the data on subreport.

Thank you.

Hi All,
Please help me in using the hyperlinks in the SSRS to call a page within a
particular frame.
I have been working on a project where i a using HTML frames and SSRS is a
part of the right frame.i have to make sure that the URL
link(eg:-http://www.google.com) opens up in the right frame,and not in a
separate window.
This is how i tried doing it.
1.In a report i have put a image control.
2.I go to the properties of the image, and go to "Navigation" tab and select
"Jump to URL" combo box and edit the expression.
3.The expression that i have given is:
="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
where fraRightFrame is the frame,in which want to open the URL.
After i deploy this report and try clicking on the link, a page loads with
the message "Page cannot be displayed" and in the address bar, i can see the
above javascript.
Please help me as to how i can call a URl in the same frame where the
report is running.
Note:-
I am using SQL server reporting services 2005 with SP1 along with Shreapoint
server 2003.
Waiting for your responce,
Thanks in advance,
Regards,
Archana KamathPlease also note that Javascript works fine in the report.That is when i try
opening the report using the report manager /reportserver it works fine.When
i click the link, the page ('google') gets loaded.
But when i include the same report in my sharepoint site ,using the page
viewer webpart and try accessing the link,it throws up an error saying "Page
cannot be displayed" and the javascript gets pasted on the address bar.
Any idea why this behaviour?
Many thanks inadvance,
Regards,
Archana
"Archana" wrote:
> Hi All,
> Please help me in using the hyperlinks in the SSRS to call a page within a
> particular frame.
> I have been working on a project where i a using HTML frames and SSRS is a
> part of the right frame.i have to make sure that the URL
> link(eg:-http://www.google.com) opens up in the right frame,and not in a
> separate window.
> This is how i tried doing it.
> 1.In a report i have put a image control.
> 2.I go to the properties of the image, and go to "Navigation" tab and select
> "Jump to URL" combo box and edit the expression.
> 3.The expression that i have given is:-
> ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> where fraRightFrame is the frame,in which want to open the URL.
> After i deploy this report and try clicking on the link, a page loads with
> the message "Page cannot be displayed" and in the address bar, i can see the
> above javascript.
> Please help me as to how i can call a URl in the same frame where the
> report is running.
> Note:-
> I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> server 2003.
> Waiting for your responce,
> Thanks in advance,
> Regards,
> Archana Kamath
>|||Hi All,
The script
="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
worked fine.
Many Thanks
Archana
"Archana" wrote:
> Please also note that Javascript works fine in the report.That is when i try
> opening the report using the report manager /reportserver it works fine.When
> i click the link, the page ('google') gets loaded.
> But when i include the same report in my sharepoint site ,using the page
> viewer webpart and try accessing the link,it throws up an error saying "Page
> cannot be displayed" and the javascript gets pasted on the address bar.
> Any idea why this behaviour?
> Many thanks inadvance,
> Regards,
> Archana
> "Archana" wrote:
> > Hi All,
> >
> > Please help me in using the hyperlinks in the SSRS to call a page within a
> > particular frame.
> >
> > I have been working on a project where i a using HTML frames and SSRS is a
> > part of the right frame.i have to make sure that the URL
> > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > separate window.
> >
> > This is how i tried doing it.
> > 1.In a report i have put a image control.
> > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > "Jump to URL" combo box and edit the expression.
> > 3.The expression that i have given is:-
> > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> >
> > where fraRightFrame is the frame,in which want to open the URL.
> >
> > After i deploy this report and try clicking on the link, a page loads with
> > the message "Page cannot be displayed" and in the address bar, i can see the
> > above javascript.
> >
> > Please help me as to how i can call a URl in the same frame where the
> > report is running.
> >
> > Note:-
> > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > server 2003.
> >
> > Waiting for your responce,
> >
> > Thanks in advance,
> > Regards,
> > Archana Kamath
> >|||Hi,
can you explain in detail how the script solved the problem.
I cannot see any different between the script that you posted in the first
post. both
seems to be the same. Can you please explain in detail how it solved the
problem.
Thanks
Bava
"Archana" wrote:
> Hi All,
> The script
> ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> worked fine.
> Many Thanks
> Archana
> "Archana" wrote:
> >
> > Please also note that Javascript works fine in the report.That is when i try
> > opening the report using the report manager /reportserver it works fine.When
> > i click the link, the page ('google') gets loaded.
> >
> > But when i include the same report in my sharepoint site ,using the page
> > viewer webpart and try accessing the link,it throws up an error saying "Page
> > cannot be displayed" and the javascript gets pasted on the address bar.
> >
> > Any idea why this behaviour?
> > Many thanks inadvance,
> > Regards,
> > Archana
> > "Archana" wrote:
> >
> > > Hi All,
> > >
> > > Please help me in using the hyperlinks in the SSRS to call a page within a
> > > particular frame.
> > >
> > > I have been working on a project where i a using HTML frames and SSRS is a
> > > part of the right frame.i have to make sure that the URL
> > > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > > separate window.
> > >
> > > This is how i tried doing it.
> > > 1.In a report i have put a image control.
> > > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > > "Jump to URL" combo box and edit the expression.
> > > 3.The expression that i have given is:-
> > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > >
> > > where fraRightFrame is the frame,in which want to open the URL.
> > >
> > > After i deploy this report and try clicking on the link, a page loads with
> > > the message "Page cannot be displayed" and in the address bar, i can see the
> > > above javascript.
> > >
> > > Please help me as to how i can call a URl in the same frame where the
> > > report is running.
> > >
> > > Note:-
> > > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > > server 2003.
> > >
> > > Waiting for your responce,
> > >
> > > Thanks in advance,
> > > Regards,
> > > Archana Kamath
> > >|||Hi,
There was some problem in my sharepoint page and not in the script, which
was not letting the report to open in the specified frame.
What i did was,created a new sharepoint page with just one page viewer web
part and included the report in it which had the hyperlink and the script.
On click of the hyperlink,new page got opened in the same frame as required
by me,solving my problem.
Best Regards,
Archana Kamath
"Bava Mani" wrote:
> Hi,
> can you explain in detail how the script solved the problem.
> I cannot see any different between the script that you posted in the first
> post. both
> seems to be the same. Can you please explain in detail how it solved the
> problem.
> Thanks
> Bava
> "Archana" wrote:
> > Hi All,
> >
> > The script
> > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > worked fine.
> > Many Thanks
> > Archana
> >
> > "Archana" wrote:
> >
> > >
> > > Please also note that Javascript works fine in the report.That is when i try
> > > opening the report using the report manager /reportserver it works fine.When
> > > i click the link, the page ('google') gets loaded.
> > >
> > > But when i include the same report in my sharepoint site ,using the page
> > > viewer webpart and try accessing the link,it throws up an error saying "Page
> > > cannot be displayed" and the javascript gets pasted on the address bar.
> > >
> > > Any idea why this behaviour?
> > > Many thanks inadvance,
> > > Regards,
> > > Archana
> > > "Archana" wrote:
> > >
> > > > Hi All,
> > > >
> > > > Please help me in using the hyperlinks in the SSRS to call a page within a
> > > > particular frame.
> > > >
> > > > I have been working on a project where i a using HTML frames and SSRS is a
> > > > part of the right frame.i have to make sure that the URL
> > > > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > > > separate window.
> > > >
> > > > This is how i tried doing it.
> > > > 1.In a report i have put a image control.
> > > > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > > > "Jump to URL" combo box and edit the expression.
> > > > 3.The expression that i have given is:-
> > > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > > >
> > > > where fraRightFrame is the frame,in which want to open the URL.
> > > >
> > > > After i deploy this report and try clicking on the link, a page loads with
> > > > the message "Page cannot be displayed" and in the address bar, i can see the
> > > > above javascript.
> > > >
> > > > Please help me as to how i can call a URl in the same frame where the
> > > > report is running.
> > > >
> > > > Note:-
> > > > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > > > server 2003.
> > > >
> > > > Waiting for your responce,
> > > >
> > > > Thanks in advance,
> > > > Regards,
> > > > Archana Kamath
> > > >|||Thanks for the reply.
"Archana" wrote:
> Hi,
> There was some problem in my sharepoint page and not in the script, which
> was not letting the report to open in the specified frame.
> What i did was,created a new sharepoint page with just one page viewer web
> part and included the report in it which had the hyperlink and the script.
> On click of the hyperlink,new page got opened in the same frame as required
> by me,solving my problem.
> Best Regards,
> Archana Kamath
>
> "Bava Mani" wrote:
> > Hi,
> > can you explain in detail how the script solved the problem.
> > I cannot see any different between the script that you posted in the first
> > post. both
> > seems to be the same. Can you please explain in detail how it solved the
> > problem.
> >
> > Thanks
> > Bava
> > "Archana" wrote:
> >
> > > Hi All,
> > >
> > > The script
> > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > > worked fine.
> > > Many Thanks
> > > Archana
> > >
> > > "Archana" wrote:
> > >
> > > >
> > > > Please also note that Javascript works fine in the report.That is when i try
> > > > opening the report using the report manager /reportserver it works fine.When
> > > > i click the link, the page ('google') gets loaded.
> > > >
> > > > But when i include the same report in my sharepoint site ,using the page
> > > > viewer webpart and try accessing the link,it throws up an error saying "Page
> > > > cannot be displayed" and the javascript gets pasted on the address bar.
> > > >
> > > > Any idea why this behaviour?
> > > > Many thanks inadvance,
> > > > Regards,
> > > > Archana
> > > > "Archana" wrote:
> > > >
> > > > > Hi All,
> > > > >
> > > > > Please help me in using the hyperlinks in the SSRS to call a page within a
> > > > > particular frame.
> > > > >
> > > > > I have been working on a project where i a using HTML frames and SSRS is a
> > > > > part of the right frame.i have to make sure that the URL
> > > > > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > > > > separate window.
> > > > >
> > > > > This is how i tried doing it.
> > > > > 1.In a report i have put a image control.
> > > > > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > > > > "Jump to URL" combo box and edit the expression.
> > > > > 3.The expression that i have given is:-
> > > > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > > > >
> > > > > where fraRightFrame is the frame,in which want to open the URL.
> > > > >
> > > > > After i deploy this report and try clicking on the link, a page loads with
> > > > > the message "Page cannot be displayed" and in the address bar, i can see the
> > > > > above javascript.
> > > > >
> > > > > Please help me as to how i can call a URl in the same frame where the
> > > > > report is running.
> > > > >
> > > > > Note:-
> > > > > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > > > > server 2003.
> > > > >
> > > > > Waiting for your responce,
> > > > >
> > > > > Thanks in advance,
> > > > > Regards,
> > > > > Archana Kamath
> > > > >

Monday, March 12, 2012

I am querying 4 views using a LEFT OUTER JOIN but my data is not complete.

Friday, March 9, 2012

I am getting error Subreport could not be shown

Friday, February 24, 2012

Hyperlinks is SSRS 2005

hyper threading

Blog Archive

About Me