Formula column.

HI,
I have a problem in formula column.
I have 8 1 bit varibles in a table
for ex: Flag1, falg2, flag3 ...Flag8
Now I want to create another variable as a small integer and copy all
the flgas to that field.
For ex:

(flag1 << 0x80) | (flag2 << 0x40) | .... | flag8

I tried all possible ways?

Let me know how to write the formula for this column.

Thanks,
Venkat.Assuming you don't have any NULLs:

(flag1*128 | flag2*64 | flag3*32 | flag4*16 | flag5*8 | flag6*4 | flag7*2 |
flag8*1)

--
David Portas
----
Please reply only to the newsgroup
--

"Venkat" <arunkvrr@.yahoo.com> wrote in message
news:f21476c8.0308281543.145ceff9@.posting.google.c om...
> HI,
> I have a problem in formula column.
> I have 8 1 bit varibles in a table
> for ex: Flag1, falg2, flag3 ...Flag8
> Now I want to create another variable as a small integer and copy all
> the flgas to that field.
> For ex:
> (flag1 << 0x80) | (flag2 << 0x40) | .... | flag8
> I tried all possible ways?
> Let me know how to write the formula for this column.
> Thanks,
> Venkat.

Formatting Reports

I have created a report but I want to format it and put in headers and a bit of colour to it.
Does anyone know how I can do this.
Thanks,
macca

This is easy thing in reporting service read those tutorila to know how they are great ones on msdn

http://msdn2.microsoft.com/en-us/library/ms170623.aspx

http://msdn2.microsoft.com/en-us/library/ms170246.aspx

Format in SP

Hi,
I am quering a table that has a bit field. The bit field is used to store a
boolean and I want to display this value in a data grid. Can I format(i do
not want a -1 or 0 displayed in the datagrid) this value before I return the
resultset?
ThanksWell, first off, a BIT cannot be -1. You must be thinking of Access or VB.
SELECT CASE bitColumn WHEN 1 THEN 'True' ELSE 'False' END FROM table
"jake" <jp@.broncos.com> wrote in message
news:uhRdKH20FHA.1252@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am quering a table that has a bit field. The bit field is used to store
> a boolean and I want to display this value in a data grid. Can I format(i
> do not want a -1 or 0 displayed in the datagrid) this value before I
> return the resultset?
> Thanks
>|||While you can use a CASE statement to transform the values, you are mingling
the data layer and the presentation layer. You can just as easily perform
the same action in your client code and maintain the tier integrity. (What
if you or someone else want to call this same query in another place and kee
p
the bit values?)
Just something to consider.
John Scragg
"jake" wrote:

> Hi,
> I am quering a table that has a bit field. The bit field is used to store
a
> boolean and I want to display this value in a data grid. Can I format(i d
o
> not want a -1 or 0 displayed in the datagrid) this value before I return t
he
> resultset?
> Thanks
>
>|||> (What if you or someone else want to call this same query in another place
and > keep the bit values?)
The 'wtf-way' would be to convert the values back and forth as needed. :)
I whole-heartedly agree - things like these belong on the presentation layer
.
ML

Format HTMLOWC

I have a .net application already that does quite a bit
of reporting and I'd like to incorporate RS into it.
Currently, I have a DetailReport.aspx page that displays
results using Office Web Components. I'd like to replace
this page with reports from RS. When I try to view
reports using the Format=HTMLOWC directly in the HTML
Viewer, the results look just like regular HTML (not like
the Excel in OWC). I thought I could just display the
report using the ReportViewer.dll included with RS, but
it doesn't seem like that will work.
So, my question is what is the best way to incorporate RS
into my existing application? I want the user to be able
to experience the report in OWC through my current web
app.
Thanks in advance!
Jim
.What is is issue you have with ReportViewer control, because we are using
ReportViewer to display the report in the web interface and it works fine.
Let me know the issue and see how I can help you
Balaji
--
Message posted via http://www.sqlmonster.com|||Thanks for your response, but I'm not sure I understand. I changed the
webapp to use the reportviewer.dll control for RS and used the
Format="HTMLOWC" property, but the report is still rendered on the webform as
HTML and not HTML with OWC. Any ideas? Both the client and the IIS server
have OWC installd, but the RS Server may not.
JE
"BALAJI via SQLMonster.com" wrote:
> What is is issue you have with ReportViewer control, because we are using
> ReportViewer to display the report in the web interface and it works fine.
> Let me know the issue and see how I can help you
> Balaji
> --
> Message posted via http://www.sqlmonster.com
>|||Actually, I'm finding that I cannot even download the report using the Export
functionality in the HTML Viewer. It just shows up as regular HTML. I have
OWC installed on the client and it used to download the same report fine.
I've installed RS SP2 - could that have broken this?
JE
"Jim Emlet" wrote:
> Thanks for your response, but I'm not sure I understand. I changed the
> webapp to use the reportviewer.dll control for RS and used the
> Format="HTMLOWC" property, but the report is still rendered on the webform as
> HTML and not HTML with OWC. Any ideas? Both the client and the IIS server
> have OWC installd, but the RS Server may not.
> JE
> "BALAJI via SQLMonster.com" wrote:
> > What is is issue you have with ReportViewer control, because we are using
> > ReportViewer to display the report in the web interface and it works fine.
> >
> > Let me know the issue and see how I can help you
> >
> > Balaji
> >
> > --
> > Message posted via http://www.sqlmonster.com
> >|||The OWC rendering has lots of limitations that are described in the
documentation. If we run into one of these restrictions, it will come out as
straight HTML.
The best way to embed reports into your applications is actually the new
ReportViewer controls in VS 2005.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim Emlet" <JimEmlet@.discussions.microsoft.com> wrote in message
news:132259F7-7CAF-404C-9F04-8D8910BCC60A@.microsoft.com...
> Actually, I'm finding that I cannot even download the report using the
> Export
> functionality in the HTML Viewer. It just shows up as regular HTML. I
> have
> OWC installed on the client and it used to download the same report fine.
> I've installed RS SP2 - could that have broken this?
> JE
> "Jim Emlet" wrote:
>> Thanks for your response, but I'm not sure I understand. I changed the
>> webapp to use the reportviewer.dll control for RS and used the
>> Format="HTMLOWC" property, but the report is still rendered on the
>> webform as
>> HTML and not HTML with OWC. Any ideas? Both the client and the IIS
>> server
>> have OWC installd, but the RS Server may not.
>> JE
>> "BALAJI via SQLMonster.com" wrote:
>> > What is is issue you have with ReportViewer control, because we are
>> > using
>> > ReportViewer to display the report in the web interface and it works
>> > fine.
>> >
>> > Let me know the issue and see how I can help you
>> >
>> > Balaji
>> >
>> > --
>> > Message posted via http://www.sqlmonster.com
>> >