Reporting Services 2005 report in Outlook 2007

I have a Reporting Services 2005 report that is emailed to users. I
created/formatted the report based on how it looked in Outlook 2003 which
all of our users had at that time. The report is wide, but just fit in the
email window when it was full size. Now I have a user who has been
converted to Outlook 2007 and he emailed me a copy of the report he received
in Outlook 2007 and it looks like it reduced the column sizes; it does not
fill the entire email window and wraps the wording on most lines because the
column sizes have been reduced.
The report is:
Delivered by: Report Server E-mail
Include Report is checked
Render Format is Web archive
Any ideas on how I can fix this?
Thanks in advance.
--
DJansonOn Feb 9, 12:50 pm, DJanson <DJan...@.discussions.microsoft.com> wrote:
> I have a Reporting Services 2005 report that is emailed to users. I
> created/formatted the report based on how it looked in Outlook 2003 which
> all of our users had at that time. The report is wide, but just fit in theemailwindow when it was full size. Now I have a user who has been
> converted to Outlook 2007 and he emailed me a copy of the report he received
> in Outlook 2007 and it looks like it reduced thecolumnsizes; it does not
> fill the entireemailwindow and wraps the wording on most lines because thecolumnsizes have been reduced.
> The report is:
> Delivered by: Report ServerE-mail
> Include Report is checked
> Render Format isWebarchive
> Any ideas on how I can fix this?
> Thanks in advance.
> --
> DJanson
I am having the same issue, but I do not have a solution.|||On Mar 15, 1:13 am, mjcarrab...@.gmail.com wrote:
> On Feb 9, 12:50 pm, DJanson <DJan...@.discussions.microsoft.com> wrote:
>
>
> > I have a Reporting Services 2005 report that is emailed to users. I
> > created/formatted the report based on how it looked inOutlook2003 which
> > all of our users had at that time. The report is wide, but just fit in theemailwindow when it was full size. Now I have a user who has been
> > converted toOutlook2007 and he emailed me a copy of the report he received
> > inOutlook2007 and it looks like it reduced thecolumnsizes; it does not
> > fill the entireemailwindow and wraps the wording on most lines because thecolumnsizes have been reduced.
> > The report is:
> > Delivered by: Report ServerE-mail
> > Include Report is checked
> > Render Format isWebarchive
> > Any ideas on how I can fix this?
> > Thanks in advance.
> > --
> > DJanson
> I am having the same issue, but I do not have a solution.- Hide quoted text -
> - Show quoted text -
Does anyone have a fix for this? My report is squished to one narrow
column in Outlook 2007, but renders fine when viewed in Outlook 2003.
Thanks.
-Joe|||I have the same problem is driving me mad. I have a half fix by adding
a long transparent gif image into the report. This makes the table
bigger. Bear in mind that the actual image file needs to be the right
size, you can't just resize it in Visual Studio.
Problem is that if the report runs to 2 pages the second page gets
squished again because the image is at the top :(
Please help!|||Apparently, us five are not the only ones having this issue. Someone reported
it to MS Feedback. Microsoft's typical response: "We are currently
investigating this issue." and the item is marked as "Closed".
How does Microsoft re-define "Closed" to mean they are currently looking
into the issue? They must have some GREAT pull with the folks over at
Wikipedia!
--
Todd C

Reporting services 2005 crashes

Hi All ,
I installed SQL server 2005 Enterprise edition 64 bit on windows server 2003
enterprise edition 64 bit machine.
I created a project and using a wizard created a report with Analysis
services cube as a datasource.Preview works fine but when I try to fix the
fonts or add elements and try to save it it crashes.How ever with out saving
I build the report or use the debug it works fine for the first time the next
time all the columns are deleted from the dataset.
I reproduced this problem thrice using diffrent prifile logons and creating
the project in different drives.
Thank you .
Rose.Applied Service pack noweverything seems good.
"Rose" wrote:
> Hi All ,
> I installed SQL server 2005 Enterprise edition 64 bit on windows server 2003
> enterprise edition 64 bit machine.
> I created a project and using a wizard created a report with Analysis
> services cube as a datasource.Preview works fine but when I try to fix the
> fonts or add elements and try to save it it crashes.How ever with out saving
> I build the report or use the debug it works fine for the first time the next
> time all the columns are deleted from the dataset.
> I reproduced this problem thrice using diffrent prifile logons and creating
> the project in different drives.
>
> Thank you .
> Rose.

Reporting Services + Analysis services Data Source

Hi all,

Till now all the reports for our application was created in Reporting Services 2005 with SQL Server Database(OLTP) stored procedures.

Most of the reports take 10 to 15 report Parameters and all are multi valued.

Now because of the slow response time,we have decided to use OLAP cubes data source. We have created the OLAP cube in Microsoft Analysis Services.

Can someone tell me how to use the report parameters to query the Cube.

Any links,books for reference would be of great help..

Thanks,

Looking forward to your replies

Hi there,

Try searching http://blogs.msdn.com.

Here is a link on how to use parameters.

http://www.databasejournal.com/features/mssql/article.php/10894_3504651_11

and here

http://blogs.msdn.com/bwelcker/archive/2005/04/24/411588.aspx

cheers,

Andrew

|||Thank you very much for replying.. i am looking at these sites.

Reporting Services (Page Issue)

I have created a report in visual studio 2005, using the reportserver. I am able to create the report as a pdf, but for somereason, data is begin shown on every other page.

Does anyone know what might cause this?

Before deploying the report have a look at it in preview mode sounds like you may have a margin applied that is increasing the overall width of your page and causing it to go onto the next page|||Thank you. That was the problem

reporting services (client or server) ad-hoc user created reports?

Hi,
I would like to allow my users to create report templates and save them.
The reports should get their data from my business objects. I'm not really
sure where to begin with this.. I image that i'll need to setup reporting
services.
Currently I have rdlc client reports and report viewer. I don't mind moving
to server reports if required, but i'd like to continue to use the viewer to
display them in my application.
Has anyone else done this?
Thanks
Andyhey Andy
have you had a look at Report Builder? This is really what this is
for.
Dianne
On Apr 26, 8:50 am, Andy <A...@.discussions.microsoft.com> wrote:
> Hi,
> I would like to allow my users to create report templates and save them.
> The reports should get their data from my business objects. I'm not really
> sure where to begin with this.. I image that i'll need to setupreportingservices.
> Currently I have rdlc client reports and report viewer. I don't mind moving
> to server reports if required, but i'd like to continue to use the viewer to
> display them in my application.
> Has anyone else done this?
> Thanks
> Andy|||On Apr 26, 5:55 pm, jewelfire <jewelfi...@.gmail.com> wrote:
> hey Andy
> have you had a look at Report Builder? This is really what this is
> for.
Yes, but I'm at the point where I still need to learn how to build the
model for use in report builder. As I said, I'm just starting with
this.. and only one book I found spends any time on ad-hoc reports,
and only one chapter.

Reporting Services - Rendering

I have created reports using Reporting Services and the problem I am having is with the Print Layout. I view a report with parameters and print. I then change the parameters and click 'View Report' again and the new report is displayed. However, the report does not refresh in the Print Layout, so if I try to print the 2nd report, the first report is the one that is printed. Any ideas how to solve this?

Thanks

Quite simple.

Close Print Layout when you change the parameters and open it after the new report is displayed. Print Layout is rendered upon demand, and just changing the parameters is not refreshing the Print Layout screen.

|||Bdot - aparerntly this is a confirmed bug but you can work around it in code by hooking up to the ViewButtonClick event and calling RefreshReport.

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

Reporting Services - Rendering

I have created reports using Reporting Services and the problem I am having is with the Print Layout. I view a report with parameters and print. I then change the parameters and click 'View Report' again and the new report is displayed. However, the report does not refresh in the Print Layout, so if I try to print the 2nd report, the first report is the one that is printed. Any ideas how to solve this?

Thanks

Quite simple.

Close Print Layout when you change the parameters and open it after the new report is displayed. Print Layout is rendered upon demand, and just changing the parameters is not refreshing the Print Layout screen.

|||Bdot - aparerntly this is a confirmed bug but you can work around it in code by hooking up to the ViewButtonClick event and calling RefreshReport.

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

Reporting Services - credentials error.

Hi everyone.

I have created a report in RS and it works fine (am invoking from VB.Net - windows forms).

However, I have copied the report into a new one as I need a very similar looking report to be called from the same application, but if I attempt to invoke it in the same way as the first I get the following error:

"An attempt was made to set credentials for a data source '<name>' associated with thre report. Report data source settings are specified in a way that prevens credentials from being submitted to the report server."

I am passing the credentials like so:

Dim cc As New DataSourceCredentials
Dim cred() As DataSourceCredentials = {cc}

cred(0).Password = "*****"
cred(0).UserName = "****"
cred(0).DataSourceName = "**DSNAME**"

Any help would be gratfully recieved, as this is driving me completely nuts.

Thanks in advance.Anyone? Someone must have come across this before.

I am slowly banging my head against a wall here ;-)

