suni - Developer IT

Display Parameter(Multi-value) in Report

- by suni

Hi, Can anyone tell me how to display all the selected value of my multi value parameter in SSRS report. When giving parameter.value option it gives error. Thanks in advance. Suni

Why AQTime slows execution even when profiling is not on, and can anything be done for it?

Hi! In AQTime for Delphi, it boasts to be very fast to get to the trouble spots by using areas and triggers etc. But it seems to me, that especially if you have very much code in the areas to profile, then the execution slows down dramatically even when the profiling is NOT on. For example, if I want to profile a specific routine late in the program flow, but don't know what is called there, I'd think to put this routine only as a trigger and the initial status for threads as Off, and then choose "Full check by Routines/Lines". However, when I do this, the program execution slows down heavily already before the trigger routine has ever been hit. For example if the "preparation flow" takes around 5 minutes without AQTime, then when I run it with profiling disabled, it already has been running for 30 minutes and still goes even when I know the trigger has not yet even been reached. I know I can try to workaround this by reducing the amount of routines/lines profiled, but it is not really a good solution for me, since I'd like to profile all of them once I get to the actual trigger routine. Also another, often better workaround is to start the application without AQTime and then use Attach to Process after the "preparation flow" has finished, but this works well only when the execution pauses in GUI in the proper place or otherwise provides a suitable time frame for doing the attaching. In all cases this is not the case. Any comments on why this is so and is there anything else to do than just try to reduce the code from the areas or attach later to the process?

Read the article

I need Help to customise the error message in SSRS

- by suni

I have SSRS REport accessing from Report Server. Is there any way i can give an error message of my own, if my report is failing to open there.

Read the article

ora-00939 error in reporting services, SSRS

- by san

Hi, I have an SSRS report , Oracle is my backend and am using this following query for dataset of my second parameter. select distinct X from v_stf_sec_user_staffing_center usc where usc.center_group_id in ( select distinct center_group_id from V_T_STAFFING_CENTER_GROUP scg where INSTR(','||REPLACE(:PI_REGION_LIST,' ')||',', ','||scg.group_abbreviation||',') 0) and usc.nt_user_name=:PI_NT_USER_NAME Here PI_REGION_LIST is a multivalued parameter of string type. and PI_NT_USER_NAME is a default string valued parameter this query works fine when i try to execute in manulally in the Data tab , also in the Oracle tool. But when i run the report in SSRS and select more than 3 values for the parameter PI_REGION_LIST the report throws an error on this dataset, ora-00939 error,too many arguments for function. I am not able to figure out the error here. Please help me with an idea. Thanks in advance, Suni.

Read the article

Centering images php

- by peak

I'm trying to center an image in php. I'm currently using this line of code echo '<img src="newimage.jpg" width="110" height="120" class="centre">'; However, this seems to have no effect. I've also tried using something like this, img.center { display: block; margin-left: auto; margin-right: auto; } <img src="newimage.jpg" alt="Suni" class="center" /> but this merely gives me a syntax error, how do I go about fixing this? Thanks

Developer IT