Showing posts with label reports. Show all posts
Showing posts with label reports. Show all posts

Friday, March 30, 2012

Report erroe

Hi All ,

i got tired from the component crytsal reports but i need it to finish an application i'm building .

i got the folloiwng error when i try to run the report.

ONE : Cannot implicitly convert type 'CrystalDecisions.Shared.TableLogOnInfos' to 'CrystalDecisions.Shared.TableLogOnInfo'

TWO: foreach statement cannot operate on variables of type 'CrystalDecisions.Shared.TableLogOnInfo' because 'CrystalDecisions.Shared.TableLogOnInfo' does not contain a public definition for 'GetEnumerator'

and here is the code that i'm using:

using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

namespace Hope
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void ConfigureCrystalReports()
{

ConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo.DatabaseName = "NorthWind";
connectionInfo.UserID = "";
connectionInfo.Password = "";

string reportPath = Application.StartupPath + "\\" +
"NorthwindCustomers.rpt";
crystalReportViewer.ReportSource = reportPath;



SetDBLogonForReport(connectionInfo);

}

private void Form1_Load(object sender, EventArgs e)
{
ConfigureCrystalReports();

}

private void SetDBLogonForReport(ConnectionInfo connectionInfo)
{
TableLogOnInfo tableLogOnInfos = crystalReportViewer.LogOnInfo;

foreach (TableLogOnInfo tableLogOnInfo in tableLogOnInfos)
{
tableLogOnInfo.ConnectionInfo = connectionInfo;
}


please try to help me find out , what's the problem , i'll get mad soon,hi
this is saurabh

i have creating a crystal report. in this report i want inserting no. of images .
can i put these images directly into the folders.
without saving in database.

plz... give reply as soon as possible....!|||Are you jokking ,

why to post here in my thread , create your own.

i'm so amazed from your action ,

Report does not render

When I go out to Reports I can see the reports but when you click on
them all yo get is the properties tab and they will not render. If I
go out the the Reportsserver they will run fine. Is there a reason
why they will not give me the option to render?Just two things, check for the access from the RM, and clear the cache and
then try deploy and run the report. I faced the same before.
Amarnath, MCTS.
"captkirkrules" wrote:
> When I go out to Reports I can see the reports but when you click on
> them all yo get is the properties tab and they will not render. If I
> go out the the Reportsserver they will run fine. Is there a reason
> why they will not give me the option to render?
>

Report Does Not Display in Designer

Hello,

I am developing some reports for an ASP.NET solution, but my IDE does not display the design view of the reports. Instead, it only displays the XML definition even when I click View Designer. Yesterday the reports showed up correctly, and I know that the design view is there. Is there a setting that has been changed somewhere?

I guess you are trying to add the report to your ASP.Net application project. If you do that and view the report (.rdl file), you can only see the xml view. You can see the design view only if you add it to Report Server project under Business Intelligence Projects group.

Shyam

|||I figured it out. Thanks.

Report Distribution based on SQL Query in RDL

I need to create multiple reports with each report being sent to the specified user. For example, 3 Managers should each get their own report. A Stored Procedure receives a ManagerID parameter, so I need 3 instances of the report. I also need each report to be sent to its associated Manager:

Mgr ID Manager Name 1 John Q Manager 2 Jane Q Manager 3 Jack O Lantern

I set up a rss file to run the report and can run it multiple times, passing in a different ID value each time, but it will not be data driven because I must hard-code the parameters in the ReportParmaters object of the report for each execution.

Is there a way, either by designing the report in VS2005 or on the Reporting Services server, to accomplish what I'm intending to do?

Did you already have a look on the datadriven subscription option in Reporting Services ? That would exactly fit your needs.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Report display in Firefox

Hi everyone,

I know there are issue with reports not displaying as expected in ReportViewer when using Firefox, including the weird 'add something wide to your header' bug, but I've encountered a slightly different problem.

I'm using a matrix report, which displays perfectly in IE, and will render nicely when exported to either excel or pdf format with either IE or Firefox. However, when you simply view the report in firefox it looks awful: all the columns of the matrix are squashed so much that you can't read anything at all. OK, I can just say to people "export the report", but it'd be good if I could fix this.

Any ideas will be much appreciated. Thanks

This is a known problem. I don't know if there are any updates yet. What you can try is add a blank textbox to the footer of the report and stretch it manually to the width of your report. This will force the report to stretch in Firefox.

|||

Hi,

I already have a line the same width as my report in the header, and I've added a blank textbox the width of the report to the footer. Unfortunately, there's no change. The 'cells' of the matrix are still mini and totally unreadable. Thanks anyway

|||

dhassen:

and I've added a blank textbox the width of the report to the footer

Just to confirm, is this the footer of the report or the page. If its the report, then add it to the page footer. For inserting a page footer, do this:

When you are in the design view of report, go to Report Menu from the menu options, add a Page Footer (if you don't have one), drag and drop an empty textbox on this footer and stretch it.

If you have already done it, I am out of solutions.

|||

yep, unfortunately it was the page footer that I tried. Ah well... see if anyone else has any ideas

Report Designer using Report Model as data source

can we use Report Designer to build reports off a Model?See my replies to the post RS.exe Script utility and Forms Authentication
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dan Krish" <DanKrish@.discussions.microsoft.com> wrote in message
news:2C2DD0D5-F184-46ED-9311-9DCA8602B1D5@.microsoft.com...
> can we use Report Designer to build reports off a Model?
>

Report Designer Sorting in Details Group?

Can you specify the Sorting in the Details group in reports designed with Report Designer? If so how?

I know that I can set the Sorting in the Details group in reports generated with Report Builder (the Sorting element is a child of the Details element).

Thanks!!!

-Brian

You can edit the Sorting in Details Group by using the Sorting tab of the Table Properties dialog in Report Designer.

-Albert

|||I don't see a Sorting tab on the Details group dialog...where is the Table Properties dialog in the Report Designer?|||To display the Table Properties dialog:

1. Click the table so that column and row handles appear above and next to the table.
2. Right-click in the upper-left hand corner where the column and row handles intersect.
3. Select Properties from the drop-down menu.

-Albert|||

Ah...they make that tough to get to don't they...

Thanks!

-Brian

Report Designer Sorting in Details Group?

Can you specify the Sorting in the Details group in reports designed with Report Designer? If so how?

I know that I can set the Sorting in the Details group in reports generated with Report Builder (the Sorting element is a child of the Details element).

Thanks!!!

-Brian

You can edit the Sorting in Details Group by using the Sorting tab of the Table Properties dialog in Report Designer.

-Albert

|||I don't see a Sorting tab on the Details group dialog...where is the Table Properties dialog in the Report Designer?|||To display the Table Properties dialog:

1. Click the table so that column and row handles appear above and next to the table.
2. Right-click in the upper-left hand corner where the column and row handles intersect.
3. Select Properties from the drop-down menu.

-Albert|||

Ah...they make that tough to get to don't they...

Thanks!

-Brian

sql

Wednesday, March 28, 2012

Report Designer for Reporting Services

Sorry if this is well known now but...

If a customer of ours installed Reporting Services on their SQL Server 2000 machine how do they design reports, assuming they do not own a copy of Visual Studio .NET 2003? Is there some form of report designer?

It is my understanding that Sql 2005 DOES come with a report designer is VS is not installed.

Regards
GrahamIn SQL Server 2000 Reporting Services, there is no Report Designer outside of the one hosted in VS 2003 (VB Standard will do). SQL 2005 comes with a version of the Visual Studio shell to host Report Designer. It also comes with Report Builder, which does not require VS at all.|||Having the components used withing Report Builder would be nice. Or being able to modify Report Builder (given the source) would even be nicer.|||

Is it possible to host the Report Designer in a custom application ? Maby like hosting the Forms Designer in a custom application.

http://msdn.microsoft.com/msdnmag/issues/06/03/DesignerHosting/default.aspx

|||Yes, yes, I've seen examples like this. But without spending an inordinate amount of time to research and test, is it possible to host the report designer in the same way? The Winforms designer, yes. But the report designer?

Report Designer for Reporting Services

Sorry if this is well known now but...

If a customer of ours installed Reporting Services on their SQL Server 2000 machine how do they design reports, assuming they do not own a copy of Visual Studio .NET 2003? Is there some form of report designer?

It is my understanding that Sql 2005 DOES come with a report designer is VS is not installed.

Regards
GrahamIn SQL Server 2000 Reporting Services, there is no Report Designer outside of the one hosted in VS 2003 (VB Standard will do). SQL 2005 comes with a version of the Visual Studio shell to host Report Designer. It also comes with Report Builder, which does not require VS at all.|||Having the components used withing Report Builder would be nice. Or being able to modify Report Builder (given the source) would even be nicer.|||

Is it possible to host the Report Designer in a custom application ? Maby like hosting the Forms Designer in a custom application.

http://msdn.microsoft.com/msdnmag/issues/06/03/DesignerHosting/default.aspx

|||Yes, yes, I've seen examples like this. But without spending an inordinate amount of time to research and test, is it possible to host the report designer in the same way? The Winforms designer, yes. But the report designer?

Report Designer for Reporting Services

Sorry if this is well known now but...

If a customer of ours installed Reporting Services on their SQL Server 2000 machine how do they design reports, assuming they do not own a copy of Visual Studio .NET 2003? Is there some form of report designer?

It is my understanding that Sql 2005 DOES come with a report designer is VS is not installed.

Regards
GrahamIn SQL Server 2000 Reporting Services, there is no Report Designer outside of the one hosted in VS 2003 (VB Standard will do). SQL 2005 comes with a version of the Visual Studio shell to host Report Designer. It also comes with Report Builder, which does not require VS at all.|||Having the components used withing Report Builder would be nice. Or being able to modify Report Builder (given the source) would even be nicer.|||

Is it possible to host the Report Designer in a custom application ? Maby like hosting the Forms Designer in a custom application.

http://msdn.microsoft.com/msdnmag/issues/06/03/DesignerHosting/default.aspx

|||Yes, yes, I've seen examples like this. But without spending an inordinate amount of time to research and test, is it possible to host the report designer in the same way? The Winforms designer, yes. But the report designer?

Report Designer deletes MDX when opening data tab

Hi!
I've got some problems with a few reports I've made. The MDX queries of the
datasets are quite complex, so I have turned off design mode when working
with them. Of course, design mode won't work anymore, but Report Designer
has understood this until now and disabled design mode when I've swapped to
the data tab. Recently though, it doesn't understand it anymore, and enters
design mode, effectively removing the MDX, if I go to the data tab.
(Removing is not quite true, it changes to an empty "select {} on 0 from
mycube" query)
I have to do more modifications to the MDX, so to keep working with my
reports I have to manually modify the XML source if I need a new field for
instance.
Tried installing VS '05 SP 1 and SQL Server '05 SP 2, but it still does the
same.
I've had the problem once before, then I solved it by comparing with an
older version - where the query definition xml elements had a slightly
different order - and setting the same order in the new version. Of course,
the elements are re-ordered when I save the reports, so I have to do this
each time.. I won't.. :P
Any ideas? Are there any hint I can include in the XML to tell the designer
to lay off my query?
Lars-ErikHello Erik,
I would like to know whether you could modify the Code of your report VS.
If so, you may try to modify the code.
Also, please verify that you have installed the SQL Server 2005 SP2
correctly.
I found a similar issue and it has been resolved in SQL 2005 SP1.
909535 FIX: A query disappears in the MDX query designer, and you cannot
modify a report in Layout view when you create the report in Business
Intelligence Development Studio in SQL Server 2005
http://support.microsoft.com/default.aspx?scid=kb;EN-US;909535
Could you please verify that?
If you have a SQL 2005 SP1 installed machine, did this issue appear on that
machine?
Sincerely,
Wei Lu
Microsoft Online Community 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 again!
Not sure what code you mean by code. I can modify the RDL using the "open
code" from the context menu in solution expl., and I can modify the custom
code of the report. Modifying the RDL using code view is what I've done to
add fields now.
I've now got Microsoft SQL Server Reporting Services Designers Version
9.00.3042.00 installed.
I checked the info in the KB article, and now I'm a bit stumped. I was sure
I had <QueryDefinition .../> elements in the dataset definitions, but
somewhere along the road they've disappeared. I've had to update two query
definitions in one dataset before while the problem existed. One of my
reports still have the element (on one line) and I can modify the query in
the data designer as I should.
I can modify my reports in layout view though, so not sure if all the info
in the KB are relevant.
With this information I can probably do a compare with older versions, get
back the QueryDefinition elements, update any old info, verify one line, and
get it working again. What worries me is that the behavior probably comes
back, since it's done so before.. Any ideas on how I can ensure stability?
I have to mention a couple of other points that might influence this:
- I do modify the RDL manually because I have 14-15 drillthrough actions in
each report that are too complex to handle using the designer. (I generate
XML for the <action> elements from a matrix with complex formulas in Excel)
- There's an issue with line breaks VS keeps suggesting to fix, and does,
but it comes back for some reason. (might be a difference created when
saving on different machines)
Lars-Erik
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:QY98NdenHHA.5420@.TK2MSFTNGHUB02.phx.gbl...
> Hello Erik,
> I would like to know whether you could modify the Code of your report VS.
> If so, you may try to modify the code.
> Also, please verify that you have installed the SQL Server 2005 SP2
> correctly.
> I found a similar issue and it has been resolved in SQL 2005 SP1.
> 909535 FIX: A query disappears in the MDX query designer, and you cannot
> modify a report in Layout view when you create the report in Business
> Intelligence Development Studio in SQL Server 2005
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;909535
> Could you please verify that?
> If you have a SQL 2005 SP1 installed machine, did this issue appear on
> that
> machine?
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.
>|||Hello Lars,
I would like to konw whether you have this issue on other reports?
And did this issue happened on SQL 2005 Sp1?
Sincerely,
Wei Lu
Microsoft Online Community 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 ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community 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!
Thanks for the follow-up.
I made the reports with no SP installed. (About said RTM something)
Have had the same issue with other reports, but think they've been behaving
properly after some repairing.
Have not tried to repair my reports yet, I'll do the extra hours I need to
repair them some time soon. If the queries disappear again, I'll create a
new post.
L-E
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:5uQJ0oboHHA.564@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.
>|||Hello,
Please let me know if you have any question and I will temporary close this
post.
Sincerely,
Wei Lu
Microsoft Online Community 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.

Report Designer

Hello all.:-)
Does anyone know of a Report Designer program that I can download? Free
would be good.:-) I just need to create and edit reports and really don't
want to go the full MSDN route.
Thanks much,
JohnHi John,
The only thing I eared about is an open source projet on Code Projet.
http://codeproject.com/csharp/RdlProject.asp
I didn't test it and i can't assume that what you're looking for.
Christophe MIGNOT
ApolloSSC
"John Holt" wrote:
> Hello all.:-)
> Does anyone know of a Report Designer program that I can download? Free
> would be good.:-) I just need to create and edit reports and really don't
> want to go the full MSDN route.
> Thanks much,
> John
>
>|||John,
You can get the full designer in VB.Net (about £60/$120), you don't
need Visual Studio.
If you can wait for SQL2005 or get on the Beta, it comes with BI Studio
so you don't need to by anything extra (except having a licence SQL2005
server) on top of that the Report Builder has just been released onto
Beta.
John Holt wrote:
> Hello all.:-)
> Does anyone know of a Report Designer program that I can download?
> Free would be good.:-) I just need to create and edit reports and
> really don't want to go the full MSDN route.
> Thanks much,
> John

