Excel or CSV output

rsullivan22 10 months ago

When I generate a report it comes out in print format like this..

But when I export it to Excel, the report comes out like this.. with no percentage column.

Any idea or is Excel/CSCV not supported anymore.. If not, what are my options.

Top Replies

HerrDoktor 10 months ago +2

can you share your query that makes up your report? I am guessing you need a floating value in the data, where you probably have a string value with the „%“ concatenated. If you remove the „%“ sign it…
rsullivan22 10 months ago in reply to osvict +1

Thanks for the feedback.. both reports are sent via email from the scheduled report area.. the PDF file shows the percentages, the excel file does not..
osvict 10 months ago in reply to rsullivan22 +1

make a copy of the report, and see what happend, other thing, the name of the report is to long? I rememeber I had issues exporting the reports because the name

0 osvict 10 months ago

try to run the report and send it to you by email from schedule report
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rsullivan22 10 months ago in reply to osvict

Thanks for the feedback.. both reports are sent via email from the scheduled report area.. the PDF file shows the percentages, the excel file does not..
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 osvict 10 months ago in reply to rsullivan22

make a copy of the report, and see what happend, other thing, the name of the report is to long? I rememeber I had issues exporting the reports because the name
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 HerrDoktor 10 months ago

can you share your query that makes up your report?

I am guessing you need a floating value in the data, where you probably have a string value with the „%“ concatenated. If you remove the „%“ sign it should work.
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel
0 osvict 10 months ago in reply to HerrDoktor

that is a good idea.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rsullivan22 10 months ago in reply to HerrDoktor

This was created using the Report Generating tools built into SW.. I am not a programmer, so I have no clue how to run this outside what is created using the various screens.. BUT if you can see an issue with why it is not creating an CSV or Excel file, please let me know so I can ask SW Support for assistance..

<Report xmlns="schemas.datacontract.org/.../SolarWinds.Reporting.Models" xmlns:i="www.w3.org/.../XMLSchema-instance">

<Category>Daily Node Availability</Category>

<Configs xmlns:a="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Data">

<a:ConfigurationData xmlns:b="schemas.datacontract.org/.../SolarWinds.Orion.Core.Reporting.Models.WebResource" i:type="b:WebResourceConfiguration">

<a:DisplaySubTitle/>

<a:DisplayTitle>Availability of Each Node</a:DisplayTitle>

<a:RefId>df6f0e3d-47a5-45ac-bbaf-afa4119a8d25</a:RefId>

<b:ParentViewType i:nil="true"/>

<b:ResourceFile>/Orion/NetPerfMon/Resources/Summary/AvailabilityOfEachNode.ascx</b:ResourceFile>

<b:Settings>

<a:ContextValue>

<a:Name>Filter</a:Name>

<a:Value>Vendor = 'Cisco' or Vendor = 'Microsoft'</a:Value>

</a:ContextValue>

<a:ContextValue>

<a:Name>Period</a:Name>

<a:Value>Last Month</a:Value>

</a:ContextValue>

</b:Settings>

<b:SubTitle/>

<b:Title>Availability of Each Node</b:Title>

</a:ConfigurationData>

<a:ConfigurationData xmlns:b="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Tables" i:type="b:TableConfiguration">

<a:DisplaySubTitle/>

<a:DisplayTitle>Custom Table</a:DisplayTitle>

<a:RefId>e6d15190-139e-48b4-b2ab-fe0bf3fad345</a:RefId>

<b:Columns>

<b:TableColumn>

<b:CellStyle xmlns:c="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Styles">

<c:BackgroundColor i:nil="true"/>

<c:Borders i:nil="true"/>

<c:DisplayName i:nil="true"/>

<c:Font i:nil="true"/>

<c:Padding i:nil="true"/>

<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>

<c:TextAlign>Left</c:TextAlign>

<c:ZebraBackgroundColor i:nil="true"/>

</b:CellStyle>

<b:DataColumnName i:nil="true"/>

<b:DisplayName>Node Name</b:DisplayName>

<b:Field xmlns:c="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Selection">

<c:DataTypeInfo>

<a:ApplicationType i:nil="true"/>

<a:DataType>

<a:Data>System.String</a:Data>

</a:DataType>

<a:DeclType>Text</a:DeclType>

<a:DefaultAggregation>NotSpecified</a:DefaultAggregation>

<a:DefaultDataUnitId i:nil="true"/>

<a:DefaultTransformId i:nil="true"/>

<a:Description/>

<a:IsFavorite>false</a:IsFavorite>

<a:IsFilterBy>false</a:IsFilterBy>

