Currency in Analysis Services

Hi,

All the reports with comes out as $ (ex.) ( $123,437,00) I am working for the requirement that the same report has to show in multiple currency (ex.) ($,Yen,Pound,AUS$ ).As i am in Analysis Side can anyone give good Suggestion to get the output. Do any one faced the same?

Take a look at the following entry on Mosha's Blogsite:

http://sqljunkies.com/WebLog/mosha/archive/2005/10/13/mdx_format_currency.aspx

HTH,

Steve

Currency Formats

Is there any dynamic way through Reporting Services where you can use
different currency formats on reports? For example, we want to be able to
display in US dollars and /or Euros.Change the language property for the desired text box to English - Irish (or
whatever) and change the format to currency. btw the character code for Euro
is ALT-0128.
"nscotia17" wrote:
> Is there any dynamic way through Reporting Services where you can use
> different currency formats on reports? For example, we want to be able to
> display in US dollars and /or Euros.|||You can also hide and display fields, rows, groups based upon a visiblitiy
expression to match whatever idetifies your currency as â?¬ or $ in your data.
"nscotia17" wrote:
> Is there any dynamic way through Reporting Services where you can use
> different currency formats on reports? For example, we want to be able to
> display in US dollars and /or Euros.

Currency format when exporting to excel

Hi,

I have a problem with the number format when i export my reports to excel with Reporting Services. I set numbers as currency with the command FormatCurrency() in visual studio, but when i export the report to excel, the numbers are considered as text.

Does anyone have a solution?
Thanks in advance.

Use the Format property on the cell/textbox, for currency the format string should be c<number decimal places>, i.e. c0 prints the currency figure with no decimal places. Once you have done this, remove the FormatCurrency() function from the expression as it overrides anything you have in the Format property. The reason the FormatCurrency() does not work when exporting to Excel is because its return value is a string, so Excel is confused - is it a currency or is it a string?

|||Thanks a lot, it works perfectly!!!! I'm so releaved

Currency Exporting to Excel

Hi,
In one of my reports I have some fields that are currency fields displayed
with the currency format string (C). However, when I export these to Excel
(2003) I get the little yellow warning that says Number stored as text. And
if I try to do a sum by dragging across the cells and clicking the sigma
button at the top, it causes it to put an odd formula in the top row.
Is there an easy fix so that #'s exported as currency remain tied to excel
as currency?
Thanks,
ChrisI tried this on a matrix in RS2005 and it worked OK.
The format was c0. I do remember it being an issue in 2000. I don't
think there was a way round it in the report definition.
The only thing you could try is, in Excel, highlight the column and
format the cell to currency. If this works you will be able to do a SUM.
Cheers
Chris
Chris Taylor wrote:
> Hi,
> In one of my reports I have some fields that are currency fields
> displayed with the currency format string (C). However, when I
> export these to Excel (2003) I get the little yellow warning that
> says Number stored as text. And if I try to do a sum by dragging
> across the cells and clicking the sigma button at the top, it causes
> it to put an odd formula in the top row.
> Is there an easy fix so that #'s exported as currency remain tied to
> excel as currency?
> Thanks,
> Chris|||Tried formatting C0, stlil getting the text formatted as #.
MS any insight on this?
"Chris" <mr.mcgoo@.gmail.com> wrote in message
news:uPH9wVvQGHA.2704@.TK2MSFTNGP15.phx.gbl...
>I tried this on a matrix in RS2005 and it worked OK.
> The format was c0. I do remember it being an issue in 2000. I don't
> think there was a way round it in the report definition.
> The only thing you could try is, in Excel, highlight the column and
> format the cell to currency. If this works you will be able to do a SUM.
> Cheers
> Chris
>
> Chris Taylor wrote:
>> Hi,
>> In one of my reports I have some fields that are currency fields
>> displayed with the currency format string (C). However, when I
>> export these to Excel (2003) I get the little yellow warning that
>> says Number stored as text. And if I try to do a sum by dragging
>> across the cells and clicking the sigma button at the top, it causes
>> it to put an odd formula in the top row.
>> Is there an easy fix so that #'s exported as currency remain tied to
>> excel as currency?
>> Thanks,
>> Chris
>
> --
>|||Hi Chris,
Please modify the column width in Excel. I have tested in my side on RS
2005, it works fine.
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Nope. I just tried this; both FormatCurrency and Format c0 send a
number as text, causing Excel to just put a Smart Tag on it and ignore
it in functions. I know that converting numbers to text is the entire
purpose of those two functions, but making them the sole means of
formatting numbers makes the Excel export function about as useless as
nipples on the Batsuit.
Wei Lu: I think Chris Taylor means "text formatted as number" and not
"the column's too narrow, so Excel puts in pound signs to tell you to
resize the column."

Currency Conversions

Hi,

All our reports gives the revenues in $ now we are planning to get the same result in various currencys.Can any one tell me How to use One-to-many & Many-to-many options?

Thanks in Advance.

Some information for you to implement currency conversion in Analysis Services.

http://msdn2.microsoft.com/en-us/library/ms175660.aspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

currency

How do i change the currency in visual studio for my reports. US is the only
one available.
any ideas?Not sure what you mean by changing the currency. During runtime, the Report
Server picks up the regional setting from the calling thread
(Accept-language HTTP header) and will format your currency accordingly. The
only thing that you need to do on your part is to use a neutral format
specifier - "C".
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"anon" <anon@.anon.com> wrote in message
news:e8yZ0gS5FHA.4012@.TK2MSFTNGP14.phx.gbl...
> How do i change the currency in visual studio for my reports. US is the
> only one available.
> any ideas?
>

Cubes in Report manager?

Can OLAP cubes be stored on report manager aswel as reporting services reports?
Many thanks
GregNot sure what you mean. Cubes can be data sources for reporting services.
You can have a shared data connection stored in reporting services, and that
data source can be analysis services. Is that what you're asking?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:B38B7CC1-7390-4807-8A76-E928B2046044@.microsoft.com...
> Can OLAP cubes be stored on report manager aswel as reporting services
> reports?
> Many thanks
>
> Greg|||He might be asking about local cubes. You could store the .cub file in RS
but the server wouldn't know anything special about it. I don't think the AS
engine would be able to load it either.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:u5rQ3%23F5EHA.1408@.TK2MSFTNGP10.phx.gbl...
> Not sure what you mean. Cubes can be data sources for reporting services.
> You can have a shared data connection stored in reporting services, and
> that data source can be analysis services. Is that what you're asking?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Greg" <Greg@.discussions.microsoft.com> wrote in message
> news:B38B7CC1-7390-4807-8A76-E928B2046044@.microsoft.com...
>> Can OLAP cubes be stored on report manager aswel as reporting services
>> reports?
>> Many thanks
>>
>> Greg
>

CSV output sql server 2000

Hi,
I have a bunch of stored procedures (some using temp tables) which give
out tables which are then used in crystal to give out reports. These
stored procs are run dynamically depending on values users select on
forms
Some people instead of reports want Comma Seperated Files (CSVs). I am
trying to find a good way of outputting to csv with using either sql
server or ASP. I tried two ways but none of them were ideal
1st method
first way i tried was creating a record set in asp and then using the
following to output the data in a comma delimited row and writing to
file.
Response.Write RecordSet.GetString(,,", ",vbCrLf,"")
The problem with the above was with data sets greater than 10,000
records the processing time increases exponentially because of memory
usage ( i found other people with the same problem)
So i tried the following
2nd method
I used bcp using the master.dbo.xp_cmdshell command to output the
csv. The problem with that is that the bcp executes the stored proc
three times and also doesnot give out column headers. So i had to run
the stored proc once in ASP and get the headers from the record set and
store it to a text file and then run the stored proc in bcp and send
the output to a csv file. Then merge the two files into a third file.
The problem with this method is that it takes around 4 times as long to
run as just the stored proceedure and also i have to create 3 files
instead of one.
I would appreciate any suggestions you have to output the csv from a
stored proc in sql server. Note users have to do this dynamically when
they submit a form so cant use the query analyzer or enterprise manager
tools.
Thanks for your time and help
:)You can use the OSQL utility in order to create a file with or without
headers (you can control the behavior of the headers with the -h
switch). Another tool that you can use is DTS package and run it with
DTSRun utility. Also I would not run the tools in a stored procedure
with xp_cmdshell, because this is a huge security problem. By working
this way you give the user a way to run there own scripts and command
on the operating system level with the privileges of the account that
runs SQL Server's service. Since you are working with ASP anyway, it
is better to run the OSQL (or if you choose a different utility, then
the other utility) from the ASP code and not from a stored procedure.
Adi
Katie wrote:
> Hi,
> I have a bunch of stored procedures (some using temp tables) which give
> out tables which are then used in crystal to give out reports. These
> stored procs are run dynamically depending on values users select on
> forms
> Some people instead of reports want Comma Seperated Files (CSVs). I am
> trying to find a good way of outputting to csv with using either sql
> server or ASP. I tried two ways but none of them were ideal
> 1st method
> first way i tried was creating a record set in asp and then using the
> following to output the data in a comma delimited row and writing to
> file.
> Response.Write RecordSet.GetString(,,", ",vbCrLf,"")
> The problem with the above was with data sets greater than 10,000
> records the processing time increases exponentially because of memory
> usage ( i found other people with the same problem)
> So i tried the following
> 2nd method
> I used bcp using the master.dbo.xp_cmdshell command to output the
> csv. The problem with that is that the bcp executes the stored proc
> three times and also doesnot give out column headers. So i had to run
> the stored proc once in ASP and get the headers from the record set and
> store it to a text file and then run the stored proc in bcp and send
> the output to a csv file. Then merge the two files into a third file.
> The problem with this method is that it takes around 4 times as long to
> run as just the stored proceedure and also i have to create 3 files
> instead of one.
> I would appreciate any suggestions you have to output the csv from a
> stored proc in sql server. Note users have to do this dynamically when
> they submit a form so cant use the query analyzer or enterprise manager
> tools.
> Thanks for your time and help
> :)|||Hi,
Thanks for your response.
But isnt OSQL also a command line utitlity? how would i run that from
inside asp. Would i use some shell command utility in vbscript?
:)
Adi wrote:
> You can use the OSQL utility in order to create a file with or without
> headers (you can control the behavior of the headers with the -h
> switch). Another tool that you can use is DTS package and run it with
> DTSRun utility. Also I would not run the tools in a stored procedure
> with xp_cmdshell, because this is a huge security problem. By working
> this way you give the user a way to run there own scripts and command
> on the operating system level with the privileges of the account that
> runs SQL Server's service. Since you are working with ASP anyway, it
> is better to run the OSQL (or if you choose a different utility, then
> the other utility) from the ASP code and not from a stored procedure.
> Adi
>
> Katie wrote:
> > Hi,
> >
> > I have a bunch of stored procedures (some using temp tables) which give
> > out tables which are then used in crystal to give out reports. These
> > stored procs are run dynamically depending on values users select on
> > forms
> >
> > Some people instead of reports want Comma Seperated Files (CSVs). I am
> > trying to find a good way of outputting to csv with using either sql
> > server or ASP. I tried two ways but none of them were ideal
> >
> > 1st method
> > first way i tried was creating a record set in asp and then using the
> > following to output the data in a comma delimited row and writing to
> > file.
> > Response.Write RecordSet.GetString(,,", ",vbCrLf,"")
> > The problem with the above was with data sets greater than 10,000
> > records the processing time increases exponentially because of memory
> > usage ( i found other people with the same problem)
> >
> > So i tried the following
> > 2nd method
> > I used bcp using the master.dbo.xp_cmdshell command to output the
> > csv. The problem with that is that the bcp executes the stored proc
> > three times and also doesnot give out column headers. So i had to run
> > the stored proc once in ASP and get the headers from the record set and
> > store it to a text file and then run the stored proc in bcp and send
> > the output to a csv file. Then merge the two files into a third file.
> > The problem with this method is that it takes around 4 times as long to
> > run as just the stored proceedure and also i have to create 3 files
> > instead of one.
> >
> > I would appreciate any suggestions you have to output the csv from a
> > stored proc in sql server. Note users have to do this dynamically when
> > they submit a form so cant use the query analyzer or enterprise manager
> > tools.
> >
> > Thanks for your time and help
> > :)|||Hi Katie
I'm sorry, but I'm not an ASP developer. As far as I know, you can
run a command line utility from an ASP code with the WScript.Shell. I
admit that I don't know much more (for example if this also has some
kind of security implications, or if there are some limitation of using
the WScript.Shell object, etc') and it would be a good idea to get more
information about running a command line utility from the ASP code.
Adi
Katie wrote:
> Hi,
> Thanks for your response.
> But isnt OSQL also a command line utitlity? how would i run that from
> inside asp. Would i use some shell command utility in vbscript?
> :)
> Adi wrote:
> > You can use the OSQL utility in order to create a file with or without
> > headers (you can control the behavior of the headers with the -h
> > switch). Another tool that you can use is DTS package and run it with
> > DTSRun utility. Also I would not run the tools in a stored procedure
> > with xp_cmdshell, because this is a huge security problem. By working
> > this way you give the user a way to run there own scripts and command
> > on the operating system level with the privileges of the account that
> > runs SQL Server's service. Since you are working with ASP anyway, it
> > is better to run the OSQL (or if you choose a different utility, then
> > the other utility) from the ASP code and not from a stored procedure.
> >
> > Adi
> >
> >
> > Katie wrote:
> > > Hi,
> > >
> > > I have a bunch of stored procedures (some using temp tables) which give
> > > out tables which are then used in crystal to give out reports. These
> > > stored procs are run dynamically depending on values users select on
> > > forms
> > >
> > > Some people instead of reports want Comma Seperated Files (CSVs). I am
> > > trying to find a good way of outputting to csv with using either sql
> > > server or ASP. I tried two ways but none of them were ideal
> > >
> > > 1st method
> > > first way i tried was creating a record set in asp and then using the
> > > following to output the data in a comma delimited row and writing to
> > > file.
> > > Response.Write RecordSet.GetString(,,", ",vbCrLf,"")
> > > The problem with the above was with data sets greater than 10,000
> > > records the processing time increases exponentially because of memory
> > > usage ( i found other people with the same problem)
> > >
> > > So i tried the following
> > > 2nd method
> > > I used bcp using the master.dbo.xp_cmdshell command to output the
> > > csv. The problem with that is that the bcp executes the stored proc
> > > three times and also doesnot give out column headers. So i had to run
> > > the stored proc once in ASP and get the headers from the record set and
> > > store it to a text file and then run the stored proc in bcp and send
> > > the output to a csv file. Then merge the two files into a third file.
> > > The problem with this method is that it takes around 4 times as long to
> > > run as just the stored proceedure and also i have to create 3 files
> > > instead of one.
> > >
> > > I would appreciate any suggestions you have to output the csv from a
> > > stored proc in sql server. Note users have to do this dynamically when
> > > they submit a form so cant use the query analyzer or enterprise manager
> > > tools.
> > >
> > > Thanks for your time and help
> > > :)|||Hi,
I tried the OSQL and was able to output a text file but the problem
with that was that it was not formatted. It included blank spaces in
the column (wasnt trimmed) and also the column headers where followed
by a -- line
Unfortunately excel wouldnot import the OSql text file correctly
:(
Adi wrote:
> Hi Katie
> I'm sorry, but I'm not an ASP developer. As far as I know, you can
> run a command line utility from an ASP code with the WScript.Shell. I
> admit that I don't know much more (for example if this also has some
> kind of security implications, or if there are some limitation of using
> the WScript.Shell object, etc') and it would be a good idea to get more
> information about running a command line utility from the ASP code.
> Adi
>
> Katie wrote:
> > Hi,
> >
> > Thanks for your response.
> > But isnt OSQL also a command line utitlity? how would i run that from
> > inside asp. Would i use some shell command utility in vbscript?
> >
> > :)
> >
> > Adi wrote:
> > > You can use the OSQL utility in order to create a file with or without
> > > headers (you can control the behavior of the headers with the -h
> > > switch). Another tool that you can use is DTS package and run it with
> > > DTSRun utility. Also I would not run the tools in a stored procedure
> > > with xp_cmdshell, because this is a huge security problem. By working
> > > this way you give the user a way to run there own scripts and command
> > > on the operating system level with the privileges of the account that
> > > runs SQL Server's service. Since you are working with ASP anyway, it
> > > is better to run the OSQL (or if you choose a different utility, then
> > > the other utility) from the ASP code and not from a stored procedure.
> > >
> > > Adi
> > >
> > >
> > > Katie wrote:
> > > > Hi,
> > > >
> > > > I have a bunch of stored procedures (some using temp tables) which give
> > > > out tables which are then used in crystal to give out reports. These
> > > > stored procs are run dynamically depending on values users select on
> > > > forms
> > > >
> > > > Some people instead of reports want Comma Seperated Files (CSVs). I am
> > > > trying to find a good way of outputting to csv with using either sql
> > > > server or ASP. I tried two ways but none of them were ideal
> > > >
> > > > 1st method
> > > > first way i tried was creating a record set in asp and then using the
> > > > following to output the data in a comma delimited row and writing to
> > > > file.
> > > > Response.Write RecordSet.GetString(,,", ",vbCrLf,"")
> > > > The problem with the above was with data sets greater than 10,000
> > > > records the processing time increases exponentially because of memory
> > > > usage ( i found other people with the same problem)
> > > >
> > > > So i tried the following
> > > > 2nd method
> > > > I used bcp using the master.dbo.xp_cmdshell command to output the
> > > > csv. The problem with that is that the bcp executes the stored proc
> > > > three times and also doesnot give out column headers. So i had to run
> > > > the stored proc once in ASP and get the headers from the record set and
> > > > store it to a text file and then run the stored proc in bcp and send
> > > > the output to a csv file. Then merge the two files into a third file.
> > > > The problem with this method is that it takes around 4 times as long to
> > > > run as just the stored proceedure and also i have to create 3 files
> > > > instead of one.
> > > >
> > > > I would appreciate any suggestions you have to output the csv from a
> > > > stored proc in sql server. Note users have to do this dynamically when
> > > > they submit a form so cant use the query analyzer or enterprise manager
> > > > tools.
> > > >
> > > > Thanks for your time and help
> > > > :)

