Showing posts with label click. Show all posts
Showing posts with label click. Show all posts

Friday, March 30, 2012

IME?

"Derived column transformation editor"

drag and drop a column into the bottom pane

right click on the 'expression' column and it has a menu item called "open IME"

but nothing happens when I do it.

Is it an expression editor?

Strategic thinking:

Microsoft BI

Reporting Services Expression language: VB.net

Integration Services Expression language: "similar to the syntax that the C and C# languages use"

great! Smile

IME - Microsoft Global Input Method Editors (IMEs) - http://www.microsoft.com/windows/ie/ie6/downloads/recommended/ime/default.mspx

It is nothing to do with SSIS, it is just an option that Windows can provide for text boxes. There is no expression editor available for derived columns, just that free entry text box.

As for the new SSIS expression syntax, yes it is a bit annoying it is yet another syntax, but the benefit is that it is very fast and baked into SSIS. Anything else would not be as fast, and in ETL that counts.

sql

Monday, March 26, 2012

Image without code!

Is it possible to insert a image in SQL Management Studio without use codes?

Like you search the image with a explorer window, click on it and... done!

The short answer is No.

Now it might be possible to visit a website that handles images for you -but it will be using SQL Code behind the scenes to SELECT/INSERT images for the browser.

|||As Arnie referred you have to depend upon the code to perform this, may be with a VBscript or any .NET script to attach that image.

Friday, March 23, 2012

Image not showing Up

When a build a report in vs.net and click the preview tab, the images show up correctly on the report output. But after I deploy the report to the reportserver and view the report, the images do no show up. Just the outline where the images should be. Do
you have any suggestions as to why the images are not showing up? Thanks.
Joe S.
If this is in a web browser, and you right-click the image and hit
properties, what is the URL that is given? Have you deployed the images to
that location?
http://www.aspfaq.com/
(Reverse address to reply.)
"Joe S." <JoeS@.discussions.microsoft.com> wrote in message
news:3BD15438-CF3F-414B-A743-BC75F106EAF4@.microsoft.com...
> When a build a report in vs.net and click the preview tab, the images show
up correctly on the report output. But after I deploy the report to the
reportserver and view the report, the images do no show up. Just the outline
where the images should be. Do you have any suggestions as to why the images
are not showing up? Thanks.
> --
> Joe S.

Image not showing Up

When a build a report in vs.net and click the preview tab, the images show u
p correctly on the report output. But after I deploy the report to the repor
tserver and view the report, the images do no show up. Just the outline wher
e the images should be. Do
you have any suggestions as to why the images are not showing up? Thanks.
--
Joe S.If this is in a web browser, and you right-click the image and hit
properties, what is the URL that is given? Have you deployed the images to
that location?
http://www.aspfaq.com/
(Reverse address to reply.)
"Joe S." <JoeS@.discussions.microsoft.com> wrote in message
news:3BD15438-CF3F-414B-A743-BC75F106EAF4@.microsoft.com...
> When a build a report in vs.net and click the preview tab, the images show
up correctly on the report output. But after I deploy the report to the
reportserver and view the report, the images do no show up. Just the outline
where the images should be. Do you have any suggestions as to why the images
are not showing up? Thanks.
> --
> Joe S.

Wednesday, March 7, 2012

IIS 405 Resource Not Allowed

I have several Reports that when I Click on the "View Report" button I
receive a 405 Resource Not Allowed Error. I have re-installed Report Server
and updated to Service pack 2 for Reporting services, with no change in the
outcome.
The Initial load of each of these reports works fine, however when I change
the condition dropdowns or "View Report" I recieve this error.
The problem first started when the Default Directory under IIS was
accidentially deleted and then re-created.
Any assistance would be appreciatedHello,
Go to IIS, right click on your web server, click on configuration button, go
to .aspx -->Edit
and be shure that on the verbs section you have the POST
hope this can help you|||rectification about my previous post:
under IIS go to the virtual folder "ReportServer" , click on the
"configuration" button .
Under the "App Mappings" tab look if you have the extension *, if it's not
the case you have to click "Add" and browse on the "Executable" field to find
aspnet_isapi.dll (c:\winnt\Microsoft.Net\framework\v1.1.4322).
On "Extension" field write * and on the verb section select "All verbs"
And that's it|||This is valid only for IIS 5.
Under IIS 6 you must insert
"c:\windows\microsoft.net\framework\v1.1.4322\aspnet_isapi.dll" filter under
"WillCard application Maps".
Bye.
"Wjm" wrote:
> rectification about my previous post:
> under IIS go to the virtual folder "ReportServer" , click on the
> "configuration" button .
> Under the "App Mappings" tab look if you have the extension *, if it's not
> the case you have to click "Add" and browse on the "Executable" field to find
> aspnet_isapi.dll (c:\winnt\Microsoft.Net\framework\v1.1.4322).
> On "Extension" field write * and on the verb section select "All verbs"
> And that's it