jump to URL and ReportParameters

Hi all...
Is there a way to set the format of a date parameter to day/month/year ?
I´m using jump to URL to navigate to another report by setting up the action
property of textbox to:
= Globals!ReportServerUrl & "?/Folder/ReportOne&InitialDate=" &
Parameters!InitialDate.Value
PS.: the language property of textbox is Portuguese (brazil)
... but in URL of "ReportOne" the date is converted to another format
(month/day/year)...
Could anyone help me?
thanks a lotPlease check the Readme file of Reporting Services 2000 SP1 or SP2:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_new_url_access_parameters
You need to specify the ParameterLanguage URL parameter.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ricardo" <ricardo@.fundep.br> wrote in message
news:eQ23gAWuFHA.252@.TK2MSFTNGP09.phx.gbl...
> Hi all...
> Is there a way to set the format of a date parameter to day/month/year ?
> I´m using jump to URL to navigate to another report by setting up the
> action property of textbox to:
> = Globals!ReportServerUrl & "?/Folder/ReportOne&InitialDate=" &
> Parameters!InitialDate.Value
> PS.: the language property of textbox is Portuguese (brazil)
> ... but in URL of "ReportOne" the date is converted to another format
> (month/day/year)...
> Could anyone help me?
> thanks a lot
>sql

Jump to URL

Hi,

I want to navigate to a webpage from my report. On clicking a report field that web page should be opened. I have written the following code,

Function OpenWindow (ByVal DealerId as Integer,ByVal CustomerNo as string,ByVal InvoiceNo as string, ByVal CustomerType as string,ByVal CustomerStatus as string,ByVal AppilcationName as string,ByVal UserId as string,ByVal CallStatus as string)as String

Dim strURL as String
Dim strTargetURL as String
Dim strFeatures as String

If CustomerType = "EXTERNAL" and CustomerStatus <> "Completed"
strURL = AppilcationName & "?" & "DealerId="& DealerId &"&CustomerNo="&CustomerNo &"&InvoiceNo="&InvoiceNo & "&UserId=" & UserId & "&CallStatus=" &CallStatus

strTargetURL = "javascript:void(window.open('"
strTargetURL = strTargetURL & strURL & "'"
strTargetURL = strTargetURL & ",'',"

strFeatures = "' width=1000,height=720,scrollbars=yes, status=no, toolbar=no, resizable=no, left=0, top=0'"

strTargetURL = strTargetURL & strFeatures
strTargetURL = strTargetURL & ",'_blank'));"

End If
Return strTargetURL

End Function

Now If I click the report field my web page is opening in a new page. But if I select the option "Open in New Window" an empty page as well as my web page is being opened. How to avoid the opening of empty page.

Help of any kind to this problem is welcome

Thanks in Advance,

Sivaatzenith

It seems that you should maybe just assign the href of the url, and not use the javascript. Personally, I don't like it when a site wants to size and/or position a window with/without various options... I guess I kookie like that :)

|||

Hi Ben,

Thanks for your reply

Can you pls give a sample containing the href in jump to url code

Regards

Sivaatzenith

|||

Sivaatzenith,

My thought was that in your OpenWindow code, you omit the javascript code...

So perhaps:
strTargetURL = "javascript:void(window.open('"
strTargetURL = strTargetURL & strURL & "'"
strTargetURL = strTargetURL & ",'',"

strFeatures = "' width=1000,height=720,scrollbars=yes, status=no, toolbar=no, resizable=no, left=0, top=0'"

strTargetURL = strTargetURL & strFeatures
strTargetURL = strTargetURL & ",'_blank'));"

becomes:
strTargetURL = strURL

I am not really sure if this will work in Sql Reporting Services or not...

Good Luck

|||

hi,

Thanks for ur reply... First I had given the following code in jump to URL

STRURL ="http:mail.yahoo.com"

Mine is a web application. The reports will be launched by web application which is in .net.These reports will be shown in report viewer ctrl. This report will also contain subreport, which will be displayed on clicking of a textbox. When I click this textbox to view the sub report and after that press the link (jump to url) I am getting a java script error... Actually thats a problem with report viewer after googling I found out that microsoft has provided a hot fix for this which is extra money. So I tried this.

Any other solution is welcome.. I tired using <a href also. but of no use... I am getting a run time error.

Thanks in advance

Sivaatzenith

|||

I apologize that I am not more familiar with reporting services, what is your specific javascript error?

|||

hi Ben,

If I click the link, my desired web page is opened in a new browser. But If I select the option "Open in a new page" an empty browser as well as my page is opened. I need to avoid this empty page.

Thanks in Advance,

Sivaatzenith.

Jump to Report problem