Reporting Services - cannot connect remotely

Hi,
I was wondering if anyone could help me. Im new to SQL and Reporting
Services.
Ive created a report and deployed it to the report server. When im
logged onto that server I can view the report ok, but when I try to
view it from a workstation I get an error message
'An error has occurred during report processing.
Cannot create a connection to data source 'ICTUForms'.
For more information about this error navigate to the report server on
the local server machine, or enable remote errors '
ICTUForms is a datasource im connecting to.
Can anyone help?I'm guessing you don't have access to the report's underlying data when you
connect on that workstation. Are you using Windows anthentication? You're
probably a local admin on the server (therefore "sa" on MSSQL) when you open
a session there, so all tables are accessible.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mo" <markhayward27@.gmail.com> wrote in message
news:8353a3cb-2baa-4443-b6ab-d13d00188771@.q27g2000prf.googlegroups.com...
> Hi,
> I was wondering if anyone could help me. Im new to SQL and Reporting
> Services.
> Ive created a report and deployed it to the report server. When im
> logged onto that server I can view the report ok, but when I try to
> view it from a workstation I get an error message
>
> 'An error has occurred during report processing.
> Cannot create a connection to data source 'ICTUForms'.
> For more information about this error navigate to the report server on
> the local server machine, or enable remote errors '
>
> ICTUForms is a datasource im connecting to.
>
> Can anyone help?

