Showing posts with label design. Show all posts
Showing posts with label design. Show all posts

Friday, March 30, 2012

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.

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

Hi,
Do I need the full visual studio 2003 to design reporting services forms?
Can I maybe use a cut down version to design forms, as we cannot afford the
upgrade fees.
ThanksMinimal configuration should be enough
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"James Wakefield" <wakey_99@.yahoo.com> wrote in message
news:%23EbRdSHxEHA.1524@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Do I need the full visual studio 2003 to design reporting services forms?
> Can I maybe use a cut down version to design forms, as we cannot afford
> the upgrade fees.
> Thanks
>|||Thanks but I'm not sure what you mean by minimal configuration?
Is that a download instead of full visual studio?
"Lev Semenets [MSFT]" wrote:
> Minimal configuration should be enough
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "James Wakefield" <wakey_99@.yahoo.com> wrote in message
> news:%23EbRdSHxEHA.1524@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > Do I need the full visual studio 2003 to design reporting services forms?
> > Can I maybe use a cut down version to design forms, as we cannot afford
> > the upgrade fees.
> >
> > Thanks
> >
>
>|||Visual Basic.NET 2003 version should be enough
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"James Wakefield" <James Wakefield@.discussions.microsoft.com> wrote in
message news:D7715297-FAB9-477D-9DB8-F17AD0C1BBFF@.microsoft.com...
> Thanks but I'm not sure what you mean by minimal configuration?
> Is that a download instead of full visual studio?
> "Lev Semenets [MSFT]" wrote:
>> Minimal configuration should be enough
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "James Wakefield" <wakey_99@.yahoo.com> wrote in message
>> news:%23EbRdSHxEHA.1524@.TK2MSFTNGP09.phx.gbl...
>> > Hi,
>> >
>> > Do I need the full visual studio 2003 to design reporting services
>> > forms?
>> > Can I maybe use a cut down version to design forms, as we cannot afford
>> > the upgrade fees.
>> >
>> > Thanks
>> >
>>

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 Design Question

Hi everyone!
I am developing a Work Order report similar to the "Adventure Works Cycles"
sample provided with Reporting Services. What I would like to do is repeat
the "Header" information on each page. I am looking at the samples for an
example on how to do this but no luck. I even reduced the height of the
"Adventure Works Cycles" sample report to see if it's Header data is carried
over and it isn't.
How do I get my "Header" data to carry over to the next page. I tried adding
it to the page Header but it doesn't like field data in it.
Thanks in advance,
YoshiLook at the Header attibute for the Table. It can be set to repeat on each
page.
--
| From: "Yoshi" <yoshi@.home.com>
| Subject: Report Design Question
| Date: Wed, 17 Nov 2004 10:06:03 -0600
| Lines: 17
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#YmgY9LzEHA.1292@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: cs24174142-174.satx.rr.com 24.174.142.174
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10|||My header data is not in the table as I am confined to the column width. I
placed the header data in the body of the report above the table. I used the
"Adventure Works Cycles" sample provided by Microsoft, as my guide.
My problem is when the detail lines carry over to the next page. I would
like page 2 to have the same header data that page 1 has. In fact, I want
subsequent pages to look like page 1 with the header data.
Make sense?
Thanks,
Yoshi
""Brad Syputa - MS"" <bradsy@.Online.Microsoft.com> wrote in message
news:wbVFvhNzEHA.2916@.cpmsftngxa10.phx.gbl...
> Look at the Header attibute for the Table. It can be set to repeat on each
> page.
> --
> | From: "Yoshi" <yoshi@.home.com>
> | Subject: Report Design Question
> | Date: Wed, 17 Nov 2004 10:06:03 -0600
> | Lines: 17
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
> | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#YmgY9LzEHA.1292@.TK2MSFTNGP10.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: cs24174142-174.satx.rr.com 24.174.142.174
> | Path:
> cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10
> phx.gbl
> | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:35173
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hi everyone!
> |
> | I am developing a Work Order report similar to the "Adventure Works
> Cycles"
> | sample provided with Reporting Services. What I would like to do is
> repeat
> | the "Header" information on each page. I am looking at the samples for
> an
> | example on how to do this but no luck. I even reduced the height of the
> | "Adventure Works Cycles" sample report to see if it's Header data is
> carried
> | over and it isn't.
> |
> | How do I get my "Header" data to carry over to the next page. I tried
> adding
> | it to the page Header but it doesn't like field data in it.
> |
> | Thanks in advance,
> |
> | Yoshi
> |
> |
> |
>|||Place the header in a table group - go to Edit Group and select the
"Repeat Header" option.|||Unfortunately, my header will not work in the "Table" header row. The
columns do not allow for the correct width.
Thanks for the response.
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100725306.172333.164530@.z14g2000cwz.googlegroups.com...
> Place the header in a table group - go to Edit Group and select the
> "Repeat Header" option.
>|||Techinically - Yoshi - you are not confined to keeping your header
outside the table. If this is the problem - then place the header back
in the header (or group header) section of the table. If for example
this is a single header in the header section of the table then you can
put the header in the left-most cell then select the adjacent cells in
the header row (by pressing Ctrl-click.) Once all the cells from that
row are selected - right-click the slected cells and select the "Merge
Cells" option. This will merger the cels an that row only - and will
leave the Details section rows intact.
Lastly if this is a stand alone text-object over a table - then right
click the textbox you want to repeat and select Properties. Then select
the Advanced button at the bottom left corner - on the General tab
there should be an option selected called "Repeat report item..." and
beneath it is a drop-down - select the table you wish the object to
repoeat with in each page and you should be in business. If your table
is named Table1 - then select Table1.
Let us know how it turns out.|||I really appreciate everyone's input. Thank you!
Hi. I tried the 2nd suggestion where I selected my stand alone text-object
that is over my table.
I right clicked the textbox and selected Properties. I then clicked the the
Advanced button at the bottom left corner on the General tab. I then clicked
the "Repeat report item with data region on every page" and selected the
"table 1" Data region in the drop down.
I run the report and it doesn't repeat the header textbox on the subsequent
pages. I believe this is all I need to do. This should repeat the text box
for the data region when it spans multiple pages, correct?
Basically, I want my header text boxes to repeat on each page. Just as if I
placed then in the Group header row in the table. Unfortunately, the header
data is formatted in such a way that the table does not lend itself for this
design.
Thanks again!
Yosh
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100731569.214512.82360@.z14g2000cwz.googlegroups.com...
> Techinically - Yoshi - you are not confined to keeping your header
> outside the table. If this is the problem - then place the header back
> in the header (or group header) section of the table. If for example
> this is a single header in the header section of the table then you can
> put the header in the left-most cell then select the adjacent cells in
> the header row (by pressing Ctrl-click.) Once all the cells from that
> row are selected - right-click the slected cells and select the "Merge
> Cells" option. This will merger the cels an that row only - and will
> leave the Details section rows intact.
> Lastly if this is a stand alone text-object over a table - then right
> click the textbox you want to repeat and select Properties. Then select
> the Advanced button at the bottom left corner - on the General tab
> there should be an option selected called "Repeat report item..." and
> beneath it is a drop-down - select the table you wish the object to
> repoeat with in each page and you should be in business. If your table
> is named Table1 - then select Table1.
> Let us know how it turns out.
>|||The textbox will only repeat each time the table repeats - so if it's
one table spanning multiple pages then you may be SOL with option 2.
How is the header formatted in such a way that it cannot be displayed
in a table header? Unfortunately I think you are going to have to put
that header in the table if you want to see it repeat across multiple
pages - if option 2 didnt work.|||It seems that if the table itself repeats then the text box will repeat
- but since it is a single table spanning mulitple pages that it will
not repeat. What is special about the header that it can't be placed in
the table itself? Because it seems at this point that you will have to
go with option A (header in the table) if you want this to work.|||Option 2 was a great suggestion but your right, it's not working because of
what you said.
Option 1 will have to do. I will need to change the format of the header so
that it works and looks nice. I hope the client says it's ok.
Thank you for being so patient and persistant with my questions/posts. I
really appreciate it!
Take care,
Yosh
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100733672.095005.163320@.z14g2000cwz.googlegroups.com...
> The textbox will only repeat each time the table repeats - so if it's
> one table spanning multiple pages then you may be SOL with option 2.
> How is the header formatted in such a way that it cannot be displayed
> in a table header? Unfortunately I think you are going to have to put
> that header in the table if you want to see it repeat across multiple
> pages - if option 2 didnt work.
>|||I believe part of the problem is the original "report" was done in Excel. I
come from the Crystal Report side of development where I could put data
fields pretty much anywhere using "free-form" placement.
I am not used to inserting column after column and merging cells to get a
very wide data field to look right in a table? That make sense?
Learning curve I guess. =0}
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100734006.823128.176120@.z14g2000cwz.googlegroups.com...
> It seems that if the table itself repeats then the text box will repeat
> - but since it is a single table spanning mulitple pages that it will
> not repeat. What is special about the header that it can't be placed in
> the table itself? Because it seems at this point that you will have to
> go with option A (header in the table) if you want this to work.
>|||Absolutely - I come from Crystal Reports side also. I have just started
with this Reporting Services stuff about a month ago. The learning
curve can be steep here. All I can say is get ready for some more pain.
This table header business you will find to be the least of your
problems.|||Hey... Thanks Papaboom! =0}
Reporting Services makes me appreciate Crystal alot more. However, I do see
how powerful Reporting Services can become. I am very excited about the ease
of use.
Maybe you can answer this question. I have a page footer that has 1 textbox
with today's date. When I export the report, the page footer is left out.
It's not exported.
I don't know why this is happening.
Thanks so much!
Y
"papaboom" <smith.jamie@.gmail.com> wrote in message
news:1100795491.349175.78160@.f14g2000cwb.googlegroups.com...
> Absolutely - I come from Crystal Reports side also. I have just started
> with this Reporting Services stuff about a month ago. The learning
> curve can be steep here. All I can say is get ready for some more pain.
> This table header business you will find to be the least of your
> problems.
>|||Sorry Yosh - on this one I havent the slightest. The most I've done
with exporting is export a couple of reports to PDF.

