Posted: 9/14/2011
i would like to create a report which can be viewed using smart phone. ie blackberry or Iphone.
What is the best tools to create those applications?
Posted: 9/15/2011
Do you want to create an SSRS report that is viewable on a smartphone? If so the key will be making is viewable by having a small number of report items that are large. You best bet is to use Visual Studio SSRS and format the pages to fit in a mobile browser and be readable as stated below. I will do some testing to see how that works out.
Creating mobile web pages.
Static pages - These are the easiest and most common. I would create them with a smaller pixel size. You can Google the recommended sizes, but I tend to use 400 wide and as many as I need long. I do like to limit it to 1000 pixel long. These reports will not be dynamic - they will be static reports that you will update manually.
Dynamic/ Interactive Pages - You can script pages or use flash (excludes IPhones) to create reports as well.
If this answers your question please mark answered.