<a:IsGroupBy>false</a:IsGroupBy>

<a:IsInherited>false</a:IsInherited>

<a:IsManaged>true</a:IsManaged>

<a:IsStatistic>false</a:IsStatistic>

<a:PreviewValue i:nil="true"/>

<a:Units/>

<a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime>

</c:DataTypeInfo>

<c:DisplayName>Node Name</c:DisplayName>

<c:NavigationPath i:nil="true"/>

<c:OwnerDisplayName>Node</c:OwnerDisplayName>

<c:RefID>

<c:Data>Orion.Nodes|NodeName</c:Data>

</c:RefID>

</b:Field>

<b:FixedWidth i:nil="true"/>

<b:HeaderStyle xmlns:c="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Styles">

<c:BackgroundColor i:nil="true"/>

<c:Borders i:nil="true"/>

<c:DisplayName i:nil="true"/>

<c:Font i:nil="true"/>

<c:Padding i:nil="true"/>

<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>

<c:TextAlign>Left</c:TextAlign>

<c:ZebraBackgroundColor i:nil="true"/>

</b:HeaderStyle>

<b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed>

<b:IsHidden>false</b:IsHidden>

<b:PercentWidth i:nil="true"/>

<b:Presenters xmlns:c="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Presentation" i:nil="true"/>

<b:PropertyName>Node/Node Name</b:PropertyName>

<b:RefId>9f396587-abe0-9ac8-b8e0-f8df28f46d1a</b:RefId>

<b:Summary>

<b:Calculation>NotSpecified</b:Calculation>

<b:CellStyle xmlns:c="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Styles" i:nil="true"/>

</b:Summary>

<b:TransformId/>

<b:ValidRange>NotSpecified</b:ValidRange>

</b:TableColumn>

</b:Columns>

<b:DefaultStyle xmlns:c="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Styles" i:nil="true"/>

<b:Filter xmlns:c="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Selection">

<c:Expression i:nil="true"/>

<c:Limit>

<c:Count i:nil="true"/>

<c:Mode>ShowAll</c:Mode>

<c:OrionServerIDsToIgnore i:nil="true"/>

<c:Percentage i:nil="true"/>

</c:Limit>

</b:Filter>

<b:Indents i:nil="true"/>

<b:Sorts xmlns:c="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Selection" i:nil="true"/>

<b:SummarizeMode>NoDataSummarization</b:SummarizeMode>

<b:TimeField xmlns:c="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Selection" i:nil="true"/>

</a:ConfigurationData>

</Configs>

<DataSources xmlns:a="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Selection">

<a:DataSource>

<a:CommandText/>

<a:DynamicSelectionType>Simple</a:DynamicSelectionType>

<a:EntityUri xmlns:b="schemas.microsoft.com/.../Arrays"/>

<a:Filter i:nil="true"/>

<a:MasterEntity>orion.nodes</a:MasterEntity>

<a:Name>All Nodes</a:Name>

<a:NetObjectId/>

<a:RefId>15cdfc2b-af67-4e95-924e-98eb96e9f6ed</a:RefId>

<a:Type>Dynamic</a:Type>

</a:DataSource>

</DataSources>

<Description>Daily Node Availability</Description>

<Footer xmlns:a="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Layout">

<a:CustomText>Daily Report for Uptime Reporting.</a:CustomText>

<a:ShowCustomText>true</a:ShowCustomText>

<a:ShowPageNumber>true</a:ShowPageNumber>

<a:ShowTimestamp>true</a:ShowTimestamp>

<a:Visible>true</a:Visible>

</Footer>

<Header xmlns:a="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Layout">

<a:Logo/>

<a:SubTitle>Daily Node Availability</a:SubTitle>

<a:Title>TCC IT Node Daily Availability</a:Title>

<a:Visible>true</a:Visible>

</Header>

<LicenseFeatureName i:nil="true"/>

<LimitationCategory>Default Folder</LimitationCategory>

<ModuleTitle i:nil="true"/>

<Name>TCC IT Node Daily Availability</Name>

<OrionFeatureName i:nil="true"/>

<PageLayout xmlns:a="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Layout">

<a:Height>0</a:Height>

<a:Orientation i:nil="true"/>

<a:PublishingType>web</a:PublishingType>

<a:Size i:nil="true"/>

<a:Units i:nil="true"/>

<a:Width>2500</a:Width>

</PageLayout>

<ReportGuid>b2f82bfd-7c6a-4ce5-aa6c-aa2090d5edb0</ReportGuid>