Report Design Previewer and Data Processing Extension DLL's

Hi all,
Do I need to define the Data Processing Extension (DPE) DLL's in the
Designer policy file: rspreviewpolicy.config ?
It's been my experience that the Report Preview mode runs in some "special"
mode that seems to bypass CAS (Code Access Security) - this makes me wonder
then if I need to define my DPE DLL's in Code Groups in this
rspreviewpolicy.config file at all.
Anyone with comments on this topic ?
- SimonSimon,
There are two preview modes - Report Preview (the Preview tab on the Report
Designer) which doesn't use CAS and the Report Host mode (F5) which uses the
settings in the rspreviewpolicy.config. The purpose of the later is to
similate the Report Server environment.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:345062E5-7002-45AD-A37D-B2126CE48354@.microsoft.com...
> Hi all,
> Do I need to define the Data Processing Extension (DPE) DLL's in the
> Designer policy file: rspreviewpolicy.config ?
> It's been my experience that the Report Preview mode runs in some
"special"
> mode that seems to bypass CAS (Code Access Security) - this makes me
wonder
> then if I need to define my DPE DLL's in Code Groups in this
> rspreviewpolicy.config file at all.
> Anyone with comments on this topic ?
> - Simon
>|||Teo,
Thanks for the quick response - I was just about to post my findings when I
saw you had already answered !
I found details on this subject at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_rdl_8mue.asp
<-- Snip -->
... There are two preview modes for Report Designer: the preview tab and
the pop-up preview window that is launched when your report project is
started in DebugLocal mode. The preview tab executes all report expressions
using the FullTrust permission set and does not apply security policy
settings. ...
<-- Snip -->
thanks again,
- Simonsql

Report design Issues.

