How to use sql express in offline mode for report generation ?

Hi , I have been using ms sql 2000 database for generating reports up till now . but now as per a new requirement , i have to obtain data for generating the report from sql express & not ms sql 2000 , and that too in offline mode . i do not know how the structure of data is there in sql express . 1)do we have data stored in tables? or do we use xml ? 2)do we write similar queries as we write in ms sql ?? 3) and lastly what is this offline stuff ? Can any one please throw some light on comparison between sql 2000 and sql express in these three points. Thanks in advance

>I do not know how the structure of data is there in sql express . 1)dowe have data stored in tables? or do we use xml ?
Data is stored in tables as in SQL2000 or SQL2005 - the limitation is on the size of the database. You can also use XML when in

2)do we write similarqueries as we write in ms sql ?
Just the same!

3) and lastly what is this offlinestuff ?
Offline refers to getting data from a ource other than SQL Server (which includes SQL 2005 Express)

sql

How to use sql express in offline mode for report generation ?

Hi , I have been using ms sql 2000 database for generating reports up till now . but now as per a new requirement , i have to obtain data for generating the report from sql express & not ms sql 2000 , and that too in offline mode . i do not know how the structure of data is there in sql express . 1)do we have data stored in tables? or do we use xml ? 2)do we write similar queries as we write in ms sql ?? 3) and lastly what is this offline stuff ? Can any one please throw some light on comparison between sql 2000 and sql express in these three points. Thanks in advance

>I do not know how the structure of data is there in sql express . 1)dowe have data stored in tables? or do we use xml ?
Data is stored in tables as in SQL2000 or SQL2005 - the limitation is on the size of the database. You can also use XML when in

2)do we write similarqueries as we write in ms sql ?
Just the same!

3) and lastly what is this offlinestuff ?
Offline refers to getting data from a ource other than SQL Server (which includes SQL 2005 Express)

sql

How to use sql express in offline mode for generating a report !!

Hi ,

I have been using ms sql 2000 database for generating reports up till now . but now as per a new requirement , i have to obtain data for generating the report from sql express & not ms sql 2000 , and that too in offline mode . i do not know how the structure of data is there in sql express .

1)do we have data stored in tables? or do we use xml ?

2)do we write similar queries as we write in ms sql ?

3) and lastly what is this offline stuff ?

Can any one please throw some light on comparison between sql 2000 and sql express in these three points.

Thanks in advance

SQL Express is the exact same database engine as SQL Server. SQL Express has maximum database size limits (4 GB), and some other functionalities are not included, but generally, you use it the same. Same tables, VIEWs, queries, security, etc.

As to the 'off-line'. I 'm not sure what you mean, but I suspect the requirement means to not allow data changes while the report is being generated. An 'Off-line' database is generally not available -it is off-line. (Go figure...) You could restrict usage by changing the database to 'Read-Only' or to 'Single User' mode. More information is needed to give a definitive response to that part.

Click here for a more detailed contrast between the versions.

|||

In addition to Arnie, you don′t need a database for generating reports in SQL Server Reporting Services. the reports can also be based on XML files or any other providers shipped with SQL Server. For SQL Server Express, you can only use local SQL Server data (stored in tables)

Jens K. Suessmeyer.

http://www.sqlserver2005.de

How to use Explicit mode ?

I read and tried many times, but I cannot successful build xml
my target xml as:
<Header>
<Body IsUpdate="Y">
<Name IsUpdate="Y">ABC Company</Name>
<Details>
<Line IsUpdate="Y">
<Feature IsUpdate="Y">Feature 1</Feature>
<Feature IsUpdate="N">Feature 2</Feature>
</Line>
</Details>
<Discount IsUpdate="Y">1120</Discount>
</Body>
</Header>
How to use Explicit Mode to build above XML?
From what table(s) is this xml being composed?
Peter DeBetta, MVP - SQL Server
http://sqlblog.com
"ABC" <abc@.abc.com> wrote in message
news:uYc0$stwHHA.3364@.TK2MSFTNGP02.phx.gbl...
>I read and tried many times, but I cannot successful build xml
> my target xml as:
> <Header>
> <Body IsUpdate="Y">
> <Name IsUpdate="Y">ABC Company</Name>
> <Details>
> <Line IsUpdate="Y">
> <Feature IsUpdate="Y">Feature 1</Feature>
> <Feature IsUpdate="N">Feature 2</Feature>
> </Line>
> </Details>
> <Discount IsUpdate="Y">1120</Discount>
> </Body>
> </Header>
> How to use Explicit Mode to build above XML?
>

How to use Explicit mode ?

I read and tried many times, but I cannot successful build xml
my target xml as:
<Header>
<Body IsUpdate="Y">
<Name IsUpdate="Y">ABC Company</Name>
<Details>
<Line IsUpdate="Y">
<Feature IsUpdate="Y">Feature 1</Feature>
<Feature IsUpdate="N">Feature 2</Feature>
</Line>
</Details>
<Discount IsUpdate="Y">1120</Discount>
</Body>
</Header>
How to use Explicit Mode to build above XML?From what table(s) is this xml being composed?
Peter DeBetta, MVP - SQL Server
http://sqlblog.com
--
"ABC" <abc@.abc.com> wrote in message
news:uYc0$stwHHA.3364@.TK2MSFTNGP02.phx.gbl...
>I read and tried many times, but I cannot successful build xml
> my target xml as:
> <Header>
> <Body IsUpdate="Y">
> <Name IsUpdate="Y">ABC Company</Name>
> <Details>
> <Line IsUpdate="Y">
> <Feature IsUpdate="Y">Feature 1</Feature>
> <Feature IsUpdate="N">Feature 2</Feature>
> </Line>
> </Details>
> <Discount IsUpdate="Y">1120</Discount>
> </Body>
> </Header>
> How to use Explicit Mode to build above XML?
>

How to use C# syntax in report expressions

I want to use C# syntax in report expressions.
I use WinForms ReportViewer in local mode.
How to use C# instead of VB.NET syntax ?
I'm thinking about the following approaches:
1. Create pre-processor which converts expressions in RDL file from C# to
VB. NET
2. Replace all expressions with a method which takes C# expression as string
parameter, evaluates it and returns result.
Any idea how to implement this ?
Where to find any samples of C# expression evaluator or C# VB .NET
expression converter ?
Andrus.On Mar 27, 4:34 am, "Andrus" <kobrule...@.hot.ee> wrote:
> I want to use C# syntax in report expressions.
> I use WinForms ReportViewer in local mode.
> How to use C# instead of VB.NET syntax ?
> I'm thinking about the following approaches:
> 1. Create pre-processor which converts expressions in RDL file from C# to
> VB. NET
> 2. Replace all expressions with a method which takes C# expression as string
> parameter, evaluates it and returns result.
> Any idea how to implement this ?
> Where to find any samples of C# expression evaluator or C# VB .NET
> expression converter ?
> Andrus.
I, myself, come from a C# background and needed to learn some basic
VB.NET for expressions in order to use SSRS 2005. Aside from basic
syntax, the two are highly similar. It doesn't seem like the time to
become familiar w/the report expressions, etc in VB.NET would be as
much of a trade off when compared to a custom C# to VB.NET expression
converting application. That said, here's one I found:
http://www.tangiblesoftwaresolutions.com/Product_Details/Instant_VB/Instant_VB.htm
Also, several are mentioned here:
http://groups.google.com/group/microsoft.public.dotnet.languages.vb/browse_thread/thread/b4787e2e70c0b9df/6ec64748dea02d40?lnk=st&q=C%23+to+vb.net+conversion&rnum=4#6ec64748dea02d40
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||> It doesn't seem like the time to
> become familiar w/the report expressions, etc in VB.NET would be as
> much of a trade off when compared to a custom C# to VB.NET expression
> converting application.
I noticed that I must write code in <Code> tags in VB .NET also.
So using reporting services requires learning full VB .NET language, not
only expressions.
I have read everywhere that .NET allows to select between C# and VB .NET
When this is fixed so that C# language can be used in RDLC files ?
Andrus.|||> I noticed that I must write code in <Code> tags in VB .NET also.
>So using reporting services requires learning full VB .NET language, not
>only expressions.
Really not true, or at least certainly not a big deal, if you put your code
in custom DLLs instead of embedding it in the report. Which you would
probably want to do for non-trivial code anyway. So put your code in custom
DLLs in C#, and go as crazy as you want creating custom functions (in C#)
which you can call in your report for anything where the built-in VB
functions seem non-intuitive or not effective from your POV.
>L<
"Andrus" <kobruleht2@.hot.ee> wrote in message
news:OWlLZNHcHHA.2120@.TK2MSFTNGP03.phx.gbl...
>> It doesn't seem like the time to
>> become familiar w/the report expressions, etc in VB.NET would be as
>> much of a trade off when compared to a custom C# to VB.NET expression
>> converting application.
> I noticed that I must write code in <Code> tags in VB .NET also.
> So using reporting services requires learning full VB .NET language, not
> only expressions.
> I have read everywhere that .NET allows to select between C# and VB .NET
> When this is fixed so that C# language can be used in RDLC files ?
> Andrus.