Report design scenario

Hey guys,

I want to create a report called "Report X", which has four reports under it. Assume the following scenario.

1. Report X

1.1. Bar chart report

1.2. Pie chart report

1.3. Matrix report

1.4. Pie chart report

In addition to this, there are about four parameters that should be available for all reports. So my question is: what approach should I follow to implement/design a report for the above requirement.

Thank you for your cooperation in advance.

Sincerely,

Amde

The question is discussed/answered in this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=374405&SiteID=1

Report Design Question two horizontal column headers one below other

I have a report requirement, i am new to reports.

I want to have two lines of column headers.( with 7 columns in parent columns header)

and 7 columns in child column header.

The first column header will show a parent record.

And after the parent record i want to show the next child related horizontal column headers and will show all child record related to the above parent record.

its a one to many: 1 parent record and below all child records for that parent record.

can i use subreports controls to show all child records of the parent.

Thank you very much for the information.

I would recommend that you a table report

Assume that you have a structure

Country A

Region A1

Region A2

Country B

Region B1

Region B2

Region B3

In this scenario create a table that groups records by country. In the group header/footer (depending on your need) add a new table that contains regions associated with the country.

HTH.

Report Description

Can someone please let me know what the use of the Report > Report Properties
> Author & Description Fields are?
When I deploy my reports to the server these values are not visible in the
report properties of the report manager nor are they exposed to be used in a
report. Both of which I want to do.I have just tested what you said below, and I found that although the Author
property I entered was overwritten by my NT login, the description came
through alright on the server after deploying. Go to the Properties tab of
the report in Report Manager and click on the General link; you should see
the description at least.
The description is very useful when searching [there is a Search for text
box at the top right of the screen].
Charles Kangai, MCT, MCDBA
"SAcanuck" wrote:
> Can someone please let me know what the use of the Report > Report Properties
> > Author & Description Fields are?
> When I deploy my reports to the server these values are not visible in the
> report properties of the report manager nor are they exposed to be used in a
> report. Both of which I want to do.|||Hi Charles:
I deployed my rdl using visual studio and the description was not displayed
on the general link of the report properties in the report manager. I also
tried this by uploading the rdl file onto the server...no description either.
Is there a setting that coud be preventing this from occuring?
"Charles Kangai" wrote:
> I have just tested what you said below, and I found that although the Author
> property I entered was overwritten by my NT login, the description came
> through alright on the server after deploying. Go to the Properties tab of
> the report in Report Manager and click on the General link; you should see
> the description at least.
> The description is very useful when searching [there is a Search for text
> box at the top right of the screen].
> Charles Kangai, MCT, MCDBA
> "SAcanuck" wrote:
> > Can someone please let me know what the use of the Report > Report Properties
> > > Author & Description Fields are?
> >
> > When I deploy my reports to the server these values are not visible in the
> > report properties of the report manager nor are they exposed to be used in a
> > report. Both of which I want to do.|||Hi checked the code in the rdl file and my description is referenced in
it...so I really dont know what the issue could be.
"Charles Kangai" wrote:
> I have just tested what you said below, and I found that although the Author
> property I entered was overwritten by my NT login, the description came
> through alright on the server after deploying. Go to the Properties tab of
> the report in Report Manager and click on the General link; you should see
> the description at least.
> The description is very useful when searching [there is a Search for text
> box at the top right of the screen].
> Charles Kangai, MCT, MCDBA
> "SAcanuck" wrote:
> > Can someone please let me know what the use of the Report > Report Properties
> > > Author & Description Fields are?
> >
> > When I deploy my reports to the server these values are not visible in the
> > report properties of the report manager nor are they exposed to be used in a
> > report. Both of which I want to do.|||Another thing we have two report server this description does appear on one
fo them, but not on the other. Why?
"Charles Kangai" wrote:
> I have just tested what you said below, and I found that although the Author
> property I entered was overwritten by my NT login, the description came
> through alright on the server after deploying. Go to the Properties tab of
> the report in Report Manager and click on the General link; you should see
> the description at least.
> The description is very useful when searching [there is a Search for text
> box at the top right of the screen].
> Charles Kangai, MCT, MCDBA
> "SAcanuck" wrote:
> > Can someone please let me know what the use of the Report > Report Properties
> > > Author & Description Fields are?
> >
> > When I deploy my reports to the server these values are not visible in the
> > report properties of the report manager nor are they exposed to be used in a
> > report. Both of which I want to do.|||If you have deployed the report before the description does not go over. It
only goes over it it is the first time you have deployed. Delete the report
on the server and redeploy and the description will come over.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:B37830C2-DE50-4695-B8D2-085B6976AC55@.microsoft.com...
> Hi Charles:
> I deployed my rdl using visual studio and the description was not
displayed
> on the general link of the report properties in the report manager. I also
> tried this by uploading the rdl file onto the server...no description
either.
> Is there a setting that coud be preventing this from occuring?
>
> "Charles Kangai" wrote:
> > I have just tested what you said below, and I found that although the
Author
> > property I entered was overwritten by my NT login, the description came
> > through alright on the server after deploying. Go to the Properties tab
of
> > the report in Report Manager and click on the General link; you should
see
> > the description at least.
> >
> > The description is very useful when searching [there is a Search for
text
> > box at the top right of the screen].
> >
> > Charles Kangai, MCT, MCDBA
> >
> > "SAcanuck" wrote:
> >
> > > Can someone please let me know what the use of the Report > Report
Properties
> > > > Author & Description Fields are?
> > >
> > > When I deploy my reports to the server these values are not visible in
the
> > > report properties of the report manager nor are they exposed to be
used in a
> > > report. Both of which I want to do.|||Bruce:
thanks it works now. Is there away to prevent the NT login name from
overwriting the Author name?
"Bruce L-C [MVP]" wrote:
> If you have deployed the report before the description does not go over. It
> only goes over it it is the first time you have deployed. Delete the report
> on the server and redeploy and the description will come over.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
> news:B37830C2-DE50-4695-B8D2-085B6976AC55@.microsoft.com...
> > Hi Charles:
> >
> > I deployed my rdl using visual studio and the description was not
> displayed
> > on the general link of the report properties in the report manager. I also
> > tried this by uploading the rdl file onto the server...no description
> either.
> >
> > Is there a setting that coud be preventing this from occuring?
> >
> >
> >
> > "Charles Kangai" wrote:
> >
> > > I have just tested what you said below, and I found that although the
> Author
> > > property I entered was overwritten by my NT login, the description came
> > > through alright on the server after deploying. Go to the Properties tab
> of
> > > the report in Report Manager and click on the General link; you should
> see
> > > the description at least.
> > >
> > > The description is very useful when searching [there is a Search for
> text
> > > box at the top right of the screen].
> > >
> > > Charles Kangai, MCT, MCDBA
> > >
> > > "SAcanuck" wrote:
> > >
> > > > Can someone please let me know what the use of the Report > Report
> Properties
> > > > > Author & Description Fields are?
> > > >
> > > > When I deploy my reports to the server these values are not visible in
> the
> > > > report properties of the report manager nor are they exposed to be
> used in a
> > > > report. Both of which I want to do.
>
>|||I don't know anything about that, sorry.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:6B8F8E52-2909-4FE6-B15A-E25ABE45CB64@.microsoft.com...
> Bruce:
> thanks it works now. Is there away to prevent the NT login name from
> overwriting the Author name?
> "Bruce L-C [MVP]" wrote:
> > If you have deployed the report before the description does not go over.
It
> > only goes over it it is the first time you have deployed. Delete the
report
> > on the server and redeploy and the description will come over.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
> > news:B37830C2-DE50-4695-B8D2-085B6976AC55@.microsoft.com...
> > > Hi Charles:
> > >
> > > I deployed my rdl using visual studio and the description was not
> > displayed
> > > on the general link of the report properties in the report manager. I
also
> > > tried this by uploading the rdl file onto the server...no description
> > either.
> > >
> > > Is there a setting that coud be preventing this from occuring?
> > >
> > >
> > >
> > > "Charles Kangai" wrote:
> > >
> > > > I have just tested what you said below, and I found that although
the
> > Author
> > > > property I entered was overwritten by my NT login, the description
came
> > > > through alright on the server after deploying. Go to the Properties
tab
> > of
> > > > the report in Report Manager and click on the General link; you
should
> > see
> > > > the description at least.
> > > >
> > > > The description is very useful when searching [there is a Search for
> > text
> > > > box at the top right of the screen].
> > > >
> > > > Charles Kangai, MCT, MCDBA
> > > >
> > > > "SAcanuck" wrote:
> > > >
> > > > > Can someone please let me know what the use of the Report > Report
> > Properties
> > > > > > Author & Description Fields are?
> > > > >
> > > > > When I deploy my reports to the server these values are not
visible in
> > the
> > > > > report properties of the report manager nor are they exposed to be
> > used in a
> > > > > report. Both of which I want to do.
> >
> >
> >

