April 2, 2009 at 8:29 am
Hi,
I have some requirement of migrating the cognos reports to SSRS ad hoc reports.
Please can you provide me some links or tutorial on how to create ad hoc reports, create dataset in ad hoc reports and all.
:discuss:
Thanks
April 2, 2009 at 10:15 am
Could you give more details: do you want to create these reports in Report Manager or through code (e.g. C# project)?
April 2, 2009 at 10:40 am
Actually I don't think much code is needed what is needed in 2005 is to create the models, if you are in the planning stage a better option is to use SQL Server 2008 it comes with free standing Report Builder that can do a lot without models. So you could look into models for 2005 and test drive 2008 which comes with a very user friendly new tool.
http://msdn.microsoft.com/en-us/library/ms157143.aspx
Kind regards,
Gift Peddie
April 2, 2009 at 11:44 am
Thanks for the response.
We will be designing or providing the desired dataset for the adhoc reports to the business as I suppose there is not much to code in report builder. Actually I have done work on report manager but with adhoc reports functionality I am totaly new and dont know how to provide these dataset to the report builder.
@SSCommited
Actuall we have SQL Server 2005 already set for this work so we will be continuing with the same. Hope we will not face any issue for not going with the sql 2008.
April 2, 2009 at 11:57 am
You could use SQL Server 2005 you just need to create model which can run from View, Table and some queries and some is the operative word because Table and Views are the preferred options.
http://msdn.microsoft.com/en-us/library/ms156272(SQL.90).aspx
Kind regards,
Gift Peddie
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply