Showing posts with label filter. Show all posts
Showing posts with label filter. Show all posts

Sunday, March 11, 2012

Change URL

Can any body help me i need to chanage my URL when select my TPM and TPK

i have two option in my Filter 1.TPM

2.TPK

i writen some custome code here but its not working i know some thing wrong in that

its my Code here:-

Public Function access(ByVal parameter As Object) As String

IF parameter Is "TPM" Then

Response.Write("<script language=""Javascript"">window.open ('//localhost/Reportserver/Pages/ReportViewer.aspx?%2fTPM%2fAFM1&rs:Command=Render&rc:Toolbar=true&RUNDATE=" & Parameters!TPM.Value & ' ,'mywindow','location=1,status=1,resizable=yes,scrollbars=1,width=400,height=400');</script>")

ElseIF parameter Is "TPK" Then

Response.Write"<scriptlanguage="javapt"">window.open //localhost/Reportserver/Pages/ReportViewer.aspx?%2fTPM%2fTPM01&rs:Command=Render&rc:Toolbar=true&TPK=" & Parameters!TPK.Value & " ','_blank','location=1,status=1,resizable=yes,scrollbars=1,width=400,height=400');</script>")

End If

End Function

Normal Url is working properly actual problem is i want to change URL depends on parameter selection.Custome code is giving some error like

Error: Response is not declared......

when i written custome code i will declare my parameter=code.access(parameter!sao.value) ? Is it Currect?

Can anybody tell me how to do this one because i really struck here only..

Thanking you.

Your code assumes that you are running in the context of an ASPX page. This isn't the case. The Response object is never declared. So the error message is correct.

|||

Wouldn't it be better if u use the reportview control and embed the report in ur aspx page?
Patrick

|||

thanx for your reply

can u give me some example code.Its actually Report Project only i shoudt use aspx pages

where can i change my custom code can u give me some any example

thanx

kiran

|||

Try reading through this website at:-
http://www.gotreportviewer.com/

|||

it ok that site.Its good

But i didt use any aspx pages in my reports i am using only Business intelligece through i developing my reports only i shoudt use aspx pages any where

i am developing only reports only.

in my report Two Filter i need to change my Url dynamically .This is Report1:

Reortid report Name PD KF TK

1 report1 1 0 0

2 report2 2 2 3

3 report3 2 1 0

Actually Here No need to change anydata Here just change my URL only what ever i select that particual option in my filter

in my filter On option is Change Url filter

in two option in TPM and TPK

This Filter is not related to anything data

this filter job is only change the URL sonly.Suppose i will select TPM option it wil come that related URL only.

when i press PD Data it will take hyper like goes to another report ok

i will select TPK option it will change my URL that related URL only.

i am giving one example:

if(value=TPM)

-its going to what ever declare here jump URL

else if (value=TPK)

-its going to what ever declare here jump URL

end

i dont know how to do this task.can any body

thanx

Thursday, March 8, 2012

Change the username in Active Directory

We use extended properties of Active Directory to filter the data in reporting services throw a web services. We send the userid (User!UserId) to the webservices and retrieve some information about the user.
But if we change the name of one user (rename not recreate), he lost all this properties. When try to execute a report show an error:
  • Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError) I know this issue is in the border of reporting services, but we have spent a lot of time without results and we need any help.

    Thanks in advance

    How are you doing your rename? Because that's where your issue is <s>.

    If you're doing it through some GUI interface and that interface doesn't transfer your extended properties on a rename, then that interface has a bug in it <sigh>.

    I do some AD coding but don't have an example I can throw in here. Basically, when any consumer queries AD for a user object, it is allowed to say what properties it's interested in retrieving. If it doesn't know about yours and doesn't retrieve them, it probably doesn't clone them along with the rest of the object. (I think, under the covers, a rename likely does a clone-and-delete.)

    So you have to write something that does know about your extended properties and write a better rename...

    >L<

    |||We rename the user in Active directory but i supposed that in some part of reporting services store the previous username, guid or something to refers to the old user. When we use the user!userID functions, reporting services get the old value instead the new value.

    Our process is:
    We have two parameters, one with the user and other with the information to retrieve and send to another queries. Send this two parameters to the web services and retrieve a parameter (a custom property defined in AD) to send in another query.

    We use directly in web browser the reporting services. And it is the default configuration of report server web.

    Thanks for your patience

    |||

    >>We rename the user in Active directory

    I know that's what you did. I asked you *how* you did this (through what interface).

    But, yes, if you're getting the old version when you look at user!userID, it doesn't matter.

    I don't see why the report server would be caching the previous user name etc, unless you have put this information in as the credentials of the user to run the report in the report configuration?

    Could this possibly be an AD refresh type of problem, instead? IOW, you do the rename and all the domain servers don't know about it?

    >L<

  • Friday, February 10, 2012

    Change merge filter

    I like to change a filter of a article. I'm using sp_changemergefilter but I
    need the name of the filter.
    I have the names of the filters with sp_helpmergefilter but only give me the
    join filters.
    I like to know if sp_changemergefilter only works with join filters?
    And how can I change a filter that is not join filter?
    Thanks for your help
    David Barquero
    I think you want to use sp_changemergearticle, something like this:
    exec sp_changemergearticle @.publication = 'Tier1', @.article = 'MergeTable',
    @.force_invalidate_snapshot = 1, @.force_reinit_subscription = 1, @.property =
    'subset_filterclause', @.value = 'locationID=1'
    Hilary Cotter
    Looking for a SQL Server replication book?
    http://www.nwsu.com/0974973602.html
    "David Barquero" <davbarquero@.hotmail.com> wrote in message
    news:ujr53NP%23EHA.1408@.TK2MSFTNGP10.phx.gbl...
    > I like to change a filter of a article. I'm using sp_changemergefilter but
    I
    > need the name of the filter.
    > I have the names of the filters with sp_helpmergefilter but only give me
    the
    > join filters.
    > I like to know if sp_changemergefilter only works with join filters?
    > And how can I change a filter that is not join filter?
    >
    > Thanks for your help
    > David Barquero
    >
    |||Hilary Thanks for your help
    I try to do it like you say me, but when I'm runing the SP it's give me
    this error
    Server: Msg 21416, Level 16, State 1, Procedure sp_changemergearticle, Line
    272
    Property 'subset_filterclause' of article 'TomaFisica' cannot be changed.
    Why I Can't change the filterclause?
    "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
    news:%23ixyH1X%23EHA.2032@.tk2msftngp13.phx.gbl...
    >I think you want to use sp_changemergearticle, something like this:
    > exec sp_changemergearticle @.publication = 'Tier1', @.article =
    > 'MergeTable',
    > @.force_invalidate_snapshot = 1, @.force_reinit_subscription = 1, @.property
    > =
    > 'subset_filterclause', @.value = 'locationID=1'
    > --
    > Hilary Cotter
    > Looking for a SQL Server replication book?
    > http://www.nwsu.com/0974973602.html
    > "David Barquero" <davbarquero@.hotmail.com> wrote in message
    > news:ujr53NP%23EHA.1408@.TK2MSFTNGP10.phx.gbl...
    > I
    > the
    >