Hi All,
Please let me know of this problem.
Can I have a static row in a matrix'
The design of the report should be like this
Matrix Header
Totals : Static Header
Row1
Row2
Row3
Labor : Static Header
Row4
Row5
Row6
The number of rows in each section is the same (only three)..
I have been breaking my head to get the design right...
Any help please....
Thanks in Advance.....I have an example of a Matrix report with Static columns on
www.msbicentral.com
register, then go to downloads, Reporting Services, RDL and search for
Static... The file is Matrix.StaticColumns.RDL
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"CCP" <CCP@.discussions.microsoft.com> wrote in message
news:636BC8E1-D49A-4130-A393-FC132812593D@.microsoft.com...
> Hi All,
> Please let me know of this problem.
> Can I have a static row in a matrix'
> The design of the report should be like this
> Matrix Header
> Totals : Static Header
> Row1
> Row2
> Row3
> Labor : Static Header
> Row4
> Row5
> Row6
>
> The number of rows in each section is the same (only three)..
> I have been breaking my head to get the design right...
> Any help please....
> Thanks in Advance.....
>
>

Report design issue

Hi,
i need to design a report similiar as the one below...
Category Time / Expense Type Totals 1/5 1/6 1/7 1/8 1/9
Regular Hours
Engineer PLC Programming 96.00 8.00 16.00 16.00 8.00
Engineer General 88.00 8.00 20.00 20.00 20.00 Project
Manager Validation 110.00 20.00 15.00 15.00
Project Manager General Head Office 24.00 8.00
Totals: 318.00 36.00 39.00 51.00 43.00 51.00
Overtime Hours
Engineer Validation San Francisco 48.00 8.00 8.00 8.00
Project Manager General San Francisco 32.00 8.00 8.00 8.00
Totals: 80.00 16.00 16.00 16.00 16.00 8.00
Expenses
Engineer Airfare $600.00 $300.00
Engineer Lodging $560.00 $80.00 $80.00 $80.00
Engineer Misc $25.00 $20.00 $5.00
Project Manager Airfare $1,800.00 $300.00 $400.00 Project
Manager Lodging $630.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00
$90.00
Equipment Equipment $999.00 $999.00
Totals: $4,614.00 $1,789.00 $575.00 $570.00 $570.00 $470.00 $0.00
$300.00 $170.00 $170.00
The 3 sections regular hours,overtimehours and expense are in 3
different tables in the database...
Please let me know the design for this kind of report..
ThanksLet me explain the report in detail...
----
HEADER1 HEADER2 tOTAL 1/2 1/3 1/4 1/
----
SECTION1
VALUE1 VALUE1 4.00 2.00 2.00
VALUE2 vALUE2 5.00 2.00
3.00
TOTAL 9.00 4.00
2.00 3.0
----
SECTION2
VALUE1 VALUE1 4.00 2.00 2.00
VALUE2 vALUE2 5.00 2.00
3.00
TOTAL 9.00 4.00
2.00 3.0
----
SECTION3
VALUE1 VALUE1 4.00 2.00 2.00
VALUE2 vALUE2 5.00 2.00
3.00
TOTAL 9.00 4.00
2.00 3.0
----
AS I MENTIONED THE 3 SECTION NEEDS TO BE REPETIVE (THESE 3 SECTIONS WILL BE
REPEATED FOR EACH DIFFERENT PROJECT) AND THEY ARE COMING FROM THE 3
DIFFERENT STORED PROCUDEURES....
IF A PARTICULAR SECTION HAS NO VALUES THEN THAT SECTION NEED NOT BE
SHOWN......
"CCP" wrote:
> Hi,
> i need to design a report similiar as the one below...
>
> Category Time / Expense Type Totals 1/5 1/6 1/7 1/8 1/9
> Regular Hours
> Engineer PLC Programming 96.00 8.00 16.00 16.00 8.00
> Engineer General 88.00 8.00 20.00 20.00 20.00 Project
> Manager Validation 110.00 20.00 15.00 15.00
> Project Manager General Head Office 24.00 8.00
> Totals: 318.00 36.00 39.00 51.00 43.00 51.00
> Overtime Hours
> Engineer Validation San Francisco 48.00 8.00 8.00 8.00
> Project Manager General San Francisco 32.00 8.00 8.00 8.00
> Totals: 80.00 16.00 16.00 16.00 16.00 8.00
> Expenses
> Engineer Airfare $600.00 $300.00
> Engineer Lodging $560.00 $80.00 $80.00 $80.00
> Engineer Misc $25.00 $20.00 $5.00
> Project Manager Airfare $1,800.00 $300.00 $400.00 Project
> Manager Lodging $630.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00
> $90.00
> Equipment Equipment $999.00 $999.00
> Totals: $4,614.00 $1,789.00 $575.00 $570.00 $570.00 $470.00 $0.00
> $300.00 $170.00 $170.00
> The 3 sections regular hours,overtimehours and expense are in 3
> different tables in the database...
> Please let me know the design for this kind of report..
> Thanks
>|||Don't want much, do you? I'm sure there are consultants out there somewhere
that would be happy to design your report for you....for a fee.
"CCP" wrote:
> Let me explain the report in detail...
> ----
> HEADER1 HEADER2 tOTAL 1/2 1/3 1/4 1/5
> ----
> SECTION1
> VALUE1 VALUE1 4.00 2.00 2.00
> VALUE2 vALUE2 5.00 2.00
> 3.00
> TOTAL 9.00 4.00
> 2.00 3.00
> ----
> SECTION2
> VALUE1 VALUE1 4.00 2.00 2.00
> VALUE2 vALUE2 5.00 2.00
> 3.00
> TOTAL 9.00 4.00
> 2.00 3.00
> ----
> SECTION3
> VALUE1 VALUE1 4.00 2.00 2.00
> VALUE2 vALUE2 5.00 2.00
> 3.00
> TOTAL 9.00 4.00
> 2.00 3.00
> ----
> AS I MENTIONED THE 3 SECTION NEEDS TO BE REPETIVE (THESE 3 SECTIONS WILL BE
> REPEATED FOR EACH DIFFERENT PROJECT) AND THEY ARE COMING FROM THE 3
> DIFFERENT STORED PROCUDEURES....
> IF A PARTICULAR SECTION HAS NO VALUES THEN THAT SECTION NEED NOT BE
> SHOWN......
> "CCP" wrote:
> > Hi,
> > i need to design a report similiar as the one below...
> >
> >
> >
> > Category Time / Expense Type Totals 1/5 1/6 1/7 1/8 1/9
> > Regular Hours
> > Engineer PLC Programming 96.00 8.00 16.00 16.00 8.00
> > Engineer General 88.00 8.00 20.00 20.00 20.00 Project
> > Manager Validation 110.00 20.00 15.00 15.00
> > Project Manager General Head Office 24.00 8.00
> > Totals: 318.00 36.00 39.00 51.00 43.00 51.00
> > Overtime Hours
> > Engineer Validation San Francisco 48.00 8.00 8.00 8.00
> > Project Manager General San Francisco 32.00 8.00 8.00 8.00
> > Totals: 80.00 16.00 16.00 16.00 16.00 8.00
> > Expenses
> > Engineer Airfare $600.00 $300.00
> > Engineer Lodging $560.00 $80.00 $80.00 $80.00
> > Engineer Misc $25.00 $20.00 $5.00
> > Project Manager Airfare $1,800.00 $300.00 $400.00 Project
> > Manager Lodging $630.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00
> > $90.00
> > Equipment Equipment $999.00 $999.00
> > Totals: $4,614.00 $1,789.00 $575.00 $570.00 $570.00 $470.00 $0.00
> > $300.00 $170.00 $170.00
> >
> > The 3 sections regular hours,overtimehours and expense are in 3
> > different tables in the database...
> > Please let me know the design for this kind of report..
> >
> > Thanks
> >|||No......
Im very new to reporting services and to programming too....
thought i would get some valuable here which could help me learn sql
reporting services......
"Ronathospice" wrote:
> Don't want much, do you? I'm sure there are consultants out there somewhere
> that would be happy to design your report for you....for a fee.
>
> "CCP" wrote:
> >
> > Let me explain the report in detail...
> > ----
> > HEADER1 HEADER2 tOTAL 1/2 1/3 1/4 1/5
> > ----
> > SECTION1
> > VALUE1 VALUE1 4.00 2.00 2.00
> > VALUE2 vALUE2 5.00 2.00
> > 3.00
> > TOTAL 9.00 4.00
> > 2.00 3.00
> > ----
> > SECTION2
> > VALUE1 VALUE1 4.00 2.00 2.00
> > VALUE2 vALUE2 5.00 2.00
> > 3.00
> > TOTAL 9.00 4.00
> > 2.00 3.00
> > ----
> > SECTION3
> > VALUE1 VALUE1 4.00 2.00 2.00
> > VALUE2 vALUE2 5.00 2.00
> > 3.00
> > TOTAL 9.00 4.00
> > 2.00 3.00
> > ----
> >
> > AS I MENTIONED THE 3 SECTION NEEDS TO BE REPETIVE (THESE 3 SECTIONS WILL BE
> > REPEATED FOR EACH DIFFERENT PROJECT) AND THEY ARE COMING FROM THE 3
> > DIFFERENT STORED PROCUDEURES....
> > IF A PARTICULAR SECTION HAS NO VALUES THEN THAT SECTION NEED NOT BE
> > SHOWN......
> >
> > "CCP" wrote:
> >
> > > Hi,
> > > i need to design a report similiar as the one below...
> > >
> > >
> > >
> > > Category Time / Expense Type Totals 1/5 1/6 1/7 1/8 1/9
> > > Regular Hours
> > > Engineer PLC Programming 96.00 8.00 16.00 16.00 8.00
> > > Engineer General 88.00 8.00 20.00 20.00 20.00 Project
> > > Manager Validation 110.00 20.00 15.00 15.00
> > > Project Manager General Head Office 24.00 8.00
> > > Totals: 318.00 36.00 39.00 51.00 43.00 51.00
> > > Overtime Hours
> > > Engineer Validation San Francisco 48.00 8.00 8.00 8.00
> > > Project Manager General San Francisco 32.00 8.00 8.00 8.00
> > > Totals: 80.00 16.00 16.00 16.00 16.00 8.00
> > > Expenses
> > > Engineer Airfare $600.00 $300.00
> > > Engineer Lodging $560.00 $80.00 $80.00 $80.00
> > > Engineer Misc $25.00 $20.00 $5.00
> > > Project Manager Airfare $1,800.00 $300.00 $400.00 Project
> > > Manager Lodging $630.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00
> > > $90.00
> > > Equipment Equipment $999.00 $999.00
> > > Totals: $4,614.00 $1,789.00 $575.00 $570.00 $570.00 $470.00 $0.00
> > > $300.00 $170.00 $170.00
> > >
> > > The 3 sections regular hours,overtimehours and expense are in 3
> > > different tables in the database...
> > > Please let me know the design for this kind of report..
> > >
> > > Thanks
> > >|||This is a simple LEFT join assuming there is a key that ties all three tables
together.
SELECT section, a.header1, a.header2
, SUM(ISNULL(a.hours ,0) + ISNULL(b.hours ,0) + ISNULL(c.hours ,0))
,ISNULL(a.hours ,0)
,ISNULL(b.hours ,0)
ISNULL(c.hours ,0)
FROM table1 a
LEFT JOIN table 2 on a.id = b.id
LEFT JOIN table 3 on a.id = c.id
GROUP BY section, a.header1, a.header2
The grouping would also need to be declared in the report output
with a sum function going in the group footer.
Good luck|||Thanks William,
ur method was very helpful for me.....
One problem though is the date field is dynamic, so can i use a matrix
instead of a table and get that design
Thanks for ur time and understanding....
"William" wrote:
> This is a simple LEFT join assuming there is a key that ties all three tables
> together.
> SELECT section, a.header1, a.header2
> , SUM(ISNULL(a.hours ,0) + ISNULL(b.hours ,0) + ISNULL(c.hours ,0))
> ,ISNULL(a.hours ,0)
> ,ISNULL(b.hours ,0)
> ISNULL(c.hours ,0)
> FROM table1 a
> LEFT JOIN table 2 on a.id = b.id
> LEFT JOIN table 3 on a.id = c.id
> GROUP BY section, a.header1, a.header2
> The grouping would also need to be declared in the report output
> with a sum function going in the group footer.
> Good luck

Report Design help for Newb - Regarding Date Paramaters

I have been trying very hard for days now to build a report using VS 2003.net
I just need to query an order table by a date range. ie) from date a to
date b. The order table contains PO's and have recorded dates. I just need
an example of how to report based upon date range. Seems simple enough,
just cant figure it out.I assume you mean you want the user to be able to specify the date range?
If you currently have a sql statement that returns all orders and have a
report that displays that data, simply modify the sql statement and specify:
where datefield between @.startdate and @.enddate
That will automatically create report parameters. When you preview the
report, it will prompt you to type in start and end dates.
For more info, just do searches for query parameters and report parameters.
Mike G.
"tdodd" <tdodd@.discussions.microsoft.com> wrote in message
news:6A7F2EE5-FAFA-4852-B771-35FBC9431D71@.microsoft.com...
>I have been trying very hard for days now to build a report using VS
>2003.net
> I just need to query an order table by a date range. ie) from date a to
> date b. The order table contains PO's and have recorded dates. I just
> need
> an example of how to report based upon date range. Seems simple enough,
> just cant figure it out.

Report Design & Layout

Hi Everybody, i have been having problems in design & layout of the following report .
i need the report layout as follows a
-
HP- FIELDS IN HEADER OF PAGE -REPEATED IN EVERY PAGE.
HR- FIELDS IN HEADER OF REPORT-ONLY ONCE ON 1st PAGE OF REPORT.

i have created a table report in the body of the report as follows.

HP - In Page Header, i have placed some text and page no
HR - In Table Header, i have placed some text & fields.
HP - In Group Header 1, i have some text & fields. & RepeatOnNewPage = true
HR - IN GROUP HEADER 1, text & fields, which i want to repeat on only 1st page.
(this is were i am having problems to set the group header for the table to
to repeat only on 1st page)
HP - In Group Header 1, some text & fields
DETAIL- some fields.

I would really appreciate your help, or any changes in design & layout of the report.

Thanks A lot IN ADVANCE
Sud

As I understand your issue, you have three rows in Group Header 1, the first row you want to repeat on every page, the second row you only want it to show on the 1st page, is this correct?

You can try creating two groups with the same group expressions. Put the first row in the first group and mark it RepeatOnNewPage. Put the second row in the second group and don't repeat it.

Wednesday, March 21, 2012

Report Builder Reports Filtering or Grouping at runtime possible?

I have a problem and i wonder whether it is possible select filter and sort
options at execution time not design time for report builder reportsGo to
http://www.msbicentral.com/Downloads/ReportingServices/RDLFiles/tabid/34/Default.aspx.
You'll have to register for a free login. There is an example of sorting at
run time, there may be one for filtering also.
"Yuksel" wrote:
> I have a problem and i wonder whether it is possible select filter and sort
> options at execution time not design time for report builder reports|||but i am not be able to download sample rdl files
"daw" wrote:
> Go to
> http://www.msbicentral.com/Downloads/ReportingServices/RDLFiles/tabid/34/Default.aspx.
> You'll have to register for a free login. There is an example of sorting at
> run time, there may be one for filtering also.
>
> "Yuksel" wrote:
> > I have a problem and i wonder whether it is possible select filter and sort
> > options at execution time not design time for report builder reports

Saturday, February 25, 2012

Report and Query Design

Hi all - have finally got reporting services working and am wondering how I would go about designing an order form. I have 2 tables - order and orderline.

Would it be best to design a query which got all information in one retrievale (so that orderid is repeated on each record retrieved) or 2 seperate queries and therefore use a subreport - the main report having the order details and the subreport containing all the orderlines.

Thanks in advance,


Stephen.

The best way to do this by using subReport or drillthrough report where you get the main data in the first report and each row will navigate to the sub report and get the detials fro great start and sample

please read this is article it also contains great sample

http://www.gotreportviewer.com/