Prev: Confused by Role Assignment for individual reports
Next: Error Message:
From: Andre on 10 Feb 2010 02:45
SQL 2005

I'm brand new to Reporting Services, but have been a SQL developer for
years. Up to this point all my reporting has been done using Crystal
Reports. I'm trying to convert some existing reports from Crystal Reports
to Reporting Services. So far I'd have to say I'm not impressed with RS as
far as it's compared to Crystal. I know some of that is familiarity so I
thought I'd ask a couple of basic questions here so I can be clear of my
understanding of RS. Thanks in advance for any help/tips you can offer.

My Questions:
.. I'm using SQL Server Business Intelligence Development Studio. I have
created a project with a shared data source. I've typed in the user name
and password, yet it never remembers the credentials. Every time I re-open
the project I have to type them in again - it's defaulted back to "use
windows authentication". Why? More importantly, how can I get it to save
my credentials?
.. How do I create the equivalent of Running Totals, and Formula fields?
Yes, I've read the whitepaper about converting from CR to RS, so I don't
need a link to it. I just want to be clear that I have to go into the Code
section and create a formula field.

Thanks, Andr�


From: Uri Dimant on 10 Feb 2010 03:27
Andre
1) When you put login and password check box save passoword down on the
window
Do you open report via RM (Report Manager) or via BID(Business Intelligence
Development Studio)?

2) You need to do is enter an expression like this:
=RunningValue(Fields!col.Value, Sum, "caption")

Formula fields --- Expression Fields



"Andre" <no(a)spam.com> wrote in message
news:e0IsCUiqKHA.5940(a)TK2MSFTNGP02.phx.gbl...
> SQL 2005
>
> I'm brand new to Reporting Services, but have been a SQL developer for
> years. Up to this point all my reporting has been done using Crystal
> Reports. I'm trying to convert some existing reports from Crystal Reports
> to Reporting Services. So far I'd have to say I'm not impressed with RS
> as far as it's compared to Crystal. I know some of that is familiarity so
> I thought I'd ask a couple of basic questions here so I can be clear of my
> understanding of RS. Thanks in advance for any help/tips you can offer.
>
> My Questions:
> . I'm using SQL Server Business Intelligence Development Studio. I have
> created a project with a shared data source. I've typed in the user name
> and password, yet it never remembers the credentials. Every time I
> re-open the project I have to type them in again - it's defaulted back to
> "use windows authentication". Why? More importantly, how can I get it to
> save my credentials?
> . How do I create the equivalent of Running Totals, and Formula fields?
> Yes, I've read the whitepaper about converting from CR to RS, so I don't
> need a link to it. I just want to be clear that I have to go into the
> Code section and create a formula field.
>
> Thanks, Andr�
>
>


From: Bruce L-C [MVP] on 10 Feb 2010 10:19
In most cases you should not have to use code behind reports. Very very
rare. As Uri mentioned you would use an expression.

The thing to wrap your head around is that RS uses a different paradigm than
Crystal. RS is built using SOA design patter (Service Oriented
Architecture). You give RS all the information it needs to do the work and
it does it. You should not have to write any code (or very little).

Another thing to consider when you are migrating your reports. Consider
designing a report a drill through. I.e. you create a link to another report
and pass parameters to that report. I make the link blue and underlined.
Users know what to do. For example, I have an invoice number. If they want
more detail they click on the invoice number. RS is very fast at pulling up
lots of small reports. Take the approach of showing what they need and make
it easy to pull up additional detail.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Andre" <no(a)spam.com> wrote in message
news:e0IsCUiqKHA.5940(a)TK2MSFTNGP02.phx.gbl...
> SQL 2005
>
> I'm brand new to Reporting Services, but have been a SQL developer for
> years. Up to this point all my reporting has been done using Crystal
> Reports. I'm trying to convert some existing reports from Crystal Reports
> to Reporting Services. So far I'd have to say I'm not impressed with RS
> as far as it's compared to Crystal. I know some of that is familiarity so
> I thought I'd ask a couple of basic questions here so I can be clear of my
> understanding of RS. Thanks in advance for any help/tips you can offer.
>
> My Questions:
> . I'm using SQL Server Business Intelligence Development Studio. I have
> created a project with a shared data source. I've typed in the user name
> and password, yet it never remembers the credentials. Every time I
> re-open the project I have to type them in again - it's defaulted back to
> "use windows authentication". Why? More importantly, how can I get it to
> save my credentials?
> . How do I create the equivalent of Running Totals, and Formula fields?
> Yes, I've read the whitepaper about converting from CR to RS, so I don't
> need a link to it. I just want to be clear that I have to go into the
> Code section and create a formula field.
>
> Thanks, Andr�
>
>
From: Andre on 10 Feb 2010 13:14
Uri - clicking save password works - I wasn't entering my credentials in the
Edit section, but rather I was entering them in the Credentials tab, where
they weren't saved. I do use BIDS.

Also thanks for the tip on RunningValue. I looked all over RS but didn't
find this. Just like last night I couldn't find a way to format a number as
"thousand separator with no decimals". A quick search of the web found the
Format Code N0 does what I wanted. It's disappointing that the regular
format editor doesn't have this as a choice and I was forced to scan the web
for such a simple thing. So my question is where do I find a good
tutorial/resource for such things as RunningValue? I wonder what other
things are available that I don't know about?

If I may ask another question you can probably help with...
In Crystal I have a formula field with this code:

If {rs;1.difference} = 0 Then 0
Else
if {rs;1.total} > 0 then
({rs;1.difference} / {rs;1.total})

I tried to convert that to an expression in a field using this code:

=IIF(Fields!difference.Value = 0, 0,
IIF(Fields!total.Value > 0, (Fields!difference.Value /
Fields!total.Value), 0))


The problem is every time the report is run, it gives me a divide by zero
error.
The values where it has #Error are:
Total: 0
Difference: -6857

From what I can tell the IIF formula should work; am I overlooking
something?


Thanks for your help - it's much appreciated.

Andre

From: Andre on 10 Feb 2010 13:19
Thanks for the info Bruce. I know I need to re-learn some things and it's
more of a matter of getting used to RS. Like I just said to Uri in my
reply, is it's disappointing that some things which seem very basic -
formatting - are not readily available. Searching the Internet for
Formatting Codes seems crazy. Why not just give me the choices in the
Format editor?

I do use subreports in CR which appear as hyperlinks, so I'm anxious to see
how they work in RS. No doubt there will be more posts from the rookie (me)
when I get to that point. In the meantime, thanks for helping me in my
transition to RS.

Andre

 |  Next  |  Last
Pages: 1 2 3 4
Prev: Confused by Role Assignment for individual reports
Next: Error Message: