Multiple item selection from a queried report parameter list

I am trying to mirror a report originally published through another non MS
reporting application which allows multiple selection from a query parameter
list by use of the normal Windows 'Ctrl' or 'Shift' keys in cojunction with
the mouse click.
This method does not appear to function with SQL Reporting Services. The
expanded list automatically closes on selection of one item.
Is there another method of performing multiple selection from a list.This is something which needs to be added reporting services. You can NOT do
a multi selection... About the best thing you can do is allow your user to
enter a delimited list... It's really a good option, but about the only
option right now...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"RW" <RW@.discussions.microsoft.com> wrote in message
news:63B4D8FB-A36B-485B-B251-9D07D810A513@.microsoft.com...
> I am trying to mirror a report originally published through another non MS
> reporting application which allows multiple selection from a query
parameter
> list by use of the normal Windows 'Ctrl' or 'Shift' keys in cojunction
with
> the mouse click.
> This method does not appear to function with SQL Reporting Services. The
> expanded list automatically closes on selection of one item.
> Is there another method of performing multiple selection from a list.

multiple instances of Reporting Services - is it possible?

Hi there,

is it possible to host multiple Reporting-Webs and Reporting-Databases on a single Server?
What I want is to create two virtual directories

http://myserver/reports
http://myserver/reports_internal

and each web points to a different Database with different reports.

Best regards
Markus

Yes, this is supported and should work fine.|||

It would be very helpfull if you could tell me how this work!

Thanks
Markus

multiple instances of reporting server?

can you have multiple instances of reporting server on the same server like
you can with sql server?Yes very much you can have multiple instances of Reporting Server.
Amarnath
"Smokey Grindle" wrote:
> can you have multiple instances of reporting server on the same server like
> you can with sql server?
>
>|||When you install RS you need to give the sql server name / instance. so it
keeps a seperate copy for each instance. Since RS stores all the info in
tables, so it requires sql server database and ofcourse instances seperate so
that RS creates report server and report server tempdb in different
instances. So all the instance will be different and acts as if it is
installed on a seperate machine.
Amarnath
"JackOfAllMasterOfNone" wrote:
> OK, so what are the mechanics for installing multiple independant instances of SSRS on a single server?
> Can it be done with some form of side-by-side libraries, such that each instance has its very own set of scripts, DLL's, CSS, etc?
> I'm thinking about consolidation of test environments onto a single server, but each SSRS instance would have to be entirely independant of the others.
> EggHeadCafe.com - .NET Developer Portal of Choice
> http://www.eggheadcafe.com
>

Multiple Filters in an AD HOC report.

There are many business users in my office who would like an AD HOC reporting
system. I am not in a position to install the reporting server right now
suite and check it out myself. I have seen some presentations and i like the
tool for the most part ...I have some questions if anyone can help...
1. Can the users select two tables for a report and manually specify the
join column between the two.
2. Can the user specify more than one condition in the filter. Like Name = X AND Address = Y AND Job = Z where Name, Address, Job can be columns from
more than 1 table
3. Can the users sort on more than one column ?
4. Can the users group by on more than one column. Nested grouping ?Your users can create their own reports using "Report Builder" provided you
create some report model. Nothing complicated Report Model is basically
imangine as a view with all the tables joined together.
Now all the 4 questions the answer is "YES" and it is possible.
Amarnath
"Tk_Neo" wrote:
> There are many business users in my office who would like an AD HOC reporting
> system. I am not in a position to install the reporting server right now
> suite and check it out myself. I have seen some presentations and i like the
> tool for the most part ...I have some questions if anyone can help...
> 1. Can the users select two tables for a report and manually specify the
> join column between the two.
> 2. Can the user specify more than one condition in the filter. Like Name => X AND Address = Y AND Job = Z where Name, Address, Job can be columns from
> more than 1 table
> 3. Can the users sort on more than one column ?
> 4. Can the users group by on more than one column. Nested grouping ?

Multiple Databases accessed by Multiple reports by Multiple users...?

Hello All,
I am somewhat new to MS Reporting Services and I've got a situation
where I have different users needing to access the same report (rdl)
but from different databases?
Ideally I would want to have each report pointing to all databases
dynamically.
Do you know how I would go about setting this up? Multiple reports
pointing to different datasources? Passing a parameter which
determines a specific datasource? - Is it even possible to pass a
parameter to the report to determine which data source to use?
Thanks for your help in advance
MagAre you using RS 2000 or RS 2005? In RS 2005 you can use data source
expressions (search books online under expressions, data sources). If RS
2000 it is much harder and a total pain and I strongly suggest going to RS
2005.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mag" <mestafanos@.gmail.com> wrote in message
news:1137700476.286569.181810@.g14g2000cwa.googlegroups.com...
> Hello All,
> I am somewhat new to MS Reporting Services and I've got a situation
> where I have different users needing to access the same report (rdl)
> but from different databases?
> Ideally I would want to have each report pointing to all databases
> dynamically.
> Do you know how I would go about setting this up? Multiple reports
> pointing to different datasources? Passing a parameter which
> determines a specific datasource? - Is it even possible to pass a
> parameter to the report to determine which data source to use?
> Thanks for your help in advance
> Mag
>

Multiple Databases

Is possible to pull data from multiple databases into one report within
Reporting Services 2000? What about RS 2005?No problem at all. Just create a new data source for each database, and
create your datasets based on the different data sources. It might be a bit
more tricky to join data from different databases in the same dataset. But
then you can create a stored procedure in one of the databases, and create
your query just as you would normally do between databases, and reference
your stored procedure in the RS Report. Goes for both RS 2000 and 2005.
Kaisa
"David" <dilworth@.newsgroups.nospam> wrote in message
news:0049509F-B71D-4DEE-9984-1544D9F3E7A0@.microsoft.com...
> Is possible to pull data from multiple databases into one report within
> Reporting Services 2000? What about RS 2005?|||Also, read up on sub reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <dilworth@.newsgroups.nospam> wrote in message
news:0049509F-B71D-4DEE-9984-1544D9F3E7A0@.microsoft.com...
> Is possible to pull data from multiple databases into one report within
> Reporting Services 2000? What about RS 2005?|||David,
The only limit that I know is that reporting services 2000 (Dont know
aboout 2005), is that you can't use 2 data sets for 1 table - so you
cant MERGE data into 1 table.
So I would recommend either creating a store procedure as suggested by
Kaisa that would get data from different databases.
If you want the data in two different tables, then YES you can use 2
tables, or a subreport as suggested by Bruce.
Regards,
Stas K.|||Still true in RS 2005.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1136556065.510433.278670@.g49g2000cwa.googlegroups.com...
> David,
> The only limit that I know is that reporting services 2000 (Dont know
> aboout 2005), is that you can't use 2 data sets for 1 table - so you
> cant MERGE data into 1 table.
> So I would recommend either creating a store procedure as suggested by
> Kaisa that would get data from different databases.
> If you want the data in two different tables, then YES you can use 2
> tables, or a subreport as suggested by Bruce.
> Regards,
> Stas K.
>|||Is it possible to collect data from multiple databases in a report model also?
I'd like to define a data source view made up of three data sources, and it
works well, but when it comes to generating the report model, it seems to me
that only the primary data source is availible for the report model. Is this
true? If so it's a real showstopper for me. The solutions I see for this
problem is:
1. Views to the other databases
2. Building a ssas cube to overcome the limitations
Please help me out!
"Bruce L-C [MVP]" wrote:
> Still true in RS 2005.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Sorcerdon" <sorcerdon@.gmail.com> wrote in message
> news:1136556065.510433.278670@.g49g2000cwa.googlegroups.com...
> > David,
> >
> > The only limit that I know is that reporting services 2000 (Dont know
> > aboout 2005), is that you can't use 2 data sets for 1 table - so you
> > cant MERGE data into 1 table.
> > So I would recommend either creating a store procedure as suggested by
> > Kaisa that would get data from different databases.
> >
> > If you want the data in two different tables, then YES you can use 2
> > tables, or a subreport as suggested by Bruce.
> >
> > Regards,
> >
> > Stas K.
> >
>
>|||Sorry, I don't use Report Model so I am not aware of what can or cannot be
done. However, I doubt that it would allow something that is not possible
from with RS Designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Erik Hedlund" <ErikHedlund@.discussions.microsoft.com> wrote in message
news:7EDBEB3A-BAE8-431E-AB03-B866C2C179E2@.microsoft.com...
> Is it possible to collect data from multiple databases in a report model
> also?
> I'd like to define a data source view made up of three data sources, and
> it
> works well, but when it comes to generating the report model, it seems to
> me
> that only the primary data source is availible for the report model. Is
> this
> true? If so it's a real showstopper for me. The solutions I see for this
> problem is:
> 1. Views to the other databases
> 2. Building a ssas cube to overcome the limitations
> Please help me out!
> "Bruce L-C [MVP]" wrote:
>> Still true in RS 2005.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Sorcerdon" <sorcerdon@.gmail.com> wrote in message
>> news:1136556065.510433.278670@.g49g2000cwa.googlegroups.com...
>> > David,
>> >
>> > The only limit that I know is that reporting services 2000 (Dont know
>> > aboout 2005), is that you can't use 2 data sets for 1 table - so you
>> > cant MERGE data into 1 table.
>> > So I would recommend either creating a store procedure as suggested by
>> > Kaisa that would get data from different databases.
>> >
>> > If you want the data in two different tables, then YES you can use 2
>> > tables, or a subreport as suggested by Bruce.
>> >
>> > Regards,
>> >
>> > Stas K.
>> >
>>|||Given that report models are based off a data source I would lean towards
"no" without some additional work. Looks like a cube may be your best bet
for gathering data like that.
"Erik Hedlund" <ErikHedlund@.discussions.microsoft.com> wrote in message
news:7EDBEB3A-BAE8-431E-AB03-B866C2C179E2@.microsoft.com...
> Is it possible to collect data from multiple databases in a report model
> also?
> I'd like to define a data source view made up of three data sources, and
> it
> works well, but when it comes to generating the report model, it seems to
> me
> that only the primary data source is availible for the report model. Is
> this
> true? If so it's a real showstopper for me. The solutions I see for this
> problem is:
> 1. Views to the other databases
> 2. Building a ssas cube to overcome the limitations
> Please help me out!
> "Bruce L-C [MVP]" wrote:
>> Still true in RS 2005.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Sorcerdon" <sorcerdon@.gmail.com> wrote in message
>> news:1136556065.510433.278670@.g49g2000cwa.googlegroups.com...
>> > David,
>> >
>> > The only limit that I know is that reporting services 2000 (Dont know
>> > aboout 2005), is that you can't use 2 data sets for 1 table - so you
>> > cant MERGE data into 1 table.
>> > So I would recommend either creating a store procedure as suggested by
>> > Kaisa that would get data from different databases.
>> >
>> > If you want the data in two different tables, then YES you can use 2
>> > tables, or a subreport as suggested by Bruce.
>> >
>> > Regards,
>> >
>> > Stas K.
>> >
>>|||Well, the report model is based upon a data source view, which is an
abstractionlayer on top of the data source(s). I the data source view it is
no problem to use tables from many data sources, but when it comes to the
report model, it seems to me that only the primary data source in the data
soure view is "in reach". I think that this is rather odd. Why should the
report model be concerned about what lies bellow the abstraction layer?
"Chris Taylor" wrote:
> Given that report models are based off a data source I would lean towards
> "no" without some additional work. Looks like a cube may be your best bet
> for gathering data like that.
>
> "Erik Hedlund" <ErikHedlund@.discussions.microsoft.com> wrote in message
> news:7EDBEB3A-BAE8-431E-AB03-B866C2C179E2@.microsoft.com...
> > Is it possible to collect data from multiple databases in a report model
> > also?
> >
> > I'd like to define a data source view made up of three data sources, and
> > it
> > works well, but when it comes to generating the report model, it seems to
> > me
> > that only the primary data source is availible for the report model. Is
> > this
> > true? If so it's a real showstopper for me. The solutions I see for this
> > problem is:
> > 1. Views to the other databases
> > 2. Building a ssas cube to overcome the limitations
> >
> > Please help me out!
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Still true in RS 2005.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Sorcerdon" <sorcerdon@.gmail.com> wrote in message
> >> news:1136556065.510433.278670@.g49g2000cwa.googlegroups.com...
> >> > David,
> >> >
> >> > The only limit that I know is that reporting services 2000 (Dont know
> >> > aboout 2005), is that you can't use 2 data sets for 1 table - so you
> >> > cant MERGE data into 1 table.
> >> > So I would recommend either creating a store procedure as suggested by
> >> > Kaisa that would get data from different databases.
> >> >
> >> > If you want the data in two different tables, then YES you can use 2
> >> > tables, or a subreport as suggested by Bruce.
> >> >
> >> > Regards,
> >> >
> >> > Stas K.
> >> >
> >>
> >>
> >>
>
>

Multiple database question

I am planning to develop reports using reporting services. My reports will use data from 3 different SQL Server databases that are application specific on three different cpu's. I'm planning on having a reporting database that is a common repository for data extraction / summarization from the other 3 databases.

I'm trying to understand the best way to approach my design (it's been a while since I've done database work - pretty obvious...):

Use Analysis Services to move the data from the three databases to the reporting database server.

Create some stored procedures that can do this.

I'm not seeing the reporting services as being a "data movement" tool but more of a shell data access tool (correct?).

Other tools someone would suggest.

Thanks and any help would be appreciated.You could also look at replication,DTS, and even log shipping.|||Hi there,

If your (or some) reports need to COMBINE the data from the three databases, you definitely need a common data access like you mentionned. But if you have "Report A" that needs the data from "Database A" and "Report B" from "Database B", that's a breeze.

Each report has it's own datasource setup. That's it!|||tootoo, there's nothing wrong with your solution. However, the snapshot approach might be needed as reporting can sometimes crucify the perf of a database.

multiple customers on the same reporting server.

Hi,
I think this is a question for the specialists among us.
Can I use one general reporting server (installed on instance
MAINREPORTING)
for multiple customers who all have their own sql instance (CUST1,
CUST2, CUST3, ..)
I would user UserAuthenciation on the reportserver url to display the
reports specific customers
can use.
Is this possible, and what do i have to take care off concerning
installation and/or configuration (especially on
the reporting side).
Greetings
VinnieWhat you want to do is have your data source based on an expression. The
problem with this is that you have to design all your reports this way and
the data source cannot be a shared data source.
But, if you do design your reports this way you can have the expression be
based on the user (global variable User!UserID).
You would need a table somewhere mapping a user to a database, query that
table and use the result for the expression that the data source is based
on.
This all works only for RS 2005 (not RS 2000).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vinnie" <vsempoux@.gmail.com> wrote in message
news:7b3fec53-bb60-4ad9-b8d3-81d9021f1831@.e4g2000hsg.googlegroups.com...
> Hi,
> I think this is a question for the specialists among us.
> Can I use one general reporting server (installed on instance
> MAINREPORTING)
> for multiple customers who all have their own sql instance (CUST1,
> CUST2, CUST3, ..)
> I would user UserAuthenciation on the reportserver url to display the
> reports specific customers
> can use.
> Is this possible, and what do i have to take care off concerning
> installation and/or configuration (especially on
> the reporting side).
> Greetings
> Vinnie

multiple connects to database

How does reporting services handle connection strings. There is a single report using a shared datasource. Testing this report seems to generate multiple connections to the database for a single user. The report being tested has 4 datasets (3 to obtain parameter value lists) using the same shared datasource but the number of connections for the single user were 20 in one instance. When does reporting services make the connection and when does it release it? It didnt seem to let these go when the report was done executing. Using RS2005 sp1 with DB2The Report Server processes the dataset queries in parallel whenever possible. This is why you see three connections open when you run a report with multiple datasets. Not sure why the number of connections jump to 20. Does the DB2 provider support connection pooling?

Multi-Parameter select problem with Oracle Database

We use Oracle database and SQL server 2005 Reporting
service Beta2. I made a simple SQL report using query:
select sum(spend)
from travel_cost
where department in (:p_dept)
I set parameter p_dept to be Multi-value: dept1 and
dept2. When I run report, if I only select dept1 or
dept2, it works fine. But when I select both or Select
All, I will get a error message:
An error has occurred during report processing. Query
execution failed for data set 'DataSet1'. ORA-12704:
Character set missmatch.
Please help.
Frank
.Is this the September CTP? June CTP? I'm not sure what beta 2 is, when did
it come out?
If it is not the September CTP then that is the issue. Get the September CTP
and try again.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Frank" <Frank@.discussions.microsoft.com> wrote in message
news:45D08B41-3791-4B9B-8C25-903F0DEC1CF4@.microsoft.com...
> We use Oracle database and SQL server 2005 Reporting
> service Beta2. I made a simple SQL report using query:
> select sum(spend)
> from travel_cost
> where department in (:p_dept)
> I set parameter p_dept to be Multi-value: dept1 and
> dept2. When I run report, if I only select dept1 or
> dept2, it works fine. But when I select both or Select
> All, I will get a error message:
> An error has occurred during report processing. Query
> execution failed for data set 'DataSet1'. ORA-12704:
> Character set missmatch.
> Please help.
> Frank
> .
>|||Is the Department column defined as NVarchar2?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank" <Frank@.discussions.microsoft.com> wrote in message
news:45D08B41-3791-4B9B-8C25-903F0DEC1CF4@.microsoft.com...
> We use Oracle database and SQL server 2005 Reporting
> service Beta2. I made a simple SQL report using query:
> select sum(spend)
> from travel_cost
> where department in (:p_dept)
> I set parameter p_dept to be Multi-value: dept1 and
> dept2. When I run report, if I only select dept1 or
> dept2, it works fine. But when I select both or Select
> All, I will get a error message:
> An error has occurred during report processing. Query
> execution failed for data set 'DataSet1'. ORA-12704:
> Character set missmatch.
> Please help.
> Frank
> .
>|||Actually, what is the data source type you are using? Are you using "Oracle"
(i.e. the MS managed provider for Oracle)?
What version of the Oracle client and what version of Oracle server are you
connecting?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%237VyvMxvFHA.1648@.TK2MSFTNGP10.phx.gbl...
> Is the Department column defined as NVarchar2?
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Frank" <Frank@.discussions.microsoft.com> wrote in message
> news:45D08B41-3791-4B9B-8C25-903F0DEC1CF4@.microsoft.com...
>> We use Oracle database and SQL server 2005 Reporting
>> service Beta2. I made a simple SQL report using query:
>> select sum(spend)
>> from travel_cost
>> where department in (:p_dept)
>> I set parameter p_dept to be Multi-value: dept1 and
>> dept2. When I run report, if I only select dept1 or
>> dept2, it works fine. But when I select both or Select
>> All, I will get a error message:
>> An error has occurred during report processing. Query
>> execution failed for data set 'DataSet1'. ORA-12704:
>> Character set missmatch.
>> Please help.
>> Frank
>> .
>>
>|||1. I just updated SQL Server Beta 2 from June version to September version.
Error message are same.
2. Our Oracle database is 8.1.7.4.0. All character fields are varchar2
and number fields are number.
3. I can get report data when I select one parameter. So it is not
character or Oracle database connection problem. I think it is Multi-Value
select function problem with Oracle database application.
Thanks
Frank
"Robert Bruckner [MSFT]" wrote:
> Actually, what is the data source type you are using? Are you using "Oracle"
> (i.e. the MS managed provider for Oracle)?
> What version of the Oracle client and what version of Oracle server are you
> connecting?
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:%237VyvMxvFHA.1648@.TK2MSFTNGP10.phx.gbl...
> > Is the Department column defined as NVarchar2?
> >
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
> >
> > "Frank" <Frank@.discussions.microsoft.com> wrote in message
> > news:45D08B41-3791-4B9B-8C25-903F0DEC1CF4@.microsoft.com...
> >>
> >> We use Oracle database and SQL server 2005 Reporting
> >> service Beta2. I made a simple SQL report using query:
> >>
> >> select sum(spend)
> >> from travel_cost
> >> where department in (:p_dept)
> >>
> >> I set parameter p_dept to be Multi-value: dept1 and
> >> dept2. When I run report, if I only select dept1 or
> >> dept2, it works fine. But when I select both or Select
> >> All, I will get a error message:
> >>
> >> An error has occurred during report processing. Query
> >> execution failed for data set 'DataSet1'. ORA-12704:
> >> Character set missmatch.
> >>
> >> Please help.
> >>
> >> Frank
> >>
> >> .
> >>
> >>
> >
> >
>
>|||Dear Robert:
1. When I set Datasource, I select Type 'Oracle'.
2. Client site, Oracle Net 8 version is 8.1.7. Oracle server version is
8.1.7.4.0.
3. Before I used June CTP software. I download September CTP software
SQLSTD.exe and run installing on the same computer. I don't remove June
version and install to default folder SQLSTD. No any error occurs. When I
run same report and get same error. How do I check the the June version has
been replaced by September version?
Thanks,
Frank
"Robert Bruckner [MSFT]" wrote:
> Actually, what is the data source type you are using? Are you using "Oracle"
> (i.e. the MS managed provider for Oracle)?
> What version of the Oracle client and what version of Oracle server are you
> connecting?
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:%237VyvMxvFHA.1648@.TK2MSFTNGP10.phx.gbl...
> > Is the Department column defined as NVarchar2?
> >
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
> >
> > "Frank" <Frank@.discussions.microsoft.com> wrote in message
> > news:45D08B41-3791-4B9B-8C25-903F0DEC1CF4@.microsoft.com...
> >>
> >> We use Oracle database and SQL server 2005 Reporting
> >> service Beta2. I made a simple SQL report using query:
> >>
> >> select sum(spend)
> >> from travel_cost
> >> where department in (:p_dept)
> >>
> >> I set parameter p_dept to be Multi-value: dept1 and
> >> dept2. When I run report, if I only select dept1 or
> >> dept2, it works fine. But when I select both or Select
> >> All, I will get a error message:
> >>
> >> An error has occurred during report processing. Query
> >> execution failed for data set 'DataSet1'. ORA-12704:
> >> Character set missmatch.
> >>
> >> Please help.
> >>
> >> Frank
> >>
> >> .
> >>
> >>
> >
> >
>
>|||The instructions said to remove everything before installing the CTP. This
means the beta for the dotnet framework as well as the rest of teh June CTP.
I would not trust any problem found unless you do this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Frank" <Frank@.discussions.microsoft.com> wrote in message
news:CDE79054-C9CF-4DA0-B2CD-892024B5D347@.microsoft.com...
> Dear Robert:
> 1. When I set Datasource, I select Type 'Oracle'.
> 2. Client site, Oracle Net 8 version is 8.1.7. Oracle server version is
> 8.1.7.4.0.
> 3. Before I used June CTP software. I download September CTP software
> SQLSTD.exe and run installing on the same computer. I don't remove June
> version and install to default folder SQLSTD. No any error occurs. When
> I
> run same report and get same error. How do I check the the June version
> has
> been replaced by September version?
> Thanks,
> Frank
> "Robert Bruckner [MSFT]" wrote:
>> Actually, what is the data source type you are using? Are you using
>> "Oracle"
>> (i.e. the MS managed provider for Oracle)?
>> What version of the Oracle client and what version of Oracle server are
>> you
>> connecting?
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:%237VyvMxvFHA.1648@.TK2MSFTNGP10.phx.gbl...
>> > Is the Department column defined as NVarchar2?
>> >
>> >
>> > -- Robert
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> >
>> >
>> > "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> > news:45D08B41-3791-4B9B-8C25-903F0DEC1CF4@.microsoft.com...
>> >>
>> >> We use Oracle database and SQL server 2005 Reporting
>> >> service Beta2. I made a simple SQL report using query:
>> >>
>> >> select sum(spend)
>> >> from travel_cost
>> >> where department in (:p_dept)
>> >>
>> >> I set parameter p_dept to be Multi-value: dept1 and
>> >> dept2. When I run report, if I only select dept1 or
>> >> dept2, it works fine. But when I select both or Select
>> >> All, I will get a error message:
>> >>
>> >> An error has occurred during report processing. Query
>> >> execution failed for data set 'DataSet1'. ORA-12704:
>> >> Character set missmatch.
>> >>
>> >> Please help.
>> >>
>> >> Frank
>> >>
>> >> .
>> >>
>> >>
>> >
>> >
>>|||Dear Bruce:
I removed all June CTP using control pannel add/remove tool include
Microfoft.net Framework 1.1 and Microsoft.net Deta 2. Then delete folder
SQLSTD and Program Files\Microsoft SQL Server. Then rerun SQLSTD.exe and
install SQL SERVER and Reporting service. But when I run Microsoft Visual
Studio 2005, my report is already here and the errors are same.
Please advice
Thanks
Frank
"Bruce L-C [MVP]" wrote:
> The instructions said to remove everything before installing the CTP. This
> means the beta for the dotnet framework as well as the rest of teh June CTP.
> I would not trust any problem found unless you do this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Frank" <Frank@.discussions.microsoft.com> wrote in message
> news:CDE79054-C9CF-4DA0-B2CD-892024B5D347@.microsoft.com...
> > Dear Robert:
> > 1. When I set Datasource, I select Type 'Oracle'.
> > 2. Client site, Oracle Net 8 version is 8.1.7. Oracle server version is
> > 8.1.7.4.0.
> > 3. Before I used June CTP software. I download September CTP software
> > SQLSTD.exe and run installing on the same computer. I don't remove June
> > version and install to default folder SQLSTD. No any error occurs. When
> > I
> > run same report and get same error. How do I check the the June version
> > has
> > been replaced by September version?
> > Thanks,
> > Frank
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> >> Actually, what is the data source type you are using? Are you using
> >> "Oracle"
> >> (i.e. the MS managed provider for Oracle)?
> >> What version of the Oracle client and what version of Oracle server are
> >> you
> >> connecting?
> >>
> >> -- Robert
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> >> news:%237VyvMxvFHA.1648@.TK2MSFTNGP10.phx.gbl...
> >> > Is the Department column defined as NVarchar2?
> >> >
> >> >
> >> > -- Robert
> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> >
> >> >
> >> >
> >> > "Frank" <Frank@.discussions.microsoft.com> wrote in message
> >> > news:45D08B41-3791-4B9B-8C25-903F0DEC1CF4@.microsoft.com...
> >> >>
> >> >> We use Oracle database and SQL server 2005 Reporting
> >> >> service Beta2. I made a simple SQL report using query:
> >> >>
> >> >> select sum(spend)
> >> >> from travel_cost
> >> >> where department in (:p_dept)
> >> >>
> >> >> I set parameter p_dept to be Multi-value: dept1 and
> >> >> dept2. When I run report, if I only select dept1 or
> >> >> dept2, it works fine. But when I select both or Select
> >> >> All, I will get a error message:
> >> >>
> >> >> An error has occurred during report processing. Query
> >> >> execution failed for data set 'DataSet1'. ORA-12704:
> >> >> Character set missmatch.
> >> >>
> >> >> Please help.
> >> >>
> >> >> Frank
> >> >>
> >> >> .
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >>
>
>|||The instructions say to remove the framework 2.0 beta, VS 2005, SQL Server
2005 june ctp. They all share the framework beta and that is why everything
needs to be gone prior to upgrading. I'm not saying that your problem won't
still be there, just that this was what the instructions said to do. Read
the file that comes with the Sept CTP.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Frank" <Frank@.discussions.microsoft.com> wrote in message
news:B8294B8E-F15F-419C-8B5E-32FF43A4CD3A@.microsoft.com...
> Dear Bruce:
> I removed all June CTP using control pannel add/remove tool include
> Microfoft.net Framework 1.1 and Microsoft.net Deta 2. Then delete folder
> SQLSTD and Program Files\Microsoft SQL Server. Then rerun SQLSTD.exe and
> install SQL SERVER and Reporting service. But when I run Microsoft Visual
> Studio 2005, my report is already here and the errors are same.
> Please advice
> Thanks
> Frank
> "Bruce L-C [MVP]" wrote:
>> The instructions said to remove everything before installing the CTP.
>> This
>> means the beta for the dotnet framework as well as the rest of teh June
>> CTP.
>> I would not trust any problem found unless you do this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> news:CDE79054-C9CF-4DA0-B2CD-892024B5D347@.microsoft.com...
>> > Dear Robert:
>> > 1. When I set Datasource, I select Type 'Oracle'.
>> > 2. Client site, Oracle Net 8 version is 8.1.7. Oracle server version
>> > is
>> > 8.1.7.4.0.
>> > 3. Before I used June CTP software. I download September CTP software
>> > SQLSTD.exe and run installing on the same computer. I don't remove
>> > June
>> > version and install to default folder SQLSTD. No any error occurs.
>> > When
>> > I
>> > run same report and get same error. How do I check the the June
>> > version
>> > has
>> > been replaced by September version?
>> > Thanks,
>> > Frank
>> >
>> > "Robert Bruckner [MSFT]" wrote:
>> >
>> >> Actually, what is the data source type you are using? Are you using
>> >> "Oracle"
>> >> (i.e. the MS managed provider for Oracle)?
>> >> What version of the Oracle client and what version of Oracle server
>> >> are
>> >> you
>> >> connecting?
>> >>
>> >> -- Robert
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
>> >> message
>> >> news:%237VyvMxvFHA.1648@.TK2MSFTNGP10.phx.gbl...
>> >> > Is the Department column defined as NVarchar2?
>> >> >
>> >> >
>> >> > -- Robert
>> >> > This posting is provided "AS IS" with no warranties, and confers no
>> >> > rights.
>> >> >
>> >> >
>> >> >
>> >> > "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> >> > news:45D08B41-3791-4B9B-8C25-903F0DEC1CF4@.microsoft.com...
>> >> >>
>> >> >> We use Oracle database and SQL server 2005 Reporting
>> >> >> service Beta2. I made a simple SQL report using query:
>> >> >>
>> >> >> select sum(spend)
>> >> >> from travel_cost
>> >> >> where department in (:p_dept)
>> >> >>
>> >> >> I set parameter p_dept to be Multi-value: dept1 and
>> >> >> dept2. When I run report, if I only select dept1 or
>> >> >> dept2, it works fine. But when I select both or Select
>> >> >> All, I will get a error message:
>> >> >>
>> >> >> An error has occurred during report processing. Query
>> >> >> execution failed for data set 'DataSet1'. ORA-12704:
>> >> >> Character set missmatch.
>> >> >>
>> >> >> Please help.
>> >> >>
>> >> >> Frank
>> >> >>
>> >> >> .
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||I remove all SQL server program and Microsoft Visual Studio and Microsoft
framework.net program. Physical delete program files\Miscosoft SQL Server,
Microsoft Visual Studio 8 and Miscrosoft Visual Studio and Miscrosoft.net
folders. Even I delete my report file folder. Then re-install SQL Server
2005 September CTP. Re-create the simple report, but I get same error when I
select multi parameters.
Thanks
Frank
"Bruce L-C [MVP]" wrote:
> The instructions say to remove the framework 2.0 beta, VS 2005, SQL Server
> 2005 june ctp. They all share the framework beta and that is why everything
> needs to be gone prior to upgrading. I'm not saying that your problem won't
> still be there, just that this was what the instructions said to do. Read
> the file that comes with the Sept CTP.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Frank" <Frank@.discussions.microsoft.com> wrote in message
> news:B8294B8E-F15F-419C-8B5E-32FF43A4CD3A@.microsoft.com...
> > Dear Bruce:
> >
> > I removed all June CTP using control pannel add/remove tool include
> > Microfoft.net Framework 1.1 and Microsoft.net Deta 2. Then delete folder
> > SQLSTD and Program Files\Microsoft SQL Server. Then rerun SQLSTD.exe and
> > install SQL SERVER and Reporting service. But when I run Microsoft Visual
> > Studio 2005, my report is already here and the errors are same.
> >
> > Please advice
> >
> > Thanks
> > Frank
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> The instructions said to remove everything before installing the CTP.
> >> This
> >> means the beta for the dotnet framework as well as the rest of teh June
> >> CTP.
> >>
> >> I would not trust any problem found unless you do this.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Frank" <Frank@.discussions.microsoft.com> wrote in message
> >> news:CDE79054-C9CF-4DA0-B2CD-892024B5D347@.microsoft.com...
> >> > Dear Robert:
> >> > 1. When I set Datasource, I select Type 'Oracle'.
> >> > 2. Client site, Oracle Net 8 version is 8.1.7. Oracle server version
> >> > is
> >> > 8.1.7.4.0.
> >> > 3. Before I used June CTP software. I download September CTP software
> >> > SQLSTD.exe and run installing on the same computer. I don't remove
> >> > June
> >> > version and install to default folder SQLSTD. No any error occurs.
> >> > When
> >> > I
> >> > run same report and get same error. How do I check the the June
> >> > version
> >> > has
> >> > been replaced by September version?
> >> > Thanks,
> >> > Frank
> >> >
> >> > "Robert Bruckner [MSFT]" wrote:
> >> >
> >> >> Actually, what is the data source type you are using? Are you using
> >> >> "Oracle"
> >> >> (i.e. the MS managed provider for Oracle)?
> >> >> What version of the Oracle client and what version of Oracle server
> >> >> are
> >> >> you
> >> >> connecting?
> >> >>
> >> >> -- Robert
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
> >> >> message
> >> >> news:%237VyvMxvFHA.1648@.TK2MSFTNGP10.phx.gbl...
> >> >> > Is the Department column defined as NVarchar2?
> >> >> >
> >> >> >
> >> >> > -- Robert
> >> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> >> > rights.
> >> >> >
> >> >> >
> >> >> >
> >> >> > "Frank" <Frank@.discussions.microsoft.com> wrote in message
> >> >> > news:45D08B41-3791-4B9B-8C25-903F0DEC1CF4@.microsoft.com...
> >> >> >>
> >> >> >> We use Oracle database and SQL server 2005 Reporting
> >> >> >> service Beta2. I made a simple SQL report using query:
> >> >> >>
> >> >> >> select sum(spend)
> >> >> >> from travel_cost
> >> >> >> where department in (:p_dept)
> >> >> >>
> >> >> >> I set parameter p_dept to be Multi-value: dept1 and
> >> >> >> dept2. When I run report, if I only select dept1 or
> >> >> >> dept2, it works fine. But when I select both or Select
> >> >> >> All, I will get a error message:
> >> >> >>
> >> >> >> An error has occurred during report processing. Query
> >> >> >> execution failed for data set 'DataSet1'. ORA-12704:
> >> >> >> Character set missmatch.
> >> >> >>
> >> >> >> Please help.
> >> >> >>
> >> >> >> Frank
> >> >> >>
> >> >> >> .
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I'll get it posted as a bug.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Frank" <Frank@.discussions.microsoft.com> wrote in message
news:5801832D-79C4-4F52-AAC9-F49E9FC65C5A@.microsoft.com...
>I remove all SQL server program and Microsoft Visual Studio and Microsoft
> framework.net program. Physical delete program files\Miscosoft SQL
> Server,
> Microsoft Visual Studio 8 and Miscrosoft Visual Studio and Miscrosoft.net
> folders. Even I delete my report file folder. Then re-install SQL Server
> 2005 September CTP. Re-create the simple report, but I get same error
> when I
> select multi parameters.
> Thanks
> Frank
> "Bruce L-C [MVP]" wrote:
>> The instructions say to remove the framework 2.0 beta, VS 2005, SQL
>> Server
>> 2005 june ctp. They all share the framework beta and that is why
>> everything
>> needs to be gone prior to upgrading. I'm not saying that your problem
>> won't
>> still be there, just that this was what the instructions said to do. Read
>> the file that comes with the Sept CTP.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> news:B8294B8E-F15F-419C-8B5E-32FF43A4CD3A@.microsoft.com...
>> > Dear Bruce:
>> >
>> > I removed all June CTP using control pannel add/remove tool include
>> > Microfoft.net Framework 1.1 and Microsoft.net Deta 2. Then delete
>> > folder
>> > SQLSTD and Program Files\Microsoft SQL Server. Then rerun SQLSTD.exe
>> > and
>> > install SQL SERVER and Reporting service. But when I run Microsoft
>> > Visual
>> > Studio 2005, my report is already here and the errors are same.
>> >
>> > Please advice
>> >
>> > Thanks
>> > Frank
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> The instructions said to remove everything before installing the CTP.
>> >> This
>> >> means the beta for the dotnet framework as well as the rest of teh
>> >> June
>> >> CTP.
>> >>
>> >> I would not trust any problem found unless you do this.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> >> news:CDE79054-C9CF-4DA0-B2CD-892024B5D347@.microsoft.com...
>> >> > Dear Robert:
>> >> > 1. When I set Datasource, I select Type 'Oracle'.
>> >> > 2. Client site, Oracle Net 8 version is 8.1.7. Oracle server
>> >> > version
>> >> > is
>> >> > 8.1.7.4.0.
>> >> > 3. Before I used June CTP software. I download September CTP
>> >> > software
>> >> > SQLSTD.exe and run installing on the same computer. I don't remove
>> >> > June
>> >> > version and install to default folder SQLSTD. No any error occurs.
>> >> > When
>> >> > I
>> >> > run same report and get same error. How do I check the the June
>> >> > version
>> >> > has
>> >> > been replaced by September version?
>> >> > Thanks,
>> >> > Frank
>> >> >
>> >> > "Robert Bruckner [MSFT]" wrote:
>> >> >
>> >> >> Actually, what is the data source type you are using? Are you using
>> >> >> "Oracle"
>> >> >> (i.e. the MS managed provider for Oracle)?
>> >> >> What version of the Oracle client and what version of Oracle server
>> >> >> are
>> >> >> you
>> >> >> connecting?
>> >> >>
>> >> >> -- Robert
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >>
>> >> >>
>> >> >> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
>> >> >> message
>> >> >> news:%237VyvMxvFHA.1648@.TK2MSFTNGP10.phx.gbl...
>> >> >> > Is the Department column defined as NVarchar2?
>> >> >> >
>> >> >> >
>> >> >> > -- Robert
>> >> >> > This posting is provided "AS IS" with no warranties, and confers
>> >> >> > no
>> >> >> > rights.
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> > "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> >> >> > news:45D08B41-3791-4B9B-8C25-903F0DEC1CF4@.microsoft.com...
>> >> >> >>
>> >> >> >> We use Oracle database and SQL server 2005 Reporting
>> >> >> >> service Beta2. I made a simple SQL report using query:
>> >> >> >>
>> >> >> >> select sum(spend)
>> >> >> >> from travel_cost
>> >> >> >> where department in (:p_dept)
>> >> >> >>
>> >> >> >> I set parameter p_dept to be Multi-value: dept1 and
>> >> >> >> dept2. When I run report, if I only select dept1 or
>> >> >> >> dept2, it works fine. But when I select both or Select
>> >> >> >> All, I will get a error message:
>> >> >> >>
>> >> >> >> An error has occurred during report processing. Query
>> >> >> >> execution failed for data set 'DataSet1'. ORA-12704:
>> >> >> >> Character set missmatch.
>> >> >> >>
>> >> >> >> Please help.
>> >> >> >>
>> >> >> >> Frank
>> >> >> >>
>> >> >> >> .
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Well, I can explain in detail how we perform the multi-value parameter query
rewrite. Since we have to support arbitrary Unicode characters for the IN
clause, we follow the SQL standard when rewriting the query. We will
generate an Oracle statement like this:
.... column IN (N'First Value', N'Second Value', N'Third Value') ...
Note the usage of N'...' which marks the string contents as Unicode. It
seems like you are using an Oracle character set (e.g. 7bit Ascii) that does
not support comparing with Unicode characters. Consequently, Oracle will
fail to execute the query.
If you want RS multi-value parameter support to work with your specific
Oracle character set, you may want to look into writing a custom data
extension that implements the IDataMultiValueParameter interface (among
other RS interfaces) and implement the query rewrite algorithm yourself to
fit your Oracle character set needs.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uFCJfBFwFHA.3400@.TK2MSFTNGP14.phx.gbl...
> I'll get it posted as a bug.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Frank" <Frank@.discussions.microsoft.com> wrote in message
> news:5801832D-79C4-4F52-AAC9-F49E9FC65C5A@.microsoft.com...
>>I remove all SQL server program and Microsoft Visual Studio and Microsoft
>> framework.net program. Physical delete program files\Miscosoft SQL
>> Server,
>> Microsoft Visual Studio 8 and Miscrosoft Visual Studio and Miscrosoft.net
>> folders. Even I delete my report file folder. Then re-install SQL
>> Server
>> 2005 September CTP. Re-create the simple report, but I get same error
>> when I
>> select multi parameters.
>> Thanks
>> Frank
>> "Bruce L-C [MVP]" wrote:
>> The instructions say to remove the framework 2.0 beta, VS 2005, SQL
>> Server
>> 2005 june ctp. They all share the framework beta and that is why
>> everything
>> needs to be gone prior to upgrading. I'm not saying that your problem
>> won't
>> still be there, just that this was what the instructions said to do.
>> Read
>> the file that comes with the Sept CTP.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> news:B8294B8E-F15F-419C-8B5E-32FF43A4CD3A@.microsoft.com...
>> > Dear Bruce:
>> >
>> > I removed all June CTP using control pannel add/remove tool include
>> > Microfoft.net Framework 1.1 and Microsoft.net Deta 2. Then delete
>> > folder
>> > SQLSTD and Program Files\Microsoft SQL Server. Then rerun SQLSTD.exe
>> > and
>> > install SQL SERVER and Reporting service. But when I run Microsoft
>> > Visual
>> > Studio 2005, my report is already here and the errors are same.
>> >
>> > Please advice
>> >
>> > Thanks
>> > Frank
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> The instructions said to remove everything before installing the CTP.
>> >> This
>> >> means the beta for the dotnet framework as well as the rest of teh
>> >> June
>> >> CTP.
>> >>
>> >> I would not trust any problem found unless you do this.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> >> news:CDE79054-C9CF-4DA0-B2CD-892024B5D347@.microsoft.com...
>> >> > Dear Robert:
>> >> > 1. When I set Datasource, I select Type 'Oracle'.
>> >> > 2. Client site, Oracle Net 8 version is 8.1.7. Oracle server
>> >> > version
>> >> > is
>> >> > 8.1.7.4.0.
>> >> > 3. Before I used June CTP software. I download September CTP
>> >> > software
>> >> > SQLSTD.exe and run installing on the same computer. I don't remove
>> >> > June
>> >> > version and install to default folder SQLSTD. No any error
>> >> > occurs.
>> >> > When
>> >> > I
>> >> > run same report and get same error. How do I check the the June
>> >> > version
>> >> > has
>> >> > been replaced by September version?
>> >> > Thanks,
>> >> > Frank
>> >> >
>> >> > "Robert Bruckner [MSFT]" wrote:
>> >> >
>> >> >> Actually, what is the data source type you are using? Are you
>> >> >> using
>> >> >> "Oracle"
>> >> >> (i.e. the MS managed provider for Oracle)?
>> >> >> What version of the Oracle client and what version of Oracle
>> >> >> server
>> >> >> are
>> >> >> you
>> >> >> connecting?
>> >> >>
>> >> >> -- Robert
>> >> >> This posting is provided "AS IS" with no warranties, and confers
>> >> >> no
>> >> >> rights.
>> >> >>
>> >> >>
>> >> >> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
>> >> >> message
>> >> >> news:%237VyvMxvFHA.1648@.TK2MSFTNGP10.phx.gbl...
>> >> >> > Is the Department column defined as NVarchar2?
>> >> >> >
>> >> >> >
>> >> >> > -- Robert
>> >> >> > This posting is provided "AS IS" with no warranties, and confers
>> >> >> > no
>> >> >> > rights.
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> > "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> >> >> > news:45D08B41-3791-4B9B-8C25-903F0DEC1CF4@.microsoft.com...
>> >> >> >>
>> >> >> >> We use Oracle database and SQL server 2005 Reporting
>> >> >> >> service Beta2. I made a simple SQL report using query:
>> >> >> >>
>> >> >> >> select sum(spend)
>> >> >> >> from travel_cost
>> >> >> >> where department in (:p_dept)
>> >> >> >>
>> >> >> >> I set parameter p_dept to be Multi-value: dept1 and
>> >> >> >> dept2. When I run report, if I only select dept1 or
>> >> >> >> dept2, it works fine. But when I select both or Select
>> >> >> >> All, I will get a error message:
>> >> >> >>
>> >> >> >> An error has occurred during report processing. Query
>> >> >> >> execution failed for data set 'DataSet1'. ORA-12704:
>> >> >> >> Character set missmatch.
>> >> >> >>
>> >> >> >> Please help.
>> >> >> >>
>> >> >> >> Frank
>> >> >> >>
>> >> >> >> .
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>|||I just posted a bug on the Yukon beta site related to this same issue. We
are running against an Oracle 9i database and get a similar error. Is the
answer for all those running against Oracle to write custom extensions? This
is going to be a tough sell to my organization. The limited documentation in
the online books for sql 2005 says Oracle is supported - it doesn't say
anything about a unicode exception. Is there an Oracle setting that is
assumed when they say Oracle is supported? I really want to make this work.
--
JO
"Robert Bruckner [MSFT]" wrote:
> Well, I can explain in detail how we perform the multi-value parameter query
> rewrite. Since we have to support arbitrary Unicode characters for the IN
> clause, we follow the SQL standard when rewriting the query. We will
> generate an Oracle statement like this:
> ..... column IN (N'First Value', N'Second Value', N'Third Value') ...
> Note the usage of N'...' which marks the string contents as Unicode. It
> seems like you are using an Oracle character set (e.g. 7bit Ascii) that does
> not support comparing with Unicode characters. Consequently, Oracle will
> fail to execute the query.
> If you want RS multi-value parameter support to work with your specific
> Oracle character set, you may want to look into writing a custom data
> extension that implements the IDataMultiValueParameter interface (among
> other RS interfaces) and implement the query rewrite algorithm yourself to
> fit your Oracle character set needs.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uFCJfBFwFHA.3400@.TK2MSFTNGP14.phx.gbl...
> > I'll get it posted as a bug.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Frank" <Frank@.discussions.microsoft.com> wrote in message
> > news:5801832D-79C4-4F52-AAC9-F49E9FC65C5A@.microsoft.com...
> >>I remove all SQL server program and Microsoft Visual Studio and Microsoft
> >> framework.net program. Physical delete program files\Miscosoft SQL
> >> Server,
> >> Microsoft Visual Studio 8 and Miscrosoft Visual Studio and Miscrosoft.net
> >> folders. Even I delete my report file folder. Then re-install SQL
> >> Server
> >> 2005 September CTP. Re-create the simple report, but I get same error
> >> when I
> >> select multi parameters.
> >> Thanks
> >> Frank
> >>
> >> "Bruce L-C [MVP]" wrote:
> >>
> >> The instructions say to remove the framework 2.0 beta, VS 2005, SQL
> >> Server
> >> 2005 june ctp. They all share the framework beta and that is why
> >> everything
> >> needs to be gone prior to upgrading. I'm not saying that your problem
> >> won't
> >> still be there, just that this was what the instructions said to do.
> >> Read
> >> the file that comes with the Sept CTP.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Frank" <Frank@.discussions.microsoft.com> wrote in message
> >> news:B8294B8E-F15F-419C-8B5E-32FF43A4CD3A@.microsoft.com...
> >> > Dear Bruce:
> >> >
> >> > I removed all June CTP using control pannel add/remove tool include
> >> > Microfoft.net Framework 1.1 and Microsoft.net Deta 2. Then delete
> >> > folder
> >> > SQLSTD and Program Files\Microsoft SQL Server. Then rerun SQLSTD.exe
> >> > and
> >> > install SQL SERVER and Reporting service. But when I run Microsoft
> >> > Visual
> >> > Studio 2005, my report is already here and the errors are same.
> >> >
> >> > Please advice
> >> >
> >> > Thanks
> >> > Frank
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> The instructions said to remove everything before installing the CTP.
> >> >> This
> >> >> means the beta for the dotnet framework as well as the rest of teh
> >> >> June
> >> >> CTP.
> >> >>
> >> >> I would not trust any problem found unless you do this.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Frank" <Frank@.discussions.microsoft.com> wrote in message
> >> >> news:CDE79054-C9CF-4DA0-B2CD-892024B5D347@.microsoft.com...
> >> >> > Dear Robert:
> >> >> > 1. When I set Datasource, I select Type 'Oracle'.
> >> >> > 2. Client site, Oracle Net 8 version is 8.1.7. Oracle server
> >> >> > version
> >> >> > is
> >> >> > 8.1.7.4.0.
> >> >> > 3. Before I used June CTP software. I download September CTP
> >> >> > software
> >> >> > SQLSTD.exe and run installing on the same computer. I don't remove
> >> >> > June
> >> >> > version and install to default folder SQLSTD. No any error
> >> >> > occurs.
> >> >> > When
> >> >> > I
> >> >> > run same report and get same error. How do I check the the June
> >> >> > version
> >> >> > has
> >> >> > been replaced by September version?
> >> >> > Thanks,
> >> >> > Frank
> >> >> >
> >> >> > "Robert Bruckner [MSFT]" wrote:
> >> >> >
> >> >> >> Actually, what is the data source type you are using? Are you
> >> >> >> using
> >> >> >> "Oracle"
> >> >> >> (i.e. the MS managed provider for Oracle)?
> >> >> >> What version of the Oracle client and what version of Oracle
> >> >> >> server
> >> >> >> are
> >> >> >> you
> >> >> >> connecting?
> >> >> >>
> >> >> >> -- Robert
> >> >> >> This posting is provided "AS IS" with no warranties, and confers
> >> >> >> no
> >> >> >> rights.
> >> >> >>
> >> >> >>
> >> >> >> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:%237VyvMxvFHA.1648@.TK2MSFTNGP10.phx.gbl...
> >> >> >> > Is the Department column defined as NVarchar2?
> >> >> >> >
> >> >> >> >
> >> >> >> > -- Robert
> >> >> >> > This posting is provided "AS IS" with no warranties, and confers
> >> >> >> > no
> >> >> >> > rights.
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > "Frank" <Frank@.discussions.microsoft.com> wrote in message
> >> >> >> > news:45D08B41-3791-4B9B-8C25-903F0DEC1CF4@.microsoft.com...
> >> >> >> >>
> >> >> >> >> We use Oracle database and SQL server 2005 Reporting
> >> >> >> >> service Beta2. I made a simple SQL report using query:
> >> >> >> >>
> >> >> >> >> select sum(spend)
> >> >> >> >> from travel_cost
> >> >> >> >> where department in (:p_dept)
> >> >> >> >>
> >> >> >> >> I set parameter p_dept to be Multi-value: dept1 and
> >> >> >> >> dept2. When I run report, if I only select dept1 or
> >> >> >> >> dept2, it works fine. But when I select both or Select
> >> >> >> >> All, I will get a error message:
> >> >> >> >>
> >> >> >> >> An error has occurred during report processing. Query
> >> >> >> >> execution failed for data set 'DataSet1'. ORA-12704:
> >> >> >> >> Character set missmatch.
> >> >> >> >>
> >> >> >> >> Please help.
> >> >> >> >>
> >> >> >> >> Frank
> >> >> >> >>
> >> >> >> >> .
> >> >> >> >>
> >> >> >> >>
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
> >
> >
>
>|||It sounds like you run into a different problem, than what was discussed on
the original thread. BTW: the original thread continued on a SQL Server 2005
specific newsgroup (microsoft.private.sqlserver2005.reportingsvcs).
There may be a solution for you that does not require writing a custom data
extension. Please try the following approach to make it work with your
character set - by using an expression-based query commandtext. E.g.:
="select sum(spend) from travel_cost where department in (" &
Join(Parameters!Department.Value, ",") & ")"
Notes:
* you may also need to take into account the handling of quotes in Oracle in
that command text expression to make it work.
* you may need to first play with the expression in a report textbox and run
the report till the evaluated expression results in a valid multi-value IN
clause and then replace the old non-expression based command text.
Hope this helps,
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"John O" <JohnO@.discussions.microsoft.com> wrote in message
news:3974E8C8-33EA-4971-B4F9-F648559EBFAF@.microsoft.com...
>I just posted a bug on the Yukon beta site related to this same issue. We
> are running against an Oracle 9i database and get a similar error. Is the
> answer for all those running against Oracle to write custom extensions?
> This
> is going to be a tough sell to my organization. The limited documentation
> in
> the online books for sql 2005 says Oracle is supported - it doesn't say
> anything about a unicode exception. Is there an Oracle setting that is
> assumed when they say Oracle is supported? I really want to make this
> work.
> --
> JO
>
> "Robert Bruckner [MSFT]" wrote:
>> Well, I can explain in detail how we perform the multi-value parameter
>> query
>> rewrite. Since we have to support arbitrary Unicode characters for the IN
>> clause, we follow the SQL standard when rewriting the query. We will
>> generate an Oracle statement like this:
>> ..... column IN (N'First Value', N'Second Value', N'Third Value') ...
>> Note the usage of N'...' which marks the string contents as Unicode. It
>> seems like you are using an Oracle character set (e.g. 7bit Ascii) that
>> does
>> not support comparing with Unicode characters. Consequently, Oracle will
>> fail to execute the query.
>> If you want RS multi-value parameter support to work with your specific
>> Oracle character set, you may want to look into writing a custom data
>> extension that implements the IDataMultiValueParameter interface (among
>> other RS interfaces) and implement the query rewrite algorithm yourself
>> to
>> fit your Oracle character set needs.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uFCJfBFwFHA.3400@.TK2MSFTNGP14.phx.gbl...
>> > I'll get it posted as a bug.
>> >
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> > news:5801832D-79C4-4F52-AAC9-F49E9FC65C5A@.microsoft.com...
>> >>I remove all SQL server program and Microsoft Visual Studio and
>> >>Microsoft
>> >> framework.net program. Physical delete program files\Miscosoft SQL
>> >> Server,
>> >> Microsoft Visual Studio 8 and Miscrosoft Visual Studio and
>> >> Miscrosoft.net
>> >> folders. Even I delete my report file folder. Then re-install SQL
>> >> Server
>> >> 2005 September CTP. Re-create the simple report, but I get same error
>> >> when I
>> >> select multi parameters.
>> >> Thanks
>> >> Frank
>> >>
>> >> "Bruce L-C [MVP]" wrote:
>> >>
>> >> The instructions say to remove the framework 2.0 beta, VS 2005, SQL
>> >> Server
>> >> 2005 june ctp. They all share the framework beta and that is why
>> >> everything
>> >> needs to be gone prior to upgrading. I'm not saying that your problem
>> >> won't
>> >> still be there, just that this was what the instructions said to do.
>> >> Read
>> >> the file that comes with the Sept CTP.
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> >> news:B8294B8E-F15F-419C-8B5E-32FF43A4CD3A@.microsoft.com...
>> >> > Dear Bruce:
>> >> >
>> >> > I removed all June CTP using control pannel add/remove tool include
>> >> > Microfoft.net Framework 1.1 and Microsoft.net Deta 2. Then delete
>> >> > folder
>> >> > SQLSTD and Program Files\Microsoft SQL Server. Then rerun
>> >> > SQLSTD.exe
>> >> > and
>> >> > install SQL SERVER and Reporting service. But when I run Microsoft
>> >> > Visual
>> >> > Studio 2005, my report is already here and the errors are same.
>> >> >
>> >> > Please advice
>> >> >
>> >> > Thanks
>> >> > Frank
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> The instructions said to remove everything before installing the
>> >> >> CTP.
>> >> >> This
>> >> >> means the beta for the dotnet framework as well as the rest of teh
>> >> >> June
>> >> >> CTP.
>> >> >>
>> >> >> I would not trust any problem found unless you do this.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> >> >> news:CDE79054-C9CF-4DA0-B2CD-892024B5D347@.microsoft.com...
>> >> >> > Dear Robert:
>> >> >> > 1. When I set Datasource, I select Type 'Oracle'.
>> >> >> > 2. Client site, Oracle Net 8 version is 8.1.7. Oracle server
>> >> >> > version
>> >> >> > is
>> >> >> > 8.1.7.4.0.
>> >> >> > 3. Before I used June CTP software. I download September CTP
>> >> >> > software
>> >> >> > SQLSTD.exe and run installing on the same computer. I don't
>> >> >> > remove
>> >> >> > June
>> >> >> > version and install to default folder SQLSTD. No any error
>> >> >> > occurs.
>> >> >> > When
>> >> >> > I
>> >> >> > run same report and get same error. How do I check the the June
>> >> >> > version
>> >> >> > has
>> >> >> > been replaced by September version?
>> >> >> > Thanks,
>> >> >> > Frank
>> >> >> >
>> >> >> > "Robert Bruckner [MSFT]" wrote:
>> >> >> >
>> >> >> >> Actually, what is the data source type you are using? Are you
>> >> >> >> using
>> >> >> >> "Oracle"
>> >> >> >> (i.e. the MS managed provider for Oracle)?
>> >> >> >> What version of the Oracle client and what version of Oracle
>> >> >> >> server
>> >> >> >> are
>> >> >> >> you
>> >> >> >> connecting?
>> >> >> >>
>> >> >> >> -- Robert
>> >> >> >> This posting is provided "AS IS" with no warranties, and
>> >> >> >> confers
>> >> >> >> no
>> >> >> >> rights.
>> >> >> >>
>> >> >> >>
>> >> >> >> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
>> >> >> >> message
>> >> >> >> news:%237VyvMxvFHA.1648@.TK2MSFTNGP10.phx.gbl...
>> >> >> >> > Is the Department column defined as NVarchar2?
>> >> >> >> >
>> >> >> >> >
>> >> >> >> > -- Robert
>> >> >> >> > This posting is provided "AS IS" with no warranties, and
>> >> >> >> > confers
>> >> >> >> > no
>> >> >> >> > rights.
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >> > "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> >> >> >> > news:45D08B41-3791-4B9B-8C25-903F0DEC1CF4@.microsoft.com...
>> >> >> >> >>
>> >> >> >> >> We use Oracle database and SQL server 2005 Reporting
>> >> >> >> >> service Beta2. I made a simple SQL report using query:
>> >> >> >> >>
>> >> >> >> >> select sum(spend)
>> >> >> >> >> from travel_cost
>> >> >> >> >> where department in (:p_dept)
>> >> >> >> >>
>> >> >> >> >> I set parameter p_dept to be Multi-value: dept1 and
>> >> >> >> >> dept2. When I run report, if I only select dept1 or
>> >> >> >> >> dept2, it works fine. But when I select both or Select
>> >> >> >> >> All, I will get a error message:
>> >> >> >> >>
>> >> >> >> >> An error has occurred during report processing. Query
>> >> >> >> >> execution failed for data set 'DataSet1'. ORA-12704:
>> >> >> >> >> Character set missmatch.
>> >> >> >> >>
>> >> >> >> >> Please help.
>> >> >> >> >>
>> >> >> >> >> Frank
>> >> >> >> >>
>> >> >> >> >> .
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>> >
>> >
>>|||It seems like in your case the RDL just contains an expression-based and
parameterized query commandtext, but there is NO query parameters defined in
the RDL. At report runtime the command text expression gets evaluated and RS
executes the command text and Oracle throws an error about a query parameter
being present but not bound to a value.
So, instead of using the Join(...) approach, you could add a query
parameter, and bind it to a multi-value report parameter and it should work.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23iExJShzFHA.2884@.TK2MSFTNGP09.phx.gbl...
> It sounds like you run into a different problem, than what was discussed
> on the original thread. BTW: the original thread continued on a SQL Server
> 2005 specific newsgroup (microsoft.private.sqlserver2005.reportingsvcs).
> There may be a solution for you that does not require writing a custom
> data extension. Please try the following approach to make it work with
> your character set - by using an expression-based query commandtext. E.g.:
> ="select sum(spend) from travel_cost where department in (" &
> Join(Parameters!Department.Value, ",") & ")"
> Notes:
> * you may also need to take into account the handling of quotes in Oracle
> in that command text expression to make it work.
> * you may need to first play with the expression in a report textbox and
> run the report till the evaluated expression results in a valid
> multi-value IN clause and then replace the old non-expression based
> command text.
> Hope this helps,
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "John O" <JohnO@.discussions.microsoft.com> wrote in message
> news:3974E8C8-33EA-4971-B4F9-F648559EBFAF@.microsoft.com...
>>I just posted a bug on the Yukon beta site related to this same issue. We
>> are running against an Oracle 9i database and get a similar error. Is
>> the
>> answer for all those running against Oracle to write custom extensions?
>> This
>> is going to be a tough sell to my organization. The limited
>> documentation in
>> the online books for sql 2005 says Oracle is supported - it doesn't say
>> anything about a unicode exception. Is there an Oracle setting that is
>> assumed when they say Oracle is supported? I really want to make this
>> work.
>> --
>> JO
>>
>> "Robert Bruckner [MSFT]" wrote:
>> Well, I can explain in detail how we perform the multi-value parameter
>> query
>> rewrite. Since we have to support arbitrary Unicode characters for the
>> IN
>> clause, we follow the SQL standard when rewriting the query. We will
>> generate an Oracle statement like this:
>> ..... column IN (N'First Value', N'Second Value', N'Third Value') ...
>> Note the usage of N'...' which marks the string contents as Unicode. It
>> seems like you are using an Oracle character set (e.g. 7bit Ascii) that
>> does
>> not support comparing with Unicode characters. Consequently, Oracle will
>> fail to execute the query.
>> If you want RS multi-value parameter support to work with your specific
>> Oracle character set, you may want to look into writing a custom data
>> extension that implements the IDataMultiValueParameter interface (among
>> other RS interfaces) and implement the query rewrite algorithm yourself
>> to
>> fit your Oracle character set needs.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uFCJfBFwFHA.3400@.TK2MSFTNGP14.phx.gbl...
>> > I'll get it posted as a bug.
>> >
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> > news:5801832D-79C4-4F52-AAC9-F49E9FC65C5A@.microsoft.com...
>> >>I remove all SQL server program and Microsoft Visual Studio and
>> >>Microsoft
>> >> framework.net program. Physical delete program files\Miscosoft SQL
>> >> Server,
>> >> Microsoft Visual Studio 8 and Miscrosoft Visual Studio and
>> >> Miscrosoft.net
>> >> folders. Even I delete my report file folder. Then re-install SQL
>> >> Server
>> >> 2005 September CTP. Re-create the simple report, but I get same
>> >> error
>> >> when I
>> >> select multi parameters.
>> >> Thanks
>> >> Frank
>> >>
>> >> "Bruce L-C [MVP]" wrote:
>> >>
>> >> The instructions say to remove the framework 2.0 beta, VS 2005, SQL
>> >> Server
>> >> 2005 june ctp. They all share the framework beta and that is why
>> >> everything
>> >> needs to be gone prior to upgrading. I'm not saying that your
>> >> problem
>> >> won't
>> >> still be there, just that this was what the instructions said to do.
>> >> Read
>> >> the file that comes with the Sept CTP.
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> >> news:B8294B8E-F15F-419C-8B5E-32FF43A4CD3A@.microsoft.com...
>> >> > Dear Bruce:
>> >> >
>> >> > I removed all June CTP using control pannel add/remove tool
>> >> > include
>> >> > Microfoft.net Framework 1.1 and Microsoft.net Deta 2. Then delete
>> >> > folder
>> >> > SQLSTD and Program Files\Microsoft SQL Server. Then rerun
>> >> > SQLSTD.exe
>> >> > and
>> >> > install SQL SERVER and Reporting service. But when I run
>> >> > Microsoft
>> >> > Visual
>> >> > Studio 2005, my report is already here and the errors are same.
>> >> >
>> >> > Please advice
>> >> >
>> >> > Thanks
>> >> > Frank
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> The instructions said to remove everything before installing the
>> >> >> CTP.
>> >> >> This
>> >> >> means the beta for the dotnet framework as well as the rest of
>> >> >> teh
>> >> >> June
>> >> >> CTP.
>> >> >>
>> >> >> I would not trust any problem found unless you do this.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> >> >> news:CDE79054-C9CF-4DA0-B2CD-892024B5D347@.microsoft.com...
>> >> >> > Dear Robert:
>> >> >> > 1. When I set Datasource, I select Type 'Oracle'.
>> >> >> > 2. Client site, Oracle Net 8 version is 8.1.7. Oracle server
>> >> >> > version
>> >> >> > is
>> >> >> > 8.1.7.4.0.
>> >> >> > 3. Before I used June CTP software. I download September CTP
>> >> >> > software
>> >> >> > SQLSTD.exe and run installing on the same computer. I don't
>> >> >> > remove
>> >> >> > June
>> >> >> > version and install to default folder SQLSTD. No any error
>> >> >> > occurs.
>> >> >> > When
>> >> >> > I
>> >> >> > run same report and get same error. How do I check the the
>> >> >> > June
>> >> >> > version
>> >> >> > has
>> >> >> > been replaced by September version?
>> >> >> > Thanks,
>> >> >> > Frank
>> >> >> >
>> >> >> > "Robert Bruckner [MSFT]" wrote:
>> >> >> >
>> >> >> >> Actually, what is the data source type you are using? Are you
>> >> >> >> using
>> >> >> >> "Oracle"
>> >> >> >> (i.e. the MS managed provider for Oracle)?
>> >> >> >> What version of the Oracle client and what version of Oracle
>> >> >> >> server
>> >> >> >> are
>> >> >> >> you
>> >> >> >> connecting?
>> >> >> >>
>> >> >> >> -- Robert
>> >> >> >> This posting is provided "AS IS" with no warranties, and
>> >> >> >> confers
>> >> >> >> no
>> >> >> >> rights.
>> >> >> >>
>> >> >> >>
>> >> >> >> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote
>> >> >> >> in
>> >> >> >> message
>> >> >> >> news:%237VyvMxvFHA.1648@.TK2MSFTNGP10.phx.gbl...
>> >> >> >> > Is the Department column defined as NVarchar2?
>> >> >> >> >
>> >> >> >> >
>> >> >> >> > -- Robert
>> >> >> >> > This posting is provided "AS IS" with no warranties, and
>> >> >> >> > confers
>> >> >> >> > no
>> >> >> >> > rights.
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >> > "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> >> >> >> > news:45D08B41-3791-4B9B-8C25-903F0DEC1CF4@.microsoft.com...
>> >> >> >> >>
>> >> >> >> >> We use Oracle database and SQL server 2005 Reporting
>> >> >> >> >> service Beta2. I made a simple SQL report using query:
>> >> >> >> >>
>> >> >> >> >> select sum(spend)
>> >> >> >> >> from travel_cost
>> >> >> >> >> where department in (:p_dept)
>> >> >> >> >>
>> >> >> >> >> I set parameter p_dept to be Multi-value: dept1 and
>> >> >> >> >> dept2. When I run report, if I only select dept1 or
>> >> >> >> >> dept2, it works fine. But when I select both or Select
>> >> >> >> >> All, I will get a error message:
>> >> >> >> >>
>> >> >> >> >> An error has occurred during report processing. Query
>> >> >> >> >> execution failed for data set 'DataSet1'. ORA-12704:
>> >> >> >> >> Character set missmatch.
>> >> >> >> >>
>> >> >> >> >> Please help.
>> >> >> >> >>
>> >> >> >> >> Frank
>> >> >> >> >>
>> >> >> >> >> .
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>> >
>> >
>>
>