• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 584
  • Last Modified:

How to pass a SSRS variable to a PHP url.

In SSRS.
I would like use the out site url to the report link.
How can I transfer the value to the url?

"//myserver/report.php?mater=<SSRS_value>".

For instance matter_code is the value in SSRS report. How do we pass the matter_code variable so that the out site PHP report renders the info for that specific matter.

Sql server Report service
Thanks
0
Tim
Asked:
Tim
  • 6
  • 4
1 Solution
 
TimSenior PHP DeveloperAuthor Commented:
need help. anyone ? Thanks
0
 
RobOwner (Aidellio)Commented:
Hi,

It looks like it should work.  What's not working for you?

Rob
0
 
TimSenior PHP DeveloperAuthor Commented:
Thanks for answer.
I try to put  "//myserver/report.php?mater=<matter_code>"
When I click the link, it just give me "//myserver/report.php?mater=<matter_code>"
I try to put  "//myserver/report.php?mater=@matter_code"
When I click the link, it just give me "//myserver/report.php?mater=@matter_code"

I need the SSRS variable( "matter_code" ) can transfer.
Like "//myserver/report.php?mater=5555"

Please help.

Thanks
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
RobOwner (Aidellio)Commented:
try the Fx button to add the variable that way.

I know php and other BI reporting tools but I'm not up on SSRS.  I'll help any way I can though ok?
0
 
TimSenior PHP DeveloperAuthor Commented:
Putting the variable using the FX option, makes no difference.
I try to put  "//myserver/report.php?mater=Fields!matter_code.Value"
When I click the link, it just give me "//myserver/report.php?mater=Fields!matter_code.Value"


Everything after the = sign is passed as text not as a variable

Please help
0
 
RobOwner (Aidellio)Commented:
Ah then try putting the variable outside the string

"//myserver/report.php?mater=" & Fields!matter_code.Value
0
 
TimSenior PHP DeveloperAuthor Commented:
Hi:

it is still same as text , do not pass the variable.

Thanks
0
 
RobOwner (Aidellio)Commented:
Is there another way to edit the link, like viewing the code behind the report? You may be abbr to remove the quotes that way?
0
 
TimSenior PHP DeveloperAuthor Commented:
="//myserver/report.php?mater=" & Fields!matter_code.Value

Yea. It works, try to put "=" before the string.
Now works.
Thank you very much.
0
 
TimSenior PHP DeveloperAuthor Commented:
Thank you very much. It works
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now