Showing posts with label field. Show all posts
Showing posts with label field. Show all posts

Friday, March 30, 2012

I don't want my cube to sort my measures and dimensions alphabetically

My cube has multiple measures and dimensions, and I want them to show in the field list of my pivot table in a specific order. However, when I preview them in BI Development Studio Browser, it automatically sorts in alphabetical. I don't want Analysis Service to reorder my measures and dimensions. Is there a way to diable the sorting feature of SSAS?

I'm afraid it's not possible:(. Oledb specification explicitly states that measure schema rowset (same true for dimensions) are sorted by name.

http://msdn2.microsoft.com/es-es/library/ms126250.aspx

You can try (and I have not tries this approach myself) to name dimensions and measures so, the form a specific order and give captions that are what you want your user to see. The more I think about this approach the less I like it.

Wednesday, March 28, 2012

I don't understand why is nothing is always evaluated to false

The following in one textbox of my report is always evaluated to false when the field package_pack_value and give an error in the str conversion function that follow saying the 'number' is nothing.


= iif ( Fields!Package_Pack_Value is Nothing, "<Null>", Str ( Fields!Package_Pack_Value.Value ) & " " & Fields!Package_Pack_Unit.Value )

I have read all the forum and search a whole day but nothing...

Maybe is the answer very stupid...

If anyone can help me it would be appreciatedCStr to convert
And try this
ISNULL(Fields!Package_Pack_Value)
|||IsNull is not defined in the Micorsoft.VisualBasic namespace and it give compiling error tryng to use it.

But you give me a part of the answer using CStr :


= iif ( CSTR(Fields!Package_Pack_Value.Value) = "", "<null>", CStr ( Fields!Package_Pack_Value.Value ) & " " & Fields!Package_Pack_Unit.Value )

This give well "<null>" when Fields!Package_Pack_Unit.Value is null.

Thank To you VectorR3|||

You need to use IsNothing(). We convert nulls to empty objects. Does this not work?

=iif ( IsNothing(Fields!Package_Pack_Value.Value), "<null>", CStr ( Fields!Package_Pack_Value.Value ) & " " & Fields!Package_Pack_Unit.Value )

sql

I don't suppose BULK UPDATE exists?... like BULK INSERT?

I have to update a field within a table of 60 records or so. Each record has a different field value. it's type varchar. i was given an excel file with the field values and was thinking of a bulk update like bulk insert, but i don't recall that it's possible that way.

Is the only way to create a table, bulk insert, then merge the two tables together with UPDATE?

Just wanted to see if there was an easier way to do it, otherwise i'll take the latter route. Thanks!

You'll need to bulk insert into a work table, then do the update.

Unfortunately (or maybe, fortunately ) there's not Bulk Update.

Or, you could do the processing with SSIS....

Friday, March 9, 2012

I am Having an Odd Problem with Exporting to Excel.

The background:
Before I get into my error let me give you some background in what I am
required to do. All the text field parameters must be stored in the
database. What I mean by this is every text box's value, background
colour, font(weight, size and etc), TextAlign and TextDecoration
information is stored in the database. This includes the fields for
headers and footers. To get these parameters to work properly in
headers and footers I have set up report parameters that get the data
from the database and then feed it to the text fields inside the header
or footer.
The problem:
I am currently getting the following error while trying to export to
Excel:
--
Microsoft Internet Explorer
--
Internet Explorer cannot download Format=EXCEL from SERVERNAME.
Internet Explorer was not able to open this Internet site. The
requested site is either unavailable or cannot be found. Please try
again later.
--
OK
--
After some investigation I discovered that the appearance property
"TextAlign" for all footers is causing this error. So, if I put in
"Left", "Right" or "Center" text directly into the
"TextAlign" field for all the footer text boxes the report exports
into Excel properly. But if I use the property from the database it
will not load into Excel. I've checked to make sure the database
field is giving a valid value. In fact, I've tried all 3 values and
had no luck. I've also tried other TextAlign parameters from
different text fields on the report and received the same error as
stated above.
What I find odd about this is the fact it works fine for all the other
properties but TextAlign. Could this be an obscure bug?
Another thing to note is in Excel I can see the header all the time;
but, I can only see the footer when I am in print preview. Is there a
way to have the footer set up just like the header; so, it is just on
bottom of the page instead of being a "true" footer. It wouldn't
be a pretty way to solve my issue but I think it would at least allow
my clients to use Excel export for now.Oh I am using SQL Server 2000 Reporing Services with SP2.|||Hello!
I have encountered the same problem with export to Excel ("Internet Explorer
cannot download Format=EXCEL from SERVERNAME."). In my case the solution was
simple. I've had just to make the name of the report shorter. You can simply
upload your rdl under another (shorter) name to report manager and it will
possibly start working.
"Jeremy Balliston" wrote:
> Oh I am using SQL Server 2000 Reporing Services with SP2.
>|||Any ideas?

Friday, February 24, 2012

hyperlinks

Hi
I just upsized a database from Access to SQL everything seems to be working
fine except I had a Hyperlink field in Access which is not working with the
SQL tables and I see no data type in SQL for hyperlinks. Is there a way
around this?
Any help with the will be greatly appreciated
ChuckHyperlinks are only text, so a simple varchar datatype does it. SQL Server d
oesn't come with a
front-end development tool, which is where the interpretation of this text (
that it is an URL and
should be treated as such) takes place. I suggest you post this in a newsgro
up for the front-end dev
tool you are using.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chuck216" <cigar216@.hotmail.com> wrote in message
news:ED93A6D4-11DB-43C0-ADEE-847722151619@.microsoft.com...
> Hi
> I just upsized a database from Access to SQL everything seems to be worki
ng
> fine except I had a Hyperlink field in Access which is not working with th
e
> SQL tables and I see no data type in SQL for hyperlinks. Is there a way
> around this?
>
> Any help with the will be greatly appreciated
> Chuck
>

hyperlinks

Hi
I just upsized a database from Access to SQL everything seems to be working
fine except I had a Hyperlink field in Access which is not working with the
SQL tables and I see no data type in SQL for hyperlinks. Is there a way
around this?
Any help with the will be greatly appreciated
ChuckHyperlinks are only text, so a simple varchar datatype does it. SQL Server doesn't come with a
front-end development tool, which is where the interpretation of this text (that it is an URL and
should be treated as such) takes place. I suggest you post this in a newsgroup for the front-end dev
tool you are using.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chuck216" <cigar216@.hotmail.com> wrote in message
news:ED93A6D4-11DB-43C0-ADEE-847722151619@.microsoft.com...
> Hi
> I just upsized a database from Access to SQL everything seems to be working
> fine except I had a Hyperlink field in Access which is not working with the
> SQL tables and I see no data type in SQL for hyperlinks. Is there a way
> around this?
>
> Any help with the will be greatly appreciated
> Chuck
>

Hyperlink to open in a new blank window.

A field in one of my reports has the navigation property jump to a url, which is a Word document on our server. The problem is the Word file opens up in the existing frame of our website, instead of opening a new frame. In the past I have used _blank. Where do I place this in Visual Studio 2003 to perform this action with Reporting Services?
Thanks for your help.

Hi
it seems that you are trying to open Document in new window so here is the line to be used in Jump to Url Textbox
="javascript:void(window.open('http://www.google.com','_blank'))" this will popup google.com in new page.
if you are picking the url from database you can use this
="javascript:void(window.open('" & Fields!URL.Value &"','_blank'))"
is this you are trying to do?
Thanks
Rohit|||

Yes, that is what I'm trying to accomplish, except it doesn't work. I copy and paste the following into Reporting Services:
Advanced TextBox Properties>Navigation>Hyperlink Action:>Jump to URL:
="javascript:void(window.open('" & Fields!MyLink.Value &"','_blank'))"
I get-->
javascript:void(window.open('" & Fields!MyLink.Value &"','_blank'))" in the URL

I'm using Windows 2000 Server, SQLServer2000, and IE 6.0.29 with all service packs installed.

|||Hi,
That means you need to Install Hotfix for SQL Server 2000 Reporting Services SP2 and make sure you already have installed Reporting Services SP2, The hot fix setup will not run on computer unless you have SP2 Installed on your computer.
Here is the Link for both
http://www.microsoft.com/downloads/details.aspx?FamilyID=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en

Thanks
Rohit
|||

I pulled one Report (RDl) on IE

For Example:-

I am havingtestreport.rdl file

I am giving another reporti.e testreport2.rdl in JUMP to URL box intestreport.rdl file

I opened the below linkwith testreport.rdl

http://localhost/reportserver/testreport

I Clicked oneone item ontestreport.rdl

I got Result on samewindow(OPENED IE) , But I want result on New Window(I have to open New Window for Sub report )

I got solution with Reporting Services SP2 package with SQL2000.RS-KB901383-v8.00.1042.00-ENGHotFix using this statement injumptoURL(

="javascript:void(window.open('http://localhost/reportserver/testreport2,'_blank'))"

But I want onlywith SQLserver2000 Reporting services only with out SP2 Package

Can u please helpme

With

Regards

Battula

|||

Hi

I'm not sure if we can use javascript to open new window without installing HotFix

but after the installation we can open report in new window with parameters thru Jump To URL like this

="javascript:void(window.open('http://localhost/reportserver?/testReport/ReportName&rs:Command=Render&Parameter1=" & Fields!Parameter1.Value & "','_blank'))"

Thanx

|||

Iam able to open new window but not able to see any text to identify that the link is present. Any idea on this.

i have to very hardly hover in the reprot to find where the link is located.

|||You would not put the link in the expression for the pop up. The expression for the field should be normal I.E. =Fields!some_value.Value or some hard coded value, the text should appear and when using the jump to URL should pop open your window. If you are still not seeing anything check your formatting, perhaps its the same color as the background, sillier things are known to happen in developing!

hyperlink to a blob field

I want to populate a field (A BLOB maybe?) with a html page that I have generated. I would like to be able to set a hyperlink to this field so users can see it by clicking on the link. Is it possible?
-RichYes you can by using XML.

hyperlink open new window

I have a link on my report which open new window. The code i have in advance properties of that field is :

="javascriptt:void(window.open('http://www.msn.com','_blank'))" (note: the extra "t" is intentionally added in the code, coz website block the keyword "java.....t")

It works great on testing server but it doesn't work on production server. Both testing and production servers run windows 2003 server and service pack 2 for reporting services.

Reports accessing form production server, when i click on report it opens up new window with address in address bar :

javascript:void(window.open('http://www.msn.com','_blank')) with "The page cannot be displayed" message. But if i open a new internet explorer window and copy past the same address in address bar then its open up www.msn.com. To test the production server behavior I created a test web page test.htm and added the java script to open new window, it works fine.

Any help would be much appreciated.

Ive had problems with this too!
I found it only works when you access the report via a URL such as
http://reportserver/reportserver?report
Rather than through the Report Manager:
http://reportserver/reports
Through the Report Manager I saw the same behaiviour "The page cannot be displayed" message but copying and pasting worked :S
Although Im not surew this is your problem as it works on your tst server, but not prod
Hope this helps
Al

Hyperlink on a report to download a file

I have an XML field (of type XML) in my report's underlying table. I want to
display a hyperlink in my report. When the user clicks on this hyperlink, I
want them to be able to save the xml value as an XML file on disk (i.e.
"Save File As" in MSIE). Has anyone tried this?
Thank you,
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.comYou might be able to use javascript to make it open the file in a new
window.|||Any luck on getting this to work? I'm trying to do the same thing but can't
find any way to do it.|||Nope. I even reposted with the subject "XML field content to be downloaded
as a file" in case my first post wasn't clear enough. But no luck.
I'll keep watching and/or post the answer if I ever figure out a way of
doing it.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Elliott" <Elliott@.discussions.microsoft.com> wrote in message
news:A0650A48-7DAB-42AE-A300-8A9DA17E5401@.microsoft.com...
> Any luck on getting this to work? I'm trying to do the same thing but
> can't
> find any way to do it.
>|||This is the closest possible solution I've found so far and it's from a
Microsoft employee:
http://tinyurl.com/2gs6sp
Basically you'd just have to create a separate web page/site that serves up
the file/xml from a hyperlink in the report. Not quite as easy has getting
it right out of the report directly, but it's definitely doable for my
project.
I'd be happy enough if the report would let me just display the xml with an
associated xsl file.|||Displaying the XML content on your report is pretty easy. Just put the
field's value in a gird like you would any other field type (char, int,
float, etc.). It's just that the cell containing the XML gets pretty big.
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Elliott" <Elliott@.discussions.microsoft.com> wrote in message
news:3EE4182B-7C2C-4A37-A71F-F007DE1D6A5C@.microsoft.com...
> This is the closest possible solution I've found so far and it's from a
> Microsoft employee:
> http://tinyurl.com/2gs6sp
> Basically you'd just have to create a separate web page/site that serves
> up
> the file/xml from a hyperlink in the report. Not quite as easy has
> getting
> it right out of the report directly, but it's definitely doable for my
> project.
> I'd be happy enough if the report would let me just display the xml with
> an
> associated xsl file.|||Yeah, I realized I could do that. However I need mine formatted for the
users; I didn't want them to see the raw xml. If they could download it
directly from the report and open it in IE (which is default), then they'd
see it formatted like a webpage since the xml references an xsl file. That
would have been my preference.
Anyway, I took Chris Hays' advice and implemented a small ASP.NET site that
serves up the xml file with the xsl. It was pretty painless and took about
an hour.

hyperlink fields

Hello fellows,
Is it possible to make a hyperlink field like we can do in MS Access?
If it is possible then how can I do it? Any suggestions please? Thankx
in advance.
Geri
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!I am not aware of MS Access thing.. can you explain this feature..be able to
relate that and find out what we can do in sql server..
Av.
http://dotnetjunkies.com/WebLog/avnrao
http://www28.brinkster.com/avdotnet
"Geri Gavertz" <gerific@.yahoo.com> wrote in message
news:ub3dAk7HFHA.1392@.TK2MSFTNGP10.phx.gbl...
> Hello fellows,
> Is it possible to make a hyperlink field like we can do in MS Access?
> If it is possible then how can I do it? Any suggestions please? Thankx
> in advance.
> Geri
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Geri Gavertz wrote:
> Hello fellows,
> Is it possible to make a hyperlink field like we can do in MS
> Access? If it is possible then how can I do it? Any suggestions
> please? Thankx in advance.
> Geri
That sounds like a front-end feature. The URL itself is just a character
string. SQL Server doesn't do anything with the data, 'cept store it.
You could put the URL in a varchar(255).
Where are you looking to use the URL?
David Gugick
Imceda Software
www.imceda.com

Sunday, February 19, 2012

hyperlink

Hi
I am trying to add a hyperlink to the table column so that it opens as an email ..that is
if user clicks onxyz@.X.com field the email should open with this addr in the to box.Any suggestions..
ThanksYou could use a template column:
<asp:TemplateColumn HeaderText="email" ItemStyle-Width="40" HeaderStyle-HorizontalAlign="center" ItemStyle-HorizontalAlign="center">
<ItemTemplate>
<a href="http://links.10026.com/?link=mailto:<%#DataBinder.Eval(Container.DataItem, "email").ToString()%>"><%#DataBinder.Eval(Container.DataItem, "email").ToString()%></a>
</ItemTemplate>
</asp:TemplateColumn>|||If you are trying to add hyperLink in SRServices then its very simple u can do that
In the layout mode click on the cell where to use MailTo and press F4 to open properties, go down and click on Action property and click...
and select Jump to URL radio button and in the text box write="mailto:" & Fields!Customer_Email.Value.
i think that is what u want
Thanks
RohitSmile [:)]