CSV output sql server 2000

Hi,
I have a bunch of stored procedures (some using temp tables) which give
out tables which are then used in crystal to give out reports. These
stored procs are run dynamically depending on values users select on
forms
Some people instead of reports want Comma Seperated Files (CSVs). I am
trying to find a good way of outputting to csv with using either sql
server or ASP. I tried two ways but none of them were ideal
1st method
first way i tried was creating a record set in asp and then using the
following to output the data in a comma delimited row and writing to
file.
Response.Write RecordSet.GetString(,,", ",vbCrLf,"")
The problem with the above was with data sets greater than 10,000
records the processing time increases exponentially because of memory
usage ( i found other people with the same problem)
So i tried the following
2nd method
I used bcp using the master.dbo.xp_cmdshell command to output the
csv. The problem with that is that the bcp executes the stored proc
three times and also doesnot give out column headers. So i had to run
the stored proc once in ASP and get the headers from the record set and
store it to a text file and then run the stored proc in bcp and send
the output to a csv file. Then merge the two files into a third file.
The problem with this method is that it takes around 4 times as long to
run as just the stored proceedure and also i have to create 3 files
instead of one.
I would appreciate any suggestions you have to output the csv from a
stored proc in sql server. Note users have to do this dynamically when
they submit a form so cant use the query analyzer or enterprise manager
tools.
Thanks for your time and help
You can use the OSQL utility in order to create a file with or without
headers (you can control the behavior of the headers with the -h
switch). Another tool that you can use is DTS package and run it with
DTSRun utility. Also I would not run the tools in a stored procedure
with xp_cmdshell, because this is a huge security problem. By working
this way you give the user a way to run there own scripts and command
on the operating system level with the privileges of the account that
runs SQL Server's service. Since you are working with ASP anyway, it
is better to run the OSQL (or if you choose a different utility, then
the other utility) from the ASP code and not from a stored procedure.
Adi
Katie wrote:
> Hi,
> I have a bunch of stored procedures (some using temp tables) which give
> out tables which are then used in crystal to give out reports. These
> stored procs are run dynamically depending on values users select on
> forms
> Some people instead of reports want Comma Seperated Files (CSVs). I am
> trying to find a good way of outputting to csv with using either sql
> server or ASP. I tried two ways but none of them were ideal
> 1st method
> first way i tried was creating a record set in asp and then using the
> following to output the data in a comma delimited row and writing to
> file.
> Response.Write RecordSet.GetString(,,", ",vbCrLf,"")
> The problem with the above was with data sets greater than 10,000
> records the processing time increases exponentially because of memory
> usage ( i found other people with the same problem)
> So i tried the following
> 2nd method
> I used bcp using the master.dbo.xp_cmdshell command to output the
> csv. The problem with that is that the bcp executes the stored proc
> three times and also doesnot give out column headers. So i had to run
> the stored proc once in ASP and get the headers from the record set and
> store it to a text file and then run the stored proc in bcp and send
> the output to a csv file. Then merge the two files into a third file.
> The problem with this method is that it takes around 4 times as long to
> run as just the stored proceedure and also i have to create 3 files
> instead of one.
> I would appreciate any suggestions you have to output the csv from a
> stored proc in sql server. Note users have to do this dynamically when
> they submit a form so cant use the query analyzer or enterprise manager
> tools.
> Thanks for your time and help
> |||Hi,
Thanks for your response.
But isnt OSQL also a command line utitlity? how would i run that from
inside asp. Would i use some shell command utility in vbscript?

Adi wrote:[vbcol=seagreen]
> You can use the OSQL utility in order to create a file with or without
> headers (you can control the behavior of the headers with the -h
> switch). Another tool that you can use is DTS package and run it with
> DTSRun utility. Also I would not run the tools in a stored procedure
> with xp_cmdshell, because this is a huge security problem. By working
> this way you give the user a way to run there own scripts and command
> on the operating system level with the privileges of the account that
> runs SQL Server's service. Since you are working with ASP anyway, it
> is better to run the OSQL (or if you choose a different utility, then
> the other utility) from the ASP code and not from a stored procedure.
> Adi
>
> Katie wrote:|||Hi Katie
I'm sorry, but I'm not an ASP developer. As far as I know, you can
run a command line utility from an ASP code with the WScript.Shell. I
admit that I don't know much more (for example if this also has some
kind of security implications, or if there are some limitation of using
the WScript.Shell object, etc') and it would be a good idea to get more
information about running a command line utility from the ASP code.
Adi
Katie wrote:[vbcol=seagreen]
> Hi,
> Thanks for your response.
> But isnt OSQL also a command line utitlity? how would i run that from
> inside asp. Would i use some shell command utility in vbscript?
>
> Adi wrote:|||Hi,
I tried the OSQL and was able to output a text file but the problem
with that was that it was not formatted. It included blank spaces in
the column (wasnt trimmed) and also the column headers where followed
by a -- line
Unfortunately excel wouldnot import the OSql text file correctly

Adi wrote:[vbcol=seagreen]
> Hi Katie
> I'm sorry, but I'm not an ASP developer. As far as I know, you can
> run a command line utility from an ASP code with the WScript.Shell. I
> admit that I don't know much more (for example if this also has some
> kind of security implications, or if there are some limitation of using
> the WScript.Shell object, etc') and it would be a good idea to get more
> information about running a command line utility from the ASP code.
> Adi
>
> Katie wrote:

CSV in EXCEL = Users not happy

I am rolling out reporting services at my company and so far, everything has
gone smooth. The main problem for users testing reports has been that when
they open a CSV file in EXCEL, it opens up with everything in the "A" column.
Our current reporting platform does not have this problem and the users want
to keep using the data in this format (CSV files in Excel).
What I would like to do is to modify the CSV rendering format in order for
it to put the CSV files straight out in ASCII format. Does anyone know if
this is possible or if there is a better workaround?First, to explain what is happening. The default rendering of CSV is Unicode
which excel doesn't know what to do with and so it puts it all in the same
column. Here is a workaround. Add a textbox at the top of the report (I call
it Export Data), change to blue and underlined. Then you want to do a jump
to URL. (right mouse click, properties, advanced properties, navigation tab)
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
Very nice and very fast.
RS 2005 will allow you to modify the config file so it defaults to rendering
in ASCII so this problem will go away. RS 2005 will be released in November.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:3AF6B09C-1FAC-48B5-A6A0-9024ABC586D5@.microsoft.com...
>I am rolling out reporting services at my company and so far, everything
>has
> gone smooth. The main problem for users testing reports has been that when
> they open a CSV file in EXCEL, it opens up with everything in the "A"
> column.
> Our current reporting platform does not have this problem and the users
> want
> to keep using the data in this format (CSV files in Excel).
> What I would like to do is to modify the CSV rendering format in order for
> it to put the CSV files straight out in ASCII format. Does anyone know if
> this is possible or if there is a better workaround?

CSS in reporting services

Hi All, I need a suggestion.
Actually I am working on a project where in we will be doing 20 - 30 SQL
Reports The Necessity is that we need to assign all the text boxes(for
captions) and the tables with a CSS so that we need not change all the
reports individually if need arises.
Can anyone please guide me in this regard, is such a thing possible.
How to assign a CSS classes for the following
. Textbox
. Tables
. Images
And where to copy the CSS File?
Thanks..On Jul 14, 4:41 am, "Vijay" <techni...@.peoplewareindia.com> wrote:
> Hi All, I need a suggestion.
> Actually I am working on a project where in we will be doing 20 - 30 SQL
> Reports The Necessity is that we need to assign all the text boxes(for
> captions) and the tables with a CSS so that we need not change all the
> reports individually if need arises.
> Can anyone please guide me in this regard, is such a thing possible.
> How to assign a CSS classes for the following
> . Textbox
> . Tables
> . Images
> And where to copy the CSS File?
> Thanks..
This link should offer your CSS customization options.
http://msdn2.microsoft.com/en-us/library/ms345247.aspx
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

