Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: angi
  • Order by date
  1. angi

    Parameters reset in SharePoint Integrated Mode

    When running a report in SharePoint Integrated Mode, clicking the Apply button to run the report doesn't do anything except reset some of my parameter fields. The report does not run; no request is sent to my SQL server. I've searched many forums to see what causes this and have come up empty...
  2. angi

    Capture SQL

    In SQL Reporting Services, is there a way to capture the exact SQL that is run for a user's report? This would help with troubleshooting long-running reports. I know that we can capture the parameters, but it would be nice to capture the final SQL query after the parameters have been inserted...
  3. angi

    Date Range Prompts

    Is there an elegant way to tie two date prompts together to create a single date range prompt. For example, I have a Low Date prompt and a High Date prompt that are fed into a stored procedure that contains "ActivityDate between @LowDate and @HighDate". How do I make the Low Date and High Date...
  4. angi

    Security Filter Causes Incorrect SQL

    I've got a strange situation with a report that I have created. Under my login which does not have any security filters, the sql for the report is correct: select a11.SBU SBU, a11.Company Company, a11.ReservationCarrier ReservationCarrier, a11.ReservationOrigin ReservationOrigin...
  5. angi

    Idle a Project During Warehouse Build

    I am trying to determine how to idle a project during the warehouse build so that users are not able to run reports until the build is completed. Here is our setup: Server A: MicroStrategy Intelligence Server (incl Metadata) Server B: MicroStrategy Web Server Server C: Warehouse SQL Server...
  6. angi

    Wish List

    1. Desired Enhancement: The ability to see the answers that were given to each prompt of a prompted report on the "Wait" page while the report is being generated. This would be very similar to what is seen on the Report Details page after a report has run. Benefit: In the event...
  7. angi

    Export Timeout

    Can someone give me some pointers on how to get around timing out when exporting reports? I am trying to export a report with 4000 rows by 34 columns (22 attribute and 12 metric columns) and I continually receive an ASP timeout after about 5 minutes. I have looked through MicroStrategy's...
  8. angi

    Canceling a Report Request

    I was wondering if anyone knows if the following is possible, either via a Web preference or via .asp page modifications. When a user executes a prompted report and receives the "Wait" page, they have the option to select the "Cancel this request" button. If they select...
  9. angi

    Cross Joins with Multiple Fact Tables

    We have a hierarchical database containing the following: Res_Summary ------------------------ ReservationKey (Key) TourOperator SBU Company ReservationCarrier ReservationOrigin ReservationDestination ReservationDepartureDate ContactName AirSales LandSales Res_Air_Detail...

Part and Inventory Search

Back
Top