anyone know how to rotate a textbox

I need to rotate a textbox on a report...i know there is theWritingMode property (sometimes just labeled Mode) of a textbox todetermine whether it is written vertically (tb-rl) or horizontally(lr-tb)...but i need it to betb-lr

any ideas?

HI,bopritchard :

To get text rotated in reporting services all you have to do is set the WritingMode to "tb-rl". You may also want to set the TextAlign and VerticalAlign to position the text correctly. Remember though the text is rotated so to get the text appearing on the left you have to set the VerticalAlign to Bottom. To get the text to align with the bottom of the text box you have to set the TextAlign to Right

|||

i need it to betb-lrnot tb-rl

Anyone have reports on Reports? (Things that go beyond the samples

Hi all,
I'd like to get a report on the reports that are deployed.
It would tell me things like this:
Report Name
DataSourceName
Connection String
Stored Procedures Called
Views/Tables Used (Probably can't be
shown if its calling a stored procedure)
Modified date
Modified Last by
Folder it is stored under in Report
ManagerFolder it is stored under in Report Manager (this is in the samples)
Last Run By
Last Run Date
Can this be done? Does anyone have it?
Are there any user created updates or changes to the samples that MSFT has
written?
KeithOn Jul 25, 1:32 pm, greenmtnsun
<greenmtn...@.discussions.microsoft.com> wrote:
> Hi all,
> I'd like to get a report on the reports that are deployed.
> It would tell me things like this:
> Report Name
> DataSourceName
> Connection String
> Stored Procedures Called
> Views/Tables Used (Probably can't be
> shown if its calling a stored procedure)
> Modified date
> Modified Last by
> Folder it is stored under in Report
> ManagerFolder it is stored under in Report Manager (this is in the samples)
> Last Run By
> Last Run Date
> Can this be done? Does anyone have it?
> Are there any user created updates or changes to the samples that MSFT has
> written?
> Keith
There are two useful tables under a database named
"ReportServer" (this is where the report server stuff is stored, like
history). Catalog and ExecutionLog are the tables and they can be
joined at reportid (execution log) and itemid (catalog). That way you
can pull the names of the report users, reports, and other fun stuff.
There are also some other valuable tables in that database, but I
don't use them that much.|||You are not supposed to access reporting services' database directly
(although you can with appropriate permission). Reporting services provides
web services to get the information the OP wants. reporting services' report
mamaner is an ggod example of an application consuming the web services to
get that kind of information. I believe the OP does not need to know more
information that report manager can show.
"Ayman" <aymantg@.gmail.com> wrote in message
news:1185386825.627743.70110@.q75g2000hsh.googlegroups.com...
> On Jul 25, 1:32 pm, greenmtnsun
> <greenmtn...@.discussions.microsoft.com> wrote:
>> Hi all,
>> I'd like to get a report on the reports that are deployed.
>> It would tell me things like this:
>> Report Name
>> DataSourceName
>> Connection String
>> Stored Procedures Called
>> Views/Tables Used (Probably can't be
>> shown if its calling a stored procedure)
>> Modified date
>> Modified Last by
>> Folder it is stored under in Report
>> ManagerFolder it is stored under in Report Manager (this is in the
>> samples)
>> Last Run By
>> Last Run Date
>> Can this be done? Does anyone have it?
>> Are there any user created updates or changes to the samples that MSFT
>> has
>> written?
>> Keith
> There are two useful tables under a database named
> "ReportServer" (this is where the report server stuff is stored, like
> history). Catalog and ExecutionLog are the tables and they can be
> joined at reportid (execution log) and itemid (catalog). That way you
> can pull the names of the report users, reports, and other fun stuff.
> There are also some other valuable tables in that database, but I
> don't use them that much.
>|||On Jul 25, 1:32 pm, greenmtnsun
<greenmtn...@.discussions.microsoft.com> wrote:
> Hi all,
> I'd like to get a report on the reports that are deployed.
> It would tell me things like this:
> Report Name
> DataSourceName
> Connection String
> Stored Procedures Called
> Views/Tables Used (Probably can't be
> shown if its calling a stored procedure)
> Modified date
> Modified Last by
> Folder it is stored under in Report
> ManagerFolder it is stored under in Report Manager (this is in the samples)
> Last Run By
> Last Run Date
> Can this be done? Does anyone have it?
> Are there any user created updates or changes to the samples that MSFT has
> written?
> Keith
If you have access to those databases, you can make your own custom
reports to show whatever you want. I have one set up to show
executions per user and which reports they executed. Others include,
most recent executions, total executions per report, etc. There is
much you can do in terms of custom reporting if you use the
ReportServer database that is created by default by SSRS.|||I have all the permissions I could ever need. If not, I'll give me them! :-)
Could you by chance share these reports you spoke of? My e-mail address is
keith underscore m underscore ramsey at yahoo dot com
I don't know if spam bots can get this address so I messed with it. _ is an
underscore. LOL.
I'd really appreciate it. They can show me how to get other peices of
information.
One thing I got frusted about was that at first blush I couldn't get an ID
number for a report to link from the RSExecutionLog to the RS databases. I
think the RSExecutionLog uses its own ID system. I hope I'm wrong. I also
don't know how they break out the connection string from things that are
encrypted.
"Ayman" wrote:
> On Jul 25, 1:32 pm, greenmtnsun
> <greenmtn...@.discussions.microsoft.com> wrote:
> > Hi all,
> >
> > I'd like to get a report on the reports that are deployed.
> >
> > It would tell me things like this:
> >
> > Report Name
> >
> > DataSourceName
> >
> > Connection String
> >
> > Stored Procedures Called
> >
> > Views/Tables Used (Probably can't be
> > shown if its calling a stored procedure)
> >
> > Modified date
> >
> > Modified Last by
> >
> > Folder it is stored under in Report
> > ManagerFolder it is stored under in Report Manager (this is in the samples)
> >
> > Last Run By
> >
> > Last Run Date
> >
> > Can this be done? Does anyone have it?
> >
> > Are there any user created updates or changes to the samples that MSFT has
> > written?
> >
> > Keith
> If you have access to those databases, you can make your own custom
> reports to show whatever you want. I have one set up to show
> executions per user and which reports they executed. Others include,
> most recent executions, total executions per report, etc. There is
> much you can do in terms of custom reporting if you use the
> ReportServer database that is created by default by SSRS.
>|||On Jul 26, 11:54 am, greenmtnsun
<greenmtn...@.discussions.microsoft.com> wrote:
> I have all the permissions I could ever need. If not, I'll give me them! :-)
> Could you by chance share these reports you spoke of? My e-mail address is
> keith underscore m underscore ramsey at yahoo dot com
> I don't know if spam bots can get this address so I messed with it. _ is an
> underscore. LOL.
> I'd really appreciate it. They can show me how to get other peices of
> information.
> One thing I got frusted about was that at first blush I couldn't get an ID
> number for a report to link from the RSExecutionLog to the RS databases. I
> think the RSExecutionLog uses its own ID system. I hope I'm wrong. I also
> don't know how they break out the connection string from things that are
> encrypted."Ayman" wrote:
> > On Jul 25, 1:32 pm, greenmtnsun
> > <greenmtn...@.discussions.microsoft.com> wrote:
> > > Hi all,
> > > I'd like to get a report on the reports that are deployed.
> > > It would tell me things like this:
> > > Report Name
> > > DataSourceName
> > > Connection String
> > > Stored Procedures Called
> > > Views/Tables Used (Probably can't be
> > > shown if its calling a stored procedure)
> > > Modified date
> > > Modified Last by
> > > Folder it is stored under in Report
> > > ManagerFolder it is stored under in Report Manager (this is in the samples)
> > > Last Run By
> > > Last Run Date
> > > Can this be done? Does anyone have it?
> > > Are there any user created updates or changes to the samples that MSFT has
> > > written?
> > > Keith
> > If you have access to those databases, you can make your own custom
> > reports to show whatever you want. I have one set up to show
> > executions per user and which reports they executed. Others include,
> > most recent executions, total executions per report, etc. There is
> > much you can do in terms of custom reporting if you use the
> > ReportServer database that is created by default by SSRS.
Here are the generic ones you can use. I posted them here to everyone
will benefit.
--Detailed
select el.username,c.name,el.timestart,el.timeend
executionlog el join
catalog c on el.reportid=c.itemid
order by timestart desc
--Reports used by user
select el.username,c.name, count(1)
from executionlog el join
catalog c on el.reportid=c.itemid
group by el.username,c.name
order by el.username,c.name
--Usage by Report
select c.name, count(1)
from executionlog el join
catalog c on el.reportid=c.itemid
group by c.name
order by count(1) desc
--Recent usages per user per report
select el.username,c.name,el.timestart,el.timeend
from executionlog el join
catalog c on el.reportid=c.itemid
where username =''INSERT IT HERE'
order by timestart desc
Hope that helps! You can put them in a report if you don't like to
see them in SSMS. By the way, it's a good way to track who has been
using the reports you developed for them! You last name sounds
Egyptian by the way.|||Thank you.
For the record, I am still looking for these to place in a report about
reports...
Connection String
Stored Procedures Called
Views/Tables Used (Probably can't be
shown if its calling a stored procedure)
Modified date
Modified Last by
"Ayman" wrote:
> On Jul 26, 11:54 am, greenmtnsun
> <greenmtn...@.discussions.microsoft.com> wrote:
> > I have all the permissions I could ever need. If not, I'll give me them! :-)
> >
> > Could you by chance share these reports you spoke of? My e-mail address is
> > keith underscore m underscore ramsey at yahoo dot com
> >
> > I don't know if spam bots can get this address so I messed with it. _ is an
> > underscore. LOL.
> >
> > I'd really appreciate it. They can show me how to get other peices of
> > information.
> >
> > One thing I got frusted about was that at first blush I couldn't get an ID
> > number for a report to link from the RSExecutionLog to the RS databases. I
> > think the RSExecutionLog uses its own ID system. I hope I'm wrong. I also
> > don't know how they break out the connection string from things that are
> > encrypted."Ayman" wrote:
> > > On Jul 25, 1:32 pm, greenmtnsun
> > > <greenmtn...@.discussions.microsoft.com> wrote:
> > > > Hi all,
> >
> > > > I'd like to get a report on the reports that are deployed.
> >
> > > > It would tell me things like this:
> >
> > > > Report Name
> >
> > > > DataSourceName
> >
> > > > Connection String
> >
> > > > Stored Procedures Called
> >
> > > > Views/Tables Used (Probably can't be
> > > > shown if its calling a stored procedure)
> >
> > > > Modified date
> >
> > > > Modified Last by
> >
> > > > Folder it is stored under in Report
> > > > ManagerFolder it is stored under in Report Manager (this is in the samples)
> >
> > > > Last Run By
> >
> > > > Last Run Date
> >
> > > > Can this be done? Does anyone have it?
> >
> > > > Are there any user created updates or changes to the samples that MSFT has
> > > > written?
> >
> > > > Keith
> >
> > > If you have access to those databases, you can make your own custom
> > > reports to show whatever you want. I have one set up to show
> > > executions per user and which reports they executed. Others include,
> > > most recent executions, total executions per report, etc. There is
> > > much you can do in terms of custom reporting if you use the
> > > ReportServer database that is created by default by SSRS.
> Here are the generic ones you can use. I posted them here to everyone
> will benefit.
> --Detailed
> select el.username,c.name,el.timestart,el.timeend
> executionlog el join
> catalog c on el.reportid=c.itemid
> order by timestart desc
> --Reports used by user
> select el.username,c.name, count(1)
> from executionlog el join
> catalog c on el.reportid=c.itemid
> group by el.username,c.name
> order by el.username,c.name
> --Usage by Report
> select c.name, count(1)
> from executionlog el join
> catalog c on el.reportid=c.itemid
> group by c.name
> order by count(1) desc
> --Recent usages per user per report
> select el.username,c.name,el.timestart,el.timeend
> from executionlog el join
> catalog c on el.reportid=c.itemid
> where username =''INSERT IT HERE'
> order by timestart desc
>
> Hope that helps! You can put them in a report if you don't like to
> see them in SSMS. By the way, it's a good way to track who has been
> using the reports you developed for them! You last name sounds
> Egyptian by the way.
>|||Since we're already into things you aren't supposed to do -
If you have a lot of reports and report execution records, look at the
indexing on the execution log file - by default, I don't think the
report ID is indexed (which seems odd, since it acts as a foreign key
to the catalog table...)

Anyone else had this error situation?

So, for the past two weeks or so every morning Reporting services has come up
with the report error "Sorting cannot be performed on table1". For some odd
reason though it does the error on all reports with any sorting whatsoever.
I've checked and double checked my sorting expressions
(=iif(Parameters!Direction.Value = "Ascending",
Fields(Parameters!SortBy.Value).Value, 0) and =iif(Parameters!Direction.Value
= "Descending", Fields(Parameters!SortBy.Value).Value, 0)...
Direction is a drop down param which is either Ascending or Descending and
SortBy is a drop down param that contains all table columns) and have had
others look at it as well and the logic is good for it. What ultimately
remedies it is a restart of IIS on the server we run the reports on.
So has anyone else experienced this problem? If so I could use any
information as to the possible cause or fix to this.Please try this - note the CInt() function call:
=iif(Parameters!Direction.Value = "Ascending",
CInt(Fields(Parameters!SortBy.Value).Value), 0)
=iif(Parameters!Direction.Value = "Descending",
CInt(Fields(Parameters!SortBy.Value).Value), 0)
etc.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Timm" <Timm@.discussions.microsoft.com> wrote in message
news:2DD5CE58-A3DF-41EF-BD47-010A0770E2AE@.microsoft.com...
> So, for the past two weeks or so every morning Reporting services has come
> up
> with the report error "Sorting cannot be performed on table1". For some
> odd
> reason though it does the error on all reports with any sorting
> whatsoever.
> I've checked and double checked my sorting expressions
> (=iif(Parameters!Direction.Value = "Ascending",
> Fields(Parameters!SortBy.Value).Value, 0) and
> =iif(Parameters!Direction.Value
> = "Descending", Fields(Parameters!SortBy.Value).Value, 0)...
> Direction is a drop down param which is either Ascending or Descending and
> SortBy is a drop down param that contains all table columns) and have had
> others look at it as well and the logic is good for it. What ultimately
> remedies it is a restart of IIS on the server we run the reports on.
> So has anyone else experienced this problem? If so I could use any
> information as to the possible cause or fix to this.|||The column names in use are string values (non-numeric) so using CInt throws
back a
different error that will cause the report to not work 100% of the time. I'm
toying with
an idea that this is something to do with the reporting services and not the
reports
themselves since restarting IIS resolves the issue for a day (and the next
day the error
occurs again).
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OOY8V1sZFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Please try this - note the CInt() function call:
> =iif(Parameters!Direction.Value = "Ascending",
> CInt(Fields(Parameters!SortBy.Value).Value), 0)
> =iif(Parameters!Direction.Value = "Descending",
> CInt(Fields(Parameters!SortBy.Value).Value), 0)
> etc.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Timm" <Timm@.discussions.microsoft.com> wrote in message
> news:2DD5CE58-A3DF-41EF-BD47-010A0770E2AE@.microsoft.com...
>> So, for the past two weeks or so every morning Reporting services has
>> come up
>> with the report error "Sorting cannot be performed on table1". For some
>> odd
>> reason though it does the error on all reports with any sorting
>> whatsoever.
>> I've checked and double checked my sorting expressions
>> (=iif(Parameters!Direction.Value = "Ascending",
>> Fields(Parameters!SortBy.Value).Value, 0) and
>> =iif(Parameters!Direction.Value
>> = "Descending", Fields(Parameters!SortBy.Value).Value, 0)...
>> Direction is a drop down param which is either Ascending or Descending
>> and
>> SortBy is a drop down param that contains all table columns) and have had
>> others look at it as well and the logic is good for it. What ultimately
>> remedies it is a restart of IIS on the server we run the reports on.
>> So has anyone else experienced this problem? If so I could use any
>> information as to the possible cause or fix to this.
>|||If they are strings, then this explains why it does not work. Use the
following expression then - note that 0 is replaced with an empty string:
=iif(Parameters!Direction.Value = "Ascending",
Fields(Parameters!SortBy.Value).Value, "")
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Timm" <tim@.gumdropbooks.com> wrote in message
news:%23F1YsdtZFHA.720@.TK2MSFTNGP15.phx.gbl...
> The column names in use are string values (non-numeric) so using CInt
> throws back a
> different error that will cause the report to not work 100% of the time.
> I'm toying with
> an idea that this is something to do with the reporting services and not
> the reports
> themselves since restarting IIS resolves the issue for a day (and the next
> day the error
> occurs again).
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:OOY8V1sZFHA.3280@.TK2MSFTNGP09.phx.gbl...
>> Please try this - note the CInt() function call:
>> =iif(Parameters!Direction.Value = "Ascending",
>> CInt(Fields(Parameters!SortBy.Value).Value), 0)
>> =iif(Parameters!Direction.Value = "Descending",
>> CInt(Fields(Parameters!SortBy.Value).Value), 0)
>> etc.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Timm" <Timm@.discussions.microsoft.com> wrote in message
>> news:2DD5CE58-A3DF-41EF-BD47-010A0770E2AE@.microsoft.com...
>> So, for the past two weeks or so every morning Reporting services has
>> come up
>> with the report error "Sorting cannot be performed on table1". For some
>> odd
>> reason though it does the error on all reports with any sorting
>> whatsoever.
>> I've checked and double checked my sorting expressions
>> (=iif(Parameters!Direction.Value = "Ascending",
>> Fields(Parameters!SortBy.Value).Value, 0) and
>> =iif(Parameters!Direction.Value
>> = "Descending", Fields(Parameters!SortBy.Value).Value, 0)...
>> Direction is a drop down param which is either Ascending or Descending
>> and
>> SortBy is a drop down param that contains all table columns) and have
>> had
>> others look at it as well and the logic is good for it. What ultimately
>> remedies it is a restart of IIS on the server we run the reports on.
>> So has anyone else experienced this problem? If so I could use any
>> information as to the possible cause or fix to this.
>>
>|||I did that change and this morning we got that error still. After restarting
IIS it now works again.
Is this a known issue or is this something that may be unique to our system?
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23ggV6FvZFHA.3280@.TK2MSFTNGP09.phx.gbl...
> If they are strings, then this explains why it does not work. Use the
> following expression then - note that 0 is replaced with an empty string:
> =iif(Parameters!Direction.Value = "Ascending",
> Fields(Parameters!SortBy.Value).Value, "")
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Timm" <tim@.gumdropbooks.com> wrote in message
> news:%23F1YsdtZFHA.720@.TK2MSFTNGP15.phx.gbl...
>> The column names in use are string values (non-numeric) so using CInt
>> throws back a
>> different error that will cause the report to not work 100% of the time.
>> I'm toying with
>> an idea that this is something to do with the reporting services and not
>> the reports
>> themselves since restarting IIS resolves the issue for a day (and the
>> next day the error
>> occurs again).
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:OOY8V1sZFHA.3280@.TK2MSFTNGP09.phx.gbl...
>> Please try this - note the CInt() function call:
>> =iif(Parameters!Direction.Value = "Ascending",
>> CInt(Fields(Parameters!SortBy.Value).Value), 0)
>> =iif(Parameters!Direction.Value = "Descending",
>> CInt(Fields(Parameters!SortBy.Value).Value), 0)
>> etc.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Timm" <Timm@.discussions.microsoft.com> wrote in message
>> news:2DD5CE58-A3DF-41EF-BD47-010A0770E2AE@.microsoft.com...
>> So, for the past two weeks or so every morning Reporting services has
>> come up
>> with the report error "Sorting cannot be performed on table1". For some
>> odd
>> reason though it does the error on all reports with any sorting
>> whatsoever.
>> I've checked and double checked my sorting expressions
>> (=iif(Parameters!Direction.Value = "Ascending",
>> Fields(Parameters!SortBy.Value).Value, 0) and
>> =iif(Parameters!Direction.Value
>> = "Descending", Fields(Parameters!SortBy.Value).Value, 0)...
>> Direction is a drop down param which is either Ascending or Descending
>> and
>> SortBy is a drop down param that contains all table columns) and have
>> had
>> others look at it as well and the logic is good for it. What ultimately
>> remedies it is a restart of IIS on the server we run the reports on.
>> So has anyone else experienced this problem? If so I could use any
>> information as to the possible cause or fix to this.
>>
>>
>|||I haven't seen this before. Are you sure you don't have any report execution
caching set up?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Timm" <tim@.gumdropbooks.com> wrote in message
news:eHjfzC3ZFHA.1040@.TK2MSFTNGP10.phx.gbl...
>I did that change and this morning we got that error still. After
>restarting IIS it now works again.
> Is this a known issue or is this something that may be unique to our
> system?
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:%23ggV6FvZFHA.3280@.TK2MSFTNGP09.phx.gbl...
>> If they are strings, then this explains why it does not work. Use the
>> following expression then - note that 0 is replaced with an empty string:
>> =iif(Parameters!Direction.Value = "Ascending",
>> Fields(Parameters!SortBy.Value).Value, "")
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Timm" <tim@.gumdropbooks.com> wrote in message
>> news:%23F1YsdtZFHA.720@.TK2MSFTNGP15.phx.gbl...
>> The column names in use are string values (non-numeric) so using CInt
>> throws back a
>> different error that will cause the report to not work 100% of the time.
>> I'm toying with
>> an idea that this is something to do with the reporting services and not
>> the reports
>> themselves since restarting IIS resolves the issue for a day (and the
>> next day the error
>> occurs again).
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:OOY8V1sZFHA.3280@.TK2MSFTNGP09.phx.gbl...
>> Please try this - note the CInt() function call:
>> =iif(Parameters!Direction.Value = "Ascending",
>> CInt(Fields(Parameters!SortBy.Value).Value), 0)
>> =iif(Parameters!Direction.Value = "Descending",
>> CInt(Fields(Parameters!SortBy.Value).Value), 0)
>> etc.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Timm" <Timm@.discussions.microsoft.com> wrote in message
>> news:2DD5CE58-A3DF-41EF-BD47-010A0770E2AE@.microsoft.com...
>> So, for the past two weeks or so every morning Reporting services has
>> come up
>> with the report error "Sorting cannot be performed on table1". For
>> some odd
>> reason though it does the error on all reports with any sorting
>> whatsoever.
>> I've checked and double checked my sorting expressions
>> (=iif(Parameters!Direction.Value = "Ascending",
>> Fields(Parameters!SortBy.Value).Value, 0) and
>> =iif(Parameters!Direction.Value
>> = "Descending", Fields(Parameters!SortBy.Value).Value, 0)...
>> Direction is a drop down param which is either Ascending or Descending
>> and
>> SortBy is a drop down param that contains all table columns) and have
>> had
>> others look at it as well and the logic is good for it. What
>> ultimately
>> remedies it is a restart of IIS on the server we run the reports on.
>> So has anyone else experienced this problem? If so I could use any
>> information as to the possible cause or fix to this.
>>
>>
>>
>|||I am new to reporting services, so my answer may not be correct.
I had same error, when 2nd parameter was changed to cint, error went
away.
Something like this -
=iif(Parameters!Direction.Value = "Ascending",
CInt(Fields(Parameters!SortBy.Value).Value), cint(0))
=iif(Parameters!Direction.Value = "Descending",
CInt(Fields(Parameters!SortBy.Value).Value), cint(0))

Anybody looked at LGX Report?

This is at freereporting.com.
It seems to be very similar to Reporting Services.
Has anybody here made a comparison?
JCLooks good, I noticed you have to pay for PDF outputs, which you don't
on RS.
Also one of the biggest advantages of RS is that it is seamless
connection to Visual Studio .Net

Anybody ever use Actuate e.Reports?

I have an interview tomorrow for a dba position and they make frequent mention of this Actuate e.Report stuff and it looks like Crystal Reports from the web site. Any opinions? Is it garbage? Should I run and hide or chase and embrace? If its crap, I can blow this off. I have a few more things cooking.Yes, I used Actuate e.report before. Similar to Crystal Report, you can design your own e report for the internet. Nothing special, same design and running same sql scripting. Nothing special to me.|||We use Actuate at my work. I'm just an intermediate developer myself, but some of the reports developed by our central IT folks are just incredible. It seems to be very powerful, but kind of a pain to learn.

Any way to put a query timeout on the datasource behind a report model?

Folks, we're wanting to put a timeout of 2 minutes on the queries which get generated by an ad-hoc report built in Report Builder. This particular report model has been generated on top of a cube by clicking the Generate Model button after creating an Analysis Services datasource in Report Manager. The connection string for that datasource reads:

Data Source=(local);Initial Catalog=MyCubeDatabase

I expected there to be a connection string property I could set (such as "Timeout=120") but I can't seem to find that in the documentation anywhere... And Timeout=120 doesn't appear to do it. Do you know of one? If not, do you know of another way to put a timeout limit on a Report Builder generated query or a Report Builder report itself?

I tried setting the "Limit report execution to the following number of seconds" at /Reports/Pages/Settings.aspx in Report Manager to 120, but that does not appear to have an effect on Report Builder reports.

See the following bug I reported for more details:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=232694

This is quite an urgent issue for us as we go live in a week. Any help would be appreciated!

Time out is this a joke , this tool can't even get the rigth result's .... Maybe in version 11B pacth 12334 you have the time out feature

Any way to protect our Report design

Is there any way...we can hide the report design. I do not want anyone to see my report design or formula or tables or sql expression i have used. Even if i can hide my formula and sql expression it will be of great help. Any help greatly appreciated
Thanx thakkarJust hide the report itself|||But I have to distribute in the company. so i have to show the file so that it can be run through our report scheduler. Any other way to protect the hard work we have done...

Thanx madhi once again
Thakkar|||No Ideas Guys!!!!!
Should be something to protect the report.sql

Any way to pop up an alert if users drillthrough to a report with too

Good morning all,
I want to somehow warn our users if they try to drillthrough when one
of the dimensions is near the top of the hierarchy. In the best case
scenario, I would love a confirm("You are attempting to go to a detail
report at a very high level of the hierarchy. Are you sure you want
to continue?")
Is there any way to do that? I am using the Jump to Report option on
the Navigation tab of the Properties box.
Thanks,
KathrynOn Nov 29, 7:50 am, kbutterly <kbutte...@.yahoo.com> wrote:
> Good morning all,
> I want to somehow warn our users if they try to drillthrough when one
> of the dimensions is near the top of the hierarchy. In the best case
> scenario, I would love a confirm("You are attempting to go to a detail
> report at a very high level of the hierarchy. Are you sure you want
> to continue?")
> Is there any way to do that? I am using the Jump to Report option on
> the Navigation tab of the Properties box.
> Thanks,
> Kathryn
You can combine using a javascript alert/confirm call with an
expression referencing something in the SSAS datasource. Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Any way to insert page breaks between tables?

I have about 5 tables on a report.
Is there a way to insert a break between the tables to prevent tables
from being chopped on a page break?
Thank you!Pull up table properties dialog and check "insert page break after this
table" checkbox and also "fit this table on one page if possible" checkbox.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"The Whistler" <sharris@.SLeasynews.com> wrote in message
news:bg48i09pocfef9h7ot6rmklf02uas8dl49@.4ax.com...
> I have about 5 tables on a report.
> Is there a way to insert a break between the tables to prevent tables
> from being chopped on a page break?
> Thank you!
>sql

Any way to create one subscription which delivers server email and file share at the same time?

Hi,

I need to know if it's possible to send out a notification email and deliver the report by file share with one subscription or at least send out a notification email depending on the event of a subscription which delivers the report file share.

My goal is not to have 2 separate subscriptions.

Thanks

You will need to have your own delivery extension created for this,as there is no composing of different delivery methods. But as the classes already exists for those two method you can just call that within your own extension.

HTH, jens Suessmeyer.

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

Hi Jens,

thanks for you reply.

If you don't mind, could you please explain your reply in details....I'm not sure about the delivery extension you mentioned.

I'm not an expert as you.

thanks again

Bo

|||

Good question...

So, how to create delivery extension ? Do anybody know place where it's possible to read something about how create it?

Thanks,

Any way to create one subscription which delivers server email and file share at the same ti

Hi,

I need to know if it's possible to send out a notification email and deliver the report by file share with one subscription or at least send out a notification email depending on the event of a subscription which delivers the report file share.

My goal is not to have 2 separate subscriptions.

Thanks

You will need to have your own delivery extension created for this,as there is no composing of different delivery methods. But as the classes already exists for those two method you can just call that within your own extension.

HTH, jens Suessmeyer.

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

Hi Jens,

thanks for you reply.

If you don't mind, could you please explain your reply in details....I'm not sure about the delivery extension you mentioned.

I'm not an expert as you.

thanks again

Bo

|||

Good question...

So, how to create delivery extension ? Do anybody know place where it's possible to read something about how create it?

Thanks,

Any way to create one subscription which delivers server email and file share at the same ti

Hi,

I need to know if it's possible to send out a notification email and deliver the report by file share with one subscription or at least send out a notification email depending on the event of a subscription which delivers the report file share.

My goal is not to have 2 separate subscriptions.

Thanks

You will need to have your own delivery extension created for this,as there is no composing of different delivery methods. But as the classes already exists for those two method you can just call that within your own extension.

HTH, jens Suessmeyer.

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

Hi Jens,

thanks for you reply.

If you don't mind, could you please explain your reply in details....I'm not sure about the delivery extension you mentioned.

I'm not an expert as you.

thanks again

Bo

|||

Good question...

So, how to create delivery extension ? Do anybody know place where it's possible to read something about how create it?

Thanks,

Any way to create one subscription which delivers server email and file share at the same ti

Hi,

I need to know if it's possible to send out a notification email and deliver the report by file share with one subscription or at least send out a notification email depending on the event of a subscription which delivers the report file share.

My goal is not to have 2 separate subscriptions.

Thanks

You will need to have your own delivery extension created for this,as there is no composing of different delivery methods. But as the classes already exists for those two method you can just call that within your own extension.

HTH, jens Suessmeyer.

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

Hi Jens,

thanks for you reply.

If you don't mind, could you please explain your reply in details....I'm not sure about the delivery extension you mentioned.

I'm not an expert as you.

thanks again

Bo

|||

Good question...

So, how to create delivery extension ? Do anybody know place where it's possible to read something about how create it?

Thanks,

Any way to bold certain words in data field?

I'm working on cleaning up a report and got a request to bold certain words within a data field. I have no idea where to start or what to search on to do this. For instance, I would want to bold any occurance of "History:" or "Technique:" but not bold "history". The data is coming over as plain text in one large data field. Any help would be greatly appreciated!

Thanks!We used to have a system that fed us the data in seperate fields of
History:
Technique:
Comparison:
Findings:
Conculsion:

but now we have a system that is unable to split the data elements up before feeding it into our system. We can't add any formating on the upstream system either unfortionately. Now our report looks like garbage lol. Hopefully one of you gurus will be able to help.

Any video/other tutorials for ASP.Net and ReportViewer control?

I have figured out how to build a report for reportserver - I even have a
video that tells me how to use the reportviewer in a Windows app, but I need
to learn how to do the basics in an ASP.Net page, with the ReportViewer
control.
Are there any basic, step by step web pages that show this, or even better -
any videos to checkout on the web?On Jan 18, 1:02 pm, "Elmo Watson" <s...@.here.com> wrote:
> I have figured out how to build a report for reportserver - I even have a
> video that tells me how to use the reportviewer in a Windows app, but I need
> to learn how to do the basics in an ASP.Net page, with the ReportViewer
> control.
> Are there any basic, step by step web pages that show this, or even better -
> any videos to checkout on the web?
These articles might be helpful.
http://www.aspfree.com/c/a/ASP.NET/Binding-Data-to-the-ReportViewer-Control-Dynamically-in-ASPNET-20/
http://msdn2.microsoft.com/en-us/library/ms252104(VS.80).aspx
Regards,
Enrique Martinez
Sr. Software Consultant

Any tips for using large parameter lists

Our parts table has 5k records. I want to use part number as a parameter for one of my reports. Is there a way to do this and have the report generate in a reasonable amount of time?

Thanks

Create a new dataset on the Data tab with the query as "SELECT part_number from Parts" and name the dataset as, say DataSet2.

Go to Report (menu) -> Report Parameters

and add a new parameter and give the name, type and prompt.

Then under Available Values, select "From Query" radio button

select DataSet2 under Dataset, part_number under Value field

Shyam

|||Thats the problem.
It takes five minutes for the param list to render.|||

Maybe you can reduce the query time on SQL server by adding index (clustered preferably) to part_number column. This is the only solution to reduce the load time.

Shyam

any suggestions for this report design

hi,
i need to design a report with the following requirements...
I need to have 5 static columns and i one dynamic column which increases
according to the user selection...
Can a matrix help here'?
I cant understand how to add static columns to a matrix?
Can any1 suggest me any way of doing it?
thanks,I have an example of static columns in a matrix on www.msbicentral.com
The name of it is Matrix.StaticColumns.RDl
Perhaps you could use that , and use the parameter in the SQL statement to
optionally return one column or another.. ie
select title, price, case @.parm when 1 then pub_id else total_sales end
from titles
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:457B9684-75D1-4E9F-9C0A-28459B5B319C@.microsoft.com...
> hi,
> i need to design a report with the following requirements...
> I need to have 5 static columns and i one dynamic column which increases
> according to the user selection...
> Can a matrix help here'?
> I cant understand how to add static columns to a matrix?
> Can any1 suggest me any way of doing it?
> thanks,
>

any stored procedure to report all the databases' information

Hello everyone,
We're going to migrate our SQL 2000 server from one domain to another. I
need to get a better idea of how our current databases are structured and
utilized. What I want is a report showing each database's:
name
data size
log size
users
if backed up or not
Before I dive into it in my own way, just wondering if there is any stored
procedure that can help collect the above information? I'd appreciate any
help.
Thanks,
Bing
sp_helpdb does most what I wanted.
"bing" wrote:

> Hello everyone,
> We're going to migrate our SQL 2000 server from one domain to another. I
> need to get a better idea of how our current databases are structured and
> utilized. What I want is a report showing each database's:
> name
> data size
> log size
> users
> if backed up or not
> Before I dive into it in my own way, just wondering if there is any stored
> procedure that can help collect the above information? I'd appreciate any
> help.
> Thanks,
> Bing

any stored procedure to report all the databases' information

Hello everyone,
We're going to migrate our SQL 2000 server from one domain to another. I
need to get a better idea of how our current databases are structured and
utilized. What I want is a report showing each database's:
name
data size
log size
users
if backed up or not
Before I dive into it in my own way, just wondering if there is any stored
procedure that can help collect the above information? I'd appreciate any
help.
Thanks,
Bingsp_helpdb does most what I wanted.
"bing" wrote:
> Hello everyone,
> We're going to migrate our SQL 2000 server from one domain to another. I
> need to get a better idea of how our current databases are structured and
> utilized. What I want is a report showing each database's:
> name
> data size
> log size
> users
> if backed up or not
> Before I dive into it in my own way, just wondering if there is any stored
> procedure that can help collect the above information? I'd appreciate any
> help.
> Thanks,
> Bing

any stored procedure to report all the databases' information

Hello everyone,
We're going to migrate our SQL 2000 server from one domain to another. I
need to get a better idea of how our current databases are structured and
utilized. What I want is a report showing each database's:
name
data size
log size
users
if backed up or not
Before I dive into it in my own way, just wondering if there is any stored
procedure that can help collect the above information? I'd appreciate any
help.
Thanks,
Bingsp_helpdb does most what I wanted.
"bing" wrote:

> Hello everyone,
> We're going to migrate our SQL 2000 server from one domain to another. I
> need to get a better idea of how our current databases are structured and
> utilized. What I want is a report showing each database's:
> name
> data size
> log size
> users
> if backed up or not
> Before I dive into it in my own way, just wondering if there is any stored
> procedure that can help collect the above information? I'd appreciate any
> help.
> Thanks,
> Bing