Showing posts with label value. Show all posts
Showing posts with label value. Show all posts

Friday, March 30, 2012

Jump to URL in ReportViewer- Underline not displaying

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 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

Jump to URL and pass parameter

I would like to jump to a URL like UPS and pass in a value (tracking number).
Is there a way to do this under the "action" of the field I would like to
pass? "Jump to Report" allows parameters but "Jump to URL" does not resolve
the actual field values.
--
Thanks in advance,
JohnHere is the specific example for the issue described. In ther Report Layout,
I select a specific field and in the properties window "action" I enter the
URL below in the "Jump to URL" option.
http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=%20Fields!TrackingNumber.Value
When executing the report, clicking in the actual value passes the URL
exactly as shown above instead of converting Fields!TrackingNumber.Value to
the actual value.
Is there an alternate way to accomplish this?
Thanks,
John|||You have to turn this into an expression:
="http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=" &
Fields!TrackingNumber.Value
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John K" <JohnK@.discussions.microsoft.com> wrote in message
news:EABF40D1-D597-4575-B149-5FDB74FC6D0F@.microsoft.com...
> Here is the specific example for the issue described. In ther Report
Layout,
> I select a specific field and in the properties window "action" I enter
the
> URL below in the "Jump to URL" option.
>
http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=%20Fields!TrackingNumber.Value
> When executing the report, clicking in the actual value passes the URL
> exactly as shown above instead of converting Fields!TrackingNumber.Value
to
> the actual value.
> Is there an alternate way to accomplish this?
> Thanks,
> John
>|||Thanks Bruce, that did it.
"Bruce L-C [MVP]" wrote:
> You have to turn this into an expression:
> ="http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=" &
> Fields!TrackingNumber.Value
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "John K" <JohnK@.discussions.microsoft.com> wrote in message
> news:EABF40D1-D597-4575-B149-5FDB74FC6D0F@.microsoft.com...
> > Here is the specific example for the issue described. In ther Report
> Layout,
> > I select a specific field and in the properties window "action" I enter
> the
> > URL below in the "Jump to URL" option.
> >
> >
> http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=%20Fields!TrackingNumber.Value
> >
> > When executing the report, clicking in the actual value passes the URL
> > exactly as shown above instead of converting Fields!TrackingNumber.Value
> to
> > the actual value.
> >
> > Is there an alternate way to accomplish this?
> >
> > Thanks,
> > John
> >
> >
>
>

Jump to URL

If I select this item and enter some value into the field, should this field
automatically be formatted as a hyperlink or do I need to manually format
the field.
Thanks,You need the fully formed URL.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tim Kelley" <tkelley@.company.com> wrote in message
news:eA16ZPo3GHA.3344@.TK2MSFTNGP05.phx.gbl...
> If I select this item and enter some value into the field, should this
> field automatically be formatted as a hyperlink or do I need to manually
> format the field.
> Thanks,
>

Wednesday, March 28, 2012

Jump To Report with Multi Valued Parameter Value

I have a mutli-valued, (cascading? dependent on other parameter
values) parameter whose values are retrieved from a database query. I
want to set the default value of the parameter to be the same as the
"Select All" function. How can I acheive this?
To explain, I have two budget reports. The first is a summary, which
groups lines by expense codes and then displays a total. Each dollar
figure is set to click through to the detail report, and filter the
results based on the expense code from the line clicked on. However,
if the user clicks on the total figure (all expense codes), the
resulting detail report only shows the detail for the first object code
in the list. It should display the detail for all object codes.
Thanks -
SarahSarah,
<sarah.lambrite@.gmail.com> wrote in message
news:1158007893.402465.74110@.b28g2000cwb.googlegroups.com...
>I have a mutli-valued, (cascading? dependent on other parameter
> values) parameter whose values are retrieved from a database query. I
> want to set the default value of the parameter to be the same as the
> "Select All" function. How can I acheive this?
SELECT 0 as Value, 'Select All' as Description
UNION ALL
SELECT ID as Value, Columnname as Description FROM YourTable
When you set =0 as your default value, you should be fine.
> To explain, I have two budget reports. The first is a summary, which
> groups lines by expense codes and then displays a total. Each dollar
> figure is set to click through to the detail report, and filter the
> results based on the expense code from the line clicked on. However,
> if the user clicks on the total figure (all expense codes), the
> resulting detail report only shows the detail for the first object code
> in the list. It should display the detail for all object codes.
It looks like RS is having troubles to determine what to put in the
parameter, I think you have the parameter set up to get the contents of the
field (expense code) of the line you click on. But on the total line there
is no such field. This can be solved by altering your subreport parameters.
Set them up so that the subreport gives the details of all the expense
codes.
Perry
> Thanks -
> Sarah
>sql

Jump to report value for parameter, cube data

Have a problem with passing information between reports using Jump to report
facility.
User clicking on field value in report to pass to second report. This works
with the second report showing the value of field user has selected in the
parameter box (Available Values set to non-queried) but report shows an error
of:
restrictions imposed by the constrained flag in the STRTOSET function were
violated
Have tried many settings to correct this but with no luck. Does anybody
know how to correct this problem.
Thanks
IanIn case this is helpful to others I have found that the field parameter was
causing the problem. I was using Fields!FieldName.Value and should have used
Fields!FieldName.UniqueName
Ian
"IanP" wrote:
> Have a problem with passing information between reports using Jump to report
> facility.
> User clicking on field value in report to pass to second report. This works
> with the second report showing the value of field user has selected in the
> parameter box (Available Values set to non-queried) but report shows an error
> of:
> restrictions imposed by the constrained flag in the STRTOSET function were
> violated
> Have tried many settings to correct this but with no luck. Does anybody
> know how to correct this problem.
> Thanks
> Ian

Jump to report expression

Hi,
Was hoping to select a jump to report based upon the value of field. Is
this not possible ?
iif(Fields!ACATEGORY.Value="Receipts","Shop 2006 Inventory Analysis Detail
Receipts Report","Shop 2006 Inventory Analysis Detail Consumption Report" )
keep getting .....
The specified server url does not link to the report server for this report
manager or is not in the correct format.Just needed a "=" before the iif
"steve" wrote:
> Hi,
> Was hoping to select a jump to report based upon the value of field. Is
> this not possible ?
> iif(Fields!ACATEGORY.Value="Receipts","Shop 2006 Inventory Analysis Detail
> Receipts Report","Shop 2006 Inventory Analysis Detail Consumption Report" )
>
> keep getting .....
> The specified server url does not link to the report server for this report
> manager or is not in the correct format.

Jump to report and parameters

I have a table where I want to jump to a different report based on the value
in the table cell. The report that I am jumping to has a parameter, and the
parameter value that I need to pass is based on the table cell's value. I
know how to set this up in the report but can't figure out how filter the
dataset that has my parameter values, and I can't filter the dataset using
ReportItems.
If I were to write some pseudocode using SQL it would look something like
this:
PopupReport(Select Param From ParamTable Where ParamKey = Fields!MyTextBox.Value)
Thanks...
Regards,
SteveIf the report you are jumping to has parameters then I am confused on the
issue. When setting up the jump to report you set the parameters of the
report you are jumping to, in this case to the field. That being the case,
what is the problem? The report you are jumping to must be able to accept
the parameter and return the correct data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Steve" <MyNoSpam@.NoSpam.org> wrote in message
news:00B417ED-8954-4CAC-A07B-48FD361A3575@.microsoft.com...
>I have a table where I want to jump to a different report based on the
>value
> in the table cell. The report that I am jumping to has a parameter, and
> the
> parameter value that I need to pass is based on the table cell's value. I
> know how to set this up in the report but can't figure out how filter the
> dataset that has my parameter values, and I can't filter the dataset using
> ReportItems.
> If I were to write some pseudocode using SQL it would look something like
> this:
> PopupReport(Select Param From ParamTable Where ParamKey => Fields!MyTextBox.Value)
> Thanks...
> Regards,
> Steve|||Hi Bruce,
The problem I have is that the parameter value that I need to pass is in a
SQL table and I need to select the correct parameter based on the cell I am
clicking on.
For instance, the textbox value I am clicking on contains a sales region,
e.g. Central, Northeast, etc, and I want to pass a list of the salereps for
that region into another report. The list of salesreps for that region is
contained in a separate sql table and the sql to find the appropriate list of
salesreps would be something like "Select RepList From Configs Where Region ='Central'", except that the region varies with the row I am clicking on in
the Reporting Services table.
I can make this work if I do something like this for the parameter
expression in the report:
iif(Fields!Region.Value="Central","1,2,3",iif(Fields!Region.Value="Northeast","4,5,6",....))
, but it's kind of ugly and hardcoded...
Hope this is clearer and thanks for your response.
Regards,
Steve
"Bruce L-C [MVP]" wrote:
> If the report you are jumping to has parameters then I am confused on the
> issue. When setting up the jump to report you set the parameters of the
> report you are jumping to, in this case to the field. That being the case,
> what is the problem? The report you are jumping to must be able to accept
> the parameter and return the correct data.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Steve" <MyNoSpam@.NoSpam.org> wrote in message
> news:00B417ED-8954-4CAC-A07B-48FD361A3575@.microsoft.com...
> >I have a table where I want to jump to a different report based on the
> >value
> > in the table cell. The report that I am jumping to has a parameter, and
> > the
> > parameter value that I need to pass is based on the table cell's value. I
> > know how to set this up in the report but can't figure out how filter the
> > dataset that has my parameter values, and I can't filter the dataset using
> > ReportItems.
> >
> > If I were to write some pseudocode using SQL it would look something like
> > this:
> >
> > PopupReport(Select Param From ParamTable Where ParamKey => > Fields!MyTextBox.Value)
> >
> > Thanks...
> >
> > Regards,
> > Steve
>
>

Jump to Report & Multi Value vs. Single Value

I have a parameterized main report that contains a link to a sub report with parameters. Then from the sub report I have a link that takes you back to main report. If I use multi value parameters or single value parameters the links going back and forth between the two reports works just dandy, when I run it on my PC. However when I deploy the reports to the Web Server, the link going from the sub report back to the main report only works if the parameters are single select. Going from the Main to the Sub it doesn’t matter.

This is the error I get using multi select parameters going from the sub report back to the main.

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)

Any suggestions?

By any chance, are the drillthrough links located in the page header or page footer?

-- Robert

Jump to report

Hi

I want to use Jump to Report option under Navigation tab.

I have two reports both with Same parameters and parameters are multiple value selectable.

In Jump to Report this is how I set the parameter value.

LeadershipTeamId =Join(Parameters!LeadershipTeamId.Value,", ")

CostCentreId =Join(Parameters!CostCentreId.Value,", ")

CostElementGroupId =Fields!CostElementGroupId.Value

This works fine if I have only one value selected for CostCentre and LeadershipTeam but when I select the multiple value I get the following error.

  • The value provided for the report parameter 'LeadershipTeamId' is not valid for its type. (rsReportParameterTypeMismatch)

    Am I missing anything here?

    Any help would be highly appreciated.

    Best Regards

    I used this expression and it seems to be working.

    =Split(Join(Parameters!LeadershipTeamId.Value,", "),",")

    Correct me if this is not the right approach.

    Now my problem is When I jump to second report the CostCentre Parameter value is not set.

    Because, costcentre value is depend on the LeadershipTeam value.

    So when I jump to second report I have LeadershipTeam value set but I have to select costcentre value.

    Is it possible to make CostCentre selected when someone jump to the report?

    Thanks for your help

    Regards

    Update: By the way it works if I select only one CostCentre.

    |||

    Solved it using this thread.

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=163803&SiteID=1

    Thanks guys

    Amit

  • Wednesday, March 21, 2012

    joining two results

    I have two sets of results built up. Each set has a state value. Although one set has 38 states in the results while the other has 23. Is it possible to join these sets and show a result for each of the 38 states even if there is not a corresponding value in the other set. All attempts I've made lose the 15 states that do not appear in the other set. Any help would be great. Thanks in advanceIf your database engine supports LEFT JOIN, or better yet FULL JOIN, then you are in business. If not, you can kind of "fake it" using a sub-select, but it is hokey.

    -PatP

    Joining two datasets?

    Hi All,

    I have got two datasets. Some 'normal' rows with state values and an addtional dataset with the translation from state value to plain text (value / text pair).

    A table object is attached to the first dataset, but I would like to show the plain text from the second dataset in a group header. So I'd like to do some kind of 'look up in another dataset'.

    I wasn't able to find a function that could help me solve this problem. Does anyone has any ideas on this?

    Kind regards.

    Create 2 new parameters: Parameter1 will have all the values from DataSet2 (dataset with text/value paur) and Parameter2 will have all the text from DataSet2.

    Write a function (VB.Net ot C#) in the report code (Report -> Report Properties -> Code tab) which will accept these parameters as object arrays and then store them in a shared variable.

    Create a textbox in the beginning of the report which will call the above function by passing both the parameters. If you just specify the parameter (say Parameter!Parameter1.Value), it is considered as an array as it have more than one value and it will be received in the function as an object array.

    Write another function (function2) in the code which will get the state id (or value) and then loop through the shared arrays (already stored) to find the corresponding text.

    Call function2 from your table header to get the text for a given value.

    Hope this helps. If more examples and explanation is needed, let me know.

    Shyam

    |||

    Hello Shyam,

    thanks a lot for your post. I think this a way to solve my problem.

    But also think MS should think about this for future versions. I think it is very complicated (Crystal Reports makes it much easier for developers). It would also be very helpful if datasets could be accessed directly within custom funcation.

    Kind regards, CLive76

    |||

    An alternative approach is to combine the two datasets already in the dataset query. Some options to consider:
    ? Linked Server functionality (see http://msdn2.microsoft.com/en-us/library/aa213283(SQL.80).aspx)
    ? OpenRowSet functionality to join data from another database server into the current query (http://msdn2.microsoft.com/en-us/library/ms190312.aspx, http://msdn2.microsoft.com/en-us/library/aa276850(SQL.80).aspx)

    -- Robert

    Friday, March 9, 2012

    Join using max value

    I want to join two tables together but only join the where the column
    in table 2 (of type date) is the maximum value. Is this possible?

    Note table 1 is the main table it is also joined to other tables too.Hello,

    Would something like this work?

    select
    *
    from
    table1 t1
    join table2 t2 on t1.joinkey=t2.joinkey
    where
    t2.date = (select max(datefield) as max_date from table2)

    Greg.

    ree32 wrote:
    > I want to join two tables together but only join the where the column
    > in table 2 (of type date) is the maximum value. Is this possible?
    > Note table 1 is the main table it is also joined to other tables too.|||Please post DDL, so that people do not have to guess what the keys,
    constraints, Declarative Referential Integrity, datatypes, etc. in your
    schema are. Sample data is also a good idea, along with clear
    specifications. It is a bitch to debug code that you cannot see.|||Actually, if you read his request, he is only asking if its possible.

    So a simple YES, (sans any explanation of technique), would appear to
    suffice.

    "--CELKO--" <jcelko212@.earthlink.net> wrote in message
    news:1112319257.363540.54270@.f14g2000cwb.googlegro ups.com...
    > Please post DDL, so that people do not have to guess what the keys,
    > constraints, Declarative Referential Integrity, datatypes, etc. in your
    > schema are. Sample data is also a good idea, along with clear
    > specifications. It is a bitch to debug code that you cannot see.|||Thanks for the idea, I will test it out later.

    "Greg" <gregdenison@.gmail.com> wrote in message news:<1112314603.380779.78130@.g14g2000cwa.googlegroups.c om>...
    > Hello,
    > Would something like this work?
    > select
    > *
    > from
    > table1 t1
    > join table2 t2 on t1.joinkey=t2.joinkey
    > where
    > t2.date = (select max(datefield) as max_date from table2)