Hi,
I guess this is a simple question. When I'm using "jump to report" in
report A, it will navigate to another report (report B). The problem
is, in report manager, there is no "back to parent" button in the
report B, so I can back to report A. Is there any solution to solve
this?
ThanksIf you are using 2005 then the button is present otherwise you need to give a
button sort of thing ie a textbox and "Action" so that it jumps to the report
A from Report B
Amarnath, MCTS
"Alphonse" wrote:
> Hi,
> I guess this is a simple question. When I'm using "jump to report" in
> report A, it will navigate to another report (report B). The problem
> is, in report manager, there is no "back to parent" button in the
> report B, so I can back to report A. Is there any solution to solve
> this?
> Thanks
>|||where is the back button present in 2005RS? i dont see any back button in
Report B.
I think we should create a action textbox link to back to the parent report.
- Bava
"Amarnath" wrote:
> If you are using 2005 then the button is present otherwise you need to give a
> button sort of thing ie a textbox and "Action" so that it jumps to the report
> A from Report B
> Amarnath, MCTS
> "Alphonse" wrote:
> > Hi,
> > I guess this is a simple question. When I'm using "jump to report" in
> > report A, it will navigate to another report (report B). The problem
> > is, in report manager, there is no "back to parent" button in the
> > report B, so I can back to report A. Is there any solution to solve
> > this?
> > Thanks
> >
> >|||From the browser, see the toolbar of the Normal report, it will be available
near the export button.
Amarnath,MCTS
"Bava Mani" wrote:
> where is the back button present in 2005RS? i dont see any back button in
> Report B.
> I think we should create a action textbox link to back to the parent report.
> - Bava
>
> "Amarnath" wrote:
> > If you are using 2005 then the button is present otherwise you need to give a
> > button sort of thing ie a textbox and "Action" so that it jumps to the report
> > A from Report B
> >
> > Amarnath, MCTS
> >
> > "Alphonse" wrote:
> >
> > > Hi,
> > > I guess this is a simple question. When I'm using "jump to report" in
> > > report A, it will navigate to another report (report B). The problem
> > > is, in report manager, there is no "back to parent" button in the
> > > report B, so I can back to report A. Is there any solution to solve
> > > this?
> > > Thanks
> > >
> > >|||Interesting i cannot find the back button in my Report Manager toolbar when
viewing the drillthrough report. There is only 'Find| Next' link near the
export button. what edition of reporting service you are using? Dev,Std, Ent ?
Thanks
Bava
"Amarnath" wrote:
> From the browser, see the toolbar of the Normal report, it will be available
> near the export button.
> Amarnath,MCTS
> "Bava Mani" wrote:
> > where is the back button present in 2005RS? i dont see any back button in
> > Report B.
> > I think we should create a action textbox link to back to the parent report.
> >
> > - Bava
> >
> >
> > "Amarnath" wrote:
> >
> > > If you are using 2005 then the button is present otherwise you need to give a
> > > button sort of thing ie a textbox and "Action" so that it jumps to the report
> > > A from Report B
> > >
> > > Amarnath, MCTS
> > >
> > > "Alphonse" wrote:
> > >
> > > > Hi,
> > > > I guess this is a simple question. When I'm using "jump to report" in
> > > > report A, it will navigate to another report (report B). The problem
> > > > is, in report manager, there is no "back to parent" button in the
> > > > report B, so I can back to report A. Is there any solution to solve
> > > > this?
> > > > Thanks
> > > >
> > > >|||yes, as far as I can see, there is no back button in the report manager
toolbar.
Btw,OOT , I post this thread in sql reporting services groups, in google
groups. But there is no replies in my thread in the google groups like in
here :(
Thanks
"Bava Mani" wrote:
> Interesting i cannot find the back button in my Report Manager toolbar when
> viewing the drillthrough report. There is only 'Find| Next' link near the
> export button. what edition of reporting service you are using? Dev,Std, Ent ?
> Thanks
> Bava
> "Amarnath" wrote:
> > From the browser, see the toolbar of the Normal report, it will be available
> > near the export button.
> >
> > Amarnath,MCTS
> >
> > "Bava Mani" wrote:
> >
> > > where is the back button present in 2005RS? i dont see any back button in
> > > Report B.
> > > I think we should create a action textbox link to back to the parent report.
> > >
> > > - Bava
> > >
> > >
> > > "Amarnath" wrote:
> > >
> > > > If you are using 2005 then the button is present otherwise you need to give a
> > > > button sort of thing ie a textbox and "Action" so that it jumps to the report
> > > > A from Report B
> > > >
> > > > Amarnath, MCTS
> > > >
> > > > "Alphonse" wrote:
> > > >
> > > > > Hi,
> > > > > I guess this is a simple question. When I'm using "jump to report" in
> > > > > report A, it will navigate to another report (report B). The problem
> > > > > is, in report manager, there is no "back to parent" button in the
> > > > > report B, so I can back to report A. Is there any solution to solve
> > > > > this?
> > > > > Thanks
> > > > >
> > > > >|||yes you are right. any MVP in this group can confirm it ? since we dont want
to tell my client to click the back button in the browser to go to parent
report. if back button is available then which editon of reproting service
support this?
"Alphonse" wrote:
> yes, as far as I can see, there is no back button in the report manager
> toolbar.
> Btw,OOT , I post this thread in sql reporting services groups, in google
> groups. But there is no replies in my thread in the google groups like in
> here :(
> Thanks
> "Bava Mani" wrote:
> > Interesting i cannot find the back button in my Report Manager toolbar when
> > viewing the drillthrough report. There is only 'Find| Next' link near the
> > export button. what edition of reporting service you are using? Dev,Std, Ent ?
> >
> > Thanks
> > Bava
> > "Amarnath" wrote:
> >
> > > From the browser, see the toolbar of the Normal report, it will be available
> > > near the export button.
> > >
> > > Amarnath,MCTS
> > >
> > > "Bava Mani" wrote:
> > >
> > > > where is the back button present in 2005RS? i dont see any back button in
> > > > Report B.
> > > > I think we should create a action textbox link to back to the parent report.
> > > >
> > > > - Bava
> > > >
> > > >
> > > > "Amarnath" wrote:
> > > >
> > > > > If you are using 2005 then the button is present otherwise you need to give a
> > > > > button sort of thing ie a textbox and "Action" so that it jumps to the report
> > > > > A from Report B
> > > > >
> > > > > Amarnath, MCTS
> > > > >
> > > > > "Alphonse" wrote:
> > > > >
> > > > > > Hi,
> > > > > > I guess this is a simple question. When I'm using "jump to report" in
> > > > > > report A, it will navigate to another report (report B). The problem
> > > > > > is, in report manager, there is no "back to parent" button in the
> > > > > > report B, so I can back to report A. Is there any solution to solve
> > > > > > this?
> > > > > > Thanks
> > > > > >
> > > > > >|||It is ok for my client to use the back button in the browser. The problem is,
if the detailed report using drilldown. Clicking the back button won't
navigate to the parent report. Any solution?
Thanks
"Bava Mani" wrote:
> yes you are right. any MVP in this group can confirm it ? since we dont want
> to tell my client to click the back button in the browser to go to parent
> report. if back button is available then which editon of reproting service
> support this?
>|||Alphonse,
Very sorry that facility is available in preview mode ie in design mode and
not through browser, solutions to yuour problem is that you can have a
textbox with "Back" text and an Action to it to go back to parent report.
Amarnath
"Alphonse" wrote:
> It is ok for my client to use the back button in the browser. The problem is,
> if the detailed report using drilldown. Clicking the back button won't
> navigate to the parent report. Any solution?
> Thanks
> "Bava Mani" wrote:
> > yes you are right. any MVP in this group can confirm it ? since we dont want
> > to tell my client to click the back button in the browser to go to parent
> > report. if back button is available then which editon of reproting service
> > support this?
> >
>

Jump to report and also URL based on parameters values

Hi,
i am doing a page whereby user can navigate to other report by clicking on
the respective column data and i am now using this navigating expression:
=Switch(Fields!Status.Value = "Pending", "EvaluatePending",
Fields!Status.Value = "Rejected", "ViewRejected", Fields!Status.Value = "Accepted", "ViewAccepted")
This expression only allows me to jump to other report but not to a URL
because i try using the following statement but got an error:
=Switch(Fields!Status.Value = "Pending",
"="http://localhost/SSS-ASP/EvaluatePending.aspx?SuggestionID=" &
Fields!SuggestionID.Value", Fields!Status.Value = "Rejected", "ViewRejected",
Fields!Status.Value = "Accepted", "ViewAccepted")
For the above statement what i want to achieved was that when user click on
the column with the Status=Pending, it will go to the
URL="http://localhost/SSS-ASP/EvaluatePending.aspx?SuggestionID=" &
Fields!SuggestionID.Value. If Status=Rejected, it will jump to the report
ViewRejected and lastly if Status=Accepted, it will jump to the report
ViewAccepted. Hope somebody can guide me with the correct expression.
Thanks in advance. =)Hello, is anybody able to help me with this problem? really need help with
this still not sure how to solve. Thanks
"JiaN" wrote:
> Hi,
> i am doing a page whereby user can navigate to other report by clicking on
> the respective column data and i am now using this navigating expression:
> =Switch(Fields!Status.Value = "Pending", "EvaluatePending",
> Fields!Status.Value = "Rejected", "ViewRejected", Fields!Status.Value => "Accepted", "ViewAccepted")
> This expression only allows me to jump to other report but not to a URL
> because i try using the following statement but got an error:
> =Switch(Fields!Status.Value = "Pending",
> "="http://localhost/SSS-ASP/EvaluatePending.aspx?SuggestionID=" &
> Fields!SuggestionID.Value", Fields!Status.Value = "Rejected", "ViewRejected",
> Fields!Status.Value = "Accepted", "ViewAccepted")
> For the above statement what i want to achieved was that when user click on
> the column with the Status=Pending, it will go to the
> URL="http://localhost/SSS-ASP/EvaluatePending.aspx?SuggestionID=" &
> Fields!SuggestionID.Value. If Status=Rejected, it will jump to the report
> ViewRejected and lastly if Status=Accepted, it will jump to the report
> ViewAccepted. Hope somebody can guide me with the correct expression.
> Thanks in advance. =)