12 Replies Latest reply on Dec 3, 2009 9:47 AM by Calvin Nelson

    Report in PDME

      Take a look at the file 'Report Examples 1.crp' in C:\Program Files\PDMWorks Enterprise\. Specifically, look at the 'Document Data of the selected files' query. You probably need to be logged in as admin to run it in report generator.
        • Report in PDME
          Idspl Support
          but my question is that how to access the data through sql from the card that i import for eg. if i import a card as a new project
          after that i feel all the info in that
          after that i wanna to see it on report generator
          then how these data comes in sql?
          because all these information are stored in data folder in pdmworks enterprise not in sql.
          • Report in PDME
            Oh, I think I see what you are looking for. Do you mean that you want to see data from the card itself? If so, it's not possible. The labels and controls are stored in the file card.
            • Report in PDME
              Ajay, I apologise but I am having a hard time understanding what it is you are trying to achieve. Are you trying to return values from sql in a data card?
                • Report in PDME
                  Idspl Support
                  Thanks Lee Young for giving ur time on my question
                  no not like that
                  i use a template [New Project] set its various columns like project no, matterial used in project like Bore dia,rod dia, customer enquiry no and many more
                  when i make a new project it saves all their value.
                  i wanna to retrive these value through sql server
                  so that i generate a report named Information about Project.
                  so wht the sql query will written to retrive the result.
                    • Report in PDME
                      Save the text below to a text file, name the file ProjectDetails.crp and open it in Report Generator.

                      §Name [Project details of selected project]

                      §Company [N/A]

                      [This query will list project details of the selected project.]

                      §Version [1.0]

                      ProjectID pProjectID [1] [Select folder. E.g "$\Documents", or browse for folder.]

                      SELECT Variable.VariableName, VariableValue.ValueText
                      FROM Variable INNER JOIN
                      VariableValue ON Variable.VariableID = VariableValue.VariableID
                      WHERE (VariableValue.ProjectID = {pProjectID})

                      I hope this is what you are looking for.
                  • Report in PDME
                    Report generator only give you csv as an option. You'll need to use a text editor to replace the commas with what you need.
                      • Report in PDME
                        Joy Garon
                        Hello Sushil -

                        A comma seperated file (csv) displays each column of information within a single text file where each column is seperated by a semi-colon.
                        Normally when opening this file in excel, it will place all the information in a single column.
                        To get a csv file to open with the information split into individual columns you will need to use the Text Import Wizard within excel instead of File, Open.

                        The instructions below ( at the end of this post) are for office 2007 files.
                        In brief: in step one select Delimited, in step 2 select Semicolon as the delimiter.

                        Another report option would be to use SQL Server 2005 Reporting Services. This would allow you to export to other types such as PDF, HTML, Excel...

                        Text Import Wizard
                        You can use Microsoft Office Excel to import data from a text file into a worksheet. The Text Import Wizard examines the text file that you are importing and helps you ensure that the data is imported in the way that you want.

                        Note To start the Text Import Wizard, on the Data tab, in the Get External Data group, click From Text. Then, in the Import Text File dialog box, double-click the text file that you want to import.

                        Step 1 of 3
                        Original data type If items in the text file are separated by tabs, colons, semicolons, spaces, or other characters, select Delimited. If all of the items in each column are the same length, select Fixed width.

                        Start import at row Type or select a row number to specify the first row of the data that you want to import.

                        File origin Select the character set that is used in the text file. In most cases, you can leave this setting at its default. If you know that the text file was created by using a different character set than the character set that you are using on your computer, you should change this setting to match that character set. For example, if your computer is set to use character set 1251 (Cyrillic, Windows), but you know that the file was produced by using character set 1252 (Western European, Windows), you should set File Origin to 1252.

                        Preview of file This box displays the text as it will appear when it is separated into columns on the worksheet.

                        Step 2 of 3 (Delimited data)
                        Delimiters Select the character that separates values in your text file. If the character is not listed, select the Other check box, and then type the character in the box that contains the cursor. These options are not available if your data type is Fixed width.

                        Treat consecutive delimiters as one Select this option if your data contains a delimiter of more than one character between data fields or if your data contains multiple custom delimiters.

                        Text qualifier Select the character that encloses values in your text file. When Excel encounters the text qualifier character, all of the text that follows that character and precedes the next occurrence of that character is imported as one value, even if the text contains a delimiter character. For example, if the delimiter is a comma (,) and the text qualifier is a quotation mark ("), "Dallas, Texas" is imported into one cell as Dallas, Texas. If no character or the apostrophe (') is specified as the text qualifier, "Dallas, Texas" is imported into two adjacent cells as "Dallas and Texas".

                        If the delimiter character occurs between text qualifiers, Excel omits the qualifiers in the imported value. If no delimiter character occurs between text qualifiers, Excel includes the qualifier character in the imported value. Hence, "Dallas Texas" (using the quotation mark text qualifier) is imported into one cell as "Dallas Texas".

                        Data preview Review the text in this box to verify that the text will be separated into columns on the worksheet as you want it.

                        Step 2 of 3 (Fixed width data)
                        Data preview Set field widths in this section. Click the preview window to set a column break, which is represented by a vertical line. Double-click a column break to remove it, or drag a column break to move it.

                        Step 3 of 3
                        Click the Advanced button to do one or more of the following:

                        Specify the type of decimal and thousands separators that are used in the text file. When the data is imported into Excel, the separators will match those that are specified for your country/region in Regional Settings (Windows Control Panel).
                        Specify that one or more numeric values may contain a trailing minus sign.

                        Column data format Click the data format of the column that is selected in the Data preview section. If you do not want to import the selected column, click Do not import column (skip).

                        After you select a data format option for the selected column, the column heading under Data preview displays the format. If you select Date, select a date format in the Date box.

                        Choose the data format that closely matches the preview data so that Excel can convert the imported data correctly. For example:

                        To convert a column of all currency number characters to the Excel Currency format, select General.
                        To convert a column of all number characters to the Excel Text format, select Text.
                        To convert a column of all date characters, each date in the order of year, month, and day, to the Excel Date format, select Date, and then select the date type of YMD in the Date box.
                        Excel will import the column as General if the conversion could yield unintended results. For example:

                        If the column contains a mix of formats, such as alphabetical and numeric characters, Excel converts the column to General.
                        If, in a column of dates, each date is in the order of year, month, and date, and you select Date along with a date type of MDY, Excel converts the column to General format. A column that contains date characters must closely match an Excel built-in date or custom date formats.
                        If Excel does not convert a column to the format that you want, you can convert the data after you import it. For more information, see the following Help topics:

                        Convert numbers stored as text to numbers
                        Convert dates stored as text to dates
                        TEXT function
                        VALUE function
                        See Also
                        Connect to (import) an OLAP database
                        Connect to (Import) external data
                        Connect to (import) SQL Server data
                        Import or export text files
                        Overview of connecting (importing) data
                          • Report in PDME
                            Idspl Support
                            Thanks Joy garon
                            but u not give the proper solution to me
                            actually i want only exact result that shown on report on excel file
                            • Re: Report in PDME
                              Calvin Nelson

                              Why does Enterprise say that it is exporting the results as Comma Separated Variables when it's actually exporting as SemiColon Seperated Variables?

                              Instead, it should jsut export it as a TXT and then it's clear to the end user that they'll have to import it into Excel.

                              I understand that having the Report Generator use commas instead of semicolons could still give you trouble since commas are allowed in the data fields. Tab delimited might have been a better choice, since you can also put semicolons into the data fields.