Reporting Service Report Background Property

Hi

I have created a report and I'm trying to adjust the background color so that the color of the report fits in better with the look and feel of the website. Thus far no luck! Any offers of help?

Check it out here:

http://www.autowired.co.uk/store/rept_serv_prob.gif

Many thanks

you probably have found this by now but just in case

in Reporting Services Property - under Background image - there is an X and and Y - try changing this to match your background colour.

cheers

jewel

Reporting Service and .Net Data provider

Question: why .Net Data provider does not work with Reporting Service.
I have created sample .Net Data Provider as recommented:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcontemplatefiles.asp
I added string name and version number and added assembly into GAC.
Console test application works fine.
but Reporting service gives me error when I create DataSoure:
--
Microsoft Development Environment
--
A connection cannot be made to the database.
Set and test the connection string.
after [OK] press. I can se error message in the Data page: "The query could
not be loaded. Verify your connection and querry string."
Why?
I have modified
"C:\Program Files\Microsoft SQL Server\80\Tools\Report
Designer\RSReportDesigner.config"
<Data>
<Extension Name="TEMP"
Type="TemplateProvider.TemplateConnection,TemplateProvider,Version=1.2.1.1,
Culture=neutral, PublicKeyToken=b2520ee0b52bee09"/>
...
<Designer>
<Extension Name="TEMP"
Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.ReportingServices.Designer"/>
...
and
"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config"
<Data>
<Extension Name="TEMP"
Type="TemplateProvider.TemplateConnection,TemplateProvider,Version=1.2.1.1,
Culture=neutral, PublicKeyToken=b2520ee0b52bee09"/>
When I creating new DataSource I can see provider "TEMP", [Edit] is
disabled.
Please point me what can be wrong. I just want to test is Report Servises
works with .Net Data provider.
thanks in advance,
Darius DCurrently two dot net dataproviders are used by RS. SQL Server and Oracle.
Your other options are ODBC and Oledb providers (I have used both of these
as well as going to SQL Server).
What is it you are trying to do? If you want to do your own data provider
then a better way is to create a data extension. That is supported and many
people have done it. I know that there is some interface that has to be
supported for the data provider to work within the designer. The Sybase
dotnet provider did not support the needed interface and can not be used
within the designer.
Bruce L-C
"DD" <dd@.jbees.com> wrote in message
news:%23OylUKAnEHA.1296@.TK2MSFTNGP09.phx.gbl...
> Question: why .Net Data provider does not work with Reporting Service.
> I have created sample .Net Data Provider as recommented:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcontemplatefiles.asp
> I added string name and version number and added assembly into GAC.
> Console test application works fine.
> but Reporting service gives me error when I create DataSoure:
> --
> Microsoft Development Environment
> --
> A connection cannot be made to the database.
> Set and test the connection string.
> after [OK] press. I can se error message in the Data page: "The query
could
> not be loaded. Verify your connection and querry string."
> Why?
>
> I have modified
> "C:\Program Files\Microsoft SQL Server\80\Tools\Report
> Designer\RSReportDesigner.config"
> <Data>
> <Extension Name="TEMP"
>
Type="TemplateProvider.TemplateConnection,TemplateProvider,Version=1.2.1.1,
> Culture=neutral, PublicKeyToken=b2520ee0b52bee09"/>
> ...
> <Designer>
> <Extension Name="TEMP"
>
Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
ngServices.Designer"/>
> ...
> and
> "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config"
> <Data>
> <Extension Name="TEMP"
>
Type="TemplateProvider.TemplateConnection,TemplateProvider,Version=1.2.1.1,
> Culture=neutral, PublicKeyToken=b2520ee0b52bee09"/>
> When I creating new DataSource I can see provider "TEMP", [Edit] is
> disabled.
> Please point me what can be wrong. I just want to test is Report Servises
> works with .Net Data provider.
> thanks in advance,
> Darius D
>
>|||I got it working. I mean custom .Net data provider with Reporting service.
I dont want to use data extensions because I need to uses custom .net
provider and as I know reporting service should support that.
But I connot find information how to do it.
Now I have such problem:
When I use Generic Query Designer I can write select queries I need and I
get results I want.
But I want to start to use VDTQueryDesigner.
When I press on [Generic Query Designer] which I expect should query schema
I get error:
--
Microsoft Development Environment
--
The following exception has occurred:
NullReferenceException: Object reference not set to an instance of an
object.
--
OK
--
My custom .Net data Provider implements customDataReader where I pass
DataSet. DataSet I filling using such code:
DataSet pDataSet = new DataSet();
string aConnString = "User ID = USR; Persist Security Info=False;
database=DB; server=SRV; Connect Timeout=30";
SqlConnection aConnection = new SqlConnection( aConnString );
SqlCommand aCommand = new SqlCommand(sCmd, aConnection);
aConnection.Open();
SqlDataAdapter aSqlDataAdapter = new SqlDataAdapter();
aSqlDataAdapter.SelectCommand = aCommand;
if (pBehaviour == CommandBehavior.Default)
{
aSqlDataAdapter.Fill(pDataSet, "REZULT_TABLE");
}
else if (pBehaviour == CommandBehavior.SchemaOnly)
{
aSqlDataAdapter.FillSchema(pDataSet, SchemaType.Source);
}
//needs try/catch/finally
aConnection.Close();
return pDataSet;
When [Generic Query Designer] is clicked
aSqlDataAdapter.FillSchema(pDataSet, SchemaType.Source);
is executed. Custom DataReader loops over public Type GetFieldType(int i)
( implements IDataReader )
after if jumps to void IDisposable.Dispose() of custom DataReader and after
return of this function I got the exeption printed above.
I have the feeling I load not correct schema information or my custom Data
provider does not implement( or does it bad) all needed functions
Any comments?
Thanks in advance,
Darius D
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ua6vMRAnEHA.3820@.TK2MSFTNGP09.phx.gbl...
> Currently two dot net dataproviders are used by RS. SQL Server and Oracle.
> Your other options are ODBC and Oledb providers (I have used both of these
> as well as going to SQL Server).
> What is it you are trying to do? If you want to do your own data provider
> then a better way is to create a data extension. That is supported and
> many
> people have done it. I know that there is some interface that has to be
> supported for the data provider to work within the designer. The Sybase
> dotnet provider did not support the needed interface and can not be used
> within the designer.
> Bruce L-C
>
> "DD" <dd@.jbees.com> wrote in message
> news:%23OylUKAnEHA.1296@.TK2MSFTNGP09.phx.gbl...
>> Question: why .Net Data provider does not work with Reporting Service.
>> I have created sample .Net Data Provider as recommented:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcontemplatefiles.asp
>> I added string name and version number and added assembly into GAC.
>> Console test application works fine.
>> but Reporting service gives me error when I create DataSoure:
>> --
>> Microsoft Development Environment
>> --
>> A connection cannot be made to the database.
>> Set and test the connection string.
>> after [OK] press. I can se error message in the Data page: "The query
> could
>> not be loaded. Verify your connection and querry string."
>> Why?
>>
>> I have modified
>> "C:\Program Files\Microsoft SQL Server\80\Tools\Report
>> Designer\RSReportDesigner.config"
>> <Data>
>> <Extension Name="TEMP"
> Type="TemplateProvider.TemplateConnection,TemplateProvider,Version=1.2.1.1,
>> Culture=neutral, PublicKeyToken=b2520ee0b52bee09"/>
>> ...
>> <Designer>
>> <Extension Name="TEMP"
> Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
> ngServices.Designer"/>
>> ...
>> and
>> "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportServer\RSReportServer.config"
>> <Data>
>> <Extension Name="TEMP"
> Type="TemplateProvider.TemplateConnection,TemplateProvider,Version=1.2.1.1,
>> Culture=neutral, PublicKeyToken=b2520ee0b52bee09"/>
>> When I creating new DataSource I can see provider "TEMP", [Edit] is
>> disabled.
>> Please point me what can be wrong. I just want to test is Report Servises
>> works with .Net Data provider.
>> thanks in advance,
>> Darius D
>>
>|||All I know is that for a Sybase dotnet managed provider to work in the
development environment it needed to implement the Reporting Services Data
Extension interface.
One other point that I know is true at least for the Oracle managed
provider. From the development UI the Oracle managed provider is only used
from the Generic Query designer. Otherwise it uses the Oledb provider. The
reason for this is that RS is that the query designer they are using does
not natively support dotnet managed providers so that is why the managed
provider is only used from the generic query designer. I would assume the
same would hold true for your custome managed provider.
Bruce L-C
"DD" <dd@.jbees.com> wrote in message
news:eWZd9TynEHA.628@.TK2MSFTNGP10.phx.gbl...
> I got it working. I mean custom .Net data provider with Reporting service.
> I dont want to use data extensions because I need to uses custom .net
> provider and as I know reporting service should support that.
> But I connot find information how to do it.
> Now I have such problem:
> When I use Generic Query Designer I can write select queries I need and I
> get results I want.
> But I want to start to use VDTQueryDesigner.
> When I press on [Generic Query Designer] which I expect should query
schema
> I get error:
> --
> Microsoft Development Environment
> --
> The following exception has occurred:
> NullReferenceException: Object reference not set to an instance of an
> object.
> --
> OK
> --
> My custom .Net data Provider implements customDataReader where I pass
> DataSet. DataSet I filling using such code:
> DataSet pDataSet = new DataSet();
> string aConnString = "User ID = USR; Persist Security Info=False;
> database=DB; server=SRV; Connect Timeout=30";
> SqlConnection aConnection = new SqlConnection( aConnString );
> SqlCommand aCommand = new SqlCommand(sCmd, aConnection);
> aConnection.Open();
> SqlDataAdapter aSqlDataAdapter = new SqlDataAdapter();
> aSqlDataAdapter.SelectCommand = aCommand;
> if (pBehaviour == CommandBehavior.Default)
> {
> aSqlDataAdapter.Fill(pDataSet, "REZULT_TABLE");
> }
> else if (pBehaviour == CommandBehavior.SchemaOnly)
> {
> aSqlDataAdapter.FillSchema(pDataSet, SchemaType.Source);
> }
> //needs try/catch/finally
> aConnection.Close();
> return pDataSet;
> When [Generic Query Designer] is clicked
> aSqlDataAdapter.FillSchema(pDataSet, SchemaType.Source);
> is executed. Custom DataReader loops over public Type GetFieldType(int i)
> ( implements IDataReader )
> after if jumps to void IDisposable.Dispose() of custom DataReader and
after
> return of this function I got the exeption printed above.
> I have the feeling I load not correct schema information or my custom Data
> provider does not implement( or does it bad) all needed functions
> Any comments?
> Thanks in advance,
> Darius D
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:ua6vMRAnEHA.3820@.TK2MSFTNGP09.phx.gbl...
> > Currently two dot net dataproviders are used by RS. SQL Server and
Oracle.
> > Your other options are ODBC and Oledb providers (I have used both of
these
> > as well as going to SQL Server).
> >
> > What is it you are trying to do? If you want to do your own data
provider
> > then a better way is to create a data extension. That is supported and
> > many
> > people have done it. I know that there is some interface that has to be
> > supported for the data provider to work within the designer. The Sybase
> > dotnet provider did not support the needed interface and can not be used
> > within the designer.
> >
> > Bruce L-C
> >
> >
> > "DD" <dd@.jbees.com> wrote in message
> > news:%23OylUKAnEHA.1296@.TK2MSFTNGP09.phx.gbl...
> >> Question: why .Net Data provider does not work with Reporting Service.
> >>
> >> I have created sample .Net Data Provider as recommented:
> >>
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcontemplatefiles.asp
> >>
> >> I added string name and version number and added assembly into GAC.
> >> Console test application works fine.
> >>
> >> but Reporting service gives me error when I create DataSoure:
> >> --
> >> Microsoft Development Environment
> >> --
> >> A connection cannot be made to the database.
> >> Set and test the connection string.
> >>
> >> after [OK] press. I can se error message in the Data page: "The query
> > could
> >> not be loaded. Verify your connection and querry string."
> >>
> >> Why?
> >>
> >>
> >> I have modified
> >> "C:\Program Files\Microsoft SQL Server\80\Tools\Report
> >> Designer\RSReportDesigner.config"
> >> <Data>
> >> <Extension Name="TEMP"
> >>
> >
Type="TemplateProvider.TemplateConnection,TemplateProvider,Version=1.2.1.1,
> >> Culture=neutral, PublicKeyToken=b2520ee0b52bee09"/>
> >> ...
> >> <Designer>
> >> <Extension Name="TEMP"
> >>
> >
Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
> > ngServices.Designer"/>
> >> ...
> >>
> >> and
> >> "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> >> Services\ReportServer\RSReportServer.config"
> >> <Data>
> >> <Extension Name="TEMP"
> >>
> >
Type="TemplateProvider.TemplateConnection,TemplateProvider,Version=1.2.1.1,
> >> Culture=neutral, PublicKeyToken=b2520ee0b52bee09"/>
> >>
> >> When I creating new DataSource I can see provider "TEMP", [Edit] is
> >> disabled.
> >>
> >> Please point me what can be wrong. I just want to test is Report
Servises
> >> works with .Net Data provider.
> >>
> >> thanks in advance,
> >> Darius D
> >>
> >>
> >>
> >
> >
>

