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?
>
Showing posts with label available. Show all posts
Showing posts with label available. Show all posts
Sunday, March 11, 2012
Thursday, March 8, 2012
Cubes not available after processing
The problem is that the cube is not available for queries. But process structure has been made, a full process of the dimensions and of the measure groups.
This is what I did do:
I did Import the SSAS Project from my live server to my local machine (laptop). I did some changings in the project in the dimensions and measure groups and deployed the solution to the server. After this I did a process structure. I logged into Analysis Server, opened a mdx script and the cube was available. Then I did a FULL Process of all the dimensions to be sure that everything is allright with them. Then I did reprocess all my Measure Groups.
Now the cube is not available. This happend the second time now. I process the cube by using ascmd.exe executing xmla commands.
After I do a process structure again it works. I can see the cube and the measure data is available after processing the measure groups.
I cannot explain this behaviour. Can you?
Best regards,
Stefoon
What happens is that when you do a full process of a dimension. The structures of any related cubes become "unprocessed". Processing a measure group under the cube does not implicitly re-process the structure of the cube.
After you do a full process of a dimension you will need to reprocess the structure again.
|||Hi,
I think you are right. I did forget about the fact that the full process destroys the maps auf the dimensions for the cube construct.
Best regards,
Stefoon
Saturday, February 25, 2012
Cube not showing up in Metadata Browser
I have a cube that is processed, available, browsable, etc., but that does not appear in the list of available cubes in the following scenarios:
Open a new MDX Query window in the Managment Studio: the Metadata browser displays the error message "Error loading Metadata: No cubes were found.", Yet I can still write a query and execute it against the cube. Use excel and try connecting to the cube using the "Data", "Import External Data", "New Database Query", "Olap Cubes","<New Data Source>", create a new "MS OLE DB Provider for Analysis Services 9.0" data source pointing to the server/database, and no cube names show up in the cube drop down. Proclarity 6.1: same problem: cube shows as not processed or unavailable and I can't connect to it.The cube works great with the Excel Cube Analysis Add-in, so I'm suspecting it is one of the new features of AS 2005 that is causing the problem. I am using Many-to-Many dimension relationships in the cube, and mutiple measure groups. Other than that, the cube is pretty straight-forward.
Any ideas on what would make this happen? I've tried deleting the cube from the server and completely redeploying the project, changing the cube name to not have a space in the name and a few other simple things.
Regards,
Clayton
This has to fall into the "bonehead" category.
The cube's "Visible" property was set to "False". Not sure how this happened, but for the record, the solution is to set the "Visible" property to "True".
|||I don't know about "bonehead." I spent 4 hours with this exact same problem. Not until I found this post did I think to view the cubes XML and change <visible>false</visble> to <visible>true</visible>. I mean, is there even a way to change this property though the designer? I just about went crazy. Thanks.|||
hello,
yes, if you open your project in BIDS, and open cube designer, look in the properties panel - it should show the cube and one of the properties listed in there is Visible (in the Advanced category).
hope this helps,
|||I did the same thing. I think what we all have accidentally done was select a dimension that we wanted to hide then went to the properties window to set the Visible property. What I just noticed is that if you click on on one of the dimensions while on the Cube Structure tab the properties window does not change to the dimension and the Visible property on the cube gets set to false accidentally. At least that how I ended up doing it. I hope this helps someone else realize how it happened to them.Cube not showing up in Metadata Browser
I have a cube that is processed, available, browsable, etc., but that does not appear in the list of available cubes in the following scenarios:
Open a new MDX Query window in the Managment Studio: the Metadata browser displays the error message "Error loading Metadata: No cubes were found.", Yet I can still write a query and execute it against the cube.
Use excel and try connecting to the cube using the "Data", "Import External Data", "New Database Query", "Olap Cubes","<New Data Source>", create a new "MS OLE DB Provider for Analysis Services 9.0" data source pointing to the server/database, and no cube names show up in the cube drop down.
Proclarity 6.1: same problem: cube shows as not processed or unavailable and I can't connect to it.
The cube works great with the Excel Cube Analysis Add-in, so I'm suspecting it is one of the new features of AS 2005 that is causing the problem. I am using Many-to-Many dimension relationships in the cube, and mutiple measure groups. Other than that, the cube is pretty straight-forward.
Any ideas on what would make this happen? I've tried deleting the cube from the server and completely redeploying the project, changing the cube name to not have a space in the name and a few other simple things.
Regards,
Clayton
This has to fall into the "bonehead" category.
The cube's "Visible" property was set to "False". Not sure how this happened, but for the record, the solution is to set the "Visible" property to "True".
|||I don't know about "bonehead." I spent 4 hours with this exact same problem. Not until I found this post did I think to view the cubes XML and change <visible>false</visble> to <visible>true</visible>. I mean, is there even a way to change this property though the designer? I just about went crazy. Thanks.|||
hello,
yes, if you open your project in BIDS, and open cube designer, look in the properties panel - it should show the cube and one of the properties listed in there is Visible (in the Advanced category).
hope this helps,
|||I did the same thing. I think what we all have accidentally done was select a dimension that we wanted to hide then went to the properties window to set the Visible property. What I just noticed is that if you click on on one of the dimensions while on the Cube Structure tab the properties window does not change to the dimension and the Visible property on the cube gets set to false accidentally. At least that how I ended up doing it. I hope this helps someone else realize how it happened to them.Cube not showing up in Metadata Browser
I have a cube that is processed, available, browsable, etc., but that does not appear in the list of available cubes in the following scenarios:
Open a new MDX Query window in the Managment Studio: the Metadata browser displays the error message "Error loading Metadata: No cubes were found.", Yet I can still write a query and execute it against the cube.
Use excel and try connecting to the cube using the "Data", "Import External Data", "New Database Query", "Olap Cubes","<New Data Source>", create a new "MS OLE DB Provider for Analysis Services 9.0" data source pointing to the server/database, and no cube names show up in the cube drop down.
Proclarity 6.1: same problem: cube shows as not processed or unavailable and I can't connect to it.
The cube works great with the Excel Cube Analysis Add-in, so I'm suspecting it is one of the new features of AS 2005 that is causing the problem. I am using Many-to-Many dimension relationships in the cube, and mutiple measure groups. Other than that, the cube is pretty straight-forward.
Any ideas on what would make this happen? I've tried deleting the cube from the server and completely redeploying the project, changing the cube name to not have a space in the name and a few other simple things.
Regards,
Clayton
This has to fall into the "bonehead" category.
The cube's "Visible" property was set to "False". Not sure how this happened, but for the record, the solution is to set the "Visible" property to "True".
|||I don't know about "bonehead." I spent 4 hours with this exact same problem. Not until I found this post did I think to view the cubes XML and change <visible>false</visble> to <visible>true</visible>. I mean, is there even a way to change this property though the designer? I just about went crazy. Thanks.|||
hello,
yes, if you open your project in BIDS, and open cube designer, look in the properties panel - it should show the cube and one of the properties listed in there is Visible (in the Advanced category).
hope this helps,
|||I did the same thing. I think what we all have accidentally done was select a dimension that we wanted to hide then went to the properties window to set the Visible property. What I just noticed is that if you click on on one of the dimensions while on the Cube Structure tab the properties window does not change to the dimension and the Visible property on the cube gets set to false accidentally. At least that how I ended up doing it. I hope this helps someone else realize how it happened to them.Tuesday, February 14, 2012
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.
>>>
>>
>>
>>
>>
>>
>
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 - Style Sheets
Am I blind, I don't see in the properties pages a CSS entry. Is this not
available in SSRS? If so, is there another method or is everything hand
coded?
ThanksWhat are you trying to do? RS uses an output independent format. The report
definition is xml but the rendering is done by the rendering engine. You can
render to html, csv, pdf, excel, etc.
The reports should be designed using the report designer. If you want to do
it another way there is a spec for the xml.
I guess I look at it like nothing is hand coded (unless you think a
graphical report designer tool is hand coding).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:%23liEgVGIHHA.420@.TK2MSFTNGP02.phx.gbl...
> Am I blind, I don't see in the properties pages a CSS entry. Is this not
> available in SSRS? If so, is there another method or is everything hand
> coded?
> Thanks
>|||Thank you - I was just wondering if there was a fast way to format a variety
of reports just like one would do with a webpage making headers, footers,
fonts, borders, etc. all the same.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23SEUliGIHHA.3780@.TK2MSFTNGP02.phx.gbl...
> What are you trying to do? RS uses an output independent format. The
> report definition is xml but the rendering is done by the rendering
> engine. You can render to html, csv, pdf, excel, etc.
> The reports should be designed using the report designer. If you want to
> do it another way there is a spec for the xml.
> I guess I look at it like nothing is hand coded (unless you think a
> graphical report designer tool is hand coding).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
> news:%23liEgVGIHHA.420@.TK2MSFTNGP02.phx.gbl...
>> Am I blind, I don't see in the properties pages a CSS entry. Is this not
>> available in SSRS? If so, is there another method or is everything hand
>> coded?
>> Thanks
>|||What you can do is setup a report template (for use by the report wizard or
when you create a new report). However, it is a report template so once the
report is created and if you want to change it you would have to modify them
one by one. Still, it might be of use to you.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/f84b9ac6-bf37-4f27-bbe4-273a4af84c2e.htm
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:%23IMgaLIIHHA.4848@.TK2MSFTNGP04.phx.gbl...
> Thank you - I was just wondering if there was a fast way to format a
> variety of reports just like one would do with a webpage making headers,
> footers, fonts, borders, etc. all the same.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23SEUliGIHHA.3780@.TK2MSFTNGP02.phx.gbl...
>> What are you trying to do? RS uses an output independent format. The
>> report definition is xml but the rendering is done by the rendering
>> engine. You can render to html, csv, pdf, excel, etc.
>> The reports should be designed using the report designer. If you want to
>> do it another way there is a spec for the xml.
>> I guess I look at it like nothing is hand coded (unless you think a
>> graphical report designer tool is hand coding).
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
>> news:%23liEgVGIHHA.420@.TK2MSFTNGP02.phx.gbl...
>> Am I blind, I don't see in the properties pages a CSS entry. Is this not
>> available in SSRS? If so, is there another method or is everything hand
>> coded?
>> Thanks
>>
>|||Thank you - that's probably a pretty good direction for us.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eYjSYmIIHHA.1248@.TK2MSFTNGP03.phx.gbl...
> What you can do is setup a report template (for use by the report wizard
> or when you create a new report). However, it is a report template so once
> the report is created and if you want to change it you would have to
> modify them one by one. Still, it might be of use to you.
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/f84b9ac6-bf37-4f27-bbe4-273a4af84c2e.htm
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
> news:%23IMgaLIIHHA.4848@.TK2MSFTNGP04.phx.gbl...
>> Thank you - I was just wondering if there was a fast way to format a
>> variety of reports just like one would do with a webpage making headers,
>> footers, fonts, borders, etc. all the same.
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:%23SEUliGIHHA.3780@.TK2MSFTNGP02.phx.gbl...
>> What are you trying to do? RS uses an output independent format. The
>> report definition is xml but the rendering is done by the rendering
>> engine. You can render to html, csv, pdf, excel, etc.
>> The reports should be designed using the report designer. If you want to
>> do it another way there is a spec for the xml.
>> I guess I look at it like nothing is hand coded (unless you think a
>> graphical report designer tool is hand coding).
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
>> news:%23liEgVGIHHA.420@.TK2MSFTNGP02.phx.gbl...
>> Am I blind, I don't see in the properties pages a CSS entry. Is this
>> not available in SSRS? If so, is there another method or is everything
>> hand coded?
>> Thanks
>>
>>
>
available in SSRS? If so, is there another method or is everything hand
coded?
ThanksWhat are you trying to do? RS uses an output independent format. The report
definition is xml but the rendering is done by the rendering engine. You can
render to html, csv, pdf, excel, etc.
The reports should be designed using the report designer. If you want to do
it another way there is a spec for the xml.
I guess I look at it like nothing is hand coded (unless you think a
graphical report designer tool is hand coding).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:%23liEgVGIHHA.420@.TK2MSFTNGP02.phx.gbl...
> Am I blind, I don't see in the properties pages a CSS entry. Is this not
> available in SSRS? If so, is there another method or is everything hand
> coded?
> Thanks
>|||Thank you - I was just wondering if there was a fast way to format a variety
of reports just like one would do with a webpage making headers, footers,
fonts, borders, etc. all the same.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23SEUliGIHHA.3780@.TK2MSFTNGP02.phx.gbl...
> What are you trying to do? RS uses an output independent format. The
> report definition is xml but the rendering is done by the rendering
> engine. You can render to html, csv, pdf, excel, etc.
> The reports should be designed using the report designer. If you want to
> do it another way there is a spec for the xml.
> I guess I look at it like nothing is hand coded (unless you think a
> graphical report designer tool is hand coding).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
> news:%23liEgVGIHHA.420@.TK2MSFTNGP02.phx.gbl...
>> Am I blind, I don't see in the properties pages a CSS entry. Is this not
>> available in SSRS? If so, is there another method or is everything hand
>> coded?
>> Thanks
>|||What you can do is setup a report template (for use by the report wizard or
when you create a new report). However, it is a report template so once the
report is created and if you want to change it you would have to modify them
one by one. Still, it might be of use to you.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/f84b9ac6-bf37-4f27-bbe4-273a4af84c2e.htm
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:%23IMgaLIIHHA.4848@.TK2MSFTNGP04.phx.gbl...
> Thank you - I was just wondering if there was a fast way to format a
> variety of reports just like one would do with a webpage making headers,
> footers, fonts, borders, etc. all the same.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23SEUliGIHHA.3780@.TK2MSFTNGP02.phx.gbl...
>> What are you trying to do? RS uses an output independent format. The
>> report definition is xml but the rendering is done by the rendering
>> engine. You can render to html, csv, pdf, excel, etc.
>> The reports should be designed using the report designer. If you want to
>> do it another way there is a spec for the xml.
>> I guess I look at it like nothing is hand coded (unless you think a
>> graphical report designer tool is hand coding).
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
>> news:%23liEgVGIHHA.420@.TK2MSFTNGP02.phx.gbl...
>> Am I blind, I don't see in the properties pages a CSS entry. Is this not
>> available in SSRS? If so, is there another method or is everything hand
>> coded?
>> Thanks
>>
>|||Thank you - that's probably a pretty good direction for us.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eYjSYmIIHHA.1248@.TK2MSFTNGP03.phx.gbl...
> What you can do is setup a report template (for use by the report wizard
> or when you create a new report). However, it is a report template so once
> the report is created and if you want to change it you would have to
> modify them one by one. Still, it might be of use to you.
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/f84b9ac6-bf37-4f27-bbe4-273a4af84c2e.htm
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
> news:%23IMgaLIIHHA.4848@.TK2MSFTNGP04.phx.gbl...
>> Thank you - I was just wondering if there was a fast way to format a
>> variety of reports just like one would do with a webpage making headers,
>> footers, fonts, borders, etc. all the same.
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:%23SEUliGIHHA.3780@.TK2MSFTNGP02.phx.gbl...
>> What are you trying to do? RS uses an output independent format. The
>> report definition is xml but the rendering is done by the rendering
>> engine. You can render to html, csv, pdf, excel, etc.
>> The reports should be designed using the report designer. If you want to
>> do it another way there is a spec for the xml.
>> I guess I look at it like nothing is hand coded (unless you think a
>> graphical report designer tool is hand coding).
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
>> news:%23liEgVGIHHA.420@.TK2MSFTNGP02.phx.gbl...
>> Am I blind, I don't see in the properties pages a CSS entry. Is this
>> not available in SSRS? If so, is there another method or is everything
>> hand coded?
>> Thanks
>>
>>
>
Subscribe to:
Posts (Atom)