Thursday, March 22, 2012
Custom URL to Report Manager
We are trying to setup a url (reports.company.com) to point to Report
Manager so that end users will not have to enter in a server name.
This works initially, but the web app changes the url back to
http://ServerName/Reports/Pages/Folder.aspx
Is there anyway to have the url not change so that it would show
http://reports.company.com/Reports/Pages/Folder.aspx?
We are wanting to customize report manager a bit before we offer to the end
user communnity.
Thanks in advance,
spindlejDuh, I must have been on crack yesterdy. After thinking about it somemore
today, I realized that the default web site in IIS configuration was set to
foward to http://ServerName/Reports/
All I needed to do was change it to forward to
http://reports.company.com/Reports/ and now it works like a charm.
Thanks to me for figuring it out :)
"spindlej" wrote:
> Hopefully someone will know the answer to this one.
> We are trying to setup a url (reports.company.com) to point to Report
> Manager so that end users will not have to enter in a server name.
> This works initially, but the web app changes the url back to
> http://ServerName/Reports/Pages/Folder.aspx
> Is there anyway to have the url not change so that it would show
> http://reports.company.com/Reports/Pages/Folder.aspx?
> We are wanting to customize report manager a bit before we offer to the end
> user communnity.
> Thanks in advance,
> spindlej
Tuesday, March 20, 2012
Custom sort the dimension members
Hello users of SSAS2005!
I am in the funny position of developing a cube for (at least) three different user groups, and each need "their" special treatment. My problem is in sort order of one particular dimension. The dimension has 3 fields: ID (=person number), Firstname and Lastname - as simple as straightforward as it can be.
Now Finance wants it sorted by ID to relate it to their documents. Human resources needs it by last name, so it can be copy-pasted directly into their structures.
It gets really hilarious when IT needs it sorted by first name (not joking here) because an external application delivers correlating date sorted by first name (again, I am not making that up).
Since I cannot convience anyone onto one common sort I need to make all three possible sort orders available, and I might end up with having 3 identical dimensions or one dimension with 3 identical attributes (except for sorting)
We use Excel as our frontend, I know I can sort a cube there as well. This is, of course, if the field to base the sorting upon is dragged onto the same axis, but that is a bit clumsy too.
What is the "best practices" approach to such a funny situation? (Except for changing the company workflow, let's take that as ... sigh ... static.)
Hello Ralf! I am not sure that this is possible in SSAS/MDX.
One way to solve this is to make the SSAS 2005 reports in Reporting Services 2005.
Check Books On Line for dynamic sorting in reporting services. It is also possible to sort with parameters.
If you can only use Excel pivot tables you can make three different reports, each sorted according to each groups preference.
Publish them i Sharepoint(or any other portal).
HTH
Thomas Ivarsson
HTH
Thomas Ivarsson
Sunday, March 11, 2012
Custom 'Order By' Function?
1) 1,2,3,4...10,11
2) 01,02,03,04...10,11
3) A1,A2,A3,B1,B2,B3...B10,B11
4) 1.1,2.1,3.1.....10.1,11.1
5) 1.1, 1.1A, 1.1B, 2.1, 2.1A, 2.1B....10.1,10.1A
The queruies that select from this table will only select records with
one of the formats at any one time. Is it possible to ensure the order
is always logically correct based on numerical and alphabetical
ordering, as above?
So far its seems ok except formats 4 & 5 where I get the folowoing
output-
1.3 1.3A 1.3P 11.3 16.3 2.3 2.3P 2.3S
Thanks
hals_leftHi
your query will work fine if ur 4 and 5 looks similar to 2.
the results in 4 & 5 are considered and sorted as per the char value.
prefix 0 ans see the results.
--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"hals_left" wrote:
> Hi I have a column varchar(4). Users enter values in one of 5 formats -
>
> 1) 1,2,3,4...10,11
> 2) 01,02,03,04...10,11
> 3) A1,A2,A3,B1,B2,B3...B10,B11
> 4) 1.1,2.1,3.1.....10.1,11.1
> 5) 1.1, 1.1A, 1.1B, 2.1, 2.1A, 2.1B....10.1,10.1A
> The queruies that select from this table will only select records with
> one of the formats at any one time. Is it possible to ensure the order
> is always logically correct based on numerical and alphabetical
> ordering, as above?
> So far its seems ok except formats 4 & 5 where I get the folowoing
> output-
> 1.3 1.3A 1.3P 11.3 16.3 2.3 2.3P 2.3S
> Thanks
> hals_left
>|||On 28 Jul 2005 08:00:54 -0700, hals_left wrote:
>Hi I have a column varchar(4). Users enter values in one of 5 formats -
>
>1) 1,2,3,4...10,11
>2) 01,02,03,04...10,11
>3) A1,A2,A3,B1,B2,B3...B10,B11
>4) 1.1,2.1,3.1.....10.1,11.1
>5) 1.1, 1.1A, 1.1B, 2.1, 2.1A, 2.1B....10.1,10.1A
Hi hals_left,
How does one store 10.1A in a varchar(4) column?
> is thgere now way to write a different
>ordering function?
Try the following. It's not pretty, but it might work:
ORDER BY
CASE
WHEN my_column LIKE '[A-Z]%'
THEN LEFT (my_column, 1)
END,
CASE
WHEN my_column LIKE '[A-Z]%'
THEN CAST (SUBSTRING (my_column, 2, 3) AS int)
WHEN my_column LIKE '%.%'
THEN CAST (LEFT (my_column, CHARINDEX ('.', my_column) - 1) AS int)
ELSE CAST (my_column AS int)
END,
CASE
WHEN my_column LIKE '%.%'
THEN SUBSTRING (my_column, CHARINDEX ('.', my_column) + 1, 4)
END
(untested)
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Custom or 3rd party report filtering tool
I am looking for a tool/application that can be used by users to select and
filter reports. The report list and field list would be pulled from a
database along with field type, and query to use to populate drop down list
filters.
User would select the report they want from a drop down list. The form
would populate with the fields required for the filter and the user would
enter into the filter as required. This information would then be sent to
the report server as either report paramaters, or have the filter items
combined into a where clause and passed as a single parameter to the report
where it would be used to filter the SQL coming from the data source.
Has anyone seen anything like this? I can't find anything on google. We'd
like an easy to use reporting interface for our users and are not willing
allow our users to use the standard RS interface for report filtering.Maybe use the Windows Sharepoint Services report explorer to let users
select their report and enable the filtering in the report.
"Dan" <kgh@.kg.com> wrote in message
news:uueqfouzHHA.3788@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I am looking for a tool/application that can be used by users to select
> and filter reports. The report list and field list would be pulled from a
> database along with field type, and query to use to populate drop down
> list filters.
> User would select the report they want from a drop down list. The form
> would populate with the fields required for the filter and the user would
> enter into the filter as required. This information would then be sent to
> the report server as either report paramaters, or have the filter items
> combined into a where clause and passed as a single parameter to the
> report where it would be used to filter the SQL coming from the data
> source.
> Has anyone seen anything like this? I can't find anything on google.
> We'd like an easy to use reporting interface for our users and are not
> willing allow our users to use the standard RS interface for report
> filtering.
>
>|||That's the standard sharepoint site for reports that comes with RS?
I don't mind this interface too much, but it's not as intuitive as I like.
One majour problem is in the difference in which we do filtering with our
reports. All of our reports have only 1 parameter and we call it
WhereAndSort. We just append this parameter value to the SQL statement in
the dataset. We do not create a parameter for every field we want the user
to potentially filter on because 1)we like to be able to add new filtering
options without re-compiling the report. 2) We recieve better performance
filtering on the SQL query rather than pulling all records and do report
filtering...
Thanks...
....still looking for another option.
Dan
"Joel Lindstrom" <joel.lindstrom@.customereffective.com> wrote in message
news:2425A0D9-A741-4A05-B694-1C9F6E7FB086@.microsoft.com...
> Maybe use the Windows Sharepoint Services report explorer to let users
> select their report and enable the filtering in the report.
> "Dan" <kgh@.kg.com> wrote in message
> news:uueqfouzHHA.3788@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> I am looking for a tool/application that can be used by users to select
>> and filter reports. The report list and field list would be pulled from
>> a database along with field type, and query to use to populate drop down
>> list filters.
>> User would select the report they want from a drop down list. The form
>> would populate with the fields required for the filter and the user would
>> enter into the filter as required. This information would then be sent
>> to the report server as either report paramaters, or have the filter
>> items combined into a where clause and passed as a single parameter to
>> the report where it would be used to filter the SQL coming from the data
>> source.
>> Has anyone seen anything like this? I can't find anything on google.
>> We'd like an easy to use reporting interface for our users and are not
>> willing allow our users to use the standard RS interface for report
>> filtering.
>>
>
Wednesday, March 7, 2012
Custom Delivery Extension
I'm in the process of creating a custom delivery extension that will
write to a file share and then email users that the file is available.
I have used the custom printing extension sample as the basis for
creating my FileShareEmail extension.
I think my question is unlike most posted here in that, I have gotten
all the config files to work. So far I have set up a few parameters
(email address to and from). I then send an email with smtp.
I successfully receive the email and I created the notification.Status
= "Status: Email Sent.". This is what i see in the log file:
ReportingServicesService!notification!3ffc!11/02/2005-09:42:06::
Notification 7493a45c-2f0b-431c-bb53-592a99a5977c completed. Success:
False, Status: Email Sent., DeliveryExtension: File Share Email,
Report: 01 - Standard Listing Report, Attempt 1
There are no exceptions and the email was sent. The Report Manager
still has Done: 1 processed of 1 total; 1 errors. in the status column.
I cannot figure out why there was an error generated. Is there a
property that i forgot to set?
Another question I have is: I can see my custom extension in data
driven subscriptions but not in the regular subscriptions. Is this by
design or am I missing a config.
Resources question: I've looked quite a few places for some more
examples (other than the printer example), does anyone know some good
blogs or sites that have some different samples implemented?
The fourth and final question: Since I am trying to replicate some of
the existing functionality of RS, is there a way to send the email
through RS instead of coding my own error checking and such into my
extension?
Thanks for your help!
Regards,
DanI figured out one of the 4 questions. My Deliver() method was
returning the wrong boolean value (i.e. true when failed and false when
succeeded).
Sunday, February 19, 2012
Custom authentication support in RS 2000
I read somewhere that only Integrated Windows Authentication is
supported in RS 2000. Out Web application has internet users, so I
cannot use IW authentication.
Is there any way to use custom authentication (form based)?
Without this we cannot use RS in our application.
Please help.
regards,
Sachin.Hi Sachin,
I don´t know if there´s a way to use form based authentication in rs - I
don´t believe so.
A possible workaround:
run the rs-web under a useraccount who may use rs (but then you can´t differ
between the internet-users) and build your own web-frontend in front of the
rs-web where users only see their reports... a lot of action but full
control.
hth, Tony
"sachin laddha" <sachinladdha@.gmail.com> schrieb im Newsbeitrag
news:1143199592.405622.169790@.g10g2000cwb.googlegroups.com...
> Hi,
> I read somewhere that only Integrated Windows Authentication is
> supported in RS 2000. Out Web application has internet users, so I
> cannot use IW authentication.
> Is there any way to use custom authentication (form based)?
> Without this we cannot use RS in our application.
> Please help.
> regards,
> Sachin.
>|||Yeah there is. There are several articles on how to do so. And samples
that come with RS2000 and 2005.
However, Custom (forms) authentiation only works in Developer Edition and
Enterprise Edition of 2000, it works with standard in 2005.
"Toni Pohl" <atwork43@.hotmail.com__nospam> wrote in message
news:uTVRWk0TGHA.5884@.TK2MSFTNGP14.phx.gbl...
> Hi Sachin,
> I don´t know if there´s a way to use form based authentication in rs - I
> don´t believe so.
> A possible workaround:
> run the rs-web under a useraccount who may use rs (but then you can´t
> differ between the internet-users) and build your own web-frontend in
> front of the rs-web where users only see their reports... a lot of action
> but full control.
> hth, Tony
> "sachin laddha" <sachinladdha@.gmail.com> schrieb im Newsbeitrag
> news:1143199592.405622.169790@.g10g2000cwb.googlegroups.com...
>> Hi,
>> I read somewhere that only Integrated Windows Authentication is
>> supported in RS 2000. Out Web application has internet users, so I
>> cannot use IW authentication.
>> Is there any way to use custom authentication (form based)?
>> Without this we cannot use RS in our application.
>> Please help.
>> regards,
>> Sachin.
>|||Using Forms Authentication in Reporting Services.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
Sadly, as was mentioned, it needs Developer or Enterprise Edition in RS
2000.
"Chris Taylor" <ctaylor7480@.newsgroups.nospam> wrote in message
news:%23Do3Wu2TGHA.4792@.TK2MSFTNGP14.phx.gbl...
> Yeah there is. There are several articles on how to do so. And samples
> that come with RS2000 and 2005.
> However, Custom (forms) authentiation only works in Developer Edition and
> Enterprise Edition of 2000, it works with standard in 2005.
> "Toni Pohl" <atwork43@.hotmail.com__nospam> wrote in message
> news:uTVRWk0TGHA.5884@.TK2MSFTNGP14.phx.gbl...
>> Hi Sachin,
>> I don´t know if there´s a way to use form based authentication in rs - I
>> don´t believe so.
>> A possible workaround:
>> run the rs-web under a useraccount who may use rs (but then you can´t
>> differ between the internet-users) and build your own web-frontend in
>> front of the rs-web where users only see their reports... a lot of action
>> but full control.
>> hth, Tony
>> "sachin laddha" <sachinladdha@.gmail.com> schrieb im Newsbeitrag
>> news:1143199592.405622.169790@.g10g2000cwb.googlegroups.com...
>> Hi,
>> I read somewhere that only Integrated Windows Authentication is
>> supported in RS 2000. Out Web application has internet users, so I
>> cannot use IW authentication.
>> Is there any way to use custom authentication (form based)?
>> Without this we cannot use RS in our application.
>> Please help.
>> regards,
>> Sachin.
>>
>