Reporting service

Hi all,

I am new to reporting services.
I have to call the reporting service(some else did this) from the web application that I have created using VB.NET . Not sure how to do it .. was reading few articles on the web .

Any good atricles out there ?

I have created web reference to http://server/ReportServer/ReportService.asmx in my web app. The report expects one parameter .

Below is the code I was starting to write to call the reporting service

Dim rs As New RSWebReference.ReportingService

rs.Credentials = System.Net.CredentialCache.DefaultCredentials

Dim result As Byte

Dim encoding As String

Dim mimetype As String

Dim parameters(2) As Parametervalue()

For some reason I cannot do ParameterValue() it says undefined. I am using Microsoft .NET Framework 1.1 . do I have to use ASP.net2.0 for using reporting services?

ANy way i can get this working

Thanks in advance.

Add an import statement that refers to the ReportService.asmx to the top of your page.

Ex:

Imports <name of your reference>

|||

details, thanks well

Reporting service

Hi all,

I am new to reporting services.
I have to call the reporting service(some else did this) from the web application that I have created using VB.NET . Not sure how to do it .. was reading few articles on the web .

Any good atricles out there ?

I have created web reference to http://server/ReportServer/ReportService.asmx in my web app. The report expects one parameter .

Below is the code I was starting to write to call the reporting service

Dim rs As New RSWebReference.ReportingService

rs.Credentials = System.Net.CredentialCache.DefaultCredentials

Dim result As Byte

Dim encoding As String

Dim mimetype As String

Dim parameters(2) As Parametervalue()

For some reason I cannot do ParameterValue() it says undefined. I am using Microsoft .NET Framework 1.1 . do I have to use ASP.net2.0 for using reporting services?

ANy way i can get this working

Thanks in advance.

Add an import statement that refers to the ReportService.asmx to the top of your page.

Ex:

Imports <name of your reference>

|||

details, thanks well

Reporting Server Rendering

Hi Everyone,

Let me first tell u guys/gals what i hve done till now. I've created a Report Server and created a TestReport.rdl file in it. This report is bound to a DataSet. Now i want to ask few qusetions:

First, Is it possible to call this report from another Project (Web) so that it could be rendered directly to ReportViewer without having to specify a DataSource ? I mean, i wouldn't have to specify the ReportDataSource again since it's already specified when i created that report.

Second, can the same functionality be specified for .rdlc (client file) ?

Till now i've worked out this code:

<code>

rptView.ProcessingMode =ProcessingMode.Remote;

rptView.ServerReport.ReportServerUrl =newUri("http://localhost/Tutorial/");

rptView.ServerReport.ReportPath ="Report2";