Report deployment without VS

Hi!
I created several reports and I want to give them to several persons for the installation on

their SQL Server 2005. Is it possible to create something like an

installation package (similar to the deployment manifest in SSIS)?
Thanks for any help!

Check out the PublishSampleReports.rss script in the C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Script Samples folder.

You can use it with the rs.exe tool to automatically publish an RDL definition to a server. To use it, your user will have to type a command, however.

If you *totally* want to automate deployment of reports you could do so by creating an MSI which uses a custom action: That custom action would essentially call the same commands as in the script above...It seems like a lot of work to me, though.

|||You can use Reporting Services Scripter to do this. Simply select the reports + datasource you want to distribute (and probably the folder too) and generate the scripts. You can then supply the generated scripts/rdl + batch file to them and all they have to do is change the servername and run the batchfile.|||

...and Jasper's reply reminds me that you can also now script this stuff right from SQL Managment Studio just like you could script tables, views, etc. back in 2000.

Launch SSMS, connect to your Report Server, then right-click the object you want to distribute and click Script.

Report deployment with RS2k, SP1

Hello,
I have a problem with report's deployment (SQL 2k, RS SP1). All my reports
have only hidden parameters (parameters with a prompt blank).
When I deploy from VS. NET 2003 to an empty folder on my RS server, the
prompts reappear and the checkbox "prompt user" is unchecked. That means
read only parameters and my reports return an error. The only way to correct
that is to manualy change the checkbox.
After the first deployment, each time I deploy the same reports (I replace
the existing), the checks stay but the prompt reappear. I have 15 reports
with 5-10 parameters on 3 environments (dev, qa, prod) and after each
deployment, I have to manualy remove the prompt..... I get crazy....
If someone have some experience with that problem or a workaround, don't
hesitate...
Thanks in adavance
LaurentHi,
have you tried rs.CreateReport with overwrite properties so that you can
overwrite all the parameter and report properties..
when i do upgrade i use this property to overwrite report in the script..
Bava
"Laurent" wrote:
> Hello,
> I have a problem with report's deployment (SQL 2k, RS SP1). All my reports
> have only hidden parameters (parameters with a prompt blank).
> When I deploy from VS. NET 2003 to an empty folder on my RS server, the
> prompts reappear and the checkbox "prompt user" is unchecked. That means
> read only parameters and my reports return an error. The only way to correct
> that is to manualy change the checkbox.
> After the first deployment, each time I deploy the same reports (I replace
> the existing), the checks stay but the prompt reappear. I have 15 reports
> with 5-10 parameters on 3 environments (dev, qa, prod) and after each
> deployment, I have to manualy remove the prompt..... I get crazy....
> If someone have some experience with that problem or a workaround, don't
> hesitate...
> Thanks in adavance
> Laurent
>
>sql

