List post with report

Im developing a program where i would like to export to excel. I found the report function, but cant get it to work
Im developing in VB.net and in a form i would like to have this form.

I have a dataset with some fields. I add the fiels into a table. It works but it only show the first record. Not the secound one. It dont give me the oppertunity to step forward or backward.

I if i could i would like all the posts in the database to be show in the same report for exampel

Firstname Lastname
John Mcgreen
Daniel Johnsson
George Anderson

Right now only the first person shows in the report.

Greatful for help

/Mitmit

I got this working by adding a listcontrol.

But i have some other information that i want to add.

Under John Mcgreen i would like to add every record in another table that is included in my dataset.
John have i id the tbl_person and this ID is FK in another tabel called tbl_record

I want every record that is registed to be shown under John that is connected to him.

John Mcgreen
1. First song from John

2. Second song from John

Daniel Johnsson

1. First song from Daniel

2. Second song from Daniel

|||Just to let you know im developing in vb.net 2.0 and uses MS Sql 2005 and Visual Studio.net 2005 and the built in report tool in VS.net.

If you dont understand my problem or have any question, please ask. This i so important for me to solve as soon as possible.

Best regards.

list of databases in Analysis Services

Hi all,

I have to write a program to read the names of databases in Analysis
Services. I don't know which table I can get this information from.

Thanks a bunchHippi wrote:
> Hi all,
> I have to write a program to read the names of databases in Analysis
> Services. I don't know which table I can get this information from.
> Thanks a bunch

would this work:

select dbid, name
from master..sysdatabases
where has_dbaccess(name) = 1

--
David Rowland
http://dbmonitor.tripod.com|||No, it doesn't work. It shows all the databases I have in SQL Server

List of All SSIS packages stored in MSDB

Hi,

I am writing one program in vb.Net where I need to bind a treeview with all the SSIS packages stored in SQL server MSDB database.

Is it possible to get all the SSIS packages by using T-SQL query or Object model ?

Thanks

Reference assembly Microsoft.SqlServer.ManagedDts.dll and create Application object (in Microsoft.SqlServer.Dts.Runtime namespace). To get list of packages use Application.GetPackageInfos method:

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.getpackageinfos(SQL.90).aspx|||

Alternatively the following query returns the list of stored packages from MSDB database:

SELECT * FROM msdb.dbo.sysdtspackages90

Thanks,
Loonysan

List of All SSIS packages stored in MSDB

Hi,

I am writing one program in vb.Net where I need to bind a treeview with all the SSIS packages stored in SQL server MSDB database.

Is it possible to get all the SSIS packages by using T-SQL query or Object model ?

Thanks

Reference assembly Microsoft.SqlServer.ManagedDts.dll and create Application object (in Microsoft.SqlServer.Dts.Runtime namespace). To get list of packages use Application.GetPackageInfos method:

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.getpackageinfos(SQL.90).aspx|||

Alternatively the following query returns the list of stored packages from MSDB database:

SELECT * FROM msdb.dbo.sysdtspackages90

Thanks,
Loonysan