</code>

but this doesn't seem to work and keeps on giving me this error:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.The request failed with HTTP status 404: Not Found.

Any points in the right direction will be greatly appreciated. TIA

ok i figured out part of the problem, it was happening because Report Server wasn't configured properly. But now it says "Report requires an Active Database Connection" but when i try to configure the database through Reporting Service Manager i get the error:

Using Other editions of SQL Server for report Data Source and/or the reprot Server Database is not supported.

not sure wat that means but i'm lookng into it.

Any help will b appreciated. TIA

Reporting Servcies Sessions

Hey

I have a problem in controlling the report session.

I created a Reporting Model using SQL reporting Services 2005 with Forms authentication on which I implemented the security Filter based on the function GetUserID() to report only against data that belong to the login User, and I deployed the Model.

Using report Builder application I created a report that contain in the first column the user name (UserName) from entity “Users”, and in the remaining columns data from other entities related to table users, I saved the report on the report server.

I logged in into report manager with user “User1” and I ran the report, the result was the same as expected (in the first column “User1” appeared and in the remaining column other data related to this user appeared) every thing went good

After that I logged in with the user “User2” and I ran the report and here was the surprise the same data that appeared for "User1" appeared for "User2". but what was Expected is different data that belong to "User 2"

After some research that says that this problem may be caused by a session issue (the session created for the first user who enters the report server will remain for the other users that enter after him), I reset IIS and I logged in with “User2”, and I ran the report the correct data for “User2” appeared So it may be a session issue.

