How to get the current record value and put it in parameter?

Question

Post reply

How to get the current record value and put it in parameter?

ally.john2

SSC Enthusiast

Points: 110
More actions
September 8, 2011 at 9:28 am

#257026

Hi I am trying to get chosen record value and put it in parameter.
Can anyone know how to do it?
Thanks
Ally

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

nigel. SSChampion Points: 11636 More actions · Answer 1

Sorry, don't understand your question, you're going to have to explain in more detail what you're trying to do.

Nigel
How to post questions

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

Ninja's_RGR'us

SSC Guru

Points: 294069

September 8, 2011 at 9:48 am

#1378676

Google output parameters

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 3

What do you mean by current record?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

ally.john2 SSC Enthusiast Points: 110 More actions · Answer 4

Hi,

Please see the attachment . When I choose one of the Report Name, I'd like to put chosen report name into parameter and pass parameter value to the subreport.

Thanks

Ally

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

Right click on your subreport object, properties, parameters.

nigel. SSChampion Points: 11636 More actions · Answer 6

I would guess you're talking about Reporting Services, Yes?

And you want to be able to click on one of the rows in your report which then opens the appropriate report?

Nigel
How to post questions

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 7

DECLARE @Param1 varchar(50)

SET @Param1 = (SELECT ReportName from #MyTable WHERE This = That)

EXEC MyStoredProc @Param1

?

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

ally.john2 SSC Enthusiast Points: 110 More actions · Answer 8

ally.john2

SSC Enthusiast

Points: 110

September 8, 2011 at 10:06 am

#1378705

Sorry I should have put chosen instead of current.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 9

ally.john2 (9/8/2011)
Sorry I should have put chosen instead of current.

Go to the properties of any textbox you want to become a link.

Then action, hit ... to get the popup.

From there on out you can open a url or another subreport.

You can set the parameters there.

Then I usually change the color to Blue, bold and underline so it looks like a link.

ally.john2 SSC Enthusiast Points: 110 More actions · Answer 10

How can I get chosen Report Name value into ReportName1 parameter ?(Please see second attachment)

Thanks

Ally

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 11

ally.john2 (9/8/2011)
How can I get chosen Report Name value into ReportName1 parameter ?(Please see second attachment)
Thanks
Ally

Please stop editing the original post, it justs makes it hard to understand the thread.

http://shahfaisalmuhammed.wordpress.com/2010/01/09/passing-parameters-to-a-drillthrough-report-in-ssrs/

ally.john2 SSC Enthusiast Points: 110 More actions · Answer 12

Pleasee the attacment called Calling_subReport.

The problem here I can not get ReportName1 parameter is null.

How can I get chosen report name into ReportName1 parameter?

Thanks

Ally

ally.john2 SSC Enthusiast Points: 110 More actions · Answer 13

ally.john2

SSC Enthusiast

Points: 110

September 8, 2011 at 10:28 am

#1378735

It woks

Thanks Mohammed.

Really appreciate it!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 14

Never tried that.

Have you tested and IIF? You could control the value there and it should be possible to make it work.