CSV Export

I'm using a webclient to pull back the different rendering format's
available from SQL Reports. I guess MS added CSV files and I would like to
bring that down - but I'm having a little trouble passing the paramater that
will bring it back. Following is my current list. Does anyone know what it
should by for csv? (I've tried CSV and it doesn't work.)
case _rsTypePDF:
fext = "pdf";
ReportFormat = "PDF";
break;
case _rsTypeIMAGE:
fext = "tif";
ReportFormat = "IMAGE";
break;
case _rsTypeMHTML:
fext = "htm";
ReportFormat = "MHTML";
break;
case _rsTypeEXCEL:
fext = "xls";
ReportFormat = "EXCEL";
break;
Thanks,
DavidGot it to work - but realize it's not what I need.
Is there a way to render just the straight ascii in a report retaining some
of the formatting such as tabs - carriage returns - etc ?
<drchips@.nospam.nospam> wrote in message
news:ugbpufmNGHA.740@.TK2MSFTNGP12.phx.gbl...
> I'm using a webclient to pull back the different rendering format's
> available from SQL Reports. I guess MS added CSV files and I would like
> to bring that down - but I'm having a little trouble passing the paramater
> that will bring it back. Following is my current list. Does anyone know
> what it should by for csv? (I've tried CSV and it doesn't work.)
> case _rsTypePDF:
> fext = "pdf";
> ReportFormat = "PDF";
> break;
> case _rsTypeIMAGE:
> fext = "tif";
> ReportFormat = "IMAGE";
> break;
> case _rsTypeMHTML:
> fext = "htm";
> ReportFormat = "MHTML";
> break;
> case _rsTypeEXCEL:
> fext = "xls";
> ReportFormat = "EXCEL";
> break;
>
> Thanks,
>
> David
>|||Hi David,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want to
export the report to CSV with tab delimited. If I misunderstood your
concern, please feel free to point it out.
Reporting Services can not do it directly. Reporting Services only could
export the CSV with comma delimited. I think the best way is to do it in
Excel. You can create a new worksheet in Excel
1. Import the data from the CSV file and select the Delimited option
at the first step and select Comma as the Delimiter.
2. After import from the CSV file, you can save it as the Text(Tab
Delimited) type.
Hope this will be helpful.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I need a straight ASCII dump of a report with some of the formatting - such
as returns, etc. Is there a way to get that?
"Wei Lu" <t-weilu@.online.microsoft.com> wrote in message
news:r6JxVfsNGHA.2336@.TK2MSFTNGXA01.phx.gbl...
> Hi David,
> Welcome to use MSDN Managed Newsgroup Support.
> From your description, my understanding of this issue is: You want to
> export the report to CSV with tab delimited. If I misunderstood your
> concern, please feel free to point it out.
> Reporting Services can not do it directly. Reporting Services only could
> export the CSV with comma delimited. I think the best way is to do it in
> Excel. You can create a new worksheet in Excel
> 1. Import the data from the CSV file and select the Delimited option
> at the first step and select Comma as the Delimiter.
> 2. After import from the CSV file, you can save it as the Text(Tab
> Delimited) type.
>
> Hope this will be helpful.
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||The other issue might be that he is getting the CSV in Unicode instead of
ASCII.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
Note the rc:Encoding that is what causes the CSV to come up in ASCII. Excel
does not know how to handle unicode and puts all the data in a single
column. With ASCII, Excel will automatically split the data out into
multiple columns.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wei Lu" <t-weilu@.online.microsoft.com> wrote in message
news:r6JxVfsNGHA.2336@.TK2MSFTNGXA01.phx.gbl...
> Hi David,
> Welcome to use MSDN Managed Newsgroup Support.
> From your description, my understanding of this issue is: You want to
> export the report to CSV with tab delimited. If I misunderstood your
> concern, please feel free to point it out.
> Reporting Services can not do it directly. Reporting Services only could
> export the CSV with comma delimited. I think the best way is to do it in
> Excel. You can create a new worksheet in Excel
> 1. Import the data from the CSV file and select the Delimited option
> at the first step and select Comma as the Delimiter.
> 2. After import from the CSV file, you can save it as the Text(Tab
> Delimited) type.
>
> Hope this will be helpful.
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi David,
Thanks for the update. And also thanks Bruce's great suggestion.
I test the solution Bruce used and it works fine on my side.
I use the following statement in a Jump to URL property of a textbox.
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
I think it meet your requirement.
Hope this will be helpful.
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I'm doing this in C#.
I wasn't sure what parameter you set to "_blank" so I set the mimetype to
it. Here's my code snippet:
case _rsTypeCSV:
fext = "csv";
ReportFormat = "CSV";
encoding = "ASCII";
mimeType = "_blank";
break;
}
results = rs.Render(ReportName, ReportFormat, historyID, deviceInfo,
parameters, credentials, showHide, out encoding, out mimeType, out
reportHistoryParameters, out warnings, out streamIDs);
I'm still getting back:
textbox1,textbox47,textbox30,textbox11,textbox72,textbox65,textbox27,textbox21,textbox57,textbox9,textbox4,textbox16,textbox78,textbox80,textbox12,textbox25,textbox36,RBP,Pulse,LBP,Icd9CodesTxt,textbox61,textbox41,textbox6,ExerciseProtocol,ExerciseStage,Time,ExerciseMets,RatePressure,HeartRate1Min,textbox170,textbox166,textbox162,TermMeds,textbox158,textbox154,textbox146,textbox142,textbox138,textbox114,textbox115,textbox110,textbox111,textbox106,textbox107,textbox102,textbox103,NlLowEf,textbox65,textbox61,textbox57,textbox93,textbox89,textbox85,textbox81,textbox77,textbox73,textbox69,AerobicCapacity,textbox49,textbox45,IschemicResponse,textbox41,textbox37,textbox33,textbox21,textbox18,textbox15,textbox12,textbox4,textbox3,textbox9,DateTxt
Nuclear Stress Imaging Report,"Palms Office
The whole report is a medical record which I can't show you - however - it
has still lost all of it's formatting. I'm not sure what I'm doing wrong
here.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23$jdHVvNGHA.1716@.TK2MSFTNGP10.phx.gbl...
> The other issue might be that he is getting the CSV in Unicode instead of
> ASCII.
> Here is an example of a Jump to URL link I use. This causes Excel to come
> up with the data in a separate window:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> If you don't want to have it appear in a new window then do this in jump
> to URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
> Note the rc:Encoding that is what causes the CSV to come up in ASCII.
> Excel does not know how to handle unicode and puts all the data in a
> single column. With ASCII, Excel will automatically split the data out
> into multiple columns.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Wei Lu" <t-weilu@.online.microsoft.com> wrote in message
> news:r6JxVfsNGHA.2336@.TK2MSFTNGXA01.phx.gbl...
>> Hi David,
>> Welcome to use MSDN Managed Newsgroup Support.
>> From your description, my understanding of this issue is: You want to
>> export the report to CSV with tab delimited. If I misunderstood your
>> concern, please feel free to point it out.
>> Reporting Services can not do it directly. Reporting Services only could
>> export the CSV with comma delimited. I think the best way is to do it in
>> Excel. You can create a new worksheet in Excel
>> 1. Import the data from the CSV file and select the Delimited option
>> at the first step and select Comma as the Delimiter.
>> 2. After import from the CSV file, you can save it as the Text(Tab
>> Delimited) type.
>>
>> Hope this will be helpful.
>> Sincerely yours,
>> Wei Lu
>> Microsoft Online Partner Support
>> Get Secure! - www.microsoft.com/security
>> =====================================================>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>|||_blank is definitely not mime type. That had to do with the frame to show in
the browser.
What you will get back is comma separated variable. Looking at what you
posted it looks like that is what you go back. If you do not want comma
separated variables then don't use CSV export.
Also, the reason you are getting back all the textbox information is because
your report has multiple textboxes above the table. What I do is add
additional table header rows, merge the cells and put my titles etc there.
While working it out I suggest using a very clean report (nothing but your
table on it).
What formatting are you expecting? CSV puts all the fields for a row on one
line separated by commas. The CSV is great for getting data into Excel.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<drchips@.nospam.nospam> wrote in message
news:OoJ5nc9NGHA.3576@.TK2MSFTNGP15.phx.gbl...
> I'm doing this in C#.
> I wasn't sure what parameter you set to "_blank" so I set the mimetype to
> it. Here's my code snippet:
> case _rsTypeCSV:
> fext = "csv";
> ReportFormat = "CSV";
> encoding = "ASCII";
> mimeType = "_blank";
> break;
> }
> results = rs.Render(ReportName, ReportFormat, historyID, deviceInfo,
> parameters, credentials, showHide, out encoding, out mimeType, out
> reportHistoryParameters, out warnings, out streamIDs);
>
> I'm still getting back:
> textbox1,textbox47,textbox30,textbox11,textbox72,textbox65,textbox27,textbox21,textbox57,textbox9,textbox4,textbox16,textbox78,textbox80,textbox12,textbox25,textbox36,RBP,Pulse,LBP,Icd9CodesTxt,textbox61,textbox41,textbox6,ExerciseProtocol,ExerciseStage,Time,ExerciseMets,RatePressure,HeartRate1Min,textbox170,textbox166,textbox162,TermMeds,textbox158,textbox154,textbox146,textbox142,textbox138,textbox114,textbox115,textbox110,textbox111,textbox106,textbox107,textbox102,textbox103,NlLowEf,textbox65,textbox61,textbox57,textbox93,textbox89,textbox85,textbox81,textbox77,textbox73,textbox69,AerobicCapacity,textbox49,textbox45,IschemicResponse,textbox41,textbox37,textbox33,textbox21,textbox18,textbox15,textbox12,textbox4,textbox3,textbox9,DateTxt
> Nuclear Stress Imaging Report,"Palms Office
> The whole report is a medical record which I can't show you - however - it
> has still lost all of it's formatting. I'm not sure what I'm doing wrong
> here.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23$jdHVvNGHA.1716@.TK2MSFTNGP10.phx.gbl...
>> The other issue might be that he is getting the CSV in Unicode instead of
>> ASCII.
>> Here is an example of a Jump to URL link I use. This causes Excel to come
>> up with the data in a separate window:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> If you don't want to have it appear in a new window then do this in jump
>> to URL:
>> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
>> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>> Note the rc:Encoding that is what causes the CSV to come up in ASCII.
>> Excel does not know how to handle unicode and puts all the data in a
>> single column. With ASCII, Excel will automatically split the data out
>> into multiple columns.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wei Lu" <t-weilu@.online.microsoft.com> wrote in message
>> news:r6JxVfsNGHA.2336@.TK2MSFTNGXA01.phx.gbl...
>> Hi David,
>> Welcome to use MSDN Managed Newsgroup Support.
>> From your description, my understanding of this issue is: You want to
>> export the report to CSV with tab delimited. If I misunderstood your
>> concern, please feel free to point it out.
>> Reporting Services can not do it directly. Reporting Services only could
>> export the CSV with comma delimited. I think the best way is to do it in
>> Excel. You can create a new worksheet in Excel
>> 1. Import the data from the CSV file and select the Delimited
>> option
>> at the first step and select Comma as the Delimiter.
>> 2. After import from the CSV file, you can save it as the Text(Tab
>> Delimited) type.
>>
>> Hope this will be helpful.
>> Sincerely yours,
>> Wei Lu
>> Microsoft Online Partner Support
>> Get Secure! - www.microsoft.com/security
>> =====================================================>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>|||It a medical diagnosis report. I need a straight ascii dump that retains
it's formatting as much as possible (Carriage returns - hopefully some
positioning by using spaces etc. )
Is there another format besides csv that can give me this? This information
needs to be posted to a central EMR repository for patient data and no meta
info for formatting is accepted by the system.
The way I'm sort of handling it now is to create an mshtml file - write a
bat file to launch it from my app. At that point - a transcriptionist has
to stick her cursor in the browser - hit Cntrl-A - Cntrl C - close the
browser - switch to her EMR interface - hit Cntrl V and save it. This
method doesn't bring any of the html tags over and retains some formatting.
I need to be able to eliminate the transcriptionists intervention in this so
she can focus on all the other work she has to do. Any suggestions? (I can
automate the interface between the systems with no problem - I just need the
ASCII dump)
Thanks for all your input so far.
David
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ec90zo9NGHA.3936@.TK2MSFTNGP12.phx.gbl...
> _blank is definitely not mime type. That had to do with the frame to show
> in the browser.
> What you will get back is comma separated variable. Looking at what you
> posted it looks like that is what you go back. If you do not want comma
> separated variables then don't use CSV export.
> Also, the reason you are getting back all the textbox information is
> because your report has multiple textboxes above the table. What I do is
> add additional table header rows, merge the cells and put my titles etc
> there.
> While working it out I suggest using a very clean report (nothing but your
> table on it).
> What formatting are you expecting? CSV puts all the fields for a row on
> one line separated by commas. The CSV is great for getting data into
> Excel.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> <drchips@.nospam.nospam> wrote in message
> news:OoJ5nc9NGHA.3576@.TK2MSFTNGP15.phx.gbl...
>> I'm doing this in C#.
>> I wasn't sure what parameter you set to "_blank" so I set the mimetype to
>> it. Here's my code snippet:
>> case _rsTypeCSV:
>> fext = "csv";
>> ReportFormat = "CSV";
>> encoding = "ASCII";
>> mimeType = "_blank";
>> break;
>> }
>> results = rs.Render(ReportName, ReportFormat, historyID, deviceInfo,
>> parameters, credentials, showHide, out encoding, out mimeType, out
>> reportHistoryParameters, out warnings, out streamIDs);
>>
>> I'm still getting back:
>> textbox1,textbox47,textbox30,textbox11,textbox72,textbox65,textbox27,textbox21,textbox57,textbox9,textbox4,textbox16,textbox78,textbox80,textbox12,textbox25,textbox36,RBP,Pulse,LBP,Icd9CodesTxt,textbox61,textbox41,textbox6,ExerciseProtocol,ExerciseStage,Time,ExerciseMets,RatePressure,HeartRate1Min,textbox170,textbox166,textbox162,TermMeds,textbox158,textbox154,textbox146,textbox142,textbox138,textbox114,textbox115,textbox110,textbox111,textbox106,textbox107,textbox102,textbox103,NlLowEf,textbox65,textbox61,textbox57,textbox93,textbox89,textbox85,textbox81,textbox77,textbox73,textbox69,AerobicCapacity,textbox49,textbox45,IschemicResponse,textbox41,textbox37,textbox33,textbox21,textbox18,textbox15,textbox12,textbox4,textbox3,textbox9,DateTxt
>> Nuclear Stress Imaging Report,"Palms Office
>> The whole report is a medical record which I can't show you - however -
>> it has still lost all of it's formatting. I'm not sure what I'm doing
>> wrong here.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:%23$jdHVvNGHA.1716@.TK2MSFTNGP10.phx.gbl...
>> The other issue might be that he is getting the CSV in Unicode instead
>> of ASCII.
>> Here is an example of a Jump to URL link I use. This causes Excel to
>> come up with the data in a separate window:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> If you don't want to have it appear in a new window then do this in jump
>> to URL:
>> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
>> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>> Note the rc:Encoding that is what causes the CSV to come up in ASCII.
>> Excel does not know how to handle unicode and puts all the data in a
>> single column. With ASCII, Excel will automatically split the data out
>> into multiple columns.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wei Lu" <t-weilu@.online.microsoft.com> wrote in message
>> news:r6JxVfsNGHA.2336@.TK2MSFTNGXA01.phx.gbl...
>> Hi David,
>> Welcome to use MSDN Managed Newsgroup Support.
>> From your description, my understanding of this issue is: You want to
>> export the report to CSV with tab delimited. If I misunderstood your
>> concern, please feel free to point it out.
>> Reporting Services can not do it directly. Reporting Services only
>> could
>> export the CSV with comma delimited. I think the best way is to do it
>> in
>> Excel. You can create a new worksheet in Excel
>> 1. Import the data from the CSV file and select the Delimited
>> option
>> at the first step and select Comma as the Delimiter.
>> 2. After import from the CSV file, you can save it as the Text(Tab
>> Delimited) type.
>>
>> Hope this will be helpful.
>> Sincerely yours,
>> Wei Lu
>> Microsoft Online Partner Support
>> Get Secure! - www.microsoft.com/security
>> =====================================================>> When responding to posts, please "Reply to Group" via your newsreader
>> so
>> that others may learn and benefit from your issue.
>> =====================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>|||CSV does not do what you want. I am not aware of a straight ASCII output.
You could do html if this is from your own app and then strip the html tags
out (the .net framework has a library that would allow that).
Bruce Loehle-Conger
<drchips@.nospam.nospam> wrote in message
news:etrP63IOGHA.2916@.tk2msftngp13.phx.gbl...
> It a medical diagnosis report. I need a straight ascii dump that retains
> it's formatting as much as possible (Carriage returns - hopefully some
> positioning by using spaces etc. )
> Is there another format besides csv that can give me this? This
> information needs to be posted to a central EMR repository for patient
> data and no meta info for formatting is accepted by the system.
> The way I'm sort of handling it now is to create an mshtml file - write a
> bat file to launch it from my app. At that point - a transcriptionist has
> to stick her cursor in the browser - hit Cntrl-A - Cntrl C - close the
> browser - switch to her EMR interface - hit Cntrl V and save it. This
> method doesn't bring any of the html tags over and retains some
> formatting.
> I need to be able to eliminate the transcriptionists intervention in this
> so she can focus on all the other work she has to do. Any suggestions? (I
> can automate the interface between the systems with no problem - I just
> need the ASCII dump)
> Thanks for all your input so far.
> David
>
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:ec90zo9NGHA.3936@.TK2MSFTNGP12.phx.gbl...
>> _blank is definitely not mime type. That had to do with the frame to show
>> in the browser.
>> What you will get back is comma separated variable. Looking at what you
>> posted it looks like that is what you go back. If you do not want comma
>> separated variables then don't use CSV export.
>> Also, the reason you are getting back all the textbox information is
>> because your report has multiple textboxes above the table. What I do is
>> add additional table header rows, merge the cells and put my titles etc
>> there.
>> While working it out I suggest using a very clean report (nothing but
>> your table on it).
>> What formatting are you expecting? CSV puts all the fields for a row on
>> one line separated by commas. The CSV is great for getting data into
>> Excel.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> <drchips@.nospam.nospam> wrote in message
>> news:OoJ5nc9NGHA.3576@.TK2MSFTNGP15.phx.gbl...
>> I'm doing this in C#.
>> I wasn't sure what parameter you set to "_blank" so I set the mimetype
>> to it. Here's my code snippet:
>> case _rsTypeCSV:
>> fext = "csv";
>> ReportFormat = "CSV";
>> encoding = "ASCII";
>> mimeType = "_blank";
>> break;
>> }
>> results = rs.Render(ReportName, ReportFormat, historyID, deviceInfo,
>> parameters, credentials, showHide, out encoding, out mimeType, out
>> reportHistoryParameters, out warnings, out streamIDs);
>>
>> I'm still getting back:
>> textbox1,textbox47,textbox30,textbox11,textbox72,textbox65,textbox27,textbox21,textbox57,textbox9,textbox4,textbox16,textbox78,textbox80,textbox12,textbox25,textbox36,RBP,Pulse,LBP,Icd9CodesTxt,textbox61,textbox41,textbox6,ExerciseProtocol,ExerciseStage,Time,ExerciseMets,RatePressure,HeartRate1Min,textbox170,textbox166,textbox162,TermMeds,textbox158,textbox154,textbox146,textbox142,textbox138,textbox114,textbox115,textbox110,textbox111,textbox106,textbox107,textbox102,textbox103,NlLowEf,textbox65,textbox61,textbox57,textbox93,textbox89,textbox85,textbox81,textbox77,textbox73,textbox69,AerobicCapacity,textbox49,textbox45,IschemicResponse,textbox41,textbox37,textbox33,textbox21,textbox18,textbox15,textbox12,textbox4,textbox3,textbox9,DateTxt
>> Nuclear Stress Imaging Report,"Palms Office
>> The whole report is a medical record which I can't show you - however -
>> it has still lost all of it's formatting. I'm not sure what I'm doing
>> wrong here.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:%23$jdHVvNGHA.1716@.TK2MSFTNGP10.phx.gbl...
>> The other issue might be that he is getting the CSV in Unicode instead
>> of ASCII.
>> Here is an example of a Jump to URL link I use. This causes Excel to
>> come up with the data in a separate window:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> If you don't want to have it appear in a new window then do this in
>> jump to URL:
>> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
>> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>> Note the rc:Encoding that is what causes the CSV to come up in ASCII.
>> Excel does not know how to handle unicode and puts all the data in a
>> single column. With ASCII, Excel will automatically split the data out
>> into multiple columns.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wei Lu" <t-weilu@.online.microsoft.com> wrote in message
>> news:r6JxVfsNGHA.2336@.TK2MSFTNGXA01.phx.gbl...
>> Hi David,
>> Welcome to use MSDN Managed Newsgroup Support.
>> From your description, my understanding of this issue is: You want to
>> export the report to CSV with tab delimited. If I misunderstood your
>> concern, please feel free to point it out.
>> Reporting Services can not do it directly. Reporting Services only
>> could
>> export the CSV with comma delimited. I think the best way is to do it
>> in
>> Excel. You can create a new worksheet in Excel
>> 1. Import the data from the CSV file and select the Delimited
>> option
>> at the first step and select Comma as the Delimiter.
>> 2. After import from the CSV file, you can save it as the
>> Text(Tab
>> Delimited) type.
>>
>> Hope this will be helpful.
>> Sincerely yours,
>> Wei Lu
>> Microsoft Online Partner Support
>> Get Secure! - www.microsoft.com/security
>> =====================================================>> When responding to posts, please "Reply to Group" via your newsreader
>> so
>> that others may learn and benefit from your issue.
>> =====================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>>
>|||One thing that might work for you but I haven't done is to use XML output
and then provide your own xslt to get a straight ascii representation of
your report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<drchips@.nospam.nospam> wrote in message
news:etrP63IOGHA.2916@.tk2msftngp13.phx.gbl...
> It a medical diagnosis report. I need a straight ascii dump that retains
> it's formatting as much as possible (Carriage returns - hopefully some
> positioning by using spaces etc. )
> Is there another format besides csv that can give me this? This
> information needs to be posted to a central EMR repository for patient
> data and no meta info for formatting is accepted by the system.
> The way I'm sort of handling it now is to create an mshtml file - write a
> bat file to launch it from my app. At that point - a transcriptionist has
> to stick her cursor in the browser - hit Cntrl-A - Cntrl C - close the
> browser - switch to her EMR interface - hit Cntrl V and save it. This
> method doesn't bring any of the html tags over and retains some
> formatting.
> I need to be able to eliminate the transcriptionists intervention in this
> so she can focus on all the other work she has to do. Any suggestions? (I
> can automate the interface between the systems with no problem - I just
> need the ASCII dump)
> Thanks for all your input so far.
> David
>
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:ec90zo9NGHA.3936@.TK2MSFTNGP12.phx.gbl...
>> _blank is definitely not mime type. That had to do with the frame to show
>> in the browser.
>> What you will get back is comma separated variable. Looking at what you
>> posted it looks like that is what you go back. If you do not want comma
>> separated variables then don't use CSV export.
>> Also, the reason you are getting back all the textbox information is
>> because your report has multiple textboxes above the table. What I do is
>> add additional table header rows, merge the cells and put my titles etc
>> there.
>> While working it out I suggest using a very clean report (nothing but
>> your table on it).
>> What formatting are you expecting? CSV puts all the fields for a row on
>> one line separated by commas. The CSV is great for getting data into
>> Excel.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> <drchips@.nospam.nospam> wrote in message
>> news:OoJ5nc9NGHA.3576@.TK2MSFTNGP15.phx.gbl...
>> I'm doing this in C#.
>> I wasn't sure what parameter you set to "_blank" so I set the mimetype
>> to it. Here's my code snippet:
>> case _rsTypeCSV:
>> fext = "csv";
>> ReportFormat = "CSV";
>> encoding = "ASCII";
>> mimeType = "_blank";
>> break;
>> }
>> results = rs.Render(ReportName, ReportFormat, historyID, deviceInfo,
>> parameters, credentials, showHide, out encoding, out mimeType, out
>> reportHistoryParameters, out warnings, out streamIDs);
>>
>> I'm still getting back:
>> textbox1,textbox47,textbox30,textbox11,textbox72,textbox65,textbox27,textbox21,textbox57,textbox9,textbox4,textbox16,textbox78,textbox80,textbox12,textbox25,textbox36,RBP,Pulse,LBP,Icd9CodesTxt,textbox61,textbox41,textbox6,ExerciseProtocol,ExerciseStage,Time,ExerciseMets,RatePressure,HeartRate1Min,textbox170,textbox166,textbox162,TermMeds,textbox158,textbox154,textbox146,textbox142,textbox138,textbox114,textbox115,textbox110,textbox111,textbox106,textbox107,textbox102,textbox103,NlLowEf,textbox65,textbox61,textbox57,textbox93,textbox89,textbox85,textbox81,textbox77,textbox73,textbox69,AerobicCapacity,textbox49,textbox45,IschemicResponse,textbox41,textbox37,textbox33,textbox21,textbox18,textbox15,textbox12,textbox4,textbox3,textbox9,DateTxt
>> Nuclear Stress Imaging Report,"Palms Office
>> The whole report is a medical record which I can't show you - however -
>> it has still lost all of it's formatting. I'm not sure what I'm doing
>> wrong here.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:%23$jdHVvNGHA.1716@.TK2MSFTNGP10.phx.gbl...
>> The other issue might be that he is getting the CSV in Unicode instead
>> of ASCII.
>> Here is an example of a Jump to URL link I use. This causes Excel to
>> come up with the data in a separate window:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> If you don't want to have it appear in a new window then do this in
>> jump to URL:
>> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
>> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>> Note the rc:Encoding that is what causes the CSV to come up in ASCII.
>> Excel does not know how to handle unicode and puts all the data in a
>> single column. With ASCII, Excel will automatically split the data out
>> into multiple columns.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wei Lu" <t-weilu@.online.microsoft.com> wrote in message
>> news:r6JxVfsNGHA.2336@.TK2MSFTNGXA01.phx.gbl...
>> Hi David,
>> Welcome to use MSDN Managed Newsgroup Support.
>> From your description, my understanding of this issue is: You want to
>> export the report to CSV with tab delimited. If I misunderstood your
>> concern, please feel free to point it out.
>> Reporting Services can not do it directly. Reporting Services only
>> could
>> export the CSV with comma delimited. I think the best way is to do it
>> in
>> Excel. You can create a new worksheet in Excel
>> 1. Import the data from the CSV file and select the Delimited
>> option
>> at the first step and select Comma as the Delimiter.
>> 2. After import from the CSV file, you can save it as the
>> Text(Tab
>> Delimited) type.
>>
>> Hope this will be helpful.
>> Sincerely yours,
>> Wei Lu
>> Microsoft Online Partner Support
>> Get Secure! - www.microsoft.com/security
>> =====================================================>> When responding to posts, please "Reply to Group" via your newsreader
>> so
>> that others may learn and benefit from your issue.
>> =====================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>>
>|||That would be great.
What is the name of that library?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e0wOQnKOGHA.2624@.TK2MSFTNGP12.phx.gbl...
> CSV does not do what you want. I am not aware of a straight ASCII output.
> You could do html if this is from your own app and then strip the html
> tags out (the .net framework has a library that would allow that).
> Bruce Loehle-Conger
>
> <drchips@.nospam.nospam> wrote in message
> news:etrP63IOGHA.2916@.tk2msftngp13.phx.gbl...
>> It a medical diagnosis report. I need a straight ascii dump that retains
>> it's formatting as much as possible (Carriage returns - hopefully some
>> positioning by using spaces etc. )
>> Is there another format besides csv that can give me this? This
>> information needs to be posted to a central EMR repository for patient
>> data and no meta info for formatting is accepted by the system.
>> The way I'm sort of handling it now is to create an mshtml file - write a
>> bat file to launch it from my app. At that point - a transcriptionist
>> has to stick her cursor in the browser - hit Cntrl-A - Cntrl C - close
>> the browser - switch to her EMR interface - hit Cntrl V and save it.
>> This method doesn't bring any of the html tags over and retains some
>> formatting.
>> I need to be able to eliminate the transcriptionists intervention in this
>> so she can focus on all the other work she has to do. Any suggestions?
>> (I can automate the interface between the systems with no problem - I
>> just need the ASCII dump)
>> Thanks for all your input so far.
>> David
>>
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:ec90zo9NGHA.3936@.TK2MSFTNGP12.phx.gbl...
>> _blank is definitely not mime type. That had to do with the frame to
>> show in the browser.
>> What you will get back is comma separated variable. Looking at what you
>> posted it looks like that is what you go back. If you do not want comma
>> separated variables then don't use CSV export.
>> Also, the reason you are getting back all the textbox information is
>> because your report has multiple textboxes above the table. What I do is
>> add additional table header rows, merge the cells and put my titles etc
>> there.
>> While working it out I suggest using a very clean report (nothing but
>> your table on it).
>> What formatting are you expecting? CSV puts all the fields for a row on
>> one line separated by commas. The CSV is great for getting data into
>> Excel.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> <drchips@.nospam.nospam> wrote in message
>> news:OoJ5nc9NGHA.3576@.TK2MSFTNGP15.phx.gbl...
>> I'm doing this in C#.
>> I wasn't sure what parameter you set to "_blank" so I set the mimetype
>> to it. Here's my code snippet:
>> case _rsTypeCSV:
>> fext = "csv";
>> ReportFormat = "CSV";
>> encoding = "ASCII";
>> mimeType = "_blank";
>> break;
>> }
>> results = rs.Render(ReportName, ReportFormat, historyID, deviceInfo,
>> parameters, credentials, showHide, out encoding, out mimeType, out
>> reportHistoryParameters, out warnings, out streamIDs);
>>
>> I'm still getting back:
>> textbox1,textbox47,textbox30,textbox11,textbox72,textbox65,textbox27,textbox21,textbox57,textbox9,textbox4,textbox16,textbox78,textbox80,textbox12,textbox25,textbox36,RBP,Pulse,LBP,Icd9CodesTxt,textbox61,textbox41,textbox6,ExerciseProtocol,ExerciseStage,Time,ExerciseMets,RatePressure,HeartRate1Min,textbox170,textbox166,textbox162,TermMeds,textbox158,textbox154,textbox146,textbox142,textbox138,textbox114,textbox115,textbox110,textbox111,textbox106,textbox107,textbox102,textbox103,NlLowEf,textbox65,textbox61,textbox57,textbox93,textbox89,textbox85,textbox81,textbox77,textbox73,textbox69,AerobicCapacity,textbox49,textbox45,IschemicResponse,textbox41,textbox37,textbox33,textbox21,textbox18,textbox15,textbox12,textbox4,textbox3,textbox9,DateTxt
>> Nuclear Stress Imaging Report,"Palms Office
>> The whole report is a medical record which I can't show you - however -
>> it has still lost all of it's formatting. I'm not sure what I'm doing
>> wrong here.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:%23$jdHVvNGHA.1716@.TK2MSFTNGP10.phx.gbl...
>> The other issue might be that he is getting the CSV in Unicode instead
>> of ASCII.
>> Here is an example of a Jump to URL link I use. This causes Excel to
>> come up with the data in a separate window:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> If you don't want to have it appear in a new window then do this in
>> jump to URL:
>> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
>> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>> Note the rc:Encoding that is what causes the CSV to come up in ASCII.
>> Excel does not know how to handle unicode and puts all the data in a
>> single column. With ASCII, Excel will automatically split the data out
>> into multiple columns.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wei Lu" <t-weilu@.online.microsoft.com> wrote in message
>> news:r6JxVfsNGHA.2336@.TK2MSFTNGXA01.phx.gbl...
>> Hi David,
>> Welcome to use MSDN Managed Newsgroup Support.
>> From your description, my understanding of this issue is: You want to
>> export the report to CSV with tab delimited. If I misunderstood your
>> concern, please feel free to point it out.
>> Reporting Services can not do it directly. Reporting Services only
>> could
>> export the CSV with comma delimited. I think the best way is to do it
>> in
>> Excel. You can create a new worksheet in Excel
>> 1. Import the data from the CSV file and select the Delimited
>> option
>> at the first step and select Comma as the Delimiter.
>> 2. After import from the CSV file, you can save it as the
>> Text(Tab
>> Delimited) type.
>>
>> Hope this will be helpful.
>> Sincerely yours,
>> Wei Lu
>> Microsoft Online Partner Support
>> Get Secure! - www.microsoft.com/security
>> =====================================================>> When responding to posts, please "Reply to Group" via your newsreader
>> so
>> that others may learn and benefit from your issue.
>> =====================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>>
>>
>|||Here are several ideas for you:
http://weblogs.asp.net/rosherove/archive/2003/05/13/6963.aspx
http://www.freevbcode.com/ShowCode.asp?ID=110
This article gives some ideas plus how it can't do everything:
http://groups.google.com/group/microsoft.public.dotnet.languages.vb/browse_thread/thread/27332781e3126287/ceebf4e075a5a8ed%23ceebf4e075a5a8ed?sa=X&oi=groupsr&start=0&num=2
from the article:
>>>>>>>
How To Strip HTML Tags :
Well, the short answer is Regular Expressions, for example:
'(assuming that you have imported System.Text.RegularExpressions)
Dim oRegEx as Regex = RegEx("<[^>]*>")
Dim myNewString as string = oRegEx.Replace(myOldString, "")
However, that won't get you anywhere close to all the way. Even after you
entirely strip out all the <htmltags> you may be left with HTML-encoded
strings such as which you will also want to parse. These are easily
handled with
System.Web.HTTPUtility.HTMLDecode()
>>>>>>
You might be better off with XML and XSLT as I mentioned in another post.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<drchips@.nospam.nospam> wrote in message
news:O1NTj6WOGHA.2128@.TK2MSFTNGP10.phx.gbl...
> That would be great.
> What is the name of that library?
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:e0wOQnKOGHA.2624@.TK2MSFTNGP12.phx.gbl...
>> CSV does not do what you want. I am not aware of a straight ASCII output.
>> You could do html if this is from your own app and then strip the html
>> tags out (the .net framework has a library that would allow that).
>> Bruce Loehle-Conger
>>
>> <drchips@.nospam.nospam> wrote in message
>> news:etrP63IOGHA.2916@.tk2msftngp13.phx.gbl...
>> It a medical diagnosis report. I need a straight ascii dump that
>> retains it's formatting as much as possible (Carriage returns -
>> hopefully some positioning by using spaces etc. )
>> Is there another format besides csv that can give me this? This
>> information needs to be posted to a central EMR repository for patient
>> data and no meta info for formatting is accepted by the system.
>> The way I'm sort of handling it now is to create an mshtml file - write
>> a bat file to launch it from my app. At that point - a transcriptionist
>> has to stick her cursor in the browser - hit Cntrl-A - Cntrl C - close
>> the browser - switch to her EMR interface - hit Cntrl V and save it.
>> This method doesn't bring any of the html tags over and retains some
>> formatting.
>> I need to be able to eliminate the transcriptionists intervention in
>> this so she can focus on all the other work she has to do. Any
>> suggestions? (I can automate the interface between the systems with no
>> problem - I just need the ASCII dump)
>> Thanks for all your input so far.
>> David
>>
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:ec90zo9NGHA.3936@.TK2MSFTNGP12.phx.gbl...
>> _blank is definitely not mime type. That had to do with the frame to
>> show in the browser.
>> What you will get back is comma separated variable. Looking at what you
>> posted it looks like that is what you go back. If you do not want comma
>> separated variables then don't use CSV export.
>> Also, the reason you are getting back all the textbox information is
>> because your report has multiple textboxes above the table. What I do
>> is add additional table header rows, merge the cells and put my titles
>> etc there.
>> While working it out I suggest using a very clean report (nothing but
>> your table on it).
>> What formatting are you expecting? CSV puts all the fields for a row on
>> one line separated by commas. The CSV is great for getting data into
>> Excel.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> <drchips@.nospam.nospam> wrote in message
>> news:OoJ5nc9NGHA.3576@.TK2MSFTNGP15.phx.gbl...
>> I'm doing this in C#.
>> I wasn't sure what parameter you set to "_blank" so I set the mimetype
>> to it. Here's my code snippet:
>> case _rsTypeCSV:
>> fext = "csv";
>> ReportFormat = "CSV";
>> encoding = "ASCII";
>> mimeType = "_blank";
>> break;
>> }
>> results = rs.Render(ReportName, ReportFormat, historyID, deviceInfo,
>> parameters, credentials, showHide, out encoding, out mimeType, out
>> reportHistoryParameters, out warnings, out streamIDs);
>>
>> I'm still getting back:
>> textbox1,textbox47,textbox30,textbox11,textbox72,textbox65,textbox27,textbox21,textbox57,textbox9,textbox4,textbox16,textbox78,textbox80,textbox12,textbox25,textbox36,RBP,Pulse,LBP,Icd9CodesTxt,textbox61,textbox41,textbox6,ExerciseProtocol,ExerciseStage,Time,ExerciseMets,RatePressure,HeartRate1Min,textbox170,textbox166,textbox162,TermMeds,textbox158,textbox154,textbox146,textbox142,textbox138,textbox114,textbox115,textbox110,textbox111,textbox106,textbox107,textbox102,textbox103,NlLowEf,textbox65,textbox61,textbox57,textbox93,textbox89,textbox85,textbox81,textbox77,textbox73,textbox69,AerobicCapacity,textbox49,textbox45,IschemicResponse,textbox41,textbox37,textbox33,textbox21,textbox18,textbox15,textbox12,textbox4,textbox3,textbox9,DateTxt
>> Nuclear Stress Imaging Report,"Palms Office
>> The whole report is a medical record which I can't show you -
>> however - it has still lost all of it's formatting. I'm not sure what
>> I'm doing wrong here.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:%23$jdHVvNGHA.1716@.TK2MSFTNGP10.phx.gbl...
>> The other issue might be that he is getting the CSV in Unicode
>> instead of ASCII.
>> Here is an example of a Jump to URL link I use. This causes Excel to
>> come up with the data in a separate window:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> If you don't want to have it appear in a new window then do this in
>> jump to URL:
>> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
>> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>> Note the rc:Encoding that is what causes the CSV to come up in
>> ASCII. Excel does not know how to handle unicode and puts all the
>> data in a single column. With ASCII, Excel will automatically split
>> the data out into multiple columns.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wei Lu" <t-weilu@.online.microsoft.com> wrote in message
>> news:r6JxVfsNGHA.2336@.TK2MSFTNGXA01.phx.gbl...
>>> Hi David,
>>>
>>> Welcome to use MSDN Managed Newsgroup Support.
>>>
>>> From your description, my understanding of this issue is: You want
>>> to
>>> export the report to CSV with tab delimited. If I misunderstood your
>>> concern, please feel free to point it out.
>>>
>>> Reporting Services can not do it directly. Reporting Services only
>>> could
>>> export the CSV with comma delimited. I think the best way is to do
>>> it in
>>> Excel. You can create a new worksheet in Excel
>>>
>>> 1. Import the data from the CSV file and select the Delimited
>>> option
>>> at the first step and select Comma as the Delimiter.
>>>
>>> 2. After import from the CSV file, you can save it as the
>>> Text(Tab
>>> Delimited) type.
>>>
>>>
>>> Hope this will be helpful.
>>>
>>> Sincerely yours,
>>>
>>> Wei Lu
>>> Microsoft Online Partner Support
>>>
>>> Get Secure! - www.microsoft.com/security
>>> =====================================================>>> When responding to posts, please "Reply to Group" via your
>>> newsreader so
>>> that others may learn and benefit from your issue.
>>> =====================================================>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights.
>>>
>>
>>
>>
>>
>>
>

Css and reports

Hi!

I saw it's possible to use css files to customize the HTML Viewer and the Report Manager. Is it possible to use css on the report layout as well?

Thank you!

No, it is currently not supported for the report layout.

-- Robert

Crystl32.ocx with vb .net

Hi all,

I've created the report with Seagate crystal reports with the source to the database through a stored procedure (with ODBC). The stored procedure contains input parameter that I want to sent it to this report from .Net through Crystal report Control Crystl32.ocx.
I installed this control into .net but I don't how can I pass the parameter which I'm writing into textbox to report that contains stored procedure as a data source.

== Some code with Crystl32.ocx that I'm using to call the report:

With cr2
.ReportFileName = Application.StartupPath + "\klient_info.rpt"
.RetrieveDataFiles()
.DiscardSavedData = True
.ParameterFields(1) = "@.KlientID;" & TextBox2.Text & ";False"
.WindowState = crptMaximized
.Action = 0

End With

With the code above I'm passing into crytal report @.klientID - what I'm writting into textbox2. But the problem is that I don't want crystal report to prompt again for inserting input parameter.

Thanks,
ProBani.With the code above I'm passing into crytal report @.klientID - what I'm writting into textbox2. But the problem is that I don't want crystal report to prompt again for inserting input parameter.

are you sure that you only have one input parameter and that it is ParameterFields(1). My guess is that Crystal either expect another paramter or that the one your inputting isn't correct. That's why you get prompted to input another param.