My question is:

Is there any way to control the session content and the session expiration?

Please note I used all the solution provided in my research such as URL parameter rs:ClearSession = true, and the Report Execution Options in report manager but non of this helped me.

I will be thankful for any one who could help me in this urgent issue.

Thank you

BOB

Hi Bob,

I have the same issue here. Did you manage to get a solution for your problem?

Julian Kooiker

Reporting Servcies Sessions

Hey

I have a problem in controlling the report session.

I created a Reporting Model using SQL reporting Services 2005 with Forms authentication on which I implemented the security Filter based on the function GetUserID() to report only against data that belong to the login User, and I deployed the Model.

Using report Builder application I created a report that contain in the first column the user name (UserName) from entity “Users”, and in the remaining columns data from other entities related to table users, I saved the report on the report server.

I logged in into report manager with user “User1” and I ran the report, the result was the same as expected (in the first column “User1” appeared and in the remaining column other data related to this user appeared) every thing went good

After that I logged in with the user “User2” and I ran the report and here was the surprise the same data that appeared for "User1" appeared for "User2". but what was Expected is different data that belong to "User 2"

After some research that says that this problem may be caused by a session issue (the session created for the first user who enters the report server will remain for the other users that enter after him), I reset IIS and I logged in with “User2”, and I ran the report the correct data for “User2” appeared So it may be a session issue.

