Disregard: SSIS as data source for reporting?

I'm trying to develop a report using an SSIS DataReaderDestination as the reports data souce. When I attempt to create the report DataSet, SSIS is not an option for the Data Source parameter....

Is there an OLE DB or .NET provider for SSIS that I need to install apart from installing reporting services?Had the wrong edition. Never let your architects download things for you :)|||

Hello,
I am experiencing the same problem you described. I have Visual Studio Team Suite installed with SQL Server 2005 Developer Edition. I would expect this setup should allow me to use any of the functionality available in Integration Services. What edition did you have to install to get the SSIS option to appear?

Thanks for your help.

Disregard: SSIS as data source for reporting?

I'm trying to develop a report using an SSIS DataReaderDestination as the reports data souce. When I attempt to create the report DataSet, SSIS is not an option for the Data Source parameter....

Is there an OLE DB or .NET provider for SSIS that I need to install apart from installing reporting services?Had the wrong edition. Never let your architects download things for you :)|||

Hello,
I am experiencing the same problem you described. I have Visual Studio Team Suite installed with SQL Server 2005 Developer Edition. I would expect this setup should allow me to use any of the functionality available in Integration Services. What edition did you have to install to get the SSIS option to appear?

Thanks for your help.

Display of Parameters

Hi,
I need to develop 2 reports using Crystal Reports 11. Both the reports are very similar except that one accepts 2 parameters & the other accepts only one parameter & hence their selection criteria would differ accordingly. I was wanting to know if I could merge both the reports into one, such that I use a third parameter which is boolean & asks which kind of report the user wants to see. Based on the boolean value the report needs to display either 1 parameter or both the parameters. Is this possible in crystal reports ? If not, what is the other best way I could do this ? Please suggest.Hi
Yes ur approch is right, u can do that. Make a single report and accept 3 parameters. based on parameter 1 filter ur report data in a if else condition in record selection formula.|||u can create any report based on different parameters at runtime. of course that means u have to code it in a more generic way... I have done this, bt its in vc++. I suggest u look into the sample code if u want it in vb...its not that hard...
ps: sample code is in ur crytl installed folder.|||Thanks for the responses. If i try using a 3rd parameter method, I have a problem. That is, I can filter the records perfectly fine, however when the parameter window shows up it shows all the parameters in it, the one's that the first report would use & the ones that the second report would also use. I dont want that. Based on the value of the boolean parameter, it should show the corresponding parameters for the first report & accordingly for the second. how do i achieve this ? I'm using only crystal reports....|||Thanks for the responses. If i try using a 3rd parameter method, I have a problem. That is, I can filter the records perfectly fine, however when the parameter window shows up it shows all the parameters in it, the one's that the first report would use & the ones that the second report would also use. I dont want that. Based on the value of the boolean parameter, it should show the corresponding parameters for the first report & accordingly for the second. how do i achieve this ? I'm using only crystal reports....

Hi
If u r not using any front end then u can use two seperate sub reports (on demand sub report) in main report. so number of reports are increased now.

Display Data in Particular Format

I want to display in following manner.i tried a lot with Matrix with celing function but i can't achieve it.

My Crieteria:

I Used to Develop An attendence Register for employees.Each Employees have Multiple Login and Logout.

NwMy Issue is I want to Group Each Employees with having his own IN andOut on a particular day he Present.And at the same time since eachemployees having several login and logout for a particular day.I wantto Wrap a matrix after certain columns and display the rest in nextline for that day of that employee

ie,

i Want in this format

Employee Name: E1

Present Day 1

IN1 OUT1 IN2 OUT2 IN3 OUT3........after a particular column it should be wrapped and displayed in next line

IN4 Out4 IN5 OUT5............this process is continued until all the login and Logouts of tht employees is displayed...

Then

Present Day2

INs and Outs

Present Day3

INs and Outs

After The first Employees

Similar Format is For all the other employees

How can i achieve this??

Could you be more specific? Say, where are your data? in SQL Server?

You can use, for example, nested datalist's, with the nested DataList configured with the columns you want to display, is very easy and there are a lot of tutorials, but I don't know exactly where are your data and where do you want to display that information.

Another way is to retrieve it in XML and render with a XSLT stylesheet. Is quite more complex but gives you more flexibility.

Here's a tutorial with nested repeaters, but the philosophy with datalists is the same.
http://www.aspnettutorials.com/tutorials/controls/nested-repeater-vb.aspx