Showing posts with label knows. Show all posts
Showing posts with label knows. Show all posts

Wednesday, March 28, 2012

How to insert an image or logo on the report manager?

Is there anybody who knows how to set up the report manager so that it will display an image on the home page of the report manager?

Thanks!

Report Manger was not built to be customizable by default. The only thing you can do is hack it by overwriting the images or to change the CSS file it uses.

You need to look in "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\" or whatever your installation directory is. In there you will find a "Styles" directory that has the CSS and an "images" directory in which you need to look for the .JPG files that start with 48 e.g. The home page user 48folderopen.jpg by default. Depending on which page you are RS will use a different image. The main downside is that you have no control over sizing so your image needs to 48x48 otherwise it will look distorted.

|||

Adam,

Thx for your response. I want to confirm one thing with you. In order to use my own image, do I have to delete the 48folderopen.jpg file and paste my own image? Please tell me the proper procedure.

Sincerely,

|||

I got the answer.

Wednesday, March 21, 2012

How to include MSDE installation in my apps installation package

Hi all,
Anybody knows how to include MSDE in my apps installation package? I've
downloaded MSDE Deployment Package from
http://www.microsoft.com/downloads/d...e9a7403-c4ba-4
d98-bb0b-2c9d6414071f&DisplayLang=en.
but unfortunatelly:
1) It's for Visual Studio; meanwhile I use InstallShield LE FoxPro
Edition, and;
2) it's a beta product, and Microsoft doesn't approve its use in the
production environment nor use it to deploy any applications.
I'm also considering alternatives to use InnoSetup. Will the solution be
easier if I use Inno?
Looking forward to hearing from all of you!
TIA,
Willianto
Try going to the tools menu in Installshield and go to "Check for updates."
I don't have limited edition of Installshield but this should be there. In
the updates you will find MSDE in there. I believe this will then show up
in your redistributables area and can then add it to your install.
"Willianto" <willianto@.remove-me.telkom-and-me.net> wrote in message
news:%2337B8J6MEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> Anybody knows how to include MSDE in my apps installation package? I've
> downloaded MSDE Deployment Package from
> http://www.microsoft.com/downloads/d...e9a7403-c4ba-4
> d98-bb0b-2c9d6414071f&DisplayLang=en.
> but unfortunatelly:
> 1) It's for Visual Studio; meanwhile I use InstallShield LE FoxPro
> Edition, and;
> 2) it's a beta product, and Microsoft doesn't approve its use in the
> production environment nor use it to deploy any applications.
> I'm also considering alternatives to use InnoSetup. Will the solution be
> easier if I use Inno?
> Looking forward to hearing from all of you!
> TIA,
> Willianto
>
|||Altman:

> Try going to the tools menu in Installshield and go to "Check for
updates."
Hmmm... is there anyway to still have the MSDE in the checklist without
having to update the ISE?
What about InnoSetup?
Regards,
Willianto
"Altman" <NotGiven@.SickOfSpam.com> wrote in message
news:ut8I9WDNEHA.3016@.tk2msftngp13.phx.gbl...
> I don't have limited edition of Installshield but this should be
there. In
> the updates you will find MSDE in there. I believe this will then
show up[vbcol=seagreen]
> in your redistributables area and can then add it to your install.
> "Willianto" <willianto@.remove-me.telkom-and-me.net> wrote in message
> news:%2337B8J6MEHA.3348@.TK2MSFTNGP09.phx.gbl...
I've[vbcol=seagreen]
http://www.microsoft.com/downloads/d...e9a7403-c4ba-4[vbcol=seagreen]
solution be
>
|||I don't think it comes with it, it is a free update to installshield, I
believe it is just a merge module. Otherwise check out this site
http://msdn.microsoft.com/library/de...eddingmsde.asp
"Willianto" <willianto@.remove-me.telkom-and-me.net> wrote in message
news:uwlMliENEHA.3476@.TK2MSFTNGP09.phx.gbl...
> Altman:
> updates."
> Hmmm... is there anyway to still have the MSDE in the checklist without
> having to update the ISE?
> What about InnoSetup?
> Regards,
> Willianto
> "Altman" <NotGiven@.SickOfSpam.com> wrote in message
> news:ut8I9WDNEHA.3016@.tk2msftngp13.phx.gbl...
> there. In
> show up
> I've
> http://www.microsoft.com/downloads/d...e9a7403-c4ba-4
> solution be
>
|||Hi Altman:
Thanks for still being with me
> I don't think it comes with it, it is a free update to installshield,
I
> believe it is just a merge module.
I've found the page where InstallShield put the msm:
http://support.installshield.com/kb/...icleid=Q106295
But it looks like, the msms are for InstallShield Developer 7.0SP3,
8.xx, and DevStudio 9.0. Since I connect to the internet with DUN, I
cannot afford to 'just try todownload and see whether it works with ISE
LT or not'. Can anybody give me a clue whether it works or not?