My question is:

Is there any way to control the session content and the session expiration?

Please note I used all the solution provided in my research such as URL parameter rs:ClearSession = true, and the Report Execution Options in report manager but non of this helped me.

I will be thankful for any one who could help me in this urgent issue.

Thank you

BOB

Hi Bob,

I have the same issue here. Did you manage to get a solution for your problem?

Julian Kooiker

Reporting off of a Database Mirror

All,

I have created an asynchronous database mirror and a snapshot of the mirrored database similar to what is described in the following article:

http://msdn2.microsoft.com/en-US/library/ms175511.aspx

The article says that once you create the mirror that "At this point, new client connections can be programmatically directed to the latest snapshot."

My question is, how can you programmatically direct connections to the latest snapshot?

Does anyone have a suggestion, or know what the article is getting at? We will use SQL Server Reporting services to query off of the database snapshot.

Thank you,

Racer-D

hi racer,

You can change your connection string to connect directly to the database snapshot.

database snapshot are treated as a new copy of the database

regards,

joey

|||And programatically means that you can do one of two things. You can either interrogate sys.databases for the most recent creation date or you can use a standard naming convention and direct based on the naming convention.

Reporting off of a Database Mirror

All,

I have created an asynchronous database mirror and a snapshot of the mirrored database similar to what is described in the following article:

http://msdn2.microsoft.com/en-US/library/ms175511.aspx

The article says that once you create the mirror that "At this point, new client connections can be programmatically directed to the latest snapshot."

My question is, how can you programmatically direct connections to the latest snapshot?

Does anyone have a suggestion, or know what the article is getting at? We will use SQL Server Reporting services to query off of the database snapshot.

Thank you,

Racer-D

hi racer,

You can change your connection string to connect directly to the database snapshot.

database snapshot are treated as a new copy of the database

regards,

joey

|||And programatically means that you can do one of two things. You can either interrogate sys.databases for the most recent creation date or you can use a standard naming convention and direct based on the naming convention.

Reporting off of a Database Mirror

All,

I have created an asynchronous database mirror and a snapshot of the mirrored database similar to what is described in the following article:

http://msdn2.microsoft.com/en-US/library/ms175511.aspx

The article says that once you create the mirror that "At this point, new client connections can be programmatically directed to the latest snapshot."

My question is, how can you programmatically direct connections to the latest snapshot?

Does anyone have a suggestion, or know what the article is getting at? We will use SQL Server Reporting services to query off of the database snapshot.

Thank you,

Racer-D

hi racer,

You can change your connection string to connect directly to the database snapshot.

database snapshot are treated as a new copy of the database

regards,

joey

|||And programatically means that you can do one of two things. You can either interrogate sys.databases for the most recent creation date or you can use a standard naming convention and direct based on the naming convention.