Monday, March 26, 2012

Report Deployment Error:

Hi while deploying the reports to the server I get the following error.
Server did not recognize the value of HTTP Header SOAPAction:
http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportingservices/ListSecureMethods.
Could anyone help me to overcome this?
Please mention if any configuration changes are to be made.
Thanks.Looks like a version mismatch between your client (VS.NET) and your
server... open http://<servername>/reportserver and in VS.NET open Help |
About Microsoft Development Environment and select "Microsoft SQL Server
Report Designer"... compare the version numbers
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"Thyagu" <Thyagu@.discussions.microsoft.com> wrote in message
news:A10C3285-CAB6-4A19-93A3-6DD7365F49B7@.microsoft.com...
> Hi while deploying the reports to the server I get the following error.
> Server did not recognize the value of HTTP Header SOAPAction:
> http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportingservices/ListSecureMethods.
> Could anyone help me to overcome this?
> Please mention if any configuration changes are to be made.
> Thanks.|||Douglas,
Thanks very much. The problem got solved once I upgraded the package to a
newer version.
Regards,
Thyagu
"Douglas McDowell" wrote:
> Looks like a version mismatch between your client (VS.NET) and your
> server... open http://<servername>/reportserver and in VS.NET open Help |
> About Microsoft Development Environment and select "Microsoft SQL Server
> Report Designer"... compare the version numbers
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>
> "Thyagu" <Thyagu@.discussions.microsoft.com> wrote in message
> news:A10C3285-CAB6-4A19-93A3-6DD7365F49B7@.microsoft.com...
> > Hi while deploying the reports to the server I get the following error.
> >
> > Server did not recognize the value of HTTP Header SOAPAction:
> > http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportingservices/ListSecureMethods.
> >
> > Could anyone help me to overcome this?
> > Please mention if any configuration changes are to be made.
> >
> > Thanks.
>
>

