Can we create distinct values for document map on a particular level?

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question about document map on SQL Server 2005 Reporting Services. I found one problem with the values retrived for the document level. That is, the values are not distinct, they are duplicate for the document level. Is it possible for us to get the distinct values for a particular document level? Hope my question is clear for your help.

Thank you very much in advance for your help and advices. I am looking forward to hearing from you.

With best regards,

Yours sincerely,

Group your data in either the table or list (whatever you are using) and use document map for the group.

Shyam

|||

Hi, Shyam,

Thanks a lot for your kind advices.

Yes, jsut found out that cause I got more than one groups in my reports. And the document map level is not the first group there, so once I run the report, the document map on that level got duplicate values. Now it is clear.

Thank you very much.

With best regards,

Yours sincerely,

Can Visual Studio map SQL Server to XSD Schema?

I am creating an annual XML document to submit to a government agency. They have published an XSD Schema. Our data is in SQL Server 2000.

I need some way of associating columns from tables in SQL Server 2000 with the elements from the XSD schema to produce a valid XML document.

It looks like I could use XMLSpy or Stylus Studio, but I think there must be some way of doing it in Visual Studio 2005. Does Visual Studio 2005 have tools to help me do this? Can anyone direct me to a WebCast or part of the documentation that would dexplain I can do this?

(P.S. If you are curious, this is for the CDFI CIIS)

SQLXML has support for mapping between SQL Server and XSD using annotations in the XSD schema. There is no tool to visualize the mapping. Here is an overview of mapping schemas:

http://msdn2.microsoft.com/en-us/library/ms171870(SQL.90).aspx

This article is about SQLXML 4, but also applies to SQLXML 3 which is available on msdn:

http://www.microsoft.com/downloads/details.aspx?FamilyID=51D4A154-8E23-47D2-A033-764259CFB53B&displaylang=en

|||Thank you for your response-- I'll check out the links.

Can Visual Studio map SQL Server to XSD Schema?

I am creating an annual XML document to submit to a government agency. They have published an XSD Schema. Our data is in SQL Server 2000.

I need some way of associating columns from tables in SQL Server 2000 with the elements from the XSD schema to produce a valid XML document.

It looks like I could use XMLSpy or Stylus Studio, but I think there must be some way of doing it in Visual Studio 2005. Does Visual Studio 2005 have tools to help me do this? Can anyone direct me to a WebCast or part of the documentation that would dexplain I can do this?

(P.S. If you are curious, this is for the CDFI CIIS)

SQLXML has support for mapping between SQL Server and XSD using annotations in the XSD schema. There is no tool to visualize the mapping. Here is an overview of mapping schemas:

http://msdn2.microsoft.com/en-us/library/ms171870(SQL.90).aspx

This article is about SQLXML 4, but also applies to SQLXML 3 which is available on msdn:

http://www.microsoft.com/downloads/details.aspx?FamilyID=51D4A154-8E23-47D2-A033-764259CFB53B&displaylang=en

|||Thank you for your response-- I'll check out the links.

can not see the drive in the enterprise manager

Hi,
My drive D is not a map drive, i try to use the
command but still the same, i only can see c drive. In
the enterprise manager, i only can see c drive, i want to
make it to see other drive, can you help me?
regards,
florence
Hi
What type of drive is D? CD, Local hard drive, memory stick?
SQL will only present drives that are local hard drives or SAN connected
volumes.
Regards
Mike
"florencelee" wrote:

> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>
|||Check to ensure the SQL Server service account has permissions to the D
drive root folder.
Hope this helps.
Dan Guzman
SQL Server MVP
"florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:3c6c01c4af5a$fca75a40$a601280a@.phx.gbl...
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>

can not see the drive in the enterprise manager

Hi,
My drive D is not a map drive, i try to use the
command but still the same, i only can see c drive. In
the enterprise manager, i only can see c drive, i want to
make it to see other drive, can you help me?
regards,
florenceHi
What type of drive is D? CD, Local hard drive, memory stick?
SQL will only present drives that are local hard drives or SAN connected
volumes.
Regards
Mike
"florencelee" wrote:

> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>|||Check to ensure the SQL Server service account has permissions to the D
drive root folder.
Hope this helps.
Dan Guzman
SQL Server MVP
"florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:3c6c01c4af5a$fca75a40$a601280a@.phx.gbl...
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>

can not see the drive in the enterprise manager

Hi,
My drive D is not a map drive, i try to use the
command but still the same, i only can see c drive. In
the enterprise manager, i only can see c drive, i want to
make it to see other drive, can you help me?
regards,
florenceHi
What type of drive is D? CD, Local hard drive, memory stick?
SQL will only present drives that are local hard drives or SAN connected
volumes.
Regards
Mike
"florencelee" wrote:
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>|||Check to ensure the SQL Server service account has permissions to the D
drive root folder.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:3c6c01c4af5a$fca75a40$a601280a@.phx.gbl...
> Hi,
> My drive D is not a map drive, i try to use the
> command but still the same, i only can see c drive. In
> the enterprise manager, i only can see c drive, i want to
> make it to see other drive, can you help me?
> regards,
> florence
>