Crystel Reports 8.0 Immadiate help!

Hi!! I have to change reporting path of reports with code but i couldn't do it. I found somethin here using craxdrt.dll but i couldn't. Anyone have codes about this problem? I have to deliver my project on monday but only this part is missing... I need immediate help!!!CR = CRYSTAL REPORTS

First of all your post is very short and not in detail. Pls specify full details when you post a question -> like COMPILER, REPORTING ENGINE WITH VERSION and if possible the code your having trouble with...

I cant help you with the code cause I dont use that technique. But I have juggled with it a few times... So heres the deal. If your using VB6 then CR comes with an activex designer.

If yur using the activex designer like me then you cannot change the database path of the report at runtime! Its only possible when you have created a separate .rpt file and youre loading that report from the disk to the viewer. If you want to use the activex designer then you must supply a datasource i.e. the number of tables that you have added in the report like :

rpt_Global.Database.SetDataSource rsM, , 1

this will give the report what it needs it will no longer look for the database.
The database and datasource that I use are Active Data -> ADO. You can find a small glimpse of what Active Data does in the useless CR documentation. If youre using external reports then u can set the path of the database at runtime like this :

dim rpt_App as new CRAXDRT.Application

Dim rpt_Global As New CRAXDRT.Report

Set rpt_Global = rpt_App.OpenReport(App.Path & "\reports\report1.rpt" )

' :::: discard any data stored in the report its imp.
rpt_global.DiscardSavedData

Dim DataFiles As CRAXDRT.DatabaseTables

Set DataFiles = rpt_Global.Database.Tables

DataFiles(1).SetLogOnInfo "", yourmdbPath , ,"yourpassword"

hope this code would resolve your problem. One more thing, What you can do on your own that cannot be done by any guru on this forum... so keep trying and experimenting...