Raster Catalog: reporting

Showing posts with label reporting. Show all posts

Friday, March 30, 2012

Reading a record without placing a lock

Dear All,
I have one server application running which continously reading and
updating a DB.
While there is a Reporting tool which generating reports.
The reports can fail, but the server application cannot. So, I need to
run a query in the Reporting tool without placing a lock on the DB
(totally transaprent to the server).
Currently this is what I am doing.
SELECT * FROM Data WITH (NOLOCK);
Question:
1. Am I doing it correctly?
2. Is there a better way of doing? Example: setting the LOCK MODE
(instead of specifying NOLOCK on every command)
Thanks in advance.<ckkwan@.my-deja.com> wrote in message
news:e9061fce-a45f-4866-9f90-9a3e0043c5fc@.s33g2000pri.googlegroups.com...
> Dear All,
> I have one server application running which continously reading and
> updating a DB.
> While there is a Reporting tool which generating reports.
> The reports can fail, but the server application cannot. So, I need to
> run a query in the Reporting tool without placing a lock on the DB
> (totally transaprent to the server).
> Currently this is what I am doing.
> SELECT * FROM Data WITH (NOLOCK);
> Question:
> 1. Am I doing it correctly?
> 2. Is there a better way of doing? Example: setting the LOCK MODE
> (instead of specifying NOLOCK on every command)
> Thanks in advance.
Hi
You can set the transaction isolation level to read uncommitted for the
session, but then you are potentially going to have dirty reads. Other ways
to do this would be to offload the reporting database either by using log
shipping, replication, mirroring or a snapshot.
John|||Hi
> 1. Am I doing it correctly?
No. What if some user inserts/deletes the row while you are reading. You
are about to get an inconsistent data. For example
you have tree pages with data like a) 10,40,60 b) 80,100,90 c)110,70,85 ,
so while you read page A another connection inserst the value let me say
50, but you have already read data from the page A , so it moves the all
data to a new created page so now that data looks like a)10,40 ,50,
b) 80,100,90 c)110,70,85 ,d)60 ... and as you keep reading you get
60(duplicate) from page D as well.
> 2. Is there a better way of doing? Example: setting the LOCK MODE
> (instead of specifying NOLOCK on every command)
Yes , you can use TABLOCK hint or if you use SQL Server 2005 take a look
at SNAPSHOT ISOLATION LEVEL in the BOL
<ckkwan@.my-deja.com> wrote in message
news:e9061fce-a45f-4866-9f90-9a3e0043c5fc@.s33g2000pri.googlegroups.com...
> Dear All,
> I have one server application running which continously reading and
> updating a DB.
> While there is a Reporting tool which generating reports.
> The reports can fail, but the server application cannot. So, I need to
> run a query in the Reporting tool without placing a lock on the DB
> (totally transaprent to the server).
> Currently this is what I am doing.
> SELECT * FROM Data WITH (NOLOCK);
> Question:
> 1. Am I doing it correctly?
> 2. Is there a better way of doing? Example: setting the LOCK MODE
> (instead of specifying NOLOCK on every command)
> Thanks in advance.|||Thanks for the info, as I have mentioned earlier in my post, the
Reporting tool can afford to fail, so I don't really mind the data
inconsistency.
There is something like LOCK MODE in informix where we can set the
LOCK hint globally for a specific connection. Is there something
similar in SqlServer (and no, this is not the ISOLATION LEVEL).
On Apr 13, 7:24=A0pm, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hi
> > 1. Am I doing it correctly?
> No. What if some user inserts/deletes the row =A0while =A0you are reading.= You
> are about to get an inconsistent data. For example
> =A0you have tree pages with data =A0like a) 10,40,60 b) 80,100,90 =A0c)110=,70,85 ,
> so while =A0you read page A =A0another connection inserst the value let me= say
> 50, but you have already read data =A0from the page A , so it moves the al=l
> data to a new created page so now that data looks like =A0a)10,40 ,50,
> b) 80,100,90 =A0c)110,70,85 ,d)60 ... and =A0as you keep reading =A0you g=et
> 60(duplicate) from page D as well.
> > 2. Is there a better way of doing? Example: setting the LOCK MODE
> > (instead of specifying NOLOCK on every command)
> Yes , you can use TABLOCK hint =A0or if you use SQL Server 2005 =A0take a =look
> at SNAPSHOT ISOLATION LEVEL in the BOL
> <ckk...@.my-deja.com> wrote in message|||<ckkwan@.my-deja.com> wrote in message
news:2d0f36bc-e70e-40c6-8961-145d20c66e59@.q1g2000prf.googlegroups.com...
Thanks for the info, as I have mentioned earlier in my post, the
Reporting tool can afford to fail, so I don't really mind the data
inconsistency.
There is something like LOCK MODE in informix where we can set the
LOCK hint globally for a specific connection. Is there something
similar in SqlServer (and no, this is not the ISOLATION LEVEL).
On Apr 13, 7:24 pm, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hi
> > 1. Am I doing it correctly?
> No. What if some user inserts/deletes the row while you are reading. You
> are about to get an inconsistent data. For example
> you have tree pages with data like a) 10,40,60 b) 80,100,90 c)110,70,85 ,
> so while you read page A another connection inserst the value let me say
> 50, but you have already read data from the page A , so it moves the all
> data to a new created page so now that data looks like a)10,40 ,50,
> b) 80,100,90 c)110,70,85 ,d)60 ... and as you keep reading you get
> 60(duplicate) from page D as well.
> > 2. Is there a better way of doing? Example: setting the LOCK MODE
> > (instead of specifying NOLOCK on every command)
> Yes , you can use TABLOCK hint or if you use SQL Server 2005 take a look
> at SNAPSHOT ISOLATION LEVEL in the BOL
> <ckk...@.my-deja.com> wrote in message
Hi
I can't see how unreliability and inconsistence made the user requirements
for this system!
John|||<<There is something like LOCK MODE in informix where we can set the
LOCK hint globally for a specific connection. Is there something
similar in SqlServer (and no, this is not the ISOLATION LEVEL).>>
The ANSI SQL Compliant way to describe how much you want to be isolated from other users is the SET
TRANSACTION ISOLATION command. SQL Server supports this, and READ UNCOMMITTED seems to do what you
want. Apparently Informix has a non-standard command named LOCK MODE, something that SQL Server do
not have. Assuming these indeed do the same thing, I support MS for using the ANSI SQL compliant
name for the command instead of some other command name. If they do not do the same, perhaps you can
enlighten un in what way they differ?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<ckkwan@.my-deja.com> wrote in message
news:2d0f36bc-e70e-40c6-8961-145d20c66e59@.q1g2000prf.googlegroups.com...
Thanks for the info, as I have mentioned earlier in my post, the
Reporting tool can afford to fail, so I don't really mind the data
inconsistency.
There is something like LOCK MODE in informix where we can set the
LOCK hint globally for a specific connection. Is there something
similar in SqlServer (and no, this is not the ISOLATION LEVEL).
On Apr 13, 7:24 pm, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hi
> > 1. Am I doing it correctly?
> No. What if some user inserts/deletes the row while you are reading. You
> are about to get an inconsistent data. For example
> you have tree pages with data like a) 10,40,60 b) 80,100,90 c)110,70,85 ,
> so while you read page A another connection inserst the value let me say
> 50, but you have already read data from the page A , so it moves the all
> data to a new created page so now that data looks like a)10,40 ,50,
> b) 80,100,90 c)110,70,85 ,d)60 ... and as you keep reading you get
> 60(duplicate) from page D as well.
> > 2. Is there a better way of doing? Example: setting the LOCK MODE
> > (instead of specifying NOLOCK on every command)
> Yes , you can use TABLOCK hint or if you use SQL Server 2005 take a look
> at SNAPSHOT ISOLATION LEVEL in the BOL
> <ckk...@.my-deja.com> wrote in message

Monday, March 26, 2012

Read perfmon log into SQL table

Is there a way i can import the .blg perfmon counter log into a table for
reporting purposesUsing Performance (System) Monitor in Windows 2000 and 2003, you can save
the log to the text file. Then you can use Bulk Insert to copy the data to a
table. I don't remember for Win 2k, but in Win 2003 you can save it even
directly to a SQL table.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:#XqypYBfDHA.1888@.TK2MSFTNGP12.phx.gbl...
> Is there a way i can import the .blg perfmon counter log into a table for
> reporting purposes
>|||Since you have the perfmon file in binary format you can pull out the actual
counters you want as csv using win2k resource kit program relog.exe. Then
create a table with the desired structure and bcp it in, or do a DTS import.
If you are running on xp or 2003 you can have perfmon log straight to a sql
server database.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:#XqypYBfDHA.1888@.TK2MSFTNGP12.phx.gbl...
> Is there a way i can import the .blg perfmon counter log into a table for
> reporting purposes
>

Read Only Reporting Server Active/Active Configuration

I currently have an active/passive cluster acting as our OLTP TX database
server that is replicating to another active/passive cluster acting as a
Reporting database server.
I have heard that if the database is read-only (e.g. reporting server) that
it is possible to set the sql server application in an active/active mode and
have requests be handled by both of the servers (e.g. shared access to a
single databse). This is what I want to do, but I don't think it is possible
since one node will be given access to the disk resources, correct?
I guess the only way to really use active/active is to have two sql server
instances each with its own disk resources that are supporting two
independent applications and then upon failure the non-failed node handles
both applications. This isn't really what I want to do because I want to
load-balance read-only requests to the same database across two servers;
which I am not able to do. Am I understanding this correctly?
The correct name is scalable shared databases, where multiple SQL 2005
servers are accessing a read-only volume.
there are many restrictions to this
Please see ; http://support.microsoft.com/default...b;en-us;910378
for more info on this
HTH,
_Edwin.
"Larry Herbinaux" <LarryHerbinaux@.discussions.microsoft.com> wrote in
message news:981C4446-DC47-43D3-B071-742BCEE767F3@.microsoft.com...
> I currently have an active/passive cluster acting as our OLTP TX database
> server that is replicating to another active/passive cluster acting as a
> Reporting database server.
> I have heard that if the database is read-only (e.g. reporting server)
that
> it is possible to set the sql server application in an active/active mode
and
> have requests be handled by both of the servers (e.g. shared access to a
> single databse). This is what I want to do, but I don't think it is
possible
> since one node will be given access to the disk resources, correct?
> I guess the only way to really use active/active is to have two sql server
> instances each with its own disk resources that are supporting two
> independent applications and then upon failure the non-failed node handles
> both applications. This isn't really what I want to do because I want to
> load-balance read-only requests to the same database across two servers;
> which I am not able to do. Am I understanding this correctly?
>
|||Thanks Edwin,
Is this also supported for SQL 2000 or just SQL 2005?
If reporting really needed to scale and the reporting requirements for some
reports needed to be up to the minute but most of the reports could use data
that was a day old, then this seems like the following configuration would
seem to give you the most bang for your buck, correct?
TX Database - 2-Node Active/Passive
Reporting Database Replicated - 2-Node Active/Passive - This would have the
entire TX Database replicated in real-time like we have today. Client access
to this database would be limited to the reports that needed to be accurate
to the minute.
Reporting Database Manual - N-Node Active/Active/Active... - This would have
two volumes as discussed in the article, and the operational volume would be
swapped out with the newly built volume just after midnight with a newer data
set. Client access to this database would limited to the reports that don't
need to be up to the minute accurate. During the downtime, access to the
Reporting Database Replicated cluster could be changed to allow all reports
to be run from it; given the fact that these changes would be done at
midnight, the load on this servers shouldn't be very great so it should be
able to handle the additional reports.
"Edwin vMierlo" wrote:

> The correct name is scalable shared databases, where multiple SQL 2005
> servers are accessing a read-only volume.
> there are many restrictions to this
> Please see ; http://support.microsoft.com/default...b;en-us;910378
> for more info on this
> HTH,
> _Edwin.
>
> "Larry Herbinaux" <LarryHerbinaux@.discussions.microsoft.com> wrote in
> message news:981C4446-DC47-43D3-B071-742BCEE767F3@.microsoft.com...
> that
> and
> possible
>
>
|||answers inline
"Larry Herbinaux" <LarryHerbinaux@.discussions.microsoft.com> wrote in
message news:F5FD9768-8D48-409C-8431-338CFD7B9D49@.microsoft.com...
> Thanks Edwin,
> Is this also supported for SQL 2000 or just SQL 2005?
SQL 2005 Enterprise Edition

> If reporting really needed to scale and the reporting requirements for
some
> reports needed to be up to the minute but most of the reports could use
data
> that was a day old, then this seems like the following configuration would
> seem to give you the most bang for your buck, correct?
> TX Database - 2-Node Active/Passive
> Reporting Database Replicated - 2-Node Active/Passive - This would have
the
> entire TX Database replicated in real-time like we have today. Client
access
> to this database would be limited to the reports that needed to be
accurate
> to the minute.
> Reporting Database Manual - N-Node Active/Active/Active... - This would
have
> two volumes as discussed in the article, and the operational volume would
be
> swapped out with the newly built volume just after midnight with a newer
data
> set. Client access to this database would limited to the reports that
don't
> need to be up to the minute accurate. During the downtime, access to the
> Reporting Database Replicated cluster could be changed to allow all
reports
> to be run from it; given the fact that these changes would be done at
> midnight, the load on this servers shouldn't be very great so it should be
> able to handle the additional reports.
Yes, while you are "swapping" in the new data, you will have downtime
[vbcol=seagreen]
> "Edwin vMierlo" wrote:
http://support.microsoft.com/default...b;en-us;910378[vbcol=seagreen]
database[vbcol=seagreen]
a[vbcol=seagreen]
mode[vbcol=seagreen]
a[vbcol=seagreen]
server[vbcol=seagreen]
handles[vbcol=seagreen]
to[vbcol=seagreen]
servers;[vbcol=seagreen]

Read Only permission for ReportingServices.GetPolicies()