> Otherwise check out this site
>
http://msdn.microsoft.com/library/de.../en-us/dnsql2k
/html/sql_embeddingmsde.asp
Ok. I've read the article. It is said that I can create my own MSI
package. Okay. That's acceptable. And for that I'm going to need
Microsoft Platform SDK. Okay, I'd check it... and... YIKES!!!!
342,000,000 bytes of download! More than 300 megs! And I connect thru
DUN! Do you have any alternatives?
Willianto
[vbcol=seagreen]
> "Willianto" <willianto@.remove-me.telkom-and-me.net> wrote in message
> news:uwlMliENEHA.3476@.TK2MSFTNGP09.phx.gbl...
without[vbcol=seagreen]
message[vbcol=seagreen]
package?[vbcol=seagreen]
http://www.microsoft.com/downloads/d...e9a7403-c4ba-4[vbcol=seagreen]
FoxPro[vbcol=seagreen]
the
>
|||You can save yourself a lot of wasted time and research by running the
setup.exe that comes with MSDE. You can pass command line arguments to
configure it. The merge modules are buggy. This what MS recommends.
HTH Bill
"Willianto" <willianto@.remove-me.telkom-and-me.net> wrote in message
news:%2337B8J6MEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> Anybody knows how to include MSDE in my apps installation package? I've
> downloaded MSDE Deployment Package from
> http://www.microsoft.com/downloads/d...e9a7403-c4ba-4
> d98-bb0b-2c9d6414071f&DisplayLang=en.
> but unfortunatelly:
> 1) It's for Visual Studio; meanwhile I use InstallShield LE FoxPro
> Edition, and;
> 2) it's a beta product, and Microsoft doesn't approve its use in the
> production environment nor use it to deploy any applications.
> I'm also considering alternatives to use InnoSetup. Will the solution be
> easier if I use Inno?
> Looking forward to hearing from all of you!
> TIA,
> Willianto
>
|||Bill:
> You can save yourself a lot of wasted time and research by running the
> setup.exe that comes with MSDE. You can pass command line arguments to
> configure it. The merge modules are buggy. This what MS recommends.

Looks like that's the only way to go...
Thank you. And thanks to you too, Altman.
I've been expecting too much from M$ freebies
Regards,
Willianto

Friday, March 9, 2012

How to Import and Export CSV File

Hi frnz ,

i want to know how to import a CSV File and export CSV File From database SQLSERVER-2005 Using ASP.NET With C#

IF any one knows Help me

Vinnu

http://www.codeproject.com/aspnet/ImportExportCSV.asp

How to import a bunch of files?

I have a large number of text files that I want to import into a database. I
have created a DTS package that knows how to import and transform the data
so that it can be imported but that seems to be hard coded to a particular
file. Doing this by hand 18 thousand times is not something I want to do. Is
there a command line interface that I can call from either DOS or WSH to
import all of this data? I'm thinking that something like
for %%f in (*.txt) do <import %%f>
would be great. Anyone have a suggestion on how this could be done?
Richard Lewis Haggard
Looping, Importing and Archiving
http://www.sqldts.com/default.aspx?246
For SQL2005 you can use the ForEach Loop file enumerator
Looping over files with the Foreach Loop
http://www.sqlis.com/default.aspx?55
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Richard Lewis Haggard" <HaggardAtWorldDotStdDotCom> wrote in message
news:eYhbjZf%23FHA.1032@.TK2MSFTNGP09.phx.gbl...
>I have a large number of text files that I want to import into a database.
>I have created a DTS package that knows how to import and transform the
>data so that it can be imported but that seems to be hard coded to a
>particular file. Doing this by hand 18 thousand times is not something I
>want to do. Is there a command line interface that I can call from either
>DOS or WSH to import all of this data? I'm thinking that something like
> for %%f in (*.txt) do <import %%f>
> would be great. Anyone have a suggestion on how this could be done?
> --
> Richard Lewis Haggard
>
|||I ended up doing it with a dtsrun package called from a pair of batch files.
In this case, c:\StockWizPro98\OUTPUT is the destination directory that
receives periodic updates and data drops. I decided to make a temp directory
that will have a single file in it and to create a DTS package that knows
how to import data from it. The
first batch file iterates through all of the input files, copies and renames
them to what the DTS package is looking for and calls the package to import
the data. Simple.
1.bat
pushd c:\StockWizPro98\OUTPUT
for %%f in (*.txt) do call 2 %%f
popd
2.bat
pushd c:\StockWizPro98\OUTPUT\temp
copy /y ..\%1 temp.txt
dtsrun /s (local) /n StockImport /e
popd
Richard Lewis Haggard
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:%23aBh2ff%23FHA.740@.TK2MSFTNGP12.phx.gbl...
> Looping, Importing and Archiving
> http://www.sqldts.com/default.aspx?246
> For SQL2005 you can use the ForEach Loop file enumerator
> Looping over files with the Foreach Loop
> http://www.sqlis.com/default.aspx?55
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Richard Lewis Haggard" <HaggardAtWorldDotStdDotCom> wrote in message
> news:eYhbjZf%23FHA.1032@.TK2MSFTNGP09.phx.gbl...
>