Member Avatar for saralamanoharan

hai all
Good Morning. I am trying to show a OLAP Report created (using cube in SqlServer 2000) in crystal reports in a asp page. i used smart activex viewer for this but the data alone in the crystal reports r shown. the drill down structure does not appears.

Also after showing the crystal report in asp, if i open the same report in crystal report, it is asking for the password to show the drill down structure if the data in the report is double clicked.

i m having both SQL Server, IIS in my system. i need help regarding this problem . could any one provide me soln immediately. if so i will be so thankful to u.


thank u
sarala

  • 4 Contributors
  • 4 Replies
  • 188 Views
  • 2 Years Discussion Span
  • Latest Post Latest Post by venu@baylogic

Dani AI

Generated

— the symptoms you describe (report shows rows but not the drill tree in the web viewer, and the same report asks for a password when double‑clicking in Designer) almost always mean the report is being rendered from a saved snapshot or the viewer does not have a live, authenticated connection to the OLAP cube. Drill‑down requires a live OLAP connection (or a server component that can re‑connect to the cube); a saved data snapshot will give flat rows only.

Steps to verify/fix in Crystal Designer first:

  • Open the .rpt and turn off any saved snapshot: Report -> Save Data with Report (ensure it is unchecked).
  • Use Database -> Set Datasource Location and confirm the report is pointing to the OLAP provider/catalog you expect.
  • Set the report logon credentials in Designer (Database -> Set Log On/Set Datasource) and refresh the report; verify drill‑down works inside Designer before moving to ASP. If Designer prompts for credentials, the web viewer will too unless the web app supplies them.

Classic ASP / IIS integration notes:

  • The web code must clear any saved data and supply valid cube credentials before the viewer renders the report. In the older (COM) APIs you must set logon for each report connection/table (CRAXDRT style). The IIS process identity must be allowed to connect to Analysis Services, or the app must programmatically pass credentials. Avoid hardcoding plain text passwords in pages; use a secure config or a dedicated service account.
  • If migrating to ASP.NET, the typical pattern is to load the ReportDocument and call SetDatabaseLogon before assigning to the viewer. Example pattern (C#) for clarity:
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath("OlapReport.rpt"));
rpt.SetDatabaseLogon("user","password","OLAPServer","CatalogName");
CrystalReportViewer1.ReportSource = rpt;

Troubleshooting checklist and final notes:

  • Confirm drill‑down works in Designer first. If Designer works but the ASP page does not, focus on credentials/impersonation and which viewer component is used (some older ActiveX viewers do not support OLAP drill behavior).
  • Log IIS errors, test with a minimal OLAP test report, and when asking for more help always state exact Crystal version, viewer version, SQL/Analysis Services version and whether Integrated Security is used. Some replies here suggested alternative tools (, ); try the Designer + logon fixes above before changing platforms.
Member Avatar for kagrawal

Hi Sarala,
I need help regarding calling OLAP reports thru .net 2005, We have reports in Crysatal Report using Essbase OLAP Cubes.. Kindly help me regarding the code. I am new to .net 2005. You can mail me at <EMAIL snipped>.

Thanks
kanak

Member Avatar for venu@baylogic

hai all
Good Morning. I am trying to show a OLAP Report created (using cube in SqlServer 2000) in crystal reports in a asp page. i used smart activex viewer for this but the data alone in the crystal reports r shown. the drill down structure does not appears.

Also after showing the crystal report in asp, if i open the same report in crystal report, it is asking for the password to show the drill down structure if the data in the report is double clicked.

i m having both SQL Server, IIS in my system. i need help regarding this problem . could any one provide me soln immediately. if so i will be so thankful to u.


thank u
sarala

Hi Sarala,
Very Good Morning,I understand your problem here,I am not familiar with this tool,But you can create very nice reports using Actuate tool,This may help you,If possible try to use this tool abd get a result,,,,,,,I wish U all the best....

Hi need your help here,What tools are using for ASP?Any open source tools are available?
Now we are working on text editor only and some reproting tools for reports,,,So can you help me to move with tools.Please remind if you have any tools for ASP.My E-Mail:

Thank you so much
Bye........

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.