Friday, March 30, 2012
Jump to URL in ReportViewer- Underline not displaying
I have a text box in a table that has its text-decoration property set to
Underline. The textbox has its value set from a column in a dataset. I have
also defined the following as its Jump to URL expression:
="http://" & Parameters!WebServerName.Value &
"/Policy/Reports/AdvisorAccountPolicyStatus.aspx?asofdate=" &
Parameters!dAsOfDate.Value & "&AdvId=" & Fields!ENCRYPTED_USER_ID.Value
The second I define the Jump to URL expression and deploy the report, the
Underline stops being displayed. If I remove the Jump to URL expression, the
Underline is displayed.
I am using the .Net ReportViewer control. I know that the HTML is being
rendered properly for the text-decoration, but the reportviewer control
refuses to display it. If I view the report using the SQL Reporting Services
management tool, the underline is displayed.
Does anyone have a solution?
Thanks,
Keith MisegadesIf anyone has a solution to this, it would be greatly appreciated.
Everything I have tried has failed and we really need a solution to this
issue.
Thanks,
Keith
"Keith" wrote:
> Hello,
> I have a text box in a table that has its text-decoration property set to
> Underline. The textbox has its value set from a column in a dataset. I have
> also defined the following as its Jump to URL expression:
> ="http://" & Parameters!WebServerName.Value &
> "/Policy/Reports/AdvisorAccountPolicyStatus.aspx?asofdate=" &
> Parameters!dAsOfDate.Value & "&AdvId=" & Fields!ENCRYPTED_USER_ID.Value
> The second I define the Jump to URL expression and deploy the report, the
> Underline stops being displayed. If I remove the Jump to URL expression, the
> Underline is displayed.
> I am using the .Net ReportViewer control. I know that the HTML is being
> rendered properly for the text-decoration, but the reportviewer control
> refuses to display it. If I view the report using the SQL Reporting Services
> management tool, the underline is displayed.
> Does anyone have a solution?
> Thanks,
> Keith Misegades
>sql
Wednesday, March 28, 2012
jump to report in the same frame of calling report
i had created a report (ReportA) in which i m calling another report (ReportB). I had added a textbox (tb) in ReportA and had set the navigation property of tb to "jump to report" and given a report name ReportB (i.e. the second report).
Now, i m using asp.net report service,
i had created an asp form in which i had added a frame, n in tat frame i had added the report service control, this report service control calls my first report (ReportA),when i click on the textbox (tb) it jumps to another report (ReportB), now the problem is when i click textbox (tb), it jumps to ReportB but this report takes whole area of internet explorer.
wat i want is when i click textbox (tb), the next report (ReportB) should come in the same frame where my first report (ReportA) was.
Plz help me out.
Thanx.
--
Message posted via http://www.sqlmonster.comIn the URL for ReportA, you'll need to Add:
&rc:LinkTarget=nameofFrame
Then in your textbox tb, you'll need to set your navigation property to jump
to URL, giving it the URL of ReportB.
"Imran Saiyed via SQLMonster.com" wrote:
> Hi,
> i had created a report (ReportA) in which i m calling another report (ReportB). I had added a textbox (tb) in ReportA and had set the navigation property of tb to "jump to report" and given a report name ReportB (i.e. the second report).
> Now, i m using asp.net report service,
> i had created an asp form in which i had added a frame, n in tat frame i had added the report service control, this report service control calls my first report (ReportA),when i click on the textbox (tb) it jumps to another report (ReportB), now the problem is when i click textbox (tb), it jumps to ReportB but this report takes whole area of internet explorer.
> wat i want is when i click textbox (tb), the next report (ReportB) should come in the same frame where my first report (ReportA) was.
> Plz help me out.
> Thanx.
> --
> Message posted via http://www.sqlmonster.com
>|||Hi,
Thanx for ur suggestion, but
firstly,
i had created my project such tat whenever new session of project is opened, it ask for username and password. therefore if i add the url of ReportB in the navigation property of textbox (tb) "jump to url", then whenever tb is clicked, it creates a new session for ReportB, so first the login screen occurs, then it enters into the project, then again i have to go to ReportA, then click tb. Therefore i was using "Jump to report" property which directly opens the ReportB.
secondly,
now i had removed the frame for some problem i was facing, n now i m using table (i.e. <td><\td>) between this td the reportviewer control is added. so i want to show ReportB in this table.
Thanx.
--
Message posted via http://www.sqlmonster.com
Jump to Report Error after SP1
property set to another report three properties are passed to the "jump to
report". There is one dataset on the original report that is using a report
datasource with a specific username and password that allows the saving of
the password.
This works correctly when executing the report in visual studio design time.
It doesn't work correctly after it is deployed and it gets executed from the
report server/manager web site. When the user clicks the text box that
executes the "jump to" report the following error comes up:
The current action cannot be completed because the user data source
credentials that are required to execute this report are not stored in the
report server database. (rsInvalidDataSourceCredentialSetting)
This worked fine before SP1 was installed.
Any assistance would be appreciated.
Tim
tfogel@.idmi.comOne of the changes in SP1 was require the unattended execution account to be
specified on the server when running reports with datasources with
CredentialsOptions = None.
If you are using a data source that requires no credentials, for ex. Access
or XML files, set the unattended account using rsconfig -u ...
If you are using a data source that requires credentials, for ex: SQL,
Oracle, DB/2, etc. store credentials in the report server.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tim Fogel" <tfogel@.idmi.com> wrote in message
news:OCEdA9dXEHA.1144@.TK2MSFTNGP12.phx.gbl...
> I have a textbox on a report that has the advanced navigation jump to
report
> property set to another report three properties are passed to the "jump to
> report". There is one dataset on the original report that is using a
report
> datasource with a specific username and password that allows the saving of
> the password.
> This works correctly when executing the report in visual studio design
time.
> It doesn't work correctly after it is deployed and it gets executed from
the
> report server/manager web site. When the user clicks the text box that
> executes the "jump to" report the following error comes up:
> The current action cannot be completed because the user data source
> credentials that are required to execute this report are not stored in the
> report server database. (rsInvalidDataSourceCredentialSetting)
> This worked fine before SP1 was installed.
> Any assistance would be appreciated.
> Tim
> tfogel@.idmi.com
>
Jump to Report Action for Textbox fails when Textbox is in Report Header
it works fine in the Preview in VS, but when it is actually uploaded,
clicking on it results in:
The path of the item "(null)" is not valid. The path must be less than
260 characters long and must start with slash. Other restrictions
apply. (rsInvalidItemPath)
Works fine when the textbox is in the report body. Anyone else having
this problem?
-WilliamAny solution to this one? Or better yet, is it noted somewhere as a bug in
the product?
thanks!
Michael R.
"nimitt" wrote:
> I am having the exact same problem... I'm using the latest service packs.
> EggHeadCafe.com - .NET Developer Portal of Choice
> http://www.eggheadcafe.com
>
Jump to report
Hi all,
I have created a hyperlink(textbox) with an action property setting of "Jump to report" The report I am jumping to takes 5 parameters. I want to pass 4 of the parameters from the main report and have the user enter the 5th. I have mapped the 4 parameters and in preview mode, everthing works great. In preview mode, the parametrs are passed and the last parameter is left waiting for entry. After deployment, this is not the case. In the deployed state, I simply get an error that parameter #5 is blank. Is there there something I am missing?
regards,
Bill
I am having the same issue. I have a report that you can jump to via a hyperlink with parametes but I also need the ability to jump to the report and have the user get prompted for the parameter. Works in Visual Studio but not when I deploy.
The only workaround I have found is to use the jump to URL and put the "http//<servername>/reportserver?/<FolderName>/<reportname>" in there. You'd have to tack on the report parameters on the end of the url
|||Just a bump. Hoping someone has some insight here.Jump to report
Hi all,
I have created a hyperlink(textbox) with an action property setting of "Jump to report" The report I am jumping to takes 5 parameters. I want to pass 4 of the parameters from the main report and have the user enter the 5th. I have mapped the 4 parameters and in preview mode, everthing works great. In preview mode, the parametrs are passed and the last parameter is left waiting for entry. After deployment, this is not the case. In the deployed state, I simply get an error that parameter #5 is blank. Is there there something I am missing?
regards,
Bill
I am having the same issue. I have a report that you can jump to via a hyperlink with parametes but I also need the ability to jump to the report and have the user get prompted for the parameter. Works in Visual Studio but not when I deploy.
The only workaround I have found is to use the jump to URL and put the "http//<servername>/reportserver?/<FolderName>/<reportname>" in there. You'd have to tack on the report parameters on the end of the url
|||Just a bump. Hoping someone has some insight here.Jump to report
Hi all,
I have created a hyperlink(textbox) with an action property setting of "Jump to report" The report I am jumping to takes 5 parameters. I want to pass 4 of the parameters from the main report and have the user enter the 5th. I have mapped the 4 parameters and in preview mode, everthing works great. In preview mode, the parametrs are passed and the last parameter is left waiting for entry. After deployment, this is not the case. In the deployed state, I simply get an error that parameter #5 is blank. Is there there something I am missing?
regards,
Bill
I am having the same issue. I have a report that you can jump to via a hyperlink with parametes but I also need the ability to jump to the report and have the user get prompted for the parameter. Works in Visual Studio but not when I deploy.
The only workaround I have found is to use the jump to URL and put the "http//<servername>/reportserver?/<FolderName>/<reportname>" in there. You'd have to tack on the report parameters on the end of the url
|||Just a bump. Hoping someone has some insight here.sql