Ad Hoc Report Writer

Public Clarification Board

• 

  mihirkale

  • 8 years ago

  Sorry to say this. Before entering this contest I thought it would be worthwhile. But now I don't see this contest going anywhere. Looks like it is one of those 'waste of time' bogus projects without a proper vision. :(

  • 8 years ago
• 

  mihirkale

  • 8 years ago

  Hi, I would like to clarify a few things about SSRS. SSRS can connect to databases like SQL Server, Oracle. The idea is to create datasources ( Similar to creating connection object in ADO.NET, by supplying the connection string). The primary source of data for the report is the DATASET. The dataset requires a valid DATASOURCE to be created first. We can create a single datasource referring to SQL Server and another datasource referring to Oracle. We can then create appropriate datasets based upon certain DB(SQL or Oracle)We can create a report which shows the data from different databases. The Tablix control (Table+Matrix) in SSRS can however refer to one dataset only. But we can have multiple Tablix controls on a single report. These can show data from both databases.

  • 8 years ago
• 

  jaiswaljk

  • 9 years ago

  Qlik View is one of it.

  • 9 years ago
  1. 
     Contest Holder

     • 8 years ago

     Qlik is an interesting approach and i like their graphic representations. Can the reports come from two databases and can we use the connections to make reports at will?

     • 8 years ago
• 

  abdellatif81

  • 9 years ago

  SSRS will be a good solution

  • 9 years ago
  1. 
     Contest Holder

     • 8 years ago

     How does this solution pull from Oracle?

     • 8 years ago
• 

  padmanabanlx

  • 9 years ago

  Shall we use Microsoft Reporting Services.

  • 9 years ago
  1. 
     Contest Holder

     • 8 years ago

     I'm not sure, will MSR straddle both data bases?

     • 8 years ago
• 

  Reza2012

  • 9 years ago

  I can use Crystal report for this solution.

  • 9 years ago
  1. 
     Contest Holder

     • 8 years ago

     Crystal Reports would be fine. When could you start if selected?

     • 8 years ago
• 

  kvukkalkar

  • 9 years ago

  I can create Reports using Oracle Report Builder. Can you clarify on your requirements. I am very comfortable with Oracle Reports.

  • 9 years ago
  1. 
     Contest Holder

     • 8 years ago

     Report builder will not work with SQL Server will it?

     • 8 years ago
• 

  hansakaw

  • 8 years ago

  Is there enough stored procedures and queries placed in the both servers those are enough to generate the reports required?

  • 8 years ago
• 
  Contest Holder

  • 8 years ago

  SQL Server. We will need to make our own ad hoc reports once the report writer is connected to the appropriate tables.

  • 8 years ago
• 

  priyamehtag

  • 9 years ago

  Besides Oracle which other database you are using? If possible please share the expected format for report. Thanks.

  • 9 years ago
• 

  smshafiqulislam

  • 9 years ago

  Give me your report format, I can deliver it from any platform you want. I am expert in navicat, oracle reports tool, crystal report, toad etc. Just let me know your report format. Thanks.

  • 9 years ago
  1. 
     Contest Holder

     • 9 years ago

     I think i might be willing to give you a shot at this but I don't see any profile for you here...are you listed?

     • 9 years ago
• 

  softwaressn

  • 9 years ago

  We can help you creating a platform for Ad-hoc reporting purposes using either Oracle BI/Hyperion Interactive Reporting/Cognos/Qlikview/Tableau. We can also help you with interactive dashboards using any of the above tools.

  • 9 years ago

Show more comments