Report deployment connection error

Hi,

I'm using the reports designer in Visual Studio 2005 Professional and have successfully been deploying reports to my client's server for several months. Now I can't deploy any reports, when I try Visual Studio almost hangs, tries for about 5 minutes to deploy a single report and then fails with an error message:

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://winserver/ReportServer.


ADDITIONAL INFORMATION:

The operation has timed out (System.Web.Services)


BUTTONS:

OK

It used to ask me for username/password for the server (credentials), now it doesn't do that. I can go to the reports server and reports interface pages in my browser OK. The reports build without any errors.

Has anyone experienced this? Any ideas on how to get it working again?

Regards,

Greg

Check for your IE settings. I think that must have changed.

In the client machine, IE Options -> Connection -> LAN settings that - check if both these 2
options were checked/enabled -
1. Automatically detect settings
2. Use Automatic Configuration Script
The option #2 was causing HTTP request from VS go through the proxy server and
passing anonymous request (401)

Or any other Security settings from a machine where deployment works fine.


|||

Hi,

Thanks for your response. I checked the settings in IE and all LAN Settings options are unchecked. Is this correct?

I am connecting through a VPN so that might be causing a problem (all options unchecked for VPN connection settings in IE). I will try directly connecting to the client's LAN and see if it works.

Regards,

Greg