Prev: Row totals?
Next: Reporting Services 2005 Item Security Issue
From: Azmi on 27 Apr 2010 11:35
I need to add vb function in SSRS code area to read the url , parse it and return the result to be used in the Data SQL select stataement.

for example
http://localhost:3765/psrForms/psrComposition.aspx?userid=abxma

for example

select userid, section, division
from usertbl
where
userid = funcode()

I do not want to add parameter I want to code it (ONLY)
Any ideas... Thank you



William Vaughn \(MVP\) wrote:

Let's see the RDL and the URL you are using to call it.
06-Jan-10

Let's see the RDL and the URL you are using to call it. Remember that the
parameters are case-sensitive. It does not sound like you are setting one or
more of the parameters. Unless all parameters have a default value or have
parameter values assigned, the report processor must show the parameter
prompts.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
____________________________________________________________________________________________

Previous Posts In This Thread:

On Monday, January 04, 2010 8:57 AM
Gary wrote:

Passing parameters to a report URL
I am sending parameters to a report via URL but the report does not accept the
parameters and still shows the parameter prompt. I want to bypass the
parameter prompt and have the report automated. How do I accomplish this?

On Wednesday, January 06, 2010 1:52 PM
William Vaughn \(MVP\) wrote:

Let's see the RDL and the URL you are using to call it.
Let's see the RDL and the URL you are using to call it. Remember that the
parameters are case-sensitive. It does not sound like you are setting one or
more of the parameters. Unless all parameters have a default value or have
parameter values assigned, the report processor must show the parameter
prompts.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
____________________________________________________________________________________________

On Friday, January 08, 2010 9:47 AM
Gary wrote:

Sorry for the delay.http://ag-east-sql1/Reports/Pages/Report.aspx?
Sorry for the delay.

http://ag-east-sql1/Reports/Pages/Report.aspx?ItemPath=%2fLegReviewRS%2fReviewDetail

I found a site that shows the parameter part of the URL but it never passes
it to the report.

Do I need to suppress the parameter prompt on the report? (I thought I had
gotten this to work before).

SELECT dbo.LGReviews.LGRevID, dbo.LGReviews.LGRevBillSumm,
dbo.LGReviews.LGRevImpact, dbo.LGReviews.LGRevFiscImpact,
dbo.LGReviews.LGRevFiscDesc,
dbo.LGReviews.LGRevOverImpact, dbo.LGReviews.LGRevImplement,
dbo.LGReviews.LGRevOthAgency,
dbo.LGReviews.LGRevGroups,
dbo.LGReviews.LGRevComments, dbo.LGReviews.LGRevConstIss,
dbo.LGReviews.LGRevRegs,
dbo.LGReviews.LGRevCreated,
dbo.LGReviews.LGRevModified, dbo.LGMain.LGMainBillNum,
dbo.LGMain.LGMainTitle,
dbo.LGMain.LGMainSessionText, dbo.LGMain.LGMainNotes,
LGMain.LGMainCommittee
FROM dbo.LGReviews INNER JOIN
dbo.LGMain ON dbo.LGReviews.LGRevMainID =
dbo.LGMain.LGMainID
WHERE dbo.LGReviews.LGRevID = @RevID



"William Vaughn (MVP)" wrote:

On Friday, January 08, 2010 10:00 AM
Bruce L-C [MVP] wrote:

There are two websites. Reports and ReportServer.
There are two websites. Reports and ReportServer. Reports is the portal that
ships with Reporting Services. ReportServer is Reporting Services. When your
URL uses Reports no parameters are passed. To pass parameters you need to
use ReportServer. Look at books online under URL Access. There are lots and
lots of things you can do with this. You can choose to render as PDF or
Excel rather than html. You can hide toolbars. But you can leave all this to
use the defaults and just deal with the parameters. From books on line:
Another way to run a parameterized report is through a URL. You can specify
one or more parameters in encoded name-value pairs, using the ampersand
character (&) to separate them.

Null parameters use special syntax; you must specify isnull for a null
value. If you specify a null value for a parameter, all other values
specified for that same parameter are ignored. The following example
illustrates multiple parameters for null and constant values:

http://exampleWebServerName/reportserver?/foldercontainingreports/orders&division=mailorder&region=west&sales:isnull=true

Parameters with multiple values are specified by repeating the parameter
name. For example:

http://exampleWebServerName/reportserver?/foldercontainingreports/orders&region=east&region=west

Boolean parameters are specified with a value of 0 or 1.

Float parameters must include the decimal separator of the server locale.

DateTime parameters must be specified with the format YYYY-MM-DDTHH:MM:SS,
which is based on the International Organization for Standardization (ISO)
8601 standard. For more information about setting parameters on a URL, see
Using URL Access Parameters.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

On Thursday, February 04, 2010 10:09 AM
Gary wrote:

I must have overlooked this. Thanks!"Bruce L-C [MVP]" wrote:
I must have overlooked this. Thanks!

"Bruce L-C [MVP]" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
BizTalk: Incorporating conditional If / Else Functoid Logic in a map.
http://www.eggheadcafe.com/tutorials/aspnet/f6fc20ab-5c6a-4f04-8a0b-bba39e4bbcf0/biztalk-incorporating-co.aspx
 | 
Pages: 1
Prev: Row totals?
Next: Reporting Services 2005 Item Security Issue