I would like for a user to view the groups that have permssion for a
particular folder in SQL Reporting Services that they have access to via the
Web Services by calling ReportingServices.GetPolicies(). I realize
(according to MS's website and trial and error) that the user must have the
"Read Security Policies" right for that folder. The only way I have found
to set this via a Role is to allow "Set security for individual items".
Is there any way to allow a user to only view the security information via
ReportingServices.GetPolicies() without allowing them to change the security
policies?
Any help would be greatly appreciated. Thank you.
Jeremy M. WhiteWell, I found a way to do it, but I'm not really excited about it.
Currently, I am selecting directly from the SQL Reporting services database.
Again, I would prefer to do it through the web services, but I guess this
will suffice. For anyone interested, here is the SQL statement to retrieve
the policy information:
SELECT
U.UserName, U.UserType, R.RoleName, R.Description
FROM
Catalog As C INNER JOIN
PolicyUserRole As PU
ON (C.PolicyID = PU.PolicyID)
INNER JOIN
Roles As R
ON (PU.RoleID = R.RoleID)
INNER JOIN
Users As U
ON (PU.UserID = U.UserID)
WHERE
C.Path = @.ItemName
If anyone is able to determine how to provide read-only access to the
policies via a role, please let me know.
Thanks,
Jeremy
"Jeremy M. White" <jeremy_white@.dart.biz> wrote in message
news:uEkE3mbzEHA.1300@.TK2MSFTNGP14.phx.gbl...
> I would like for a user to view the groups that have permssion for a
> particular folder in SQL Reporting Services that they have access to via
the
> Web Services by calling ReportingServices.GetPolicies(). I realize
> (according to MS's website and trial and error) that the user must have
the
> "Read Security Policies" right for that folder. The only way I have found
> to set this via a Role is to allow "Set security for individual items".
> Is there any way to allow a user to only view the security information via
> ReportingServices.GetPolicies() without allowing them to change the
security
> policies?
> Any help would be greatly appreciated. Thank you.
> Jeremy M. White
>

Read only or hidden report parameters in Reporting Services

I have 3 parameters in my report page. I am setting 2 parameters in default from my aspx application for this report. So i dont want to show these 2 parameters when i execute my report. I tried rc:parameters = false in querystring which is just hiding the whole parameters. But is there a way to make the other 2 parameters readonly or hidden and show 1 parameter to take input when i execute the report.Try going to Report Manager portal, editing the report parameters, and setting visibility to false.
Alternatively, I think you can also do this if you remove the name of the parameter in the report designer.sql

Monday, March 12, 2012

RDL's future with other reporting platforms

Hi,
Which reporting tools of the market today support RDL I mean if I make a
report in RDL which reporting tools will be able to understand the report
that is made in RDL and render it? This is extreamly important for us to
know. We need to decided on, in which format should our own reports be
saved.
Thanks,
ShafiaShafia wrote:
> Which reporting tools of the market today support RDL I mean if I
> make a report in RDL which reporting tools will be able to understand
> the report that is made in RDL and render it? This is extreamly
> important for us to know. We need to decided on, in which format
> should our own reports be saved.
Have a look at:
http://www.misag.com/ca/jm/see/
regards
Frank

rdlc viewer issues

I've created a few reporting services local (Visual Studio) reports to see
if this is a viable enterprise reporting option. I'm having rather abysmal
experience with the report viewer.
I design my report in the designer and it looks great. I run the
application and view it on the screen and see
- The left edges of text in text boxes is "clipped", as if the text is
running outside the textbox margin or something
- Some textboxes have switched to multiline as if it isn't long enough to
display the contents, but the textbox isn't tall enough for that and what
displays is just gobbledy-gook.
If I switch the view to print layout mode the clipping is still there but
the textboxes now display the entire contents horizontally like they did in
the designer.
In any case, if I print the report from the viewer it comes out pretty much
like it looked in the designer.
So, to recap:
- Left edges of text boxes are clipped in the viewer
- Reports layout like I designed them when in print layout mode but not
otherwise
- Printed reports don't look like they do when viewed on the screen
I must be doing something horribly wrong or have a misunderstanding of the
paradigm, because in my mind this is ridiculous for a reporting tool to
behave this way. I understand the CanGrow property, but it only controls
vertical sizing and in order to preserve my report esthetics I would need it
to grow horizontally.Make sure you report items (Textboxes, Lines, Rectangles, etc) do not
overlap. This usually causes the report to behave oddly in HTML as it
cannot overlap html objects very well. Usually you can avoid
overlapping items by using a table for your data region, instead of the
freeform List. Also, check the padding of your textboxes, and increase
the padding if needed.
Textboxes do not grow horizontally as this is the layout of the report
and is the behavior by design. You should increase the width of your
textboxes to the max size that you can within your report layout for
the data that will be displayed in them. You can set the CanGrow
property to true, which basically allows the renderer to wrap the text
to another line(s), like you said, controlling vertical sizing.
A lot of times, the result you get from viewing the report in the
viewer in HTML will not be exactly the same as when printing or
exporting to PDF or TIFF. The latter are print layout formats, and
will render the reports slightly different, because their media is
paper. For example, if you report has a page footer, in HTML, the
footer will show immediately after last item on the page, even if the
item is in the "middle" of the page, because HTML does not have concept
of "page sizes". If you print it or export to PDF, you will notice
that the renderer places the page footer at the bottom of the paper
page.
Hope this helps you!
Regards,
Thiago Silva, MCAD.NET
On Nov 22, 7:22 am, "Daniel Billingsley"
<DanielBillings...@.newsgroup.nospam> wrote:
> I've created a few reporting services local (Visual Studio) reports to see
> if this is a viable enterprise reporting option. I'm having rather abysmal
> experience with the report viewer.
> I design my report in the designer and it looks great. I run the
> application and view it on the screen and see
> - The left edges of text in text boxes is "clipped", as if the text is
> running outside the textbox margin or something
> - Some textboxes have switched to multiline as if it isn't long enough to
> display the contents, but the textbox isn't tall enough for that and what
> displays is just gobbledy-gook.
> If I switch the view to print layout mode the clipping is still there but
> the textboxes now display the entire contents horizontally like they did in
> the designer.
> In any case, if I print the report from the viewer it comes out pretty much
> like it looked in the designer.
> So, to recap:
> - Left edges of text boxes are clipped in the viewer
> - Reports layout like I designed them when in print layout mode but not
> otherwise
> - Printed reports don't look like they do when viewed on the screen
> I must be doing something horribly wrong or have a misunderstanding of the
> paradigm, because in my mind this is ridiculous for a reporting tool to
> behave this way. I understand the CanGrow property, but it only controls
> vertical sizing and in order to preserve my report esthetics I would need it
> to grow horizontally.|||Well, I have to say I think not handling overlapping items is a ridiculous
limitation - one that surely has the graphics designers in the crowd
laughing their rears off. My use of it is not a list layout issue, it's a
graphic design issue, so using a table doesn't help. What I'm trying to
create is an effect similar to the windows forms GroupBox whereby there's a
box with a border that is interrupted for the "title" of the box.
Additionally, I'd like the title to be surrounded with a border itself.
This is not really all that complex graphically, so I think it's a rather
sever limitation that the rdlc report can't handle it.
Considering that increasing the width of the textbox doesn't really work.
The problem I'm trying to point out is that I can't predict what it will
look like at runtime while in the designer. And even if I put forth the
painful effort of making a change and then having to run the application to
see the results (another completely ridiculous limitation), the problem
still exists that it would look good in the view but when printed look like
I was an idiot because there'd be a bunch of whitespace in the end of the
box (border).
IMPORTANT NOTE - this is all really a problem with textboxes with borders in
general and really doesn't have anything to do with the fact that I am using
it in an overlapping way in this particular case.
I say again, for a report writer not to be able to predict the results, and
for the results to be that different between viewing and printing, is
unacceptable. Period. Yes, I would expect the differences in the way page
footers are handled because there are no "pages" in HTML. Of course it
would work that way. But not that the actual layout of the body of the
report would change so significantly.
I did not appreciate that the default for the viewer was an HTML view. This
seems like another case where the relationship to the SQL RS engine is a
liability.
"tafs7" <tsilva7@.gmail.com> wrote in message
news:1164347626.531755.16330@.l39g2000cwd.googlegroups.com...
> Make sure you report items (Textboxes, Lines, Rectangles, etc) do not
> overlap. This usually causes the report to behave oddly in HTML as it
> cannot overlap html objects very well. Usually you can avoid
> overlapping items by using a table for your data region, instead of the
> freeform List. Also, check the padding of your textboxes, and increase
> the padding if needed.
> Textboxes do not grow horizontally as this is the layout of the report
> and is the behavior by design. You should increase the width of your
> textboxes to the max size that you can within your report layout for
> the data that will be displayed in them. You can set the CanGrow
> property to true, which basically allows the renderer to wrap the text
> to another line(s), like you said, controlling vertical sizing.
> A lot of times, the result you get from viewing the report in the
> viewer in HTML will not be exactly the same as when printing or
> exporting to PDF or TIFF. The latter are print layout formats, and
> will render the reports slightly different, because their media is
> paper. For example, if you report has a page footer, in HTML, the
> footer will show immediately after last item on the page, even if the
> item is in the "middle" of the page, because HTML does not have concept
> of "page sizes". If you print it or export to PDF, you will notice
> that the renderer places the page footer at the bottom of the paper
> page.
> Hope this helps you!
> Regards,
> Thiago Silva, MCAD.NET
>
> On Nov 22, 7:22 am, "Daniel Billingsley"
> <DanielBillings...@.newsgroup.nospam> wrote:
>> I've created a few reporting services local (Visual Studio) reports to
>> see
>> if this is a viable enterprise reporting option. I'm having rather
>> abysmal
>> experience with the report viewer.
>> I design my report in the designer and it looks great. I run the
>> application and view it on the screen and see
>> - The left edges of text in text boxes is "clipped", as if the text is
>> running outside the textbox margin or something
>> - Some textboxes have switched to multiline as if it isn't long enough to
>> display the contents, but the textbox isn't tall enough for that and what
>> displays is just gobbledy-gook.
>> If I switch the view to print layout mode the clipping is still there but
>> the textboxes now display the entire contents horizontally like they did
>> in
>> the designer.
>> In any case, if I print the report from the viewer it comes out pretty
>> much
>> like it looked in the designer.
>> So, to recap:
>> - Left edges of text boxes are clipped in the viewer
>> - Reports layout like I designed them when in print layout mode but not
>> otherwise
>> - Printed reports don't look like they do when viewed on the screen
>> I must be doing something horribly wrong or have a misunderstanding of
>> the
>> paradigm, because in my mind this is ridiculous for a reporting tool to
>> behave this way. I understand the CanGrow property, but it only controls
>> vertical sizing and in order to preserve my report esthetics I would need
>> it
>> to grow horizontally.
>|||Hey, Daniel
Have you tried using a rectangle with borders, instead of a textbox as
the container? I don't think you'll get quite the same effect as the
GroupBox with the title, but at least your rectangle will serve as a
container for other items, and you can have a textbox on the inside of
this rectangle at the top left corner acting as the "title" (note the
"Parent" property in the property page of any textbox placed inside the
rectangle, and you should see the rectangle name)
There is really nothing that prevents you from overlapping items in a
report, however in this version of the product, it unfortunately
doesn't do well rendering overlaps in all renderers. This is mainly a
problem for the HTML rendering extension of the viewer. The same
report, when exported to PDF, will look perfect, though.
In the Visual Studio designer, when you preview a report that contains
overlapped items, you will get a warning in the output window but this
will not prevent you from running the report:
[rsOverlappingReportItems] The textbox 'textbox3' and the rectangle
'rectangle1' overlap. Overlapping report items are not supported in
all renderers.
Build complete -- 0 errors, 1 warnings
As far as the textbox stretching horizontally, it would make no sense
to allow for textboxes to do that because it could inherently stretch
the width of the report body and page width causing the report to print
extra pages just for the extra width, since the printed page size is a
property that is set in the report (e.g. 8.5x11in vs. 11x8.5in -
portrait or landscape letter).
Now, since you're using the RDLC format, I am assuming you have a
custom application that provides a UI to the user for selecting reports
and entering parameters (if required). If that's the case, then your
application is responsible for providing the data as well and then
handing that over to the ReportViewer control for rendering. As such,
there is no way to "preview" your report from the Visual Studio
designer, because it doesn't know where the data is coming from. I
would recommend developing your reports as regular RDL files to begin
with, so you can test on the VS designer. You can even preview it w/
the ReportViewer by right-clicking the report name in the Solution
Explorer and selecting "Run". This will spin off a separate process
with an external windows app hosting the ReportViewer (note that
because this is a windows app, it still won't render the actual HTML
results you'd get from Internet Explorer).
Once you're happy with the results, you can "doctor" your RDL file so
it becomes an RDLC (see http://www.gotreportviewer.com for more
details) that is usable by your custom application.
Hope this helps you.
If you need any references to help you further your skills in SSRS, I
would recommend reading some of the SSRS team blogs for tips:
All about the ReportViewer - http://www.gotreportviewer.com/
Brian Welcker - http://blogs.msdn.com/bwelcker
Chris Hays - http://blogs.msdn.com/ChrisHays/ <= Sleazy Hacks for SSRS
:)
Tudor's blog - http://blogs.msdn.com/tudortr/
Lukasz Pawlowski - http://blogs.msdn.com/lukaszp/
Bob Meyers- http://blogs.msdn.com/bobmeyers
Regards,
Thiago Silva, MCAD.NET
Daniel Billingsley wrote:
> Well, I have to say I think not handling overlapping items is a ridiculous
> limitation - one that surely has the graphics designers in the crowd
> laughing their rears off. My use of it is not a list layout issue, it's a
> graphic design issue, so using a table doesn't help. What I'm trying to
> create is an effect similar to the windows forms GroupBox whereby there's a
> box with a border that is interrupted for the "title" of the box.
> Additionally, I'd like the title to be surrounded with a border itself.
> This is not really all that complex graphically, so I think it's a rather
> sever limitation that the rdlc report can't handle it.
> Considering that increasing the width of the textbox doesn't really work.
> The problem I'm trying to point out is that I can't predict what it will
> look like at runtime while in the designer. And even if I put forth the
> painful effort of making a change and then having to run the application to
> see the results (another completely ridiculous limitation), the problem
> still exists that it would look good in the view but when printed look like
> I was an idiot because there'd be a bunch of whitespace in the end of the
> box (border).
> IMPORTANT NOTE - this is all really a problem with textboxes with borders in
> general and really doesn't have anything to do with the fact that I am using
> it in an overlapping way in this particular case.
> I say again, for a report writer not to be able to predict the results, and
> for the results to be that different between viewing and printing, is
> unacceptable. Period. Yes, I would expect the differences in the way page
> footers are handled because there are no "pages" in HTML. Of course it
> would work that way. But not that the actual layout of the body of the
> report would change so significantly.
> I did not appreciate that the default for the viewer was an HTML view. This
> seems like another case where the relationship to the SQL RS engine is a
> liability.
> "tafs7" <tsilva7@.gmail.com> wrote in message
> news:1164347626.531755.16330@.l39g2000cwd.googlegroups.com...
> >
> > Make sure you report items (Textboxes, Lines, Rectangles, etc) do not
> > overlap. This usually causes the report to behave oddly in HTML as it
> > cannot overlap html objects very well. Usually you can avoid
> > overlapping items by using a table for your data region, instead of the
> > freeform List. Also, check the padding of your textboxes, and increase
> > the padding if needed.
> >
> > Textboxes do not grow horizontally as this is the layout of the report
> > and is the behavior by design. You should increase the width of your
> > textboxes to the max size that you can within your report layout for
> > the data that will be displayed in them. You can set the CanGrow
> > property to true, which basically allows the renderer to wrap the text
> > to another line(s), like you said, controlling vertical sizing.
> >
> > A lot of times, the result you get from viewing the report in the
> > viewer in HTML will not be exactly the same as when printing or
> > exporting to PDF or TIFF. The latter are print layout formats, and
> > will render the reports slightly different, because their media is
> > paper. For example, if you report has a page footer, in HTML, the
> > footer will show immediately after last item on the page, even if the
> > item is in the "middle" of the page, because HTML does not have concept
> > of "page sizes". If you print it or export to PDF, you will notice
> > that the renderer places the page footer at the bottom of the paper
> > page.
> >
> > Hope this helps you!
> >
> > Regards,
> > Thiago Silva, MCAD.NET
> >
> >
> > On Nov 22, 7:22 am, "Daniel Billingsley"
> > <DanielBillings...@.newsgroup.nospam> wrote:
> >> I've created a few reporting services local (Visual Studio) reports to
> >> see
> >> if this is a viable enterprise reporting option. I'm having rather
> >> abysmal
> >> experience with the report viewer.
> >>
> >> I design my report in the designer and it looks great. I run the
> >> application and view it on the screen and see
> >> - The left edges of text in text boxes is "clipped", as if the text is
> >> running outside the textbox margin or something
> >> - Some textboxes have switched to multiline as if it isn't long enough to
> >> display the contents, but the textbox isn't tall enough for that and what
> >> displays is just gobbledy-gook.
> >>
> >> If I switch the view to print layout mode the clipping is still there but
> >> the textboxes now display the entire contents horizontally like they did
> >> in
> >> the designer.
> >>
> >> In any case, if I print the report from the viewer it comes out pretty
> >> much
> >> like it looked in the designer.
> >>
> >> So, to recap:
> >> - Left edges of text boxes are clipped in the viewer
> >> - Reports layout like I designed them when in print layout mode but not
> >> otherwise
> >> - Printed reports don't look like they do when viewed on the screen
> >>
> >> I must be doing something horribly wrong or have a misunderstanding of
> >> the
> >> paradigm, because in my mind this is ridiculous for a reporting tool to
> >> behave this way. I understand the CanGrow property, but it only controls
> >> vertical sizing and in order to preserve my report esthetics I would need
> >> it
> >> to grow horizontally.
> >

RDLC Reporting Service - setting up query parameters - is this possible?

Hi, I have my RDLC report, called on a ReportViewer, which receives a parameter (id of a column to filter the data), and the report receives this parameter very well, however, I want to use the value of this parameter to a query parameter of the dataset. On VS2005 we can asociate data sets to a report, but not a report parameter to a query parameter...is there any way to make this work?

I've heard that this is not possible using client report and report viewer, as print button. If I use a server report, will I have the print button on my application available?If not, how can I present the report with the print button available?

Thanks a lot!

You must use a server report to use reporting services built in print functionality.

For the parameters, you can programaticallly declare an array of parameters and pass them to the report. The report has a parameter section in the report properties where you can map the parameters. Alternatively, you can use any "parameters" in the creation of your datasets and not pass any parameters to the report.

|||

dr_99:
You must use a server report to use reporting services built in print functionality.
For the parameters, you can programaticallly declare an array of parameters and pass them to the report. The report has a parameter section in the report properties where you can map the parameters. Alternatively, you can use any "parameters" in the creation of your datasets and not pass any parameters to the report.

Yes I'm sure about that, thanks a lot!Only one problem, on IE the print button appears, but on Firefox does not appear, has anyone ideia what can cause this?It is set to visible!Thanks!

rdlc parameters error

I have :

Dim params(0)As Microsoft.Reporting.WebForms.ReportParameterparams(0) =New Microsoft.Reporting.WebForms.ReportParameter("aa","47",False)

ReportViewer1.LocalReport.SetParameters(params)

ReportViewer1.ServerReport.Refresh()

but it make error :

An error occurred during local report processing.

Microsoft.Reporting.WebForms.LocalProcessingException was unhandled by user code
Message="An error occurred during local report processing."
Source="Microsoft.ReportViewer.WebForms"
StackTrace:
at Microsoft.Reporting.WebForms.LocalReport.CompileReport()
at Microsoft.Reporting.WebForms.LocalReport.SetParameters(IEnumerable`1 parameters)
at _Default.Page_Load(Object sender, EventArgs e) in E:\Moje dokumenty\Visual Studio 2005\WebSites\VB\AJAXEnabledWebSite5\Default.aspx.vb:line 13
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Hello,

Maybe u need to determine the process mode by

ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local

or add to

ReportViewer2.ReportPath = Path Of report & "Inv_DamageVoucher_Template_En"

ReportViewer2.SetParameter("<Perametername>", "<Parameter Value>")

ReportViewer2.Parameters = Microsoft.Samples.ReportingServices.ReportViewer.multiState.False

|||

I use it several times and it works fine the problem with the false parameters try use this

string strTime = System.DateTime.Now.ToShortTimeString();RptParameters[0] =
 new Microsoft.Reporting.WebForms.ReportParameter("ReportParameterName",Value);
RptParameters[1]=
 new Microsoft.Reporting.WebForms.ReportParameter("ReportParameterName",Value);

http://forums.asp.net/p/1168478/1951923.aspx#1951923

Friday, March 9, 2012

rdl or rdlc for custom reports

Are custom reports going to carry on using the rdlc extension. If so is the rdlc extension going to be associated with the reporting project designer. Currently rdlc files only show up the designer and not the data or preview tabs in BIDS.

Paul's documentation blog post refers to rdl rather than rdlc files.

Simon, the final release of SP2 will default to RDL files rather than RDLC files.

Cheers,
Dan

|||

If you don't want to rename your report files to .RDLC for the November CTP, you can type "*.RDL" into the custom reports dialog and hit enter. The report will load just fine... however, any subsequent drilldown actions to other reports will probably default to a .RDLC extension instead of .RDL.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||Exactly, thats what I found :)

RDL name with umlauts

Hello,
I programmatically upload a rdl file to my reporting server with Delphi 7
like this:
procedure TRepServWrapper.PublishRDLFile (const rdlname, rdlfile, parentPath
: String);
var
fs : TFileStream;
byteArray : TByteDynArray;
warnings : ArrayOfWarning;
i : Integer;
begin
fs := TFileStream.Create(rdlfile,fmOpenRead);
Try
Try
if fs.Size > 0 Then
begin
SetLength(byteArray, fs.Size);
fs.ReadBuffer(byteArray[0],fs.Size);
end;
except on e:Exception do
raise ECouldNotOpenRDLFile.Create('TRepServWrapper.PublishRDLFile: '
+ errCouldNotOpenRDLFile + ': '+e.Message);
end;
finally
fs.Free;
end;
Try
warnings := FRSInt.CreateReport(rdlname,parentPath,True,byteArray,nil);
If Not (warnings = nil) Then
begin
for i := 0 to High(warnings)-1 do
SendDebug('Warnung beim Upload der RDL: '+ warnings[i].Message);
end;
except on e : Exception do
raise ECouldNotUploadRDL.Create('TRepServWrapper.PublishRDLFile: ' +
errCouldNotUploadRDL + ': ' + e.Message);
end;
end;
This works except one thing:
Due to german users I'd like to have umlauts in the rdl name. Unfortunately
Reporting Services do not allow that (besides some other special characters).
Is there a special conversion to make this work?
Thank you in advance.
Sandra GeislerHello Sandra,
which version of Reporting Services do you use?
Which Webservice, should be ReportService2005?
Can you reproduce this with the upload function in Report Manager?
Can you reproduce this with the sample RSS script, which uploads the sample
report?
Regards
Klaus Sobel
Microsoft Developer Support EMEA
"Sandra Geisler" <SandraGeisler@.discussions.microsoft.com> schrieb im
Newsbeitrag news:D3D806A0-7ADA-4168-BF28-7C9E17B0522C@.microsoft.com...
> Hello,
> I programmatically upload a rdl file to my reporting server with Delphi 7
> like this:
> procedure TRepServWrapper.PublishRDLFile (const rdlname, rdlfile,
> parentPath
> : String);
> var
> fs : TFileStream;
> byteArray : TByteDynArray;
> warnings : ArrayOfWarning;
> i : Integer;
> begin
> fs := TFileStream.Create(rdlfile,fmOpenRead);
> Try
> Try
> if fs.Size > 0 Then
> begin
> SetLength(byteArray, fs.Size);
> fs.ReadBuffer(byteArray[0],fs.Size);
> end;
> except on e:Exception do
> raise ECouldNotOpenRDLFile.Create('TRepServWrapper.PublishRDLFile: '
> + errCouldNotOpenRDLFile + ': '+e.Message);
> end;
> finally
> fs.Free;
> end;
> Try
> warnings :=> FRSInt.CreateReport(rdlname,parentPath,True,byteArray,nil);
> If Not (warnings = nil) Then
> begin
> for i := 0 to High(warnings)-1 do
> SendDebug('Warnung beim Upload der RDL: '+ warnings[i].Message);
> end;
> except on e : Exception do
> raise ECouldNotUploadRDL.Create('TRepServWrapper.PublishRDLFile: ' +
> errCouldNotUploadRDL + ': ' + e.Message);
> end;
> end;
>
> This works except one thing:
> Due to german users I'd like to have umlauts in the rdl name.
> Unfortunately
> Reporting Services do not allow that (besides some other special
> characters).
> Is there a special conversion to make this work?
> Thank you in advance.
> Sandra Geisler|||Hello,
thanks for your fast reply.
I also get this error message (sry, I forgot):
Der Name des Elements 'T'bel' ist nicht gÃ¼ltig. Der Name kann hÃ¶chstens 260
Zeichen lang sein und kann nicht mit einem SchrÃ¤gstrich beginnen; auÃ?erdem
gelten weitere EinschrÃ¤nkungen. Informationen zu allen EinschrÃ¤nkungen finden
Sie in der Dokumentation. --> Der Name des Elements 'S'sel' ist nicht
gÃ¼ltig. Der Name kann hÃ¶chstens 260 Zeichen lang sein und kann nicht mit
einem SchrÃ¤gstrich beginnen; auÃ?erdem gelten weitere EinschrÃ¤nkungen.
Informationen zu allen EinschrÃ¤nkungen finden Sie in der
Dokumentation. 13:05:43
Regarding your questions:
> which version of Reporting Services do you use?
SQL Server 2000 SP4, Reporting Services Enterprise Version 8.00.1038.00
(i.e. SP2)
> Which Webservice, should be ReportService2005?
ummmmhh, where do I look that up? But regarding to question 1 I do not think
it is ReportService2005...
> Can you reproduce this with the upload function in Report Manager?
No, that works ok with the same rdl. But, in this case you dont have to
enter the name of the rdl resp. report, just the rdl file location and the
name is created automatically (and correctly).
Thanks in advance
Sandra Geisler
"Klaus Sobel [MS]" wrote:
> Hello Sandra,
> which version of Reporting Services do you use?
> Which Webservice, should be ReportService2005?
> Can you reproduce this with the upload function in Report Manager?
> Can you reproduce this with the sample RSS script, which uploads the sample
> report?
> Regards
> Klaus Sobel
> Microsoft Developer Support EMEA
> "Sandra Geisler" <SandraGeisler@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:D3D806A0-7ADA-4168-BF28-7C9E17B0522C@.microsoft.com...
> > Hello,
> >
> > I programmatically upload a rdl file to my reporting server with Delphi 7
> > like this:
> >
> > procedure TRepServWrapper.PublishRDLFile (const rdlname, rdlfile,
> > parentPath
> > : String);
> > var
> > fs : TFileStream;
> > byteArray : TByteDynArray;
> > warnings : ArrayOfWarning;
> > i : Integer;
> > begin
> > fs := TFileStream.Create(rdlfile,fmOpenRead);
> > Try
> > Try
> > if fs.Size > 0 Then
> > begin
> > SetLength(byteArray, fs.Size);
> > fs.ReadBuffer(byteArray[0],fs.Size);
> > end;
> > except on e:Exception do
> > raise ECouldNotOpenRDLFile.Create('TRepServWrapper.PublishRDLFile: '
> > + errCouldNotOpenRDLFile + ': '+e.Message);
> > end;
> > finally
> > fs.Free;
> > end;
> >
> > Try
> > warnings :=> > FRSInt.CreateReport(rdlname,parentPath,True,byteArray,nil);
> > If Not (warnings = nil) Then
> > begin
> > for i := 0 to High(warnings)-1 do
> > SendDebug('Warnung beim Upload der RDL: '+ warnings[i].Message);
> > end;
> > except on e : Exception do
> > raise ECouldNotUploadRDL.Create('TRepServWrapper.PublishRDLFile: ' +
> > errCouldNotUploadRDL + ': ' + e.Message);
> > end;
> > end;
> >
> >
> > This works except one thing:
> > Due to german users I'd like to have umlauts in the rdl name.
> > Unfortunately
> > Reporting Services do not allow that (besides some other special
> > characters).
> > Is there a special conversion to make this work?
> >
> > Thank you in advance.
> >
> > Sandra Geisler
>
>|||Hello Sandra,
at the end the Upload in Report Manager is also using the CreateReport
method, so in general it works with the web service method.
It's possible that the problem is related with the DELPHI app, which is
calling the web service.
Try the sample RSS Script UploadReports.rss
You should find it in
\Programme\Microsoft SQL Server\MSSQL\Reporting Services\Samples
If this works there's a problem with the DELPHI app.
Best Regards
Klaus Sobel
Microsoft Developer Support EMEA
"Sandra Geisler" <SandraGeisler@.discussions.microsoft.com> schrieb im
Newsbeitrag news:49BCE6D2-B86E-4E7C-961C-1F5FB3C4DBFF@.microsoft.com...
> Hello,
> thanks for your fast reply.
> I also get this error message (sry, I forgot):
> Der Name des Elements 'T'bel' ist nicht gültig. Der Name kann höchstens
> 260
> Zeichen lang sein und kann nicht mit einem Schrägstrich beginnen; außerdem
> gelten weitere Einschränkungen. Informationen zu allen Einschränkungen
> finden
> Sie in der Dokumentation. --> Der Name des Elements 'S'sel' ist nicht
> gültig. Der Name kann höchstens 260 Zeichen lang sein und kann nicht mit
> einem Schrägstrich beginnen; außerdem gelten weitere Einschränkungen.
> Informationen zu allen Einschränkungen finden Sie in der
> Dokumentation. 13:05:43
> Regarding your questions:
>> which version of Reporting Services do you use?
> SQL Server 2000 SP4, Reporting Services Enterprise Version 8.00.1038.00
> (i.e. SP2)
>> Which Webservice, should be ReportService2005?
> ummmmhh, where do I look that up? But regarding to question 1 I do not
> think
> it is ReportService2005...
>> Can you reproduce this with the upload function in Report Manager?
> No, that works ok with the same rdl. But, in this case you dont have to
> enter the name of the rdl resp. report, just the rdl file location and the
> name is created automatically (and correctly).
> Thanks in advance
> Sandra Geisler
>
> "Klaus Sobel [MS]" wrote:
>> Hello Sandra,
>> which version of Reporting Services do you use?
>> Which Webservice, should be ReportService2005?
>> Can you reproduce this with the upload function in Report Manager?
>> Can you reproduce this with the sample RSS script, which uploads the
>> sample
>> report?
>> Regards
>> Klaus Sobel
>> Microsoft Developer Support EMEA
>> "Sandra Geisler" <SandraGeisler@.discussions.microsoft.com> schrieb im
>> Newsbeitrag news:D3D806A0-7ADA-4168-BF28-7C9E17B0522C@.microsoft.com...
>> > Hello,
>> >
>> > I programmatically upload a rdl file to my reporting server with Delphi
>> > 7
>> > like this:
>> >
>> > procedure TRepServWrapper.PublishRDLFile (const rdlname, rdlfile,
>> > parentPath
>> > : String);
>> > var
>> > fs : TFileStream;
>> > byteArray : TByteDynArray;
>> > warnings : ArrayOfWarning;
>> > i : Integer;
>> > begin
>> > fs := TFileStream.Create(rdlfile,fmOpenRead);
>> > Try
>> > Try
>> > if fs.Size > 0 Then
>> > begin
>> > SetLength(byteArray, fs.Size);
>> > fs.ReadBuffer(byteArray[0],fs.Size);
>> > end;
>> > except on e:Exception do
>> > raise
>> > ECouldNotOpenRDLFile.Create('TRepServWrapper.PublishRDLFile: '
>> > + errCouldNotOpenRDLFile + ': '+e.Message);
>> > end;
>> > finally
>> > fs.Free;
>> > end;
>> >
>> > Try
>> > warnings :=>> > FRSInt.CreateReport(rdlname,parentPath,True,byteArray,nil);
>> > If Not (warnings = nil) Then
>> > begin
>> > for i := 0 to High(warnings)-1 do
>> > SendDebug('Warnung beim Upload der RDL: '+
>> > warnings[i].Message);
>> > end;
>> > except on e : Exception do
>> > raise ECouldNotUploadRDL.Create('TRepServWrapper.PublishRDLFile: '
>> > +
>> > errCouldNotUploadRDL + ': ' + e.Message);
>> > end;
>> > end;
>> >
>> >
>> > This works except one thing:
>> > Due to german users I'd like to have umlauts in the rdl name.
>> > Unfortunately
>> > Reporting Services do not allow that (besides some other special
>> > characters).
>> > Is there a special conversion to make this work?
>> >
>> > Thank you in advance.
>> >
>> > Sandra Geisler
>>|||Hello Klaus,
thanks for your reply.
Unfortunately I don't have this sample script on my test machine.
I suppose the problem does not origin from the delphi app, anyway not
directly.
I agree, that the Report Manager also has to use the CreateReport method to
upload the rdl. But I think there is perhaps some encoding incompatibility
between the delphi app and the webservice. The origin of the described error
message is definitely the webservice, namely :
Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings rsInvalidItemName
But I don't understand that, because the name definitely does not contain
any invalid characters and the problem only occurs with umlauts. Other names
are accepted, so that the constitution of the path of the rdl could not be
the problem. The error only occurs if in the CreateReport method the first
parameter contains an umlaut.
The wrapping class has the following registration code for the callback
interface:
InvRegistry.RegisterInterface(TypeInfo(ReportingServiceSoap),
'http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices',
'utf-8');
Whereby ReportingServiceSoap is the callback interface where the methods of
the webservice are defined.
I think it is some encoding issue, but I don't know exactly where to start
searching.
Thanks in advance
Sandra Geisler
"Klaus Sobel [MS]" wrote:
> Hello Sandra,
> at the end the Upload in Report Manager is also using the CreateReport
> method, so in general it works with the web service method.
> It's possible that the problem is related with the DELPHI app, which is
> calling the web service.
> Try the sample RSS Script UploadReports.rss
> You should find it in
> \Programme\Microsoft SQL Server\MSSQL\Reporting Services\Samples
> If this works there's a problem with the DELPHI app.
> Best Regards
> Klaus Sobel
> Microsoft Developer Support EMEA
> "Sandra Geisler" <SandraGeisler@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:49BCE6D2-B86E-4E7C-961C-1F5FB3C4DBFF@.microsoft.com...
> > Hello,
> >
> > thanks for your fast reply.
> >
> > I also get this error message (sry, I forgot):
> >
> > Der Name des Elements 'T'bel' ist nicht gÃ¼ltig. Der Name kann hÃ¶chstens
> > 260
> > Zeichen lang sein und kann nicht mit einem SchrÃ¤gstrich beginnen; auÃ?erdem
> > gelten weitere EinschrÃ¤nkungen. Informationen zu allen EinschrÃ¤nkungen
> > finden
> > Sie in der Dokumentation. --> Der Name des Elements 'S'sel' ist nicht
> > gÃ¼ltig. Der Name kann hÃ¶chstens 260 Zeichen lang sein und kann nicht mit
> > einem SchrÃ¤gstrich beginnen; auÃ?erdem gelten weitere EinschrÃ¤nkungen.
> > Informationen zu allen EinschrÃ¤nkungen finden Sie in der
> > Dokumentation. 13:05:43
> >
> > Regarding your questions:
> >
> >> which version of Reporting Services do you use?
> >
> > SQL Server 2000 SP4, Reporting Services Enterprise Version 8.00.1038.00
> > (i.e. SP2)
> >
> >> Which Webservice, should be ReportService2005?
> > ummmmhh, where do I look that up? But regarding to question 1 I do not
> > think
> > it is ReportService2005...
> >
> >> Can you reproduce this with the upload function in Report Manager?
> >
> > No, that works ok with the same rdl. But, in this case you dont have to
> > enter the name of the rdl resp. report, just the rdl file location and the
> > name is created automatically (and correctly).
> >
> > Thanks in advance
> >
> > Sandra Geisler
> >
> >
> >
> > "Klaus Sobel [MS]" wrote:
> >
> >> Hello Sandra,
> >>
> >> which version of Reporting Services do you use?
> >> Which Webservice, should be ReportService2005?
> >> Can you reproduce this with the upload function in Report Manager?
> >> Can you reproduce this with the sample RSS script, which uploads the
> >> sample
> >> report?
> >>
> >> Regards
> >>
> >> Klaus Sobel
> >>
> >> Microsoft Developer Support EMEA
> >> "Sandra Geisler" <SandraGeisler@.discussions.microsoft.com> schrieb im
> >> Newsbeitrag news:D3D806A0-7ADA-4168-BF28-7C9E17B0522C@.microsoft.com...
> >> > Hello,
> >> >
> >> > I programmatically upload a rdl file to my reporting server with Delphi
> >> > 7
> >> > like this:
> >> >
> >> > procedure TRepServWrapper.PublishRDLFile (const rdlname, rdlfile,
> >> > parentPath
> >> > : String);
> >> > var
> >> > fs : TFileStream;
> >> > byteArray : TByteDynArray;
> >> > warnings : ArrayOfWarning;
> >> > i : Integer;
> >> > begin
> >> > fs := TFileStream.Create(rdlfile,fmOpenRead);
> >> > Try
> >> > Try
> >> > if fs.Size > 0 Then
> >> > begin
> >> > SetLength(byteArray, fs.Size);
> >> > fs.ReadBuffer(byteArray[0],fs.Size);
> >> > end;
> >> > except on e:Exception do
> >> > raise
> >> > ECouldNotOpenRDLFile.Create('TRepServWrapper.PublishRDLFile: '
> >> > + errCouldNotOpenRDLFile + ': '+e.Message);
> >> > end;
> >> > finally
> >> > fs.Free;
> >> > end;
> >> >
> >> > Try
> >> > warnings :=> >> > FRSInt.CreateReport(rdlname,parentPath,True,byteArray,nil);
> >> > If Not (warnings = nil) Then
> >> > begin
> >> > for i := 0 to High(warnings)-1 do
> >> > SendDebug('Warnung beim Upload der RDL: '+
> >> > warnings[i].Message);
> >> > end;
> >> > except on e : Exception do
> >> > raise ECouldNotUploadRDL.Create('TRepServWrapper.PublishRDLFile: '
> >> > +
> >> > errCouldNotUploadRDL + ': ' + e.Message);
> >> > end;
> >> > end;
> >> >
> >> >
> >> > This works except one thing:
> >> > Due to german users I'd like to have umlauts in the rdl name.
> >> > Unfortunately
> >> > Reporting Services do not allow that (besides some other special
> >> > characters).
> >> > Is there a special conversion to make this work?
> >> >
> >> > Thank you in advance.
> >> >
> >> > Sandra Geisler
> >>
> >>
> >>
>
>|||Oh my god, I solved it ;-).
It was an encoding issue which had its origin in the SOAPHTPPClient unit of
Delphi.
I had to set the THTTPRIO.HTTPWebNode.UseUTF8InHeader to true and then it
worked :-)...
Thank you very much for your support!
"Sandra Geisler" wrote:
> Hello Klaus,
> thanks for your reply.
> Unfortunately I don't have this sample script on my test machine.
> I suppose the problem does not origin from the delphi app, anyway not
> directly.
> I agree, that the Report Manager also has to use the CreateReport method to
> upload the rdl. But I think there is perhaps some encoding incompatibility
> between the delphi app and the webservice. The origin of the described error
> message is definitely the webservice, namely :
> Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings rsInvalidItemName
> But I don't understand that, because the name definitely does not contain
> any invalid characters and the problem only occurs with umlauts. Other names
> are accepted, so that the constitution of the path of the rdl could not be
> the problem. The error only occurs if in the CreateReport method the first
> parameter contains an umlaut.
> The wrapping class has the following registration code for the callback
> interface:
> InvRegistry.RegisterInterface(TypeInfo(ReportingServiceSoap),
> 'http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices',
> 'utf-8');
> Whereby ReportingServiceSoap is the callback interface where the methods of
> the webservice are defined.
> I think it is some encoding issue, but I don't know exactly where to start
> searching.
> Thanks in advance
> Sandra Geisler
> "Klaus Sobel [MS]" wrote:
> > Hello Sandra,
> >
> > at the end the Upload in Report Manager is also using the CreateReport
> > method, so in general it works with the web service method.
> >
> > It's possible that the problem is related with the DELPHI app, which is
> > calling the web service.
> >
> > Try the sample RSS Script UploadReports.rss
> >
> > You should find it in
> >
> > \Programme\Microsoft SQL Server\MSSQL\Reporting Services\Samples
> >
> > If this works there's a problem with the DELPHI app.
> >
> > Best Regards
> >
> > Klaus Sobel
> >
> > Microsoft Developer Support EMEA
> >
> > "Sandra Geisler" <SandraGeisler@.discussions.microsoft.com> schrieb im
> > Newsbeitrag news:49BCE6D2-B86E-4E7C-961C-1F5FB3C4DBFF@.microsoft.com...
> > > Hello,
> > >
> > > thanks for your fast reply.
> > >
> > > I also get this error message (sry, I forgot):
> > >
> > > Der Name des Elements 'T'bel' ist nicht gÃ¼ltig. Der Name kann hÃ¶chstens
> > > 260
> > > Zeichen lang sein und kann nicht mit einem SchrÃ¤gstrich beginnen; auÃ?erdem
> > > gelten weitere EinschrÃ¤nkungen. Informationen zu allen EinschrÃ¤nkungen
> > > finden
> > > Sie in der Dokumentation. --> Der Name des Elements 'S'sel' ist nicht
> > > gÃ¼ltig. Der Name kann hÃ¶chstens 260 Zeichen lang sein und kann nicht mit
> > > einem SchrÃ¤gstrich beginnen; auÃ?erdem gelten weitere EinschrÃ¤nkungen.
> > > Informationen zu allen EinschrÃ¤nkungen finden Sie in der
> > > Dokumentation. 13:05:43
> > >
> > > Regarding your questions:
> > >
> > >> which version of Reporting Services do you use?
> > >
> > > SQL Server 2000 SP4, Reporting Services Enterprise Version 8.00.1038.00
> > > (i.e. SP2)
> > >
> > >> Which Webservice, should be ReportService2005?
> > > ummmmhh, where do I look that up? But regarding to question 1 I do not
> > > think
> > > it is ReportService2005...
> > >
> > >> Can you reproduce this with the upload function in Report Manager?
> > >
> > > No, that works ok with the same rdl. But, in this case you dont have to
> > > enter the name of the rdl resp. report, just the rdl file location and the
> > > name is created automatically (and correctly).
> > >
> > > Thanks in advance
> > >
> > > Sandra Geisler
> > >
> > >
> > >
> > > "Klaus Sobel [MS]" wrote:
> > >
> > >> Hello Sandra,
> > >>
> > >> which version of Reporting Services do you use?
> > >> Which Webservice, should be ReportService2005?
> > >> Can you reproduce this with the upload function in Report Manager?
> > >> Can you reproduce this with the sample RSS script, which uploads the
> > >> sample
> > >> report?
> > >>
> > >> Regards
> > >>
> > >> Klaus Sobel
> > >>
> > >> Microsoft Developer Support EMEA
> > >> "Sandra Geisler" <SandraGeisler@.discussions.microsoft.com> schrieb im
> > >> Newsbeitrag news:D3D806A0-7ADA-4168-BF28-7C9E17B0522C@.microsoft.com...
> > >> > Hello,
> > >> >
> > >> > I programmatically upload a rdl file to my reporting server with Delphi
> > >> > 7
> > >> > like this:
> > >> >
> > >> > procedure TRepServWrapper.PublishRDLFile (const rdlname, rdlfile,
> > >> > parentPath
> > >> > : String);
> > >> > var
> > >> > fs : TFileStream;
> > >> > byteArray : TByteDynArray;
> > >> > warnings : ArrayOfWarning;
> > >> > i : Integer;
> > >> > begin
> > >> > fs := TFileStream.Create(rdlfile,fmOpenRead);
> > >> > Try
> > >> > Try
> > >> > if fs.Size > 0 Then
> > >> > begin
> > >> > SetLength(byteArray, fs.Size);
> > >> > fs.ReadBuffer(byteArray[0],fs.Size);
> > >> > end;
> > >> > except on e:Exception do
> > >> > raise
> > >> > ECouldNotOpenRDLFile.Create('TRepServWrapper.PublishRDLFile: '
> > >> > + errCouldNotOpenRDLFile + ': '+e.Message);
> > >> > end;
> > >> > finally
> > >> > fs.Free;
> > >> > end;
> > >> >
> > >> > Try
> > >> > warnings :=> > >> > FRSInt.CreateReport(rdlname,parentPath,True,byteArray,nil);
> > >> > If Not (warnings = nil) Then
> > >> > begin
> > >> > for i := 0 to High(warnings)-1 do
> > >> > SendDebug('Warnung beim Upload der RDL: '+
> > >> > warnings[i].Message);
> > >> > end;
> > >> > except on e : Exception do
> > >> > raise ECouldNotUploadRDL.Create('TRepServWrapper.PublishRDLFile: '
> > >> > +
> > >> > errCouldNotUploadRDL + ': ' + e.Message);
> > >> > end;
> > >> > end;
> > >> >
> > >> >
> > >> > This works except one thing:
> > >> > Due to german users I'd like to have umlauts in the rdl name.
> > >> > Unfortunately
> > >> > Reporting Services do not allow that (besides some other special
> > >> > characters).
> > >> > Is there a special conversion to make this work?
> > >> >
> > >> > Thank you in advance.
> > >> >
> > >> > Sandra Geisler
> > >>
> > >>
> > >>
> >
> >
> >|||Sandra,
you saved my day.
I stuck in a similar problem. But UseUTF8InHeader solved it.
Thank you
"Sandra Geisler" wrote:
> Oh my god, I solved it ;-).
> It was an encoding issue which had its origin in the SOAPHTPPClient unit of
> Delphi.
> I had to set the THTTPRIO.HTTPWebNode.UseUTF8InHeader to true and then it
> worked :-)...
> Thank you very much for your support!|||Glad to be of some help!
Best regards
Sandra
"Christian Loidl" wrote:
> Sandra,
> you saved my day.
> I stuck in a similar problem. But UseUTF8InHeader solved it.
> Thank you
> "Sandra Geisler" wrote:
> > Oh my god, I solved it ;-).
> > It was an encoding issue which had its origin in the SOAPHTPPClient unit of
> > Delphi.
> > I had to set the THTTPRIO.HTTPWebNode.UseUTF8InHeader to true and then it
> > worked :-)...
> >
> > Thank you very much for your support!
>

rdl generator

HI all
im new to sql reporting services, im in need of a rdl (report definition language)generator
are there any resouirces out there on the net ?
if so , can u suggest some links for the same?
thanks in advance !

Hi,

I do not really know if I am interpreting your question in the right way..

You are not searching for a tool like the "Business Intelligence Development Studio" which is included in the Client Installation of SQL 2005 and is the tool for developing projects for SSIS, SSAS and SSRS...

If you want to develope your own report generator you could use this link and code http://msdn2.microsoft.com/en-us/library/ms170239.aspx as a start point.

cheers,
Markus

|||

This one I think it best: http://msdn2.microsoft.com/en-us/library/ms170667.aspx

Here are a few others:

http://www.codeproject.com/csharp/rdlproject.asp

http://blogs.msdn.com/swisowaty/archive/2006/06/07/620838.aspx

|||

thanks ??€?§Q? for your response... i had managed to come across those links and build the rdl generator

follow up:

what we actually need was a custom report designer that would give the corresponding rdl file of the user specified format

so the rdl generator was just a small part ..

so any ideas/clues /suggestions are very welcome , pls help !

|||thanks markus for that link , but i had already come up with that one...and no we are not supposed to use the report builder in the ssrs package .|||

kuruvilla wrote:

a custom report designer that would give the corresponding rdl file of the user specified format

What do you mean by this?

|||

Hi,

instead of programming a new softwareon your own you probably should give rsinteract [www.rsinteract.com] a try...

cheers

Markus

|||well what i meant was the same utilities which u have with the reporrt builder , is what is needed but maybe not as diverse and feature rich as we have in the report builder tool
something which the customers can use
in case u wanna know the details they are AND MOST IMPORTANTLY IT SHOULD BE WINDOWS BASED NOT A WEB APPLICATION:-

o follows a Wizard pattern to generate Report

o Tree-view listing of Reports, Reports can be grouped and sub-grouped

o Wizard navigates treads the following path, Select a table->Brings up Related Tables->Field Selection->Manipulate Field (Can select a field, for query generation, but opt to not print it)->Multiple Sorts->Filtering of Data

The above procedure acts as a Query Generator and generates a Query to be executed to retrieve data

o Report Designer, a canvas area to decide the layout of the Report. Actual Report generation is assisted by a third-party tool.

o Fields on Report Designer can be formatted using a context menu

o Formula option provides complete flexibility in defining a formula field More details required

o No Sub-Reports

o Data entry forms are linked to fields on the Reports, user can click on a field and a Form is opened with relevant data

o Report is divided in different section Report Header, Page Header, Section Header etc.

o Tree-view of the Controls Structure, placed on the canvas can be seen. The structure is editable through this feature

o Drawing tools are provided to be used on the canvas

o Image of different formats can be placed on the canvas

o Text boxes and Font can be formatted

o Page Setup, Paper Size for the Report can be defined

o Status bar provides information while dragging fields and on mouse-over for the formula fields

o Report can be exported to various formats Excel, HTML, DBF, CSV, PDF

o Report can be send via an Email. It can be send as a PDF attachment, as an attachment in Custom format with a Custom reader. (Custom format not required now)

o Reports can be compressed and send via an Email

o Snapped Grid Context-sensitive help

|||THANKS MARCKUS..well thats just about what i needed i guess, but not as a web app, but i need it to be embedded in the windows application

rdl generator

Hi,

I do not really know if I am interpreting your question in the right way..

If you want to develope your own report generator you could use this link and code http://msdn2.microsoft.com/en-us/library/ms170239.aspx as a start point.

cheers,
Markus

|||

This one I think it best: http://msdn2.microsoft.com/en-us/library/ms170667.aspx

Here are a few others:

http://www.codeproject.com/csharp/rdlproject.asp

http://blogs.msdn.com/swisowaty/archive/2006/06/07/620838.aspx

|||

thanks ??€?§Q? for your response... i had managed to come across those links and build the rdl generator

follow up:

what we actually need was a custom report designer that would give the corresponding rdl file of the user specified format

so the rdl generator was just a small part ..

so any ideas/clues /suggestions are very welcome , pls help !

|||thanks markus for that link , but i had already come up with that one...and no we are not supposed to use the report builder in the ssrs package .|||

kuruvilla wrote:

a custom report designer that would give the corresponding rdl file of the user specified format

What do you mean by this?

|||

Hi,

instead of programming a new softwareon your own you probably should give rsinteract [www.rsinteract.com] a try...

cheers

Markus

o follows a Wizard pattern to generate Report

o Tree-view listing of Reports, Reports can be grouped and sub-grouped

The above procedure acts as a Query Generator and generates a Query to be executed to retrieve data

o Report Designer, a canvas area to decide the layout of the Report. Actual Report generation is assisted by a third-party tool.

o Fields on Report Designer can be formatted using a context menu

o Formula option provides complete flexibility in defining a formula field More details required

o No Sub-Reports

o Data entry forms are linked to fields on the Reports, user can click on a field and a Form is opened with relevant data

o Report is divided in different section Report Header, Page Header, Section Header etc.

o Tree-view of the Controls Structure, placed on the canvas can be seen. The structure is editable through this feature

o Drawing tools are provided to be used on the canvas

o Image of different formats can be placed on the canvas

o Text boxes and Font can be formatted

o Page Setup, Paper Size for the Report can be defined

o Status bar provides information while dragging fields and on mouse-over for the formula fields

o Report can be exported to various formats Excel, HTML, DBF, CSV, PDF

o Report can be send via an Email. It can be send as a PDF attachment, as an attachment in Custom format with a Custom reader. (Custom format not required now)

o Reports can be compressed and send via an Email

o Snapped Grid Context-sensitive help

|||THANKS MARCKUS..well thats just about what i needed i guess, but not as a web app, but i need it to be embedded in the windows application

RDL Generator

I need more information of RDL Generator, i need to convert Crystal reports
to Reporting Services.an RDL file is an XML file and the entire definition is available on the MS
web site (and RS help)
There is a company dedicated to this job convertion:
http://www.rpttosql.com/
I don't remember the name of another company which has created a tool to do
this.
"Inés" <Inés@.discussions.microsoft.com> wrote in message
news:66F3FAF7-4EE1-40BD-8CB4-5C0062D4C48A@.microsoft.com...
>I need more information of RDL Generator, i need to convert Crystal reports
> to Reporting Services.

RDL generation problem

Hi,

I am working with SQL Server 2005 Reporting Service from few days, though I am

not expert, for some reason I have to run on field without having sound

knowledge of RDL, but need your help, gys. I am using SQL Server Business

Intelligence Development Studio to design report.

Here is the procedure of my work to populate a RDL report

Then I drag and drop necessary field to my report layout.

Put required parameters to preview tab and then run report.

This is quite simple, I didn't face any problem with this process, even though

the process may not correct, but working perfect. My problem is

when the stored procedure returns multiple result set. The data tab only

shows the first result set though the SP returns multiple result set, I have

run the SP in the Query Analyzer. I don't want change my stored procedure.

And please give me some suggestions about the best procedure

to develop RDL report in real life.

Please reply me ASAP, it’s very urgent.

Thank youTareqe

Hi there,

SQL RS doesn't support multiple resultsets. You will need to either write a wrapper stored procedure to retrieve the dataset you want or modify your stored procedure.

regards,

Andrew

RDL File Not Saved

I am using Visual Studio .NET 2003 (with Reporting Services installed), and a
cluster of SQL Server 2000 in a Citrix environment.
I created a Business Inteligence Project, a Shared data source, added a new
report and created a new dataset. I added tables to my Data tab, setup the
relationships, etc.
I Save All and exit VS (without building or deploying the solution). Next
time I come back my Report Data file does not contain the tables I previously
added on. No matter how many tables I add the size of the .rdl file seems to
be 1 kB.
This hapens occasionally only. I could not find a relationship yet but there
are occasions when the rdl file does save properly and thus I don't loose all
my work.
Any suggestions would be greatly appreciated!
Thanks
SorinTry to switch to Layout view before saving your project.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"SOPONL" <SOPONL@.discussions.microsoft.com> wrote in message
news:891ADFC9-F003-4789-94E6-85214AF9AF02@.microsoft.com...
>I am using Visual Studio .NET 2003 (with Reporting Services installed), and
>a
> cluster of SQL Server 2000 in a Citrix environment.
> I created a Business Inteligence Project, a Shared data source, added a
> new
> report and created a new dataset. I added tables to my Data tab, setup the
> relationships, etc.
> I Save All and exit VS (without building or deploying the solution). Next
> time I come back my Report Data file does not contain the tables I
> previously
> added on. No matter how many tables I add the size of the .rdl file seems
> to
> be 1 kB.
> This hapens occasionally only. I could not find a relationship yet but
> there
> are occasions when the rdl file does save properly and thus I don't loose
> all
> my work.
> Any suggestions would be greatly appreciated!
> Thanks
> Sorin|||I've switched to Layout, saved the project and closed VS. Then I re-open the
project; the tables were still not there.
"Lev Semenets [MSFT]" wrote:
> Try to switch to Layout view before saving your project.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "SOPONL" <SOPONL@.discussions.microsoft.com> wrote in message
> news:891ADFC9-F003-4789-94E6-85214AF9AF02@.microsoft.com...
> >I am using Visual Studio .NET 2003 (with Reporting Services installed), and
> >a
> > cluster of SQL Server 2000 in a Citrix environment.
> >
> > I created a Business Inteligence Project, a Shared data source, added a
> > new
> > report and created a new dataset. I added tables to my Data tab, setup the
> > relationships, etc.
> >
> > I Save All and exit VS (without building or deploying the solution). Next
> > time I come back my Report Data file does not contain the tables I
> > previously
> > added on. No matter how many tables I add the size of the .rdl file seems
> > to
> > be 1 kB.
> >
> > This hapens occasionally only. I could not find a relationship yet but
> > there
> > are occasions when the rdl file does save properly and thus I don't loose
> > all
> > my work.
> >
> > Any suggestions would be greatly appreciated!
> >
> > Thanks
> > Sorin
>
>|||In the Data tab I always click in the top section until I see the "*" after
the file name and then right-click the tab to save it.
"SOPONL" wrote:
> I've switched to Layout, saved the project and closed VS. Then I re-open the
> project; the tables were still not there.
> "Lev Semenets [MSFT]" wrote:
> > Try to switch to Layout view before saving your project.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "SOPONL" <SOPONL@.discussions.microsoft.com> wrote in message
> > news:891ADFC9-F003-4789-94E6-85214AF9AF02@.microsoft.com...
> > >I am using Visual Studio .NET 2003 (with Reporting Services installed), and
> > >a
> > > cluster of SQL Server 2000 in a Citrix environment.
> > >
> > > I created a Business Inteligence Project, a Shared data source, added a
> > > new
> > > report and created a new dataset. I added tables to my Data tab, setup the
> > > relationships, etc.
> > >
> > > I Save All and exit VS (without building or deploying the solution). Next
> > > time I come back my Report Data file does not contain the tables I
> > > previously
> > > added on. No matter how many tables I add the size of the .rdl file seems
> > > to
> > > be 1 kB.
> > >
> > > This hapens occasionally only. I could not find a relationship yet but
> > > there
> > > are occasions when the rdl file does save properly and thus I don't loose
> > > all
> > > my work.
> > >
> > > Any suggestions would be greatly appreciated!
> > >
> > > Thanks
> > > Sorin
> >
> >
> >

RDL File from Report Designer

I'm very new to Reporting Services, so I have a basic question. Once I have
designed a report in Report Designer (generated an RDL file), without
deploying it to the Report Server, is it possible to view this report somehow
given this RDL file alone?You can view the report in Preview mode or debug local mode which takes the
secuity policy setting to run the report.
This two method of viewing the report does not require to deploy the report
in the report server.
HTH
Balaji
--
Message posted via http://www.sqlmonster.com|||Thanks for your reply. I guess I need to make myself more clear. I mean
whether I could view the report outside of Report Designer without deploying
the report?
For example, in Crystal Reports, all we need is a report viewer dll plus the
report definition. In other words, the report is really portable.
Thanks
jenny
"BALAJI via SQLMonster.com" wrote:
> You can view the report in Preview mode or debug local mode which takes the
> secuity policy setting to run the report.
> This two method of viewing the report does not require to deploy the report
> in the report server.
> HTH
> Balaji
> --
> Message posted via http://www.sqlmonster.com
>|||Visual Studio 2005 will have two controls (winform and webform) that will
either work with RS or can work in local mode. In local mode you give it a
report and the dataset, no server necessary.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<yinjennytam@.newsgroup.nospam> wrote in message
news:DF5FCCA2-F0F3-47A2-BC12-183DA08E7345@.microsoft.com...
> Thanks for your reply. I guess I need to make myself more clear. I mean
> whether I could view the report outside of Report Designer without
> deploying
> the report?
> For example, in Crystal Reports, all we need is a report viewer dll plus
> the
> report definition. In other words, the report is really portable.
> Thanks
> jenny
>
> "BALAJI via SQLMonster.com" wrote:
>> You can view the report in Preview mode or debug local mode which takes
>> the
>> secuity policy setting to run the report.
>> This two method of viewing the report does not require to deploy the
>> report
>> in the report server.
>> HTH
>> Balaji
>> --
>> Message posted via http://www.sqlmonster.com|||Thanks for your quick reply!
Good point! I've heard of that too, but does it work with custom data
processing extension? We have defined our own datasource and I can't seem to
find a way to run the report in VS 2005 in local mode. :-(
Thanks
Jenny
"Bruce L-C [MVP]" wrote:
> Visual Studio 2005 will have two controls (winform and webform) that will
> either work with RS or can work in local mode. In local mode you give it a
> report and the dataset, no server necessary.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <yinjennytam@.newsgroup.nospam> wrote in message
> news:DF5FCCA2-F0F3-47A2-BC12-183DA08E7345@.microsoft.com...
> > Thanks for your reply. I guess I need to make myself more clear. I mean
> > whether I could view the report outside of Report Designer without
> > deploying
> > the report?
> >
> > For example, in Crystal Reports, all we need is a report viewer dll plus
> > the
> > report definition. In other words, the report is really portable.
> >
> > Thanks
> > jenny
> >
> >
> > "BALAJI via SQLMonster.com" wrote:
> >
> >> You can view the report in Preview mode or debug local mode which takes
> >> the
> >> secuity policy setting to run the report.
> >>
> >> This two method of viewing the report does not require to deploy the
> >> report
> >> in the report server.
> >>
> >> HTH
> >> Balaji
> >>
> >> --
> >> Message posted via http://www.sqlmonster.com
> >>
>
>|||In the local mode of the ReportViewer, you don't need a data extension -
your code supplies the dataset. Data extensions are only needed on the
Report Server.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<yinjennytam@.newsgroup.nospam> wrote in message
news:5B0DA793-B022-4159-8735-3336C9E310E3@.microsoft.com...
> Thanks for your quick reply!
> Good point! I've heard of that too, but does it work with custom data
> processing extension? We have defined our own datasource and I can't seem
> to
> find a way to run the report in VS 2005 in local mode. :-(
> Thanks
> Jenny
>
> "Bruce L-C [MVP]" wrote:
>> Visual Studio 2005 will have two controls (winform and webform) that will
>> either work with RS or can work in local mode. In local mode you give it
>> a
>> report and the dataset, no server necessary.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <yinjennytam@.newsgroup.nospam> wrote in message
>> news:DF5FCCA2-F0F3-47A2-BC12-183DA08E7345@.microsoft.com...
>> > Thanks for your reply. I guess I need to make myself more clear. I
>> > mean
>> > whether I could view the report outside of Report Designer without
>> > deploying
>> > the report?
>> >
>> > For example, in Crystal Reports, all we need is a report viewer dll
>> > plus
>> > the
>> > report definition. In other words, the report is really portable.
>> >
>> > Thanks
>> > jenny
>> >
>> >
>> > "BALAJI via SQLMonster.com" wrote:
>> >
>> >> You can view the report in Preview mode or debug local mode which
>> >> takes
>> >> the
>> >> secuity policy setting to run the report.
>> >>
>> >> This two method of viewing the report does not require to deploy the
>> >> report
>> >> in the report server.
>> >>
>> >> HTH
>> >> Balaji
>> >>
>> >> --
>> >> Message posted via http://www.sqlmonster.com
>> >>
>>|||Please bear with me as I'm still very new to this Reporting Services. Maybe
I should explain my problem.
So far I have attempted to create my own data processing extension using the
Reporting Services of SQL Server 2005 April CTP version and even successfully
created reports (.rdl files). Although I have some troubles getting the
Report Server up and running sometimes, I managed to deploy those reports and
view them in Report Manager. So far so good. However, ideally we need to
support mobile users. The question is how do we make reports portable to
them? Is it possible for mobile users to view reports without a connection
to Report Server? Something like the Report Designer when we preview the
reports (or does this go through the Report Server behind the scene?).
We want to make use of our custom data processing extension to feed the data
to the reports. With ReportViewer controls, it looks like that there are two
options, one of which (as you mentioned) requires us to supply the dataset
and the other requires a connection to the Report Server.
Previously, with Crystal Reports, we support our mobile users with a simple
Report Viewer dll so that they can view reports even when disconnected.
Also, I'm very impressed with the powerful ReportBuilder (seen the webcast)
and even played with it a little bit. Unfortunately, it seems to me that I
cannot set up a model designer based on my custom data processing extension
... :-( Is that right?
Thank you very much for reading this post. :-)
Jenny
"Brian Welcker [MSFT]" wrote:
> In the local mode of the ReportViewer, you don't need a data extension -
> your code supplies the dataset. Data extensions are only needed on the
> Report Server.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> <yinjennytam@.newsgroup.nospam> wrote in message
> news:5B0DA793-B022-4159-8735-3336C9E310E3@.microsoft.com...
> > Thanks for your quick reply!
> >
> > Good point! I've heard of that too, but does it work with custom data
> > processing extension? We have defined our own datasource and I can't seem
> > to
> > find a way to run the report in VS 2005 in local mode. :-(
> >
> > Thanks
> > Jenny
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Visual Studio 2005 will have two controls (winform and webform) that will
> >> either work with RS or can work in local mode. In local mode you give it
> >> a
> >> report and the dataset, no server necessary.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> <yinjennytam@.newsgroup.nospam> wrote in message
> >> news:DF5FCCA2-F0F3-47A2-BC12-183DA08E7345@.microsoft.com...
> >> > Thanks for your reply. I guess I need to make myself more clear. I
> >> > mean
> >> > whether I could view the report outside of Report Designer without
> >> > deploying
> >> > the report?
> >> >
> >> > For example, in Crystal Reports, all we need is a report viewer dll
> >> > plus
> >> > the
> >> > report definition. In other words, the report is really portable.
> >> >
> >> > Thanks
> >> > jenny
> >> >
> >> >
> >> > "BALAJI via SQLMonster.com" wrote:
> >> >
> >> >> You can view the report in Preview mode or debug local mode which
> >> >> takes
> >> >> the
> >> >> secuity policy setting to run the report.
> >> >>
> >> >> This two method of viewing the report does not require to deploy the
> >> >> report
> >> >> in the report server.
> >> >>
> >> >> HTH
> >> >> Balaji
> >> >>
> >> >> --
> >> >> Message posted via http://www.sqlmonster.com
> >> >>
> >>
> >>
> >>
>
>|||VS 2005 will have both a webform and winform control. When operating in
local mode you give it the report and dataset. These controls are available
in Beta 2 of VS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<yinjennytam@.newsgroup.nospam> wrote in message
news:8E8E3B78-31EB-4262-9F7A-096AE009EE0F@.microsoft.com...
> Please bear with me as I'm still very new to this Reporting Services.
> Maybe
> I should explain my problem.
> So far I have attempted to create my own data processing extension using
> the
> Reporting Services of SQL Server 2005 April CTP version and even
> successfully
> created reports (.rdl files). Although I have some troubles getting the
> Report Server up and running sometimes, I managed to deploy those reports
> and
> view them in Report Manager. So far so good. However, ideally we need to
> support mobile users. The question is how do we make reports portable to
> them? Is it possible for mobile users to view reports without a
> connection
> to Report Server? Something like the Report Designer when we preview the
> reports (or does this go through the Report Server behind the scene?).
> We want to make use of our custom data processing extension to feed the
> data
> to the reports. With ReportViewer controls, it looks like that there are
> two
> options, one of which (as you mentioned) requires us to supply the dataset
> and the other requires a connection to the Report Server.
> Previously, with Crystal Reports, we support our mobile users with a
> simple
> Report Viewer dll so that they can view reports even when disconnected.
> Also, I'm very impressed with the powerful ReportBuilder (seen the
> webcast)
> and even played with it a little bit. Unfortunately, it seems to me that
> I
> cannot set up a model designer based on my custom data processing
> extension
> ... :-( Is that right?
> Thank you very much for reading this post. :-)
> Jenny
>
> "Brian Welcker [MSFT]" wrote:
>> In the local mode of the ReportViewer, you don't need a data extension -
>> your code supplies the dataset. Data extensions are only needed on the
>> Report Server.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> <yinjennytam@.newsgroup.nospam> wrote in message
>> news:5B0DA793-B022-4159-8735-3336C9E310E3@.microsoft.com...
>> > Thanks for your quick reply!
>> >
>> > Good point! I've heard of that too, but does it work with custom data
>> > processing extension? We have defined our own datasource and I can't
>> > seem
>> > to
>> > find a way to run the report in VS 2005 in local mode. :-(
>> >
>> > Thanks
>> > Jenny
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Visual Studio 2005 will have two controls (winform and webform) that
>> >> will
>> >> either work with RS or can work in local mode. In local mode you give
>> >> it
>> >> a
>> >> report and the dataset, no server necessary.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> <yinjennytam@.newsgroup.nospam> wrote in message
>> >> news:DF5FCCA2-F0F3-47A2-BC12-183DA08E7345@.microsoft.com...
>> >> > Thanks for your reply. I guess I need to make myself more clear. I
>> >> > mean
>> >> > whether I could view the report outside of Report Designer without
>> >> > deploying
>> >> > the report?
>> >> >
>> >> > For example, in Crystal Reports, all we need is a report viewer dll
>> >> > plus
>> >> > the
>> >> > report definition. In other words, the report is really portable.
>> >> >
>> >> > Thanks
>> >> > jenny
>> >> >
>> >> >
>> >> > "BALAJI via SQLMonster.com" wrote:
>> >> >
>> >> >> You can view the report in Preview mode or debug local mode which
>> >> >> takes
>> >> >> the
>> >> >> secuity policy setting to run the report.
>> >> >>
>> >> >> This two method of viewing the report does not require to deploy
>> >> >> the
>> >> >> report
>> >> >> in the report server.
>> >> >>
>> >> >> HTH
>> >> >> Balaji
>> >> >>
>> >> >> --
>> >> >> Message posted via http://www.sqlmonster.com
>> >> >>
>> >>
>> >>
>> >>
>>

Friday, March 30, 2012

Reading a record without placing a lock

Monday, March 26, 2012

Read perfmon log into SQL table

Read Only Reporting Server Active/Active Configuration

Read Only permission for ReportingServices.GetPolicies()

Read only or hidden report parameters in Reporting Services

Monday, March 12, 2012

RDL's future with other reporting platforms

rdlc viewer issues

RDLC Reporting Service - setting up query parameters - is this possible?

rdlc parameters error

Friday, March 9, 2012

rdl or rdlc for custom reports

RDL name with umlauts

rdl generator

rdl generator

RDL Generator

RDL generation problem

RDL File Not Saved

RDL File from Report Designer

Raster Catalog

Blog Archive

About Me