new to Reporting Services

Friends...

I am new to SQL Server Reporting Services... Pls let me know where and how to start... I browsed thru many sites, none of them provides easy and simple explanation with examples... Pls refer me any useful websites which has step-by-step simple and base explanations with simple examples or demos...

Thanx & Regards...

Salai

chk out this blog for a step by step tutorial on creating reports. If you comment out the code inPageSaveStateComplete then you will get a report else a pdf.

http://technoblab.blogspot.com

....................................................................

Remember to "Mark as Answer" on the post that helped you

|||

Look aroundhttp://www.databasejournal.com

|||

This might help you:

http://www.codeproject.com/aspnet/ReportViewer.asp

sql

new to crystal report

hi friends,
i'm new to crystal report. i'd like to know which method is better to make report in crystal report. i developing programes using vb. could anyone help me pls
thankx for ur helpWhat version of Crystal are you using and what version of VB? Also, what kind of data are you going to use? From a database?

If you do a search on this forum for 'CDO', I have posted many examples. I use CR 8.5 using RDC and VB 6. CDO is Crystal Reports version of a recordset. It leaves all the data gathering up to VB so that Crystal never has to touch the database. VB loads all the data into an array, then stuffs the array into a CDO rowset (similar to an ADO recordset or an RDO resultset), then VB passes the CDO rowset to Crystal to display the data.|||Hi im totally new to crystal reports as well.. im using crystal reports 9 and vb .net. I want to pass parameters to a crystal report using vb.. what i exactly want is that the info the user has entered to a field will be passed to a certain portion in the crystal report.. after entering the required fields, i want to see the whole report in the next page.. how should i do this? help!|||If you do a search on this forum for 'CDO', I have posted many examples. I use CR 8.5 using RDC and VB 6. CDO is Crystal Reports version of a recordset. It leaves all the data gathering up to VB so that Crystal never has to touch the database. VB loads all the data into an array, then stuffs the array into a CDO rowset (similar to an ADO recordset or an RDO resultset), then VB passes the CDO rowset to Crystal to display the data.

thankx for the kind help. it's really a great help.

New setup of MySQL on my machine....

Hello friends, I am a begginer in MySQL. Kindly guide me how can I
install and run MySQL server on my machine (Runnig Wnidows XP
professional and SQL server 2000). Is it neccessary to remove SQL
server from the machine before installing MySQL and what version of IIS
is required? Kindly help me in this regard, it will be appreciated.
Thanks in advance.This is an MSSQL (Microsoft SQL Server) group, so I guess you will get
a better response in a MySQL forum.

Simon

New record in table already or not when in an INSTEAD OF trigger?

Hi, friends,
I am writting a INSTEAD OF INSERT trigger for an insert action on Users
table of our SQL Server 2000 DB.
I know there is only one record (the new inserted one) in inserted table,
but, is this new record also already in Users table? In anther word, if I do
a query in the trigger like:
DECLARE @.newUserID INT
SELECT @.newUserID = i.userID FROM inserted AS i
SELECT * FROM Users WHERE userID = @.newUserID
should I get a record back for the last SELECT statement, not yet? Any
reference paper?
Thanks for your help.No, the row that is in the inserted table in the INSTEAD OF TRIGGER is _not_
already in the base table. And if you don't explicitly insert the row in the
base table inside your trigger, the row will never be inserted. If you want
the behaviour you describe, you should use an AFTER trigger.
Jacco Schalkwijk
SQL Server MVP
"Andrew" <Andrew@.discussions.microsoft.com> wrote in message
news:22E7E45F-E28D-4D21-8E95-67C235390200@.microsoft.com...
> Hi, friends,
> I am writting a INSTEAD OF INSERT trigger for an insert action on Users
> table of our SQL Server 2000 DB.
> I know there is only one record (the new inserted one) in inserted table,
> but, is this new record also already in Users table? In anther word, if I
> do
> a query in the trigger like:
> DECLARE @.newUserID INT
> SELECT @.newUserID = i.userID FROM inserted AS i
> SELECT * FROM Users WHERE userID = @.newUserID
> should I get a record back for the last SELECT statement, not yet? Any
> reference paper?
> Thanks for your help.
>|||On Thu, 24 Mar 2005 14:37:04 -0800, Andrew wrote:

>I am writting a INSTEAD OF INSERT trigger for an insert action on Users
>table of our SQL Server 2000 DB.
>I know there is only one record (the new inserted one) in inserted table,
(snip)
Hi Andrew,
This is only true for single-row inserts. If you execute an INSERT INTO
... SELECT ... command, ALL new rows will be in the inserted table.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)