Newbie question on identically named fields in a dataset

This is my first stab at this. I have a simple report that returns a few
columns from a database no sp no expressions just a select statement. There
are two tables that have the same field name and the dataset canâ't seem to
distinguish between them it returns the first field into both columns. When
I run it in Query Analyzer it looks fine. What am I missing here?Query Analyzer seems to be a bit more forgiving about identical names. In
your query, just use Aliases, and you should be ok.
A query like
"Select table1.col1 as Table1Col1, table2.Col1 as Table2Col1 from Table1,
Table2 (...)"
should give you fields named Table1Col1 and Table2Col1. A bit more trouble
to write, but you eliminate possible errors.
Kaisa M. Lindahl
"RYF" <RYF@.discussions.microsoft.com> wrote in message
news:BD3D2857-937A-4602-80AD-C472FB295245@.microsoft.com...
> This is my first stab at this. I have a simple report that returns a few
> columns from a database no sp no expressions just a select statement.
> There
> are two tables that have the same field name and the dataset can't seem to
> distinguish between them it returns the first field into both columns.
> When
> I run it in Query Analyzer it looks fine. What am I missing here?|||THX that did the trick!
"Kaisa M. Lindahl" wrote:
> Query Analyzer seems to be a bit more forgiving about identical names. In
> your query, just use Aliases, and you should be ok.
> A query like
> "Select table1.col1 as Table1Col1, table2.Col1 as Table2Col1 from Table1,
> Table2 (...)"
> should give you fields named Table1Col1 and Table2Col1. A bit more trouble
> to write, but you eliminate possible errors.
> Kaisa M. Lindahl
> "RYF" <RYF@.discussions.microsoft.com> wrote in message
> news:BD3D2857-937A-4602-80AD-C472FB295245@.microsoft.com...
> > This is my first stab at this. I have a simple report that returns a few
> > columns from a database no sp no expressions just a select statement.
> > There
> > are two tables that have the same field name and the dataset can't seem to
> > distinguish between them it returns the first field into both columns.
> > When
> > I run it in Query Analyzer it looks fine. What am I missing here?
>
>

Newbie Question on =Today()

I need to pull some reports from an older ERP system in the US via ODBC
I have the report in play, but want to limit the criteria to the items
shipped today
I have a TODAY_FIELD as a calculated Field with the parameter =TODAY()
The Format of the Oracle view is mm/dd/yyyy hh:mm:ss AM and the
TODAY_FIELD
matches that. (ie 8/30/2006 12:00:00 AM)
So I am looking for the criteria for WHERE (REAL_SHIP_DATE >
TODAY()) which will not generate and ORA-00904 error.
Can anyone please help?getdate() is the system date to use. Or am I understanding what you want
wrong?
"VB" <vodkablokey@.gmail.com> wrote in message
news:1156941597.512536.214380@.b28g2000cwb.googlegroups.com...
>I need to pull some reports from an older ERP system in the US via ODBC
> I have the report in play, but want to limit the criteria to the items
> shipped today
> I have a TODAY_FIELD as a calculated Field with the parameter =TODAY()
> The Format of the Oracle view is mm/dd/yyyy hh:mm:ss AM and the
> TODAY_FIELD
> matches that. (ie 8/30/2006 12:00:00 AM)
> So I am looking for the criteria for WHERE (REAL_SHIP_DATE >
> TODAY()) which will not generate and ORA-00904 error.
> Can anyone please help?
>|||Ben Watts wrote:
> getdate() is the system date to use. Or am I understanding what you want
> wrong?
> "VB" <vodkablokey@.gmail.com> wrote in message
> news:1156941597.512536.214380@.b28g2000cwb.googlegroups.com...
> >I need to pull some reports from an older ERP system in the US via ODBC
> >
> > I have the report in play, but want to limit the criteria to the items
> > shipped today
> >
> > I have a TODAY_FIELD as a calculated Field with the parameter =TODAY()
> >
> > The Format of the Oracle view is mm/dd/yyyy hh:mm:ss AM and the
> > TODAY_FIELD
> > matches that. (ie 8/30/2006 12:00:00 AM)
> >
> > So I am looking for the criteria for WHERE (REAL_SHIP_DATE >
> > TODAY()) which will not generate and ORA-00904 error.
> >
> > Can anyone please help?
> >
I am looking to report all shipping transactions (TRANSACTION_CODE ='OESHIP') which have happened since Midnight.
I know = TODAY() will give you 12:00am today, how do I pass this as a
criteria to a ODBC database call?
I had tried =TODAY() but this is rejected, it seems to suggest I need
to use TO_DATE, but I don't know how to do this either.
Thanks for getting back though :)|||Try:
WHERE REAL_SHIP_DATE > CAST( CONVERT( VARCHAR(8), GETDATE(), 112) AS DATETIME)
This takes the the curent system time, as suggested by Ben, chops of the
time and returns a DateTime value at the very start of the day, similar to
the vb Today() function.
HTH,
Magendo_man
"VB" wrote:
> Ben Watts wrote:
> > getdate() is the system date to use. Or am I understanding what you want
> > wrong?
> > "VB" <vodkablokey@.gmail.com> wrote in message
> > news:1156941597.512536.214380@.b28g2000cwb.googlegroups.com...
> > >I need to pull some reports from an older ERP system in the US via ODBC
> > >
> > > I have the report in play, but want to limit the criteria to the items
> > > shipped today
> > >
> > > I have a TODAY_FIELD as a calculated Field with the parameter =TODAY()
> > >
> > > The Format of the Oracle view is mm/dd/yyyy hh:mm:ss AM and the
> > > TODAY_FIELD
> > > matches that. (ie 8/30/2006 12:00:00 AM)
> > >
> > > So I am looking for the criteria for WHERE (REAL_SHIP_DATE >
> > > TODAY()) which will not generate and ORA-00904 error.
> > >
> > > Can anyone please help?
> > >
> I am looking to report all shipping transactions (TRANSACTION_CODE => 'OESHIP') which have happened since Midnight.
> I know = TODAY() will give you 12:00am today, how do I pass this as a
> criteria to a ODBC database call?
> I had tried =TODAY() but this is rejected, it seems to suggest I need
> to use TO_DATE, but I don't know how to do this either.
> Thanks for getting back though :)
>|||magendo_man wrote:
> Try:
> WHERE REAL_SHIP_DATE > CAST( CONVERT( VARCHAR(8), GETDATE(), 112) AS DATETIME)
> This takes the the curent system time, as suggested by Ben, chops of the
> time and returns a DateTime value at the very start of the day, similar to
> the vb Today() function.
> HTH,
> Magendo_man
> "VB" wrote:
> >
> > Ben Watts wrote:
> > > getdate() is the system date to use. Or am I understanding what you want
> > > wrong?
> > > "VB" <vodkablokey@.gmail.com> wrote in message
> > > news:1156941597.512536.214380@.b28g2000cwb.googlegroups.com...
> > > >I need to pull some reports from an older ERP system in the US via ODBC
> > > >
> > > > I have the report in play, but want to limit the criteria to the items
> > > > shipped today
> > > >
> > > > I have a TODAY_FIELD as a calculated Field with the parameter =TODAY()
> > > >
> > > > The Format of the Oracle view is mm/dd/yyyy hh:mm:ss AM and the
> > > > TODAY_FIELD
> > > > matches that. (ie 8/30/2006 12:00:00 AM)
> > > >
> > > > So I am looking for the criteria for WHERE (REAL_SHIP_DATE >
> > > > TODAY()) which will not generate and ORA-00904 error.
> > > >
> > > > Can anyone please help?
> > > >
> >
> > I am looking to report all shipping transactions (TRANSACTION_CODE => > 'OESHIP') which have happened since Midnight.
> >
> > I know = TODAY() will give you 12:00am today, how do I pass this as a
> > criteria to a ODBC database call?
> >
> > I had tried =TODAY() but this is rejected, it seems to suggest I need
> > to use TO_DATE, but I don't know how to do this either.
> >
> > Thanks for getting back though :)
> >
> >
THanks, that would do the trick.
When I try it though I get a new error, INVALID or MISSING EXPRESSION
Any ideas?|||VB wrote:
> magendo_man wrote:
> > Try:
> >
> > WHERE REAL_SHIP_DATE > CAST( CONVERT( VARCHAR(8), GETDATE(), 112) AS DATETIME)
> >
> > This takes the the curent system time, as suggested by Ben, chops of the
> > time and returns a DateTime value at the very start of the day, similar to
> > the vb Today() function.
> >
> > HTH,
> > Magendo_man
> >
> > "VB" wrote:
> >
> > >
> > > Ben Watts wrote:
> > > > getdate() is the system date to use. Or am I understanding what you want
> > > > wrong?
> > > > "VB" <vodkablokey@.gmail.com> wrote in message
> > > > news:1156941597.512536.214380@.b28g2000cwb.googlegroups.com...
> > > > >I need to pull some reports from an older ERP system in the US via ODBC
> > > > >
> > > > > I have the report in play, but want to limit the criteria to the items
> > > > > shipped today
> > > > >
> > > > > I have a TODAY_FIELD as a calculated Field with the parameter =TODAY()
> > > > >
> > > > > The Format of the Oracle view is mm/dd/yyyy hh:mm:ss AM and the
> > > > > TODAY_FIELD
> > > > > matches that. (ie 8/30/2006 12:00:00 AM)
> > > > >
> > > > > So I am looking for the criteria for WHERE (REAL_SHIP_DATE >
> > > > > TODAY()) which will not generate and ORA-00904 error.
> > > > >
> > > > > Can anyone please help?
> > > > >
> > >
> > > I am looking to report all shipping transactions (TRANSACTION_CODE => > > 'OESHIP') which have happened since Midnight.
> > >
> > > I know = TODAY() will give you 12:00am today, how do I pass this as a
> > > criteria to a ODBC database call?
> > >
> > > I had tried =TODAY() but this is rejected, it seems to suggest I need
> > > to use TO_DATE, but I don't know how to do this either.
> > >
> > > Thanks for getting back though :)
> > >
> > >
> THanks, that would do the trick.
> When I try it though I get a new error, INVALID or MISSING EXPRESSION
> Any ideas?
SOrry Folks, I realised (eventually) instead of trying to re-invent the
wheel I should just create a view in the database with the sysdate -1
call and just report the view.

Newbie Question accessing values in other data regions

Hi,
i have a simple report that has two data regions,
i want to use a calculated field in one data region that refers to a
field in the other region.
how do i achieve this?
sql server 2000 RS 2000
regardsThink of RS data regions as repeaters that expand to show all rows in the
underlying dataset. So, a data region cell is relative since its position is
known only during runtime. It is like trying to link two database tables
that don't have a common key. For this reason, you can only get an
aggregated value from another region, e.g. Sum(Fields!FieldName.Value).
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"cg" <colingresty@.yahoo.co.uk> wrote in message
news:1131975339.742358.216470@.z14g2000cwz.googlegroups.com...
> Hi,
> i have a simple report that has two data regions,
> i want to use a calculated field in one data region that refers to a
> field in the other region.
> how do i achieve this?
> sql server 2000 RS 2000
> regards
>|||thanks Teo,
that makes things a bit clearer.

Newbie question about sprocs

When I run my stored proceedure in query analyzer and copy the text to the pane in the report designer, all is well, but if I run the same stored proceedure as a stored procedure in the report designer it doesn't return all the fields that it does as text. What's the difference? What do I do to fix this?Two things come to mind. Ownership and location of the stored procedure.
OWNERSHIP:
Objects like tables, views, and stored procedures can be owned by different
logins.
Lets say you have two users in your database
user1
user2
They can both create a table called FOO
Each table can have different columns.
Each user can also create a stored procedure named procFOO
These stored procedures can return different columns.
LOCATION OF THE STORED PROCEDURE:
It is possible to create stored procedures in multiple databases. For
example, procFOO within northwind could select from the Products table and
procFOO within pubs could select from the authors table. Are you calling
the stored procedure from the database that you created it in (and are
running it from Query Analyzer)?
--
Keith
"Arly" <Arly@.discussions.microsoft.com> wrote in message
news:8F8426EB-7C6C-49C5-9C8F-825EB089A880@.microsoft.com...
> When I run my stored proceedure in query analyzer and copy the text to the
pane in the report designer, all is well, but if I run the same stored
proceedure as a stored procedure in the report designer it doesn't return
all the fields that it does as text. What's the difference? What do I do to
fix this?|||So I hit the nail on the head; was it an ownership or a location issue?
--
Keith
"Arly" <Arly@.discussions.microsoft.com> wrote in message
news:8EC3378E-037A-4C6A-93BE-7367603FDBE3@.microsoft.com...
> Thanks you were a great help. All is well!
> "Keith Kratochvil" wrote:
> > Two things come to mind. Ownership and location of the stored
procedure.
> >
> > OWNERSHIP:
> > Objects like tables, views, and stored procedures can be owned by
different
> > logins.
> > Lets say you have two users in your database
> > user1
> > user2
> > They can both create a table called FOO
> > Each table can have different columns.
> > Each user can also create a stored procedure named procFOO
> > These stored procedures can return different columns.
> >
> > LOCATION OF THE STORED PROCEDURE:
> > It is possible to create stored procedures in multiple databases. For
> > example, procFOO within northwind could select from the Products table
and
> > procFOO within pubs could select from the authors table. Are you
calling
> > the stored procedure from the database that you created it in (and are
> > running it from Query Analyzer)?
> >
> > --
> > Keith
> >
> >
> > "Arly" <Arly@.discussions.microsoft.com> wrote in message
> > news:8F8426EB-7C6C-49C5-9C8F-825EB089A880@.microsoft.com...
> > > When I run my stored proceedure in query analyzer and copy the text to
the
> > pane in the report designer, all is well, but if I run the same stored
> > proceedure as a stored procedure in the report designer it doesn't
return
> > all the fields that it does as text. What's the difference? What do I do
to
> > fix this?
> >
> >

Newbie Question about Events

Hello,
I have a report in an .aspx page. When the user expands the row the records
display correctly except when there are a ton of records (1500 or more).
Does anyone know a way to display the records in another page when the user
expands a row?
Thanks,
JohnOn Jun 4, 11:18 am, John <J...@.discussions.microsoft.com> wrote:
> Hello,
> I have a report in an .aspx page. When the user expands the row the records
> display correctly except when there are a ton of records (1500 or more).
> Does anyone know a way to display the records in another page when the user
> expands a row?
> Thanks,
> John
You can either use a subreport or you can use drill-through or Jump to
URL or Report (via right-clicking the cell/etc to jump through and
select the Navigation tab and link to a new report/etc). Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Newbie question - Syntax for passing parameters to a sub report

Hey, I've looked pretty much everywhere I could, but I am unable to
figure out the correct syntax for my problem.
I have a main report that I am running with a stored procedure.
I also have a sub report that I am running with the same stored
procedure.
The stored procedure has 3 parameters. (a session identifier, an
operator, and a language code)
Here are the steps I have taken so far...
- added the subreport to my main report
- right click on the subreport (in the layout view) and click
Properties; then select the parameters tab.
- not sure what to do here.
** NOTE reportName is clients and the subreport is has the reportName
subClients
I thought the syntax would be... (main report)
Parameter Name: SubClients!@.SessionID
Parameter Value: =Parameters!SessionID.Value
(subreport)
Parameter Name: @.SessionID
Parameter Value: =Parameters!SessionID.Value
This doesn't work. I get this following error message...
A parameter in the subreport ?SubClients' has the name
?SubClients!SessionID.Value'. Parameter names must be CLS-compliant
identifiers.
This error and I also got a few others - not sure what to do.
Please help me, someone, anyone.
Thank you in advance.
Ciao
RobClick on expression when you are mapping the parameters of the subreport.
That wil bring you to the expression builder.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob" <buju8@.yahoo.com> wrote in message
news:3cff8d2d.0501131505.5862fa69@.posting.google.com...
> Hey, I've looked pretty much everywhere I could, but I am unable to
> figure out the correct syntax for my problem.
> I have a main report that I am running with a stored procedure.
> I also have a sub report that I am running with the same stored
> procedure.
> The stored procedure has 3 parameters. (a session identifier, an
> operator, and a language code)
> Here are the steps I have taken so far...
> - added the subreport to my main report
> - right click on the subreport (in the layout view) and click
> Properties; then select the parameters tab.
> - not sure what to do here.
> ** NOTE reportName is clients and the subreport is has the reportName
> subClients
> I thought the syntax would be... (main report)
> Parameter Name: SubClients!@.SessionID
> Parameter Value: =Parameters!SessionID.Value
> (subreport)
> Parameter Name: @.SessionID
> Parameter Value: =Parameters!SessionID.Value
> This doesn't work. I get this following error message...
> A parameter in the subreport 'SubClients' has the name
> 'SubClients!SessionID.Value'. Parameter names must be CLS-compliant
> identifiers.
>
> This error and I also got a few others - not sure what to do.
> Please help me, someone, anyone.
> Thank you in advance.
> Ciao
> Rob

newbie Question - Grouping charts?

Hi - can anyone help me with the best way to group & repeat charts?
The scenario is that I have 3 different CPU capacity report charts ran on 20
different servers & I want to group the reports together by server so it
will look like:
Server1
CPU Chart1
CPU Chart2
CPUChart3
Server2
CPUChart1
CPUChart2
CPUChart3
......
I can set up grouping by server on a table & produce the CPUReport1 chart
for each server but I cannot add CPUReport2 to the table as it is based on a
different dataset.
I'm sure there must be a technique to do this kinda thing but I haven't been
using reporting services for long & I can't figure it out!
Any ideas much appreciated!
Thanks
Mike KneeDid you tried subreport? that will solve this kind of requirement.
"Michael Knee" wrote:
> Hi - can anyone help me with the best way to group & repeat charts?
> The scenario is that I have 3 different CPU capacity report charts ran on 20
> different servers & I want to group the reports together by server so it
> will look like:
> Server1
> CPU Chart1
> CPU Chart2
> CPUChart3
> Server2
> CPUChart1
> CPUChart2
> CPUChart3
> ......
> I can set up grouping by server on a table & produce the CPUReport1 chart
> for each server but I cannot add CPUReport2 to the table as it is based on a
> different dataset.
> I'm sure there must be a technique to do this kinda thing but I haven't been
> using reporting services for long & I can't figure it out!
> Any ideas much appreciated!
> Thanks
> Mike Knee
>
>|||Cool - I will give that a look, thanks
"Bava Mani" <BavaMani@.discussions.microsoft.com> wrote in message
news:82B6ABAF-AE51-44B8-8BA5-FABDF26DDB48@.microsoft.com...
> Did you tried subreport? that will solve this kind of requirement.
> "Michael Knee" wrote:
>> Hi - can anyone help me with the best way to group & repeat charts?
>> The scenario is that I have 3 different CPU capacity report charts ran on
>> 20
>> different servers & I want to group the reports together by server so it
>> will look like:
>> Server1
>> CPU Chart1
>> CPU Chart2
>> CPUChart3
>> Server2
>> CPUChart1
>> CPUChart2
>> CPUChart3
>> ......
>> I can set up grouping by server on a table & produce the CPUReport1 chart
>> for each server but I cannot add CPUReport2 to the table as it is based
>> on a
>> different dataset.
>> I'm sure there must be a technique to do this kinda thing but I haven't
>> been
>> using reporting services for long & I can't figure it out!
>> Any ideas much appreciated!
>> Thanks
>> Mike Knee
>>

newbie question - DDDW in RS

hi,
I'm a RS newbie and trying to convert powerbuilder report to RS.
Is there a dropdown datawindow (DDDW) function in RS?
I mean can I use DDDW in a column(eg. department id) to retrieve code name
(eg department )
from a code table.
I have so many code id columns to join code table and I don't wanna use join
in SQL.
TIAReport parameters can be based on a query.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"steffi" <steffibev@.hotmail.com> wrote in message
news:O34bWe1RFHA.3716@.TK2MSFTNGP14.phx.gbl...
> hi,
> I'm a RS newbie and trying to convert powerbuilder report to RS.
> Is there a dropdown datawindow (DDDW) function in RS?
> I mean can I use DDDW in a column(eg. department id) to retrieve code
name
> (eg department )
> from a code table.
> I have so many code id columns to join code table and I don't wanna use
join
> in SQL.
> TIA
>
>

Newbie Question

Hi Guys,

I am new to this Reporting Service world. May be its very simple question.

I have create a report in SQL Server 2005 reporting services and want to link this report with aspx page. How I do this. Just want to link report with default.aspx page so when this page open report also open automatically.

Please let me guide how could I do this.

Regards

I would recommend using the ASP.net ReportViewer control. It will make the web app appear much more polished than just linking to the reportmanager.|||If you don not want anything to change programmtically you can also just display the appropiate report in your frame targeting to the URL of you report on the ReportServer interface. (The one that you see if you navigate through the webservice http://Server/reportserver, e.g. http://server/reportserver?Somefolder/Report&Parameter=SomeValue)

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de|||

Greate!! Thanks for your reply.

I pasted a report control on my aspx page but how I link my report with this page. I used the below code but it giving me error message

ReportViewer1.LocalReport.ReportEmbeddedResource = @.\\Business\Business\RPT825.rdl; (This is my local machine path)

and the Error message is

An error occurred during local report processing.|||

Hi Guys,

Please ignore my previous email. I have fixed the above issue. Now I don't know how to pass a parameter value to a report.

I wrote the below line in my aspx page and when I ran this application it gives me a error message

"The rDate parameter is missing a value"

Below is the code that I wrote in my page_load event

ReportViewer1.LocalReport.ReportPath = @."C:\Business\RPT825.rdl";

Could you please let me know how to pass parameter value to a report.

Regards

|||

ReportViewer1.LocalReport.SetParameters( );

Juran

sql

Newbie Question

I want to load a dropdown list based on another dropdown selection.Iam not sure how to do this.

Both are report parameters.Based on one parameter i need to load another parameter.

Can someone help me.

Thanks in advance

mahalaks.

hello,

I believe in the properties for the drop down, you can define a constraint (drop down), which is where you set that up.

Brian

|||

Both dropdown boxes are report parameters.

Based on the report parameters dropdown boxes are coming.

No properties can be set for this.

Newbie question

When the installation of the Enterprizd edition completed
there was a message as follows
Setup could not initialize the report server. You must
manually initialize the report server beforeusing it for
the first time. For more information , seethe Reporting
Services setup documentaion.
I looked through the readme doc bit did not see anything
about this. Can anyone tell me what this means?I found the command window command to initialize the
report server
rsactivate -c"%installdir%\Reporting
Services\ReportServer\RSReportServer.config"
It reurned a message saying that
" Failure to start the web service. The Report Server
Web Service has not generated a public key. The
Servermay not have started sucessfully. Check the log
files for more information.
>--Original Message--
>When the installation of the Enterprizd edition
completed
>there was a message as follows
>Setup could not initialize the report server. You must
>manually initialize the report server beforeusing it for
>the first time. For more information , seethe Reporting
>Services setup documentaion.
>I looked through the readme doc bit did not see anything
>about this. Can anyone tell me what this means?
>.
>|||I believe the documentation states that you aren't supposed to have to
activate and install of RS unless installing in a web farm configuration.
However, I ran into this problem when installing a non web farm install of
RS.
I was able to overcome this by accessing the report manager or report
service with a user account that has administrative priviledges. Initially,
I was using a lower priviledge account to execute reports programmatically
which was failing. Once I hit the service with an Admin account, it
activated and then my lower priviledge account worked fine after that for
what I needed it to do.
Dale
"jim abel" <jim.abel@.lmco.com> wrote in message
news:2d4e101c469b1$0889e840$a301280a@.phx.gbl...
> When the installation of the Enterprizd edition completed
> there was a message as follows
> Setup could not initialize the report server. You must
> manually initialize the report server beforeusing it for
> the first time. For more information , seethe Reporting
> Services setup documentaion.
> I looked through the readme doc bit did not see anything
> about this. Can anyone tell me what this means?

Newbie Question

I'm new to Reporting Services 2005. My question is this. Say I create a
report that retrieves data from database "xyz". Assume also that identical
copies of database "xyz" (identical in schema, not in the data it contains)
might be sitting on many different servers, servicing different clients. Is
it a simple matter to simply change the connection string of the report and
have it retrieve data from a different server the database is sitting on?
I guess what I'm really wondering is what sort of data sits in the
'ReportServer' database and does this data need to get moved to the same
ReportServer database on each server I want to run the report against? If
this is not the case, and I'm hoping it's not, what data actually gets
stored in the 'ReportServer' database.
Thanks.
Amos.The ReportServer database stores the metadata and the catalog.
I does not stores the data used by your reports
I your case, changing the connection string should be enough
Med Bouchenafa
"Amos Soma" <amos_j_soma@.yahoo.com> a écrit dans le message de news:
eehPKcEJGHA.984@.tk2msftngp13.phx.gbl...
> I'm new to Reporting Services 2005. My question is this. Say I create a
> report that retrieves data from database "xyz". Assume also that identical
> copies of database "xyz" (identical in schema, not in the data it
> contains) might be sitting on many different servers, servicing different
> clients. Is it a simple matter to simply change the connection string of
> the report and have it retrieve data from a different server the database
> is sitting on?
> I guess what I'm really wondering is what sort of data sits in the
> 'ReportServer' database and does this data need to get moved to the same
> ReportServer database on each server I want to run the report against? If
> this is not the case, and I'm hoping it's not, what data actually gets
> stored in the 'ReportServer' database.
> Thanks.
> Amos.
>

Newbie Question

How do I create a report in SQL?
I have a database created with a table that has names
I would like to print the table out by last name in ascending order.
Any ideas or help?
Thanks
Tom
----
I am using the free version of SPAMfighter for private users.
It has removed 61 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!If I'm understanding you correctly, you will want to open the Business
Intelligence Development environment, create a new reporting services
project and follow the report creation wizard and for the query enter
something like:
select * from NamesTable order by names
Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer
Thomas Grassi wrote:
> How do I create a report in SQL?
> I have a database created with a table that has names
> I would like to print the table out by last name in ascending order.
> Any ideas or help?
> Thanks
> Tom
> ----
> I am using the free version of SPAMfighter for private users.
> It has removed 61 spam emails to date.
> Paying users do not have this message in their emails.
> Try SPAMfighter for free now!|||The way you have asked, I can make out your are very new... to SSRS..
Anyways the great way to start SSRS is to go to SQL 2005 online help
find "Reporting Services Tutorial" from the left pane and select the
"Creating a Basic Report" and go through all the 6 lessons, they are very
simple and you can start using RS for your purpose.
Amarnath, MCTS.
"Thomas Grassi" wrote:
> How do I create a report in SQL?
> I have a database created with a table that has names
> I would like to print the table out by last name in ascending order.
> Any ideas or help?
> Thanks
> Tom
> ----
> I am using the free version of SPAMfighter for private users.
> It has removed 61 spam emails to date.
> Paying users do not have this message in their emails.
> Try SPAMfighter for free now!
>
>

Newbie Problems Configuring Report Server

I have SQL 2005 with SP 1. I am in the reporting services configuration
manager and I am at the point where the following options have green circles
with checkmarks:
Server Status
Report Server Virtual Directory
Report Manager Virtual Directory
Windows Service Identity
Web Service Identity
Database Setup
Encryption Keys is a blue circle with an exclamation point with the choices
Backup, Restore, Change and Delete. I choose Backup and gave the key a
password and clicked ok but the applied button at the bottom stayed grayed
out.
Below the Encryption Keys button is Initialization and that is in a gray
circle with a checkmark. Since it is gray I can not select it.
What is it that the configuration manager is waiting for me to do?
I tried going into the SQL Server Management Studio to see if I could
connect to the Report Server from there. I get an error message saying
"Cannot connect to RBDS01. The request failed with HTTP Status 400: Bad
Request. (Microsoft.SqlServer.Management.UI.RSClient)
I would appreciate any ideas as to what I need to do so that I can connect
to the Report Server?
Thanks.
Rick Bellefond
RB Data Services
www.rbdata.comIf the "server status" shows green then it is ok that your server is
connecting. encryption is optional it creates automatically so if you want
to change or take backup this can be done using this option.
otherwise it should work seeing the green check mark on "server status" Hope
you are connecting to the same server you configured. ie (RBDS01)
Go to surface area and check for the network enabled in which you are
accesing ie tcp/ip.
Amarnath
"Rick" wrote:
> I have SQL 2005 with SP 1. I am in the reporting services configuration
> manager and I am at the point where the following options have green circles
> with checkmarks:
> Server Status
> Report Server Virtual Directory
> Report Manager Virtual Directory
> Windows Service Identity
> Web Service Identity
> Database Setup
> Encryption Keys is a blue circle with an exclamation point with the choices
> Backup, Restore, Change and Delete. I choose Backup and gave the key a
> password and clicked ok but the applied button at the bottom stayed grayed
> out.
> Below the Encryption Keys button is Initialization and that is in a gray
> circle with a checkmark. Since it is gray I can not select it.
> What is it that the configuration manager is waiting for me to do?
> I tried going into the SQL Server Management Studio to see if I could
> connect to the Report Server from there. I get an error message saying
> "Cannot connect to RBDS01. The request failed with HTTP Status 400: Bad
> Request. (Microsoft.SqlServer.Management.UI.RSClient)
> I would appreciate any ideas as to what I need to do so that I can connect
> to the Report Server?
> Thanks.
>
> Rick Bellefond
> RB Data Services
> www.rbdata.com
>

Newbie pie chart report problem

Hi, I've just started using Pie Charts and I'm stuck on a value problem (I think!). My category will be "Connection Status", and the values can be: success:human; success:machine; Connected; Null.

What I want to do is merge the "success:human" and "connected" values into one slice of pie. Is this possible?

Thanks, Dan

Sorry, I was confused, just needed to change the SQL to include both values.

Newbie needs a hand with SQL2005 Reports

I'm trying to run some reports on SQL 2005, but can't even pass the first step of launching the report builder. I have SQL2005 on my local machine, but the report server is installed on a remote server. I launched SQL Business Intelligence Development Studio, which brings Visual studio, but i keep getting a prompt to enter a connection string. How do i get the connection string, or how do i set up my datasource?

Help!

To answer your question, try the following, but i think you need to configure 'iis', as well as 'reporting services configuration' before hand:

open sql server business intelligence studio
file
new
project
report server project
ok
view
solution explorer
right click reports
add
new item
data source
add
edit
<enter your database details here>

...and so on

look up the microsoft tutorial for creating a basic report in 'sql server business intelligence studio' help

Newbie needing help ASAP with width issue in sql report.

I am building a Sql Report in VS.net 2006 I have run into an issue I have 258 colums it am using the wizard table generator in design mode. the problem is the screen will on allow 160 inches wide I need to mak this larger to 300 inches the purpose of the report is to sort data and them save to csv format is there a better way or can some on tell me how to increase the size of the width the properties tab will not allow me to explain pass 160 inches. Some one please help me thanksWhy not tackle the job another way ? Have a look at http://www.codeproject.com/useritems/filehelpers.asp "An easy to use .NET library to read/write strong typed data from fileswith fixed length or delimited records (CSV). Also has support toimport/export data from different data storages (Excel, Acces,SqlServer, MySql)"|||The issue I am having is a task was given to me to pull data from an invoice module out of SQL and creat a 288 field output of data in a csv format. The problem is we on have about 100 fields data the rest have to be blank and all this has to be in an order so . I was going to build a report in th sql reports in my business intell create the headers for all 288 files and create the expression in the correct placement create several sort paramerters then I was going to just save as csv format this would create the csv file with the correct order and blank fields separated by the commas. the problem is I dont know how to creat empty fields on an output to csv.|||

Suppose your table FRED has three fields A, C and D and you want to output 5, use:

SELECT A, ' ' AS B, C, ' ' AS D, E FROM FRED

That will create 2 empty fields - you can readily extend the technique to create 188 blank fields.

|||

Thank youy this makes sense. The only question is I may need it to look like this

"john", "Smith","","","","","","","404","555-5555","123 Main Street","","completed",

If I under stand the your code I can select A,B,' ' AS C,' ' AS D,' ' AS E, ' ' AS F, ' ' AS G, ' ' AS H,I,J,K,' ' AS L,M FROM TABLE

|||

>>The only question is I may need it to look like this: "john", "Smith","","","","","","","404","555-5555","123 Main Street","","completed",
The quoting takes places aroung each value, whether it is occupied or empty.

>>If I under stand the your code I can select A,B,' ' AS C,' ' AS D,' ' AS E, ' ' AS F, ' ' AS G, ' ' AS H,I,J,K,' ' AS L,M FROM TABLE

Yes! I put a space between the quote marks for clarity; you will not need to do this.

Newbie Need help with tsql query

I am tring to use this tsql query in a sql 2005 report it keeps giving me the error below. This query works in my ms sql 2000 ok but I keep getting this error in the 2005. Can some one look at this and tell me what I am doing wrong. Thank you.

There is an error in the query. Incorrect syntax near '('.

SELECT
DISTINCT
JOB.JOBID,
JOB.*,
PAYER.PAY_COMPANY,
PATIENT.SSN,
PATIENT.LASTNAME,
PATIENT.FIRSTNAME,
PATIENT.MIDDLENAME,
PATIENT.AM_PHONE,
PATIENT.EMAIL,
JOB_OUTCOME.DESCRIPTION AS 'JOB_OUTCOME_DESC'

FROM
(((((JOB LEFT JOIN PATIENT ON JOB.PATIENTID = PATIENT.PATIENTID)
( LEFT JOIN PAYER ON JOB.PAYERID = PAYER.PAYERID)
( LEFT JOIN REFERRAL_SOURCE AS ADJUSTER ON JOB.ADJUSTER.REFERRAL_ID)
( LEFT JOIN REFERRAL_SOURCE AS CM ON JOB.CASEMANAGERID = CM.REFERRAL_ID)
( LEFT JOIN JOB_OUTCOME ON JOB.JOBOUTCOMEID = JOB_OUTCOME_ID)

WHERE
(JOB.APPT_DATE BETWEEN @.STARTDATE AND @.ENDDATE)

AND (JOB.TRANSPORTATION = '1')

AND (AREACOORDINATOR = '138')

ORDER BY
JOB.APPT_DATE DESC;

In this line

FROM
(((((JOB LEFT JOIN PATIENT ON JOB.PATIENTID = PATIENT.PATIENTID)

there are five (5) opening parentheses, but ONLY one of them is closed.

This could NOT have worked in SQL 2000 either.

Please post the ENTIRE query so that we may better assist you.

|||

Sorry I pasted the wrong one The 5 ( are becuase the opens before the left look at it again. This works just fine in sql 2000 in a cold fusion application I am using this in sql 2005 with a asp.net application.

There is an error in the query. An expression of non-boolean type specified in a context where a condition is expected, near ')'.

SELECT
DISTINCT
JOB.JOBID,
JOB.*,
PAYER.PAY_COMPANY,
PATIENT.SSN,
PATIENT.LASTNAME,
PATIENT.FIRSTNAME,
PATIENT.MIDDLENAME,
PATIENT.AM_PHONE,
PATIENT.EMAIL,
JOB_OUTCOME.DESCRIPTION AS 'JOB_OUTCOME_DESC'

FROM
(((((JOB LEFT JOIN PATIENT ON JOB.PATIENTID = PATIENT.PATIENTID)
LEFT JOIN PAYER ON JOB.PAYERID = PAYER.PAYERID)
LEFT JOIN REFERRAL_SOURCE AS ADJUSTER ON JOB.ADJUSTER.REFERRAL_ID)
LEFT JOIN REFERRAL_SOURCE AS CM ON JOB.CASEMANAGERID = CM.REFERRAL_ID)
LEFT JOIN JOB_OUTCOME ON JOB.JOBOUTCOMEID = JOB_OUTCOME_ID)

WHERE
((JOB.APPT_DATE >= '02/19/2007' AND ( JOB.APPT_DATE <= '02/19/2007'))

AND (JOB.TRANSPORTATION = '1')

AND (AREACOORDINATOR = '138')

ORDER BY
JOB.APPT_DATE DESC;

|||

Your parentheses are still not correct. This is missing a closing parenthesis.

((JOB.APPT_DATE >= '02/19/2007' AND ( JOB.APPT_DATE <= '02/19/2007'))

AND (JOB.TRANSPORTATION = '1')

AND (AREACOORDINATOR = '138')

|||The problem (once you get your parenthesis straighten out is here:

(((((JOB LEFT JOIN PATIENT ON JOB.PATIENTID = PATIENT.PATIENTID)
LEFT JOIN PAYER ON JOB.PAYERID = PAYER.PAYERID)
LEFT JOIN REFERRAL_SOURCE AS ADJUSTER ON JOB.ADJUSTER.REFERRAL_ID)
LEFT JOIN REFERRAL_SOURCE AS CM ON JOB.CASEMANAGERID = CM.REFERRAL_ID)
LEFT JOIN JOB_OUTCOME ON JOB.JOBOUTCOMEID = JOB_OUTCOME_ID)

You need to have JOB.ADJUSTER.REFERRAL_ID = REFERRAL_SOURCE..

Or something along these lines.

I would just get rid of most of these parentheses. None of them are actually needed in your query in the JOIN or WHERE clause.
|||

Thanks Louis.

That was to be my next suggestion.

But first, I wanted to help the OP understand that when he/she posts

This query works in my ms sql 2000

, or,

This works just fine in sql 2000 in a cold fusion application

and the query can't possible execute, he/she needs to be a bit more 'critical' when looking over the code and finding the obvious mistakes.

I've been feeling a bit pedantic today...

|||I know the feeling

Newbie Here: headers print even though drill down not clicked

I have a report containing drill down detail. The headers for the drill down
detail prints even at the summary level. This is causing two pages to print
for every one due to the headings. How can I turn the headers off unless the
user has selected to view the drill down data.
Any help would be greatly appreciated. Thanks!Hello,
Try setting the visibility of that header row to toggled by the same field
as the detail row.
Cheers,
Kathy
"Wishing I was skiing mom" wrote:
> I have a report containing drill down detail. The headers for the drill down
> detail prints even at the summary level. This is causing two pages to print
> for every one due to the headings. How can I turn the headers off unless the
> user has selected to view the drill down data.
> Any help would be greatly appreciated. Thanks!|||Thanks for your suggestion. Unfortunately I receive an error message
indicating that the toggle item must share the same scope.
Thanks again,
Jackie
"Kathy" wrote:
> Hello,
> Try setting the visibility of that header row to toggled by the same field
> as the detail row.
> Cheers,
> Kathy
> "Wishing I was skiing mom" wrote:
> > I have a report containing drill down detail. The headers for the drill down
> > detail prints even at the summary level. This is causing two pages to print
> > for every one due to the headings. How can I turn the headers off unless the
> > user has selected to view the drill down data.
> >
> > Any help would be greatly appreciated. Thanks!

Newbie error deploying report

Hello,
I apologize if this has been posted. I did a search and didn't find it
so here it goes. I have been using RS for about 2 months now and are ready
to put into production. On the production box we checked to use SSL during
installation. Now when we try to deploy/upload any .rds or .rdl file we get
errors. From VS we get this message.
Deploying report 'Syncing Report'.
The underlying connection was closed: Could not establish trust relationship
with remote server.
Any help would be greatly appreciated. Thanks in advance.There is a the property on the root of your solution in VS that is
http://servername/reportserver. Change to use
https://servername/reportserver.
--
| From: "Jake Smythe" <rondican@.hotmail.com>
| Subject: Newbie error deploying report
| Date: Tue, 8 Mar 2005 13:48:46 -0800
| Lines: 17
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <Odi7liCJFHA.1304@.TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: mail.virtualconstruction.net 66.63.143.230
| Path:
TK2MSFTNGXA02.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP0
8.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:44941
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hello,
|
| I apologize if this has been posted. I did a search and didn't find
it
| so here it goes. I have been using RS for about 2 months now and are
ready
| to put into production. On the production box we checked to use SSL
during
| installation. Now when we try to deploy/upload any .rds or .rdl file we
get
| errors. From VS we get this message.
|
| Deploying report 'Syncing Report'.
| The underlying connection was closed: Could not establish trust
relationship
| with remote server.
|
|
| Any help would be greatly appreciated. Thanks in advance.
|
|
|
||||The most common reason for this is that the hostname you used as the
deployment server doesn't match the name on the server's SSL certificate,
which is usually the fully-qualified domain name.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jake Smythe" <rondican@.hotmail.com> wrote in message
news:Odi7liCJFHA.1304@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I apologize if this has been posted. I did a search and didn't find it
> so here it goes. I have been using RS for about 2 months now and are ready
> to put into production. On the production box we checked to use SSL during
> installation. Now when we try to deploy/upload any .rds or .rdl file we
get
> errors. From VS we get this message.
> Deploying report 'Syncing Report'.
> The underlying connection was closed: Could not establish trust
relationship
> with remote server.
>
> Any help would be greatly appreciated. Thanks in advance.
>
>|||Brad,
Thanks that works. I do have another problem though when trying to add a
new subscription I get the following message. Any idea on where it's
erroring out? This happens right after I hit the OK button on the main part
of adding a subscription. Thanks so far for the help.
SQL Server Reporting Services
Error
The underlying connection was closed: Could not establish trust relationship
with remote server.
Home
""Brad Syputa - MS"" <bradsy@.Online.Microsoft.com> wrote in message
news:MkNP6yCJFHA.1140@.TK2MSFTNGXA02.phx.gbl...
> There is a the property on the root of your solution in VS that is
> http://servername/reportserver. Change to use
> https://servername/reportserver.
> --
> | From: "Jake Smythe" <rondican@.hotmail.com>
> | Subject: Newbie error deploying report
> | Date: Tue, 8 Mar 2005 13:48:46 -0800
> | Lines: 17
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <Odi7liCJFHA.1304@.TK2MSFTNGP09.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: mail.virtualconstruction.net 66.63.143.230
> | Path:
> TK2MSFTNGXA02.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP0
> 8.phx.gbl!TK2MSFTNGP09.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:44941
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hello,
> |
> | I apologize if this has been posted. I did a search and didn't find
> it
> | so here it goes. I have been using RS for about 2 months now and are
> ready
> | to put into production. On the production box we checked to use SSL
> during
> | installation. Now when we try to deploy/upload any .rds or .rdl file we
> get
> | errors. From VS we get this message.
> |
> | Deploying report 'Syncing Report'.
> | The underlying connection was closed: Could not establish trust
> relationship
> | with remote server.
> |
> |
> | Any help would be greatly appreciated. Thanks in advance.
> |
> |
> |
> |
>