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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.