Little problem

I'm trying to render a report inside an iframe, just setting the src
attribute of the iframe to the report url. When the report needs no
parameters, this works just fine, but if it needs parameters, the
report viewer will keep asking for them, although I used
rc:Paremeters=False in the url. If I paste the url I'm using in ie or
firefox, the report will render fine and will use the paremeters
specified on the url itself, but that same url will never work inside
the iframe.
Any ideas?
Thanks in advance.> Any ideas?
I would try to pass null values for these parameters.
The syntax is :
ParameterName:isnull=true
Med Bouchenafa
"jman0" <jman0@.zapo.net> a écrit dans le message de news:
1135616400.317347.23290@.g49g2000cwa.googlegroups.com...
> I'm trying to render a report inside an iframe, just setting the src
> attribute of the iframe to the report url. When the report needs no
> parameters, this works just fine, but if it needs parameters, the
> report viewer will keep asking for them, although I used
> rc:Paremeters=False in the url. If I paste the url I'm using in ie or
> firefox, the report will render fine and will use the paremeters
> specified on the url itself, but that same url will never work inside
> the iframe.
>
> Thanks in advance.
>

List Attribute Names for Single Node

Hello,

I am trying to accomplish the following goal:

"For any given node in an xml variable, return via recordset a list of attributes."

Take the following query:

DECLARE @.x xml
SET @.x = '
<Item>
<Data Key="ID" Value="1001" />
<Data Key="Name" Value="Blue" />
<Data Key="Type" Value="Color" />
</Item>'

SELECT x.value('@.Key','varchar(255)') as [Key],
x.value('@.Value','varchar(255)') as [Value]
FROM @.x.nodes('//Item/Data') Data(x)

That will return:

Key | Value
-
ID | 1001
Name | Blue
Type | Color

What I want is to be able to query @.x ahead of time such that I get back something to the effect of:

Attribute

Key
Value

The reason is that I want to be able to build the columns of my SELECT statement dynamically by iterating through the attributes of a node. I would then execute my prepared statement to get that Key/Value recordset back.

Ignoring the structure of my example XML, what I'm returning in my Key/Value recordset, and how I'm going about returning it...all I want is to know whether or not I can get via recordset a list of attributes for an XML node, and if I can, how I do it.

Thanks!
Daniel

This is a bit clumsey, but should work.

WITH AllAttr(Vals)
AS
(SELECT @.x.query('<root>{for $a in /Item/Data/@.* return <attr>{$a}</attr>}</root>'))
SELECT DISTINCT
x.value('local-name(@.*[1])','varchar(255)') as [Attribute]
FROM AllAttr
CROSS APPLY Vals.nodes('/root/attr') Data(x)

|||

For any given node, for example <Data>, you do:

declare @.x xml
SET @.x = '
<Item>
<Data Key="ID" Value="1001" />
<Data Key="Name" Value="Blue" />
<Data Key="Type" Value="Color" />
</Item>'
select distinct x.value('local-name(.)', 'varchar(20)')
from @.x.nodes('//Data/@.*') as ref(x)