<Sections xmlns:a="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Layout">

<a:Section>

<a:BorderStyle xmlns:b="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Styles">

<b:Bottom i:nil="true"/>

<b:Color i:nil="true"/>

<b:Left i:nil="true"/>

<b:Right i:nil="true"/>

<b:Top i:nil="true"/>

</a:BorderStyle>

<a:Columns>

<a:SectionColumn>

<a:BorderStyle xmlns:b="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Styles">

<b:Bottom i:nil="true"/>

<b:Color i:nil="true"/>

<b:Left i:nil="true"/>

<b:Right i:nil="true"/>

<b:Top i:nil="true"/>

</a:BorderStyle>

<a:Cells>

<a:SectionCell>

<a:Config xmlns:b="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Data" i:nil="true"/>

<a:ConfigId>df6f0e3d-47a5-45ac-bbaf-afa4119a8d25</a:ConfigId>

<a:DataSelectionRefId>00000000-0000-0000-0000-000000000000</a:DataSelectionRefId>

<a:DisplayName>Availability of Each Node</a:DisplayName>

<a:RefId>ae74092e-e2f4-4469-87d3-1c1222c2945d</a:RefId>

<a:RenderProvider>SolarWinds.Orion.Web.Reporting,WebResource</a:RenderProvider>

<a:TimeframeRefId>ffffffff-ffff-ffff-ffff-ffffffffffff</a:TimeframeRefId>

</a:SectionCell>

<a:SectionCell>

<a:Config xmlns:b="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Data" i:nil="true"/>

<a:ConfigId>e6d15190-139e-48b4-b2ab-fe0bf3fad345</a:ConfigId>

<a:DataSelectionRefId>15cdfc2b-af67-4e95-924e-98eb96e9f6ed</a:DataSelectionRefId>

<a:DisplayName>Custom Table</a:DisplayName>

<a:RefId>cca24c98-35c7-407d-8954-990a0f7da20c</a:RefId>

<a:RenderProvider>SolarWinds.Reporting,Table</a:RenderProvider>

<a:TimeframeRefId>ffffffff-ffff-ffff-ffff-ffffffffffff</a:TimeframeRefId>

</a:SectionCell>

</a:Cells>

<a:ColumnGutter i:nil="true"/>

<a:PercentWidth>100</a:PercentWidth>

<a:PixelWidth i:nil="true"/>

<a:RefId>c30b7d7d-666f-426c-88fc-5553fe3d460e</a:RefId>

<a:Subtitle/>

<a:Title/>

</a:SectionColumn>

</a:Columns>

<a:RefId>689837f3-b4ce-4d8c-bd2f-fd2dae8e3a88</a:RefId>

</a:Section>

</Sections>

<TimeFrames xmlns:a="schemas.datacontract.org/.../SolarWinds.Reporting.Models.Timing">

<a:TimeFrame>

<a:DisplayName>Past Hour</a:DisplayName>

<a:IsStatic>false</a:IsStatic>

<a:RefId>72e45cd3-6aa7-4167-88e1-4fa7a5bafa51</a:RefId>

<a:Relative>

<a:NamedTimeFrame>PastHour</a:NamedTimeFrame>

<a:Unit>Hour</a:Unit>

<a:UnitCount>1</a:UnitCount>

</a:Relative>

<a:Static i:nil="true"/>

</a:TimeFrame>

<a:TimeFrame>

<a:DisplayName>Past Hour</a:DisplayName>

<a:IsStatic>false</a:IsStatic>

<a:RefId>36dfc04f-ae3b-4663-89c1-2547dc7187f7</a:RefId>

<a:Relative>

<a:NamedTimeFrame>PastHour</a:NamedTimeFrame>

<a:Unit>Hour</a:Unit>

<a:UnitCount>1</a:UnitCount>

</a:Relative>

<a:Static i:nil="true"/>

</a:TimeFrame>

</TimeFrames>

</Report>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Larcywo 9 months ago

Deciding between Excel and CSV for output can be tricky. I use Excel if I need more formatting options or if my data is complex. It’s great for keeping everything neat and organized. But if you need a straightforward, no-frills format, CSV is super handy. It’s also a breeze to share across different programs. I’ve found that learning split date and time in excel can help when dealing with larger datasets, making it easier to manage and analyze. Check out some tips on this if you haven’t already—they might make your decision easier.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 KaiVias 3 months ago in reply to Larcywo

If you're looking for better ways to format or manage your exported data, Microsoft Excel Books can be a great resource. They cover useful tips on handling large datasets, structuring reports, and automating tasks with macros.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel