Problem with sql query reformatting on its own

I'm having a problem with some of my reports in SQL reporting services.
After I enter my sql query, the software reformats removing parenthesis and
moving sections of the statement around. Is there a way I can force the
system to accept my query as is?Use the generic query designer (the button to switch to this is one of the
buttons to the right of the ...)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Diane Chase via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:cc800d5f7276462981022ea63d09d5a6@.SQLMonster.com...
> I'm having a problem with some of my reports in SQL reporting services.
> After I enter my sql query, the software reformats removing parenthesis
> and
> moving sections of the statement around. Is there a way I can force the
> system to accept my query as is?|||Thanks Bruce that worked!
--
Message posted via http://www.sqlmonster.com

Problem with SQL 2005 Beta 2 Reporting Services

I've just installed SQL 2005 Beta 2 onto a Windows Server 2003 SP1 box.
I've installed all the components, including Reporting Services.
When I try to connect to the web site I get the message
The request failed with HTTP status 407: Proxy Authentication Required.
Anonymous access to the web site is allowed.
Any thoughts?
Thanks
Laurence
--
Laurence Sharp
Senior Systems Engineer
TNS UKOn Thu, 7 Apr 2005 07:09:05 -0700, "Laurence Sharp"
<LaurenceSharp@.discussions.microsoft.com> wrote:
>I've just installed SQL 2005 Beta 2 onto a Windows Server 2003 SP1 box.
>I've installed all the components, including Reporting Services.
>When I try to connect to the web site I get the message
>The request failed with HTTP status 407: Proxy Authentication Required.
>Anonymous access to the web site is allowed.
>Any thoughts?
>Thanks
>Laurence
Hi Laurence,
Questions about RS2005 should probably go to the
microsoft.private.sqlserver2005.reportingsvcs. Despite the name it's a
public newsgroup intended for the RS2005 beta and CTPs.
Are you really using Beta 2 from June/July last year? Beta 2 has
functionality similar to RS2000 with little new.
If you are, then you should probably update BUT be sure to read
carefully CTPNotes.mht about uninstall order before upgrading.
The February CTP has new functionality and has fewer configuration
problems than earlier builds.
Andrew Watt
MVP - InfoPath

Problem with SQL 2000 Reporting Services in Windows Server 2000 IIS 5.0

Hi,

I′m having a problem with the SQL 2000 Reporting Services.
I′ve installed it in a windows 2000 server with IIS 5.0 and after i′ve installed the Reporting Services (even with the SP2 os Reporting Services installed), when i try to log on to the reports webside in order to start creating the folders of the reports that i want to create i get an error (ACCESS DENIED) and i′m trying to access it locally.

How can i solve this?

Regards,

Ricardo

Are you trying to open the website on the installed server or via another computer ?

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

|||Hi,

I′m trying to open the website on the instaled server. Even if i try to open it from a diferent computer, the error is the same.|||

Try using the rskeymgmt utility to backup the encryption key, and rsactivate utility to activate the site.

Check to see if the Default Application Pool in IIS is using the Network account identity.

Filemon from www.sysinternals.com may also help identify where the issue is.

cheers,

Andrew

|||Do you get an rsAccessDenied or the IIS Access Denied ?

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

Problem with sorting in exported Excel document

Hello. I am using Reporting Services 2000 and Microsoft Excel 2003 running on
Windows XP Professional. I have a report that contains sales information that
I am exporting to Excel. The first two lines of the report contain title
information. They span all columns of the report. For example, the first line
(let's call it Food Sales Information) spans 15 columns. After the first two
lines of title information, there is a line containing the names of the
columns. After that, I have a lot of lines containing the sales data. I
export this to Excel. When I click in one of the numeric columns and click
the "A->Z" (sort ascending) button, I get the following error:
"This operation requires the merged cells to be identically sized."
Clciking Show Help gives me the following detail:
"This error only appears if you attempted to sort a range of previously
merged cells, but not all cells in the sort range were merged or are not of
the same size.
To avoid this behavior, unmerge all the merged cells in the range, or merge
all the cells in the range to be the same as the largest merged cell
grouping."
I believe this error to be caused the the two header rows. When I delete the
two header rows from the exported Excel document, I do not get the error.
Is there any way around this problem? Can I get the data to sort in Excel
without removing the header? Thanks in advance for the help.For those of you with this problem in the future who find this post
through google, Teo pointed me to a blog with this very issue
addressed. The bottom line is exporting to Excel from RS2000 leaves a
lot to be desired. Here is the blog with a work-around for this
problem:
http://blogs.msdn.com/chrisbal/archive/2006/07/08/659545.aspx

Problem with SetReportDataSources method

Hi,

Thanks in Advacne,

I'm using Reporting Service 2000 Web Service SetReportDataSources method to associate Datasource with Report. But I'm getting error.

"The data source 'DS_Code_002' cannot be found in this report. --> The data source 'DS_Code_002' cannot be found in this report. "

I searched lot but i didn't get solution .Some posts telling like "this is a bug in RSWS". Please help me to resolve the issue.

Code:

DataSourceReference reference = new DataSourceReference();

reference.Reference = txtDSPath.Text;

DataSource[] dataSources = new DataSource[1];

DataSource ds = new DataSource();

ds.Item = (DataSourceDefinitionOrReference) reference;

ds.Name = "Dsname";

dataSources[0] = ds;

rs.SetReportDataSources(txtReportPath.Text, dataSources);

Thanks again,

Krishna kumar.M

Hi,

After the long try myself found the answer.

if datasource name is same like the hardcoded data source name in .rdl file it is working fine

So I chnage to code as follows now it is working fine. Otherwise you have to change the name in .rdl file manually.

Code

DataSourceReference dRef= new ReportingService.ReportingServiceWS.DataSourceReference( );

dRef.Reference = txtDSPath.Text;

DataSource []ds = rs.GetReportDataSources(txtReportPath.Text);

DataSource d = new ReportingService.ReportingServiceWS.DataSource();

d.Item = (RS.DataSourceDefinitionOrReference)dRef;

d.Name= ds[0].Name; // Get the new name store it in new object

ds[0] = d;

rs.SetReportDataSources(txtReportPath.Text,ds);

Problem with Resporting services on sharepoint: Server Error in '/' Application.

Hi,

I have a problem with Resporting services on sharepoint. My local host machine reporting services is ok though.

The problem is when I click on "properties" button on sharepoint reporting services, and when I click on Parameters, Data Sources, Execution, and other bottons on the left hand side, I get the following error:

Server Error in '/' Application.

---

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested Url: /Reports/Pages/Report.aspx

Does anybody know how to fix this?

Thanks,

Yes, this is a common problem with sharepoint installed on the Report Server. Sharepoint claims all HTTP request for itself and used therefore its own HTTP handler, the request won′t get further to Reporting Services, it will be caught by SPS. To fix this problem, you can define excluded path which "excludes" the path for the SPS Http Handler und lets it through to the other HTTP Handler.

YOu can find these settings under the Central administation of Sharepoint. I f I have time this weekend, I will record a screencast for that and publish that on my site under the section Screencasts.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks. Please do That!

I NEED HELP!!!!

|||

Goods news Alexan,

after several hours I finished the screencast. Look in the screencast section on my site. Would be nice to have some feedback what you are thinking about that and if that helped.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I see only three previous screencasts. Are you sure you uploaded it?

|||Look in the screencast section, not the announcements.

HTH, Jens Suessmeyer.

http://www.sqlserver0205.de|||Was the Screencast helpful ?|||

Thank you very much for all that Jens.

I showed it to my supervisor and he said he already tried that (excluded them) but it didn't work for him, so he is probably going to reinstall sharepoint and reporting server again.

I appreciate your help and support anyway.

Sincerely,

Alexan

|||I know this is late, but I have just posted an entry on my blog that helps for some of this configuration... http://portal.sqltrainer.com/Lists/Posts/Post.aspx?ID=11

Problem with Resporting services on sharepoint: Server Error in '/' Application.

Hi,

I have a problem with Resporting services on sharepoint. My local host machine reporting services is ok though.

The problem is when I click on "properties" button on sharepoint reporting services, and when I click on Parameters, Data Sources, Execution, and other bottons on the left hand side, I get the following error:

Server Error in '/' Application.

---

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested Url: /Reports/Pages/Report.aspx

Does anybody know how to fix this?

Thanks,

Yes, this is a common problem with sharepoint installed on the Report Server. Sharepoint claims all HTTP request for itself and used therefore its own HTTP handler, the request won′t get further to Reporting Services, it will be caught by SPS. To fix this problem, you can define excluded path which "excludes" the path for the SPS Http Handler und lets it through to the other HTTP Handler.

YOu can find these settings under the Central administation of Sharepoint. I f I have time this weekend, I will record a screencast for that and publish that on my site under the section Screencasts.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks. Please do That!

I NEED HELP!!!!

|||

Goods news Alexan,

after several hours I finished the screencast. Look in the screencast section on my site. Would be nice to have some feedback what you are thinking about that and if that helped.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I see only three previous screencasts. Are you sure you uploaded it?

|||Look in the screencast section, not the announcements.

HTH, Jens Suessmeyer.

http://www.sqlserver0205.de|||Was the Screencast helpful ?|||

Thank you very much for all that Jens.

I showed it to my supervisor and he said he already tried that (excluded them) but it didn't work for him, so he is probably going to reinstall sharepoint and reporting server again.

I appreciate your help and support anyway.

Sincerely,

Alexan

|||I know this is late, but I have just posted an entry on my blog that helps for some of this configuration... http://portal.sqltrainer.com/Lists/Posts/Post.aspx?ID=11

Problem with Resporting services on sharepoint: Server Error in '/' Application.

Hi,

I have a problem with Resporting services on sharepoint. My local host machine reporting services is ok though.

The problem is when I click on "properties" button on sharepoint reporting services, and when I click on Parameters, Data Sources, Execution, and other bottons on the left hand side, I get the following error:

Server Error in '/' Application.

---

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested Url: /Reports/Pages/Report.aspx

Does anybody know how to fix this?

Thanks,

Yes, this is a common problem with sharepoint installed on the Report Server. Sharepoint claims all HTTP request for itself and used therefore its own HTTP handler, the request won′t get further to Reporting Services, it will be caught by SPS. To fix this problem, you can define excluded path which "excludes" the path for the SPS Http Handler und lets it through to the other HTTP Handler.

YOu can find these settings under the Central administation of Sharepoint. I f I have time this weekend, I will record a screencast for that and publish that on my site under the section Screencasts.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks. Please do That!

I NEED HELP!!!!

|||

Goods news Alexan,

after several hours I finished the screencast. Look in the screencast section on my site. Would be nice to have some feedback what you are thinking about that and if that helped.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I see only three previous screencasts. Are you sure you uploaded it?

|||Look in the screencast section, not the announcements.

HTH, Jens Suessmeyer.

http://www.sqlserver0205.de|||Was the Screencast helpful ?|||

Thank you very much for all that Jens.

I showed it to my supervisor and he said he already tried that (excluded them) but it didn't work for him, so he is probably going to reinstall sharepoint and reporting server again.

I appreciate your help and support anyway.

Sincerely,

Alexan

|||I know this is late, but I have just posted an entry on my blog that helps for some of this configuration... http://portal.sqltrainer.com/Lists/Posts/Post.aspx?ID=11

Problem with Resporting services on sharepoint: Server Error in '/' Application.

Hi,

I have a problem with Resporting services on sharepoint. My local host machine reporting services is ok though.

The problem is when I click on "properties" button on sharepoint reporting services, and when I click on Parameters, Data Sources, Execution, and other bottons on the left hand side, I get the following error:

Server Error in '/' Application.

---

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested Url: /Reports/Pages/Report.aspx

Does anybody know how to fix this?

Thanks,

Yes, this is a common problem with sharepoint installed on the Report Server. Sharepoint claims all HTTP request for itself and used therefore its own HTTP handler, the request won′t get further to Reporting Services, it will be caught by SPS. To fix this problem, you can define excluded path which "excludes" the path for the SPS Http Handler und lets it through to the other HTTP Handler.

YOu can find these settings under the Central administation of Sharepoint. I f I have time this weekend, I will record a screencast for that and publish that on my site under the section Screencasts.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks. Please do That!

I NEED HELP!!!!

|||

Goods news Alexan,

after several hours I finished the screencast. Look in the screencast section on my site. Would be nice to have some feedback what you are thinking about that and if that helped.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I see only three previous screencasts. Are you sure you uploaded it?

|||Look in the screencast section, not the announcements.

HTH, Jens Suessmeyer.

http://www.sqlserver0205.de|||Was the Screencast helpful ?|||

Thank you very much for all that Jens.

I showed it to my supervisor and he said he already tried that (excluded them) but it didn't work for him, so he is probably going to reinstall sharepoint and reporting server again.

I appreciate your help and support anyway.

Sincerely,

Alexan

|||I know this is late, but I have just posted an entry on my blog that helps for some of this configuration... http://portal.sqltrainer.com/Lists/Posts/Post.aspx?ID=11

Problem with Reporting Services 2005

I installed SQL SERVER 2005 with RS2005 - it worked great.
Cause of a problem we had to re-installed the IIS so the virtual directories
of RS where gone...
To continue with errors i deleted the DB of RS
So now i try to re-install the RS but i get this error:
Reason: Your upgrade is blocked. For more information about upgrade support,
see the "Version and Edition Upgrades" and "Hardware and Software
Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
Online.
Build version check:
Your upgrade is blocked because the existing component is a later version
than the version you are trying to upgrade to. To modify an existing SQL
Server component, go to Add or Remove Programs in Control Panel, select the
component you would like to modify, and then click Change/Remove.
So what should i do?when i try to it from Add/Remove it also don't work...
My version is :
Microsoft SQL Server Management Studio 9.00.2047.00
But when it try to install the RS it say : 9.1.2047.00
So what's the problem?Can you just try recreating the virtual directories and the databases using
Reporting services configuration manager instead of a complete reinstall?
--
Ramu
This posting is provided "AS IS" with no warranties, and confers no rights.
"ש×?×?×?" wrote:
> I installed SQL SERVER 2005 with RS2005 - it worked great.
> Cause of a problem we had to re-installed the IIS so the virtual directories
> of RS where gone...
> To continue with errors i deleted the DB of RS
> So now i try to re-install the RS but i get this error:
> Reason: Your upgrade is blocked. For more information about upgrade support,
> see the "Version and Edition Upgrades" and "Hardware and Software
> Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
> Online.
> Build version check:
> Your upgrade is blocked because the existing component is a later version
> than the version you are trying to upgrade to. To modify an existing SQL
> Server component, go to Add or Remove Programs in Control Panel, select the
> component you would like to modify, and then click Change/Remove.
>
> So what should i do?when i try to it from Add/Remove it also don't work...
> My version is :
> Microsoft SQL Server Management Studio 9.00.2047.00
> But when it try to install the RS it say : 9.1.2047.00
> So what's the problem?
>|||thanks,it helped
what amazing tool!!!
"Ramu_MSFT" wrote:
> Can you just try recreating the virtual directories and the databases using
> Reporting services configuration manager instead of a complete reinstall?
> --
> Ramu
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "ש×?×?×?" wrote:
> > I installed SQL SERVER 2005 with RS2005 - it worked great.
> > Cause of a problem we had to re-installed the IIS so the virtual directories
> > of RS where gone...
> > To continue with errors i deleted the DB of RS
> > So now i try to re-install the RS but i get this error:
> >
> > Reason: Your upgrade is blocked. For more information about upgrade support,
> > see the "Version and Edition Upgrades" and "Hardware and Software
> > Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
> > Online.
> >
> > Build version check:
> > Your upgrade is blocked because the existing component is a later version
> > than the version you are trying to upgrade to. To modify an existing SQL
> > Server component, go to Add or Remove Programs in Control Panel, select the
> > component you would like to modify, and then click Change/Remove.
> >
> >
> > So what should i do?when i try to it from Add/Remove it also don't work...
> >
> > My version is :
> > Microsoft SQL Server Management Studio 9.00.2047.00
> > But when it try to install the RS it say : 9.1.2047.00
> >
> > So what's the problem?
> >

Problem with Reporting service toolbox!

Hi All!!!!

When I create new reporting service I have problem with toolbox as follows:

Please help me to solved problem. Thanks

Hi,

From the image you provided, it seems that the report items in toolbox is mixed up.

Since we don't know if you have any modification on the toolbox (especially for the control assembly), I just provide you some steps to diagnose the problem.

1. Try to right click on the report items in your toolbox, and choose "Reset ToolBox" button, to see if it can fix the issue.
2. Try to right click on the report items in your toolbox, and click on 'choose items' to open the "Choose Toolbox items" window, switch to the .NET Framework components tab, try to check if there are so many textboxes control with different edition.
3. Go to %SystemRoot%/Assembly/ folder, try to find if the textbox controls exists normally.(Is any other extra textbox controls?)
4. After those steps, if the problem still exists, try to re-install your Business Intelligence Projects components.

Thanks.

Problem with Reporting Service SQL 2000 and Sybase

Hi,
The connection to Sybase with OLEDB and ODBC have the same problem when the
query have parameter. The query below don´t execute:
select prod_cod,cod_empresa from estatistica.dbo.zomba
where vida = @.vida
OLEDB error: "An error occurred while executing the query. The given type
name was unrecognized"
versions used: 02.70.0016 and 02.70.0042 (provided by Sybase support)
ODBC error: "Error [HY000][DataDirect][ODBC Sybase wire protocol driver][SQL
Server] must declare variable @.vida"
versions used: 04.10.0049 (provided by Sybase support)
Someone have the same problem?
Thanks,
LandryI work extensively with Sybase. The issue you are seeing is that query
variables for ODBC have to be a ? (unnamed parameter). I suggest you stick
with the ODBC driver. I have had issues with OLEDB.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Landry" <landry@.dsai.com.br.NEWS> wrote in message
news:em6ndG7RFHA.688@.TK2MSFTNGP10.phx.gbl...
> Hi,
> The connection to Sybase with OLEDB and ODBC have the same problem when
> the
> query have parameter. The query below don´t execute:
> select prod_cod,cod_empresa from estatistica.dbo.zomba
> where vida = @.vida
> OLEDB error: "An error occurred while executing the query. The given type
> name was unrecognized"
> versions used: 02.70.0016 and 02.70.0042 (provided by Sybase support)
> ODBC error: "Error [HY000][DataDirect][ODBC Sybase wire protocol
> driver][SQL
> Server] must declare variable @.vida"
> versions used: 04.10.0049 (provided by Sybase support)
> Someone have the same problem?
> Thanks,
> Landry
>
>|||Hi,
Thanks.
I test ? with OLEDB and ODBC and have the same error!
select prod_cod,cod_empresa from estatistica.dbo.zomba
where vida = ?
I test Stored Procedures with parameters and have the same error.
Landry
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escreveu na mensagem
news:u%23sw%23m7RFHA.3704@.TK2MSFTNGP12.phx.gbl...
>I work extensively with Sybase. The issue you are seeing is that query
>variables for ODBC have to be a ? (unnamed parameter). I suggest you stick
>with the ODBC driver. I have had issues with OLEDB.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Landry" <landry@.dsai.com.br.NEWS> wrote in message
> news:em6ndG7RFHA.688@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> The connection to Sybase with OLEDB and ODBC have the same problem when
>> the
>> query have parameter. The query below don´t execute:
>> select prod_cod,cod_empresa from estatistica.dbo.zomba
>> where vida = @.vida
>> OLEDB error: "An error occurred while executing the query. The given
>> type
>> name was unrecognized"
>> versions used: 02.70.0016 and 02.70.0042 (provided by Sybase support)
>> ODBC error: "Error [HY000][DataDirect][ODBC Sybase wire protocol
>> driver][SQL
>> Server] must declare variable @.vida"
>> versions used: 04.10.0049 (provided by Sybase support)
>> Someone have the same problem?
>> Thanks,
>> Landry
>>
>>
>|||The best thing to do is as you are doing, first get a query and then move on
to stored procedures. That is the data type of vida?
Also, when are you getting this error? From the data tab clicking on the ! ?
Or from the preview?
Let's concentrate on ODBC. What error do you get with ODBC (it can't be the
same as before because at that point you had this error: must declare
variable @.vida).
I do all my queries from the generic query window. Try that (the button is
to the right of the ... to switch to generic query designer).
Also, what version of Sysbase. I am using 12.5.2 client and have used that
against both an 11.x (I don't remember the exact version) and 12.5.1
servers.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Landry" <landry@.dsai.com.br.NEWS> wrote in message
news:e4V1j7BSFHA.1348@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Thanks.
> I test ? with OLEDB and ODBC and have the same error!
> select prod_cod,cod_empresa from estatistica.dbo.zomba
> where vida = ?
> I test Stored Procedures with parameters and have the same error.
> Landry
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escreveu na mensagem
> news:u%23sw%23m7RFHA.3704@.TK2MSFTNGP12.phx.gbl...
>>I work extensively with Sybase. The issue you are seeing is that query
>>variables for ODBC have to be a ? (unnamed parameter). I suggest you stick
>>with the ODBC driver. I have had issues with OLEDB.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Landry" <landry@.dsai.com.br.NEWS> wrote in message
>> news:em6ndG7RFHA.688@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> The connection to Sybase with OLEDB and ODBC have the same problem when
>> the
>> query have parameter. The query below don´t execute:
>> select prod_cod,cod_empresa from estatistica.dbo.zomba
>> where vida = @.vida
>> OLEDB error: "An error occurred while executing the query. The given
>> type
>> name was unrecognized"
>> versions used: 02.70.0016 and 02.70.0042 (provided by Sybase support)
>> ODBC error: "Error [HY000][DataDirect][ODBC Sybase wire protocol
>> driver][SQL
>> Server] must declare variable @.vida"
>> versions used: 04.10.0049 (provided by Sybase support)
>> Someone have the same problem?
>> Thanks,
>> Landry
>>
>>
>>
>|||Hi Bruce,
Thanks, the problem is ODBC version, now work fine with cliente version
12.5.3, the most recent.
The Sybase suport will analyze the OLEDB to correct the error.
Thanks,
Landry
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escreveu na mensagem
news:urhgPMCSFHA.3336@.TK2MSFTNGP09.phx.gbl...
> The best thing to do is as you are doing, first get a query and then move
> on to stored procedures. That is the data type of vida?
> Also, when are you getting this error? From the data tab clicking on the !
> ? Or from the preview?
> Let's concentrate on ODBC. What error do you get with ODBC (it can't be
> the same as before because at that point you had this error: must declare
> variable @.vida).
> I do all my queries from the generic query window. Try that (the button is
> to the right of the ... to switch to generic query designer).
> Also, what version of Sysbase. I am using 12.5.2 client and have used that
> against both an 11.x (I don't remember the exact version) and 12.5.1
> servers.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Landry" <landry@.dsai.com.br.NEWS> wrote in message
> news:e4V1j7BSFHA.1348@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> Thanks.
>> I test ? with OLEDB and ODBC and have the same error!
>> select prod_cod,cod_empresa from estatistica.dbo.zomba
>> where vida = ?
>> I test Stored Procedures with parameters and have the same error.
>> Landry
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escreveu na mensagem
>> news:u%23sw%23m7RFHA.3704@.TK2MSFTNGP12.phx.gbl...
>>I work extensively with Sybase. The issue you are seeing is that query
>>variables for ODBC have to be a ? (unnamed parameter). I suggest you
>>stick with the ODBC driver. I have had issues with OLEDB.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Landry" <landry@.dsai.com.br.NEWS> wrote in message
>> news:em6ndG7RFHA.688@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> The connection to Sybase with OLEDB and ODBC have the same problem when
>> the
>> query have parameter. The query below don´t execute:
>> select prod_cod,cod_empresa from estatistica.dbo.zomba
>> where vida = @.vida
>> OLEDB error: "An error occurred while executing the query. The given
>> type
>> name was unrecognized"
>> versions used: 02.70.0016 and 02.70.0042 (provided by Sybase support)
>> ODBC error: "Error [HY000][DataDirect][ODBC Sybase wire protocol
>> driver][SQL
>> Server] must declare variable @.vida"
>> versions used: 04.10.0049 (provided by Sybase support)
>> Someone have the same problem?
>> Thanks,
>> Landry
>>
>>
>>
>>
>

Problem with Reporting Server Security. I can not have the correct permissions.

Hi,
I'm trying to configure the RS's Security. i 've created two rules, one
rule for administrators and the other one for IUSR_machine. I connect to
Windows 2000 server as administrator.
The problem is that when i access the Report Administrator via URL, it
applies the rules of the IUSR_machine, so i can't make administrator tasks.
¿Why does the Report Administrator think that I am an IUSR_machine user, and
how can I connect as administrator?
Please, anybody can help me,
thanks in advance.
Oliver.I am able to reproduce your issue when I set my report manager site to allow
anonymous access. When I do this, it ignores my windows authentication
forcing the report manager to treat me as a consumer, not an admin. This is
not the default setting. Did someone change it afterwards? If you find this
to be the case, uncheck the "Anonymous Access" box and try it again. Make
sure "Integrated Windows Authentication" is checked at the bottom of the
Authentication Methods dialog.
({IIS Manager}=>{Default Web Site}=>{Reports}=>{Properties}=>{Directory
Security}=>{Edit}).
"oli" wrote:
> Hi,
> I'm trying to configure the RS's Security. i 've created two rules, one
> rule for administrators and the other one for IUSR_machine. I connect to
> Windows 2000 server as administrator.
> The problem is that when i access the Report Administrator via URL, it
> applies the rules of the IUSR_machine, so i can't make administrator tasks.
> ¿Why does the Report Administrator think that I am an IUSR_machine user, and
> how can I connect as administrator?
>
> Please, anybody can help me,
> thanks in advance.
> Oliver.
>
>|||Thanks for your response.
I have verifed the Security in IIS. When I configured the authentication I
activated the Report Server with "anonymous access", but I configured the
Report Manager only with "Integrated Windows Authentication". With this
configuration, the RS works in the way I wrote in the first mail.
Oliver.
>I am able to reproduce your issue when I set my report manager site to
>allow
> anonymous access. When I do this, it ignores my windows authentication
> forcing the report manager to treat me as a consumer, not an admin. This
> is
> not the default setting. Did someone change it afterwards? If you find
> this
> to be the case, uncheck the "Anonymous Access" box and try it again. Make
> sure "Integrated Windows Authentication" is checked at the bottom of the
> Authentication Methods dialog.
> ({IIS Manager}=>{Default Web Site}=>{Reports}=>{Properties}=>{Directory
> Security}=>{Edit}).
>
> "oli" wrote:
>> Hi,
>> I'm trying to configure the RS's Security. i 've created two rules,
>> one
>> rule for administrators and the other one for IUSR_machine. I connect to
>> Windows 2000 server as administrator.
>> The problem is that when i access the Report Administrator via URL, it
>> applies the rules of the IUSR_machine, so i can't make administrator
>> tasks.
>> ¿Why does the Report Administrator think that I am an IUSR_machine user,
>> and
>> how can I connect as administrator?
>>
>> Please, anybody can help me,
>> thanks in advance.
>> Oliver.
>>|||If i put both report server and report administration with integrated
windows authentication it's goes fine, but the problems appears when i
configure report administration with itegrated windows authentication and
report server with anonymous access.
Oliver
"oli" <oli1350@.hotmail.com> escribió en el mensaje
news:eu%23AV%23IpEHA.3900@.TK2MSFTNGP10.phx.gbl...
> Thanks for your response.
> I have verifed the Security in IIS. When I configured the authentication I
> activated the Report Server with "anonymous access", but I configured the
> Report Manager only with "Integrated Windows Authentication". With this
> configuration, the RS works in the way I wrote in the first mail.
>
> Oliver.
>
>>I am able to reproduce your issue when I set my report manager site to
>>allow
>> anonymous access. When I do this, it ignores my windows authentication
>> forcing the report manager to treat me as a consumer, not an admin. This
>> is
>> not the default setting. Did someone change it afterwards? If you find
>> this
>> to be the case, uncheck the "Anonymous Access" box and try it again. Make
>> sure "Integrated Windows Authentication" is checked at the bottom of the
>> Authentication Methods dialog.
>> ({IIS Manager}=>{Default Web Site}=>{Reports}=>{Properties}=>{Directory
>> Security}=>{Edit}).
>>
>> "oli" wrote:
>> Hi,
>> I'm trying to configure the RS's Security. i 've created two rules,
>> one
>> rule for administrators and the other one for IUSR_machine. I connect to
>> Windows 2000 server as administrator.
>> The problem is that when i access the Report Administrator via URL, it
>> applies the rules of the IUSR_machine, so i can't make administrator
>> tasks.
>> ¿Why does the Report Administrator think that I am an IUSR_machine user,
>> and
>> how can I connect as administrator?
>>
>> Please, anybody can help me,
>> thanks in advance.
>> Oliver.
>>
>

Problem with reporting and queries

I am having a problem with several reports at work. We use an SQL
generator package where we fill in a template, and the system
generates SQL code.

The reports I have been running at a low level return a sales value of
$96,000 for a specific office for 2006.

Here is my filter,

Office = 23

Region = Northeast

Product Cat = (several different categories)

Year = 2006

When I added some additional columns, the sale for the same office
went to over $9 Million. When I analyzed this further, I found all
offices in the region were being returned for the second report, and
thus I ended up with the sales for all of the regions sales.

What I am really confused about is how using the exact same filter, a
simple report can show one number and then by adding some facts or
columns my sales went up. (and I did confirm character by character
we are using the same filter.)

Is this explainable based on some principle of SQL I am unfamiliar
with?

One explanation I received from IT, who is too busy to look at my
problem, is that by adding additional columns, I essentially asked our
SQL generator to set up a larger join than I expected.

If this were true, wouldn't the filter still eliminate records that
don't meet the filter requirements?

I suspect the SQL generator applied the filter at the wrong spot. I
tried looking at the SQL: code, but it is very complicated.

So I am turning to this forum to see if anyone can think of a logical
explanation that would allow SQL to in effect return a larger dataset
than my original report.

Thanks for any help.AF (bscinc@.Yahoo_NoSpam.com) writes:

Quote:

Originally Posted by

When I added some additional columns, the sale for the same office
went to over $9 Million. When I analyzed this further, I found all
offices in the region were being returned for the second report, and
thus I ended up with the sales for all of the regions sales.
>
What I am really confused about is how using the exact same filter, a
simple report can show one number and then by adding some facts or
columns my sales went up. (and I did confirm character by character
we are using the same filter.)
>
Is this explainable based on some principle of SQL I am unfamiliar
with?
>
One explanation I received from IT, who is too busy to look at my
problem, is that by adding additional columns, I essentially asked our
SQL generator to set up a larger join than I expected.
>
If this were true, wouldn't the filter still eliminate records that
don't meet the filter requirements?
>
I suspect the SQL generator applied the filter at the wrong spot. I
tried looking at the SQL: code, but it is very complicated.
>
So I am turning to this forum to see if anyone can think of a logical
explanation that would allow SQL to in effect return a larger dataset
than my original report.

It's of course impossible to debug a tool that I have never seen.
I can think of lots of reasons, including user errors on your
part, errors in the tool you use, or in the data model you access.

If I understood your story correctly, the second report rendered the
filter on office void and useless. That's some kind of clue, but enough
to say "Aha!".

You could at least post the queries, to give us something to work with.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Problem with report manager find command

I am using sql server reporting services with service pack 2 applied. One of
my users has encountered a strange problem using the find command after a
report has been run.
If you try to use the find command in the report manager to locate a string
that is in the last group on a page, it will report "The search text was not
found". The find command works fine for test in all other groups on the
report. If you export the report to pdf, the acrobat search function will
find the text. I have tested several of my reports they all seem to have the
same problem.
Has anyone else had this problem with the find command in the report
manager? Any idea how to fix it?Hi,
Welcome to use MSDN Managed Newsgroup Support.
To state the problem clearly, would you tell me how you are searching the
string in report manager?
Do you use the Ctrl-F to find a string in a report via browser? If so,
which browser and what version do you use?
The Search for Feature in the Report Manager Page can only search published
reports, folders, shared data sources, and resources.
Thank you for your patience and cooperations. Please let me know your
results with this so that I can provide further association. I look forward
your reply.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks for the input. I will try to be more clear.
Here is the procedure I am using. First I am run the report in Internet
Explorer 6. I type the search string into the text box which appears between
the zoom factor (100%) and the word find. When I hover my mouse over the
text box a tool tip pops up and displays "find text". Finally, I click on
the word "Find".
Normally the report will jump to wherever the search string is first found
in the report, regardless of which page it appears on. As I stated earlier
if the search string appears in the last group on a page, for some reason it
will not be found.
I noticed today that the problem only seems to occur if the last group on
the page spans onto the next page. If the last group on the page finishes on
the page you can successfully find items in that group.
"Wei Lu" wrote:
"Wei Lu" wrote:
> Hi,
> Welcome to use MSDN Managed Newsgroup Support.
> To state the problem clearly, would you tell me how you are searching the
> string in report manager?
> Do you use the Ctrl-F to find a string in a report via browser? If so,
> which browser and what version do you use?
> The Search for Feature in the Report Manager Page can only search published
> reports, folders, shared data sources, and resources.
> Thank you for your patience and cooperations. Please let me know your
> results with this so that I can provide further association. I look forward
> your reply.
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hi Guess,
Thank you for update. I understood your concern is that you are trying to
search the string in a report with a html viewer and you can not find it if
the string in the last group. If I misunderstood your concern, please feel
free to point it out.
In the reporting service, this Search feature searches for content in the
report by typing a word or phrase that you want to find (the maximum value
length is 256 characters). The search is case-insensitive and begins at the
page or section that is currently selected. Only visible content is
included in a search operation. This search feature is based on javascript.
So I'd like to know if you use the Ctrl-F to search the string, will you
find it properly? Is this string visible or not?
Also you may want to insert a page break after the table to test.
Further, if you installed the Sample, you may check if the issue occurs on
¡"product catalog" sample report.
Thank you for your patience and cooperations. Please let me know your
results with this so that I can provide further association. I look forward
your reply.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for you efforts.
To answer your question, the text is visible. If I use Ctrl-F, it does find
the text as long as I am currently on the page where the text appears. In my
experience, the find/next commands in the report manager will find a string
on the current page as well as all other pages (both before and after the
current page) except in the circumstances described in my earlier posts.
The problem I am having does occur in the Product Catalog sample report.
For example on page five, the last line of the report has product no. of
"BK-M38S-56". The find command will not find this product no.. If I use
Ctrl-F it will find the product no., as long as I am on page 5. In fact I
can not use the find/next commands to locate any product no. in the
"Mountain-400" section on page 5.
The sample reports are on my local machine. The earlier reports I tested
were on our application server. I am curious to know if you experience the
same problem on page 5 of the product catalog.
I tried adding a page break after the table in the Product Catalog sample
report. It did not make any difference.
"Wei Lu" wrote:
> Hi Guess,
> Thank you for update. I understood your concern is that you are trying to
> search the string in a report with a html viewer and you can not find it if
> the string in the last group. If I misunderstood your concern, please feel
> free to point it out.
> In the reporting service, this Search feature searches for content in the
> report by typing a word or phrase that you want to find (the maximum value
> length is 256 characters). The search is case-insensitive and begins at the
> page or section that is currently selected. Only visible content is
> included in a search operation. This search feature is based on javascript.
> So I'd like to know if you use the Ctrl-F to search the string, will you
> find it properly? Is this string visible or not?
> Also you may want to insert a page break after the table to test.
> Further, if you installed the Sample, you may check if the issue occurs on
> ¡"product catalog" sample report.
> Thank you for your patience and cooperations. Please let me know your
> results with this so that I can provide further association. I look forward
> your reply.
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Guess,
I have searched in our internal knowledge base, it is a known issue in
Reporting Service and is fixed in SQL Server 2005 Reporting Services.
For now, if it has much business impact on you, I recommend that you open a
Support incident
with Microsoft Customer Service and Support (CSS) so that a dedicated
Support Professional can work with you in a more timely and efficient
manner. If you need any help in this regard, please let me know.
For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
If there are further questions on the issue, please feel free to let us
know. Have a great day!
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Problem with Report Builder reporting from a remote database

Hi All,
I had the same problem with an earlier build of SQL Server.
The data for my report model is located on a different server than SQL Server 2005. On the SQL Server 2005 server I can use the Report Builder and it works just fine.
When I try to run the Report Builder on my desktop I get the following error:

For more information about this error navigate to the report server on the local server machine, or enable remote errors
-
Cannot create a connection to data source 'dataSource1'.
-
An error has occurred during report processing.

What needs to be in order for users to build reports whose data is located on a different server than SQL Server 2005?

Thanks for your help,
RoyMy guess is you are using Windows Integrated Authentication for connection to both the model and its data source. This won't work if you have two "hops". The typical practice is to store credentials for a user with read-only access to the database on the datasource, and use integrated authentication on the model.

Problem with 'Reply-To' in data driven subscription

I am running SQL Server 2000 sp4 and Reporting Services 2000 sp2. I set
up a data driven subscription with a static Reply-To address. However,
when the report runs, the reply is the default in the config file.
I've seen 1 other post on this but no solution. Help would be
appreciated.
NeilI captured this info using SQL Profiler:
exec CreateSubscription @.Report_Name =N'/WebInvoiceStatus_Reports/VendorActivity', @.id ='86750772-3D96-4059-8B1E-9F5F5D6C8000', @.OwnerSid =0x01050000000000051500000093E362480D7A5A33828BA628CA300100, @.OwnerName
= N'US\A0312698', @.OwnerAuthType = 1, @.Locale = N'en-US',
@.DeliveryExtension = N'Report Server Email', @.InactiveFlags = 0,
@.ExtensionSettings =N'<ParameterValues><ParameterValue><Name>TO</Name><Field>EmailAddress</Field></ParameterValue><ParameterValue><Name>ReplyTo</Name><Value>aphelp@.abcdef.com</Value>...
This shows that the value I wanted was being picked up. So I wonder if
the problem is with the smtp.
Neil|||My issue is not with the 'Reply-To' I just discovered.
It is the 'From' that I have been trying to change and that cannot be
done for each subscription.
The From did change when I changed it in the config file.
I love solving my own problems.
Neil

Problem with ProClarity analystics 6 for SQL Server 2005 reporting services

Hi, all here,

Thank you very much for your kind attention.

I'v got a problem with Microsoft ProClarity for SQL Server 2005 reporting services as below:

Created a 3-D effect reports (which are views in ProClarity professional ) and exported it into SQL Server 2005 reporting services, but the result in SQL Server 2005 reporting serivces is totally different, no 3-D result, and also the color of the report has totally changed, for better result in SQL Server 2005, I have to manually modify the reporting file in reporting services.

Another problem is: the views created in ProClarity always change colors (the colors I think are aweful) after exported into SQL Server 2005 reporting services.

Can any expert for that give me any adives for that? What can we try to solve this problem?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

I recommend http://www.proclarity.com/services/support.asp for these problems.

Regards

Thomas Ivarsson

|||

Thanks a lot.

With best regards,

Problem with ProClarity analystics 6 for SQL Server 2005 reporting services

Hi, all here,

Thank you very much for your kind attention.

I'v got a problem with Microsoft ProClarity for SQL Server 2005 reporting services as below:

Created a 3-D effect reports (which are views in ProClarity professional ) and exported it into SQL Server 2005 reporting services, but the result in SQL Server 2005 reporting serivces is totally different, no 3-D result, and also the color of the report has totally changed, for better result in SQL Server 2005, I have to manually modify the reporting file in reporting services.

Another problem is: the views created in ProClarity always change colors (the colors I think are aweful) after exported into SQL Server 2005 reporting services.

Can any expert for that give me any adives for that? What can we try to solve this problem?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

I recommend http://www.proclarity.com/services/support.asp for these problems.

Regards

Thomas Ivarsson

|||

Thanks a lot.

With best regards,

Problem with printing

Hi! I recently begin to use reporting tools of SLQ 2005 instead of AR or CR. I found the DUI very easy to use and I'm partially sastify beause when I try to print my report, the printer always blow out a second white page. For one page report I can live with that but for 156 page report it's becoming a lot annoing. Is there somebody who experience the same problem? And by the way resolve it?

Here the dexcription of the report:

Is a list grouped by clientId with a sub report getting the clientId from the parent one as the parameter. Event with the insert page break after list true or false the result is the same while printing.

Thx you very much

Daniel

This has to do with the sum of your margins and page settings must not exceed the portrait / landscape settings in your report. The link below gives a good example of this.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1259621&SiteID=1

|||That resolve my problem thank you very much.|||

Glad to help. Please remember to mark the correct answer as "Mark as answer". This will aid others searching for similar problems and issues.

Thanks!