Qualifier in URL Access not working

Hi,

When I export to CSV using URL Access, it doesn't include the default Qualifier ("). Even when I tried to use Qualifier=" or some other value, it doesn't include the qualifier in the output CSV file.

Any idea?

Thanks in advance.

Mouli
What version of Reporting Services are you using?

-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.|||

You probably need to add rc: before Qualifier to make it work.

Your URL would look something like:

/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier" href="http://links.10026.com/?link=http:///reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier">http://<server>/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier="

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

I'm trying to get the "-text qualifier to work as well in CSV exports, but without any luck. Are there any other conditions which should be met for text columns to get exported within quotes?

Regards, Jeroen

|||

What does the URL you're specifying look like?

-Lukasz

Qualifier in URL Access not working

Hi,

When I export to CSV using URL Access, it doesn't include the default Qualifier ("). Even when I tried to use Qualifier=" or some other value, it doesn't include the qualifier in the output CSV file.

Any idea?

Thanks in advance.

Mouli
What version of Reporting Services are you using?

-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.|||

You probably need to add rc: before Qualifier to make it work.

Your URL would look something like:

/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier" href="http://links.10026.com/?link=http:///reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier">http://<server>/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier="

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

I'm trying to get the "-text qualifier to work as well in CSV exports, but without any luck. Are there any other conditions which should be met for text columns to get exported within quotes?

Regards, Jeroen

|||

What does the URL you're specifying look like?

-Lukasz

Qualifier in URL Access not working

Hi,

When I export to CSV using URL Access, it doesn't include the default Qualifier ("). Even when I tried to use Qualifier=" or some other value, it doesn't include the qualifier in the output CSV file.

Any idea?

Thanks in advance.

Mouli
What version of Reporting Services are you using?

-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.|||

You probably need to add rc: before Qualifier to make it work.

Your URL would look something like:

/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier" href="http://links.10026.com/?link=http:///reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier">http://<server>/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier="

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

I'm trying to get the "-text qualifier to work as well in CSV exports, but without any luck. Are there any other conditions which should be met for text columns to get exported within quotes?

Regards, Jeroen

|||

What does the URL you're specifying look like?

-Lukasz

Qualifier in URL Access not working

Hi,

When I export to CSV using URL Access, it doesn't include the default Qualifier ("). Even when I tried to use Qualifier=" or some other value, it doesn't include the qualifier in the output CSV file.

Any idea?

Thanks in advance.

Mouli
What version of Reporting Services are you using?

-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.|||

You probably need to add rc: before Qualifier to make it work.

Your URL would look something like:

/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier" href="http://links.10026.com/?link=http:///reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier">http://<server>/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier="

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

I'm trying to get the "-text qualifier to work as well in CSV exports, but without any luck. Are there any other conditions which should be met for text columns to get exported within quotes?

Regards, Jeroen

|||

What does the URL you're specifying look like?

-Lukasz

Qualified table name syntax

Im trying to write a generic data access layer that supports SQL CE and Im wondering if any type of schema qualifier can be placed in front of a table name when executing a sql statement.

I've tried soemthing like this

select * from dbo.Account

I get this error,

The table name is not valid. [ Token line number (if known) = 1,Token line offset (if known) = 19,Table name = account ]

It doesnt make really make sense to include a qualifier for sql ce but I just wanted to make sure that there wasnt some other syntax that I wasnt aware of.

Thanks.

Nope, as I describe in the book, the SQL engine for "SQL Server" Compact Edition is not SQL Server--it uses a subset so the concept of "ownership" or "schemas" does not exist--it simply confuses the little engine. See www.hitchhikerguides.net FMI.|||thanks for confirming my